Fetch Candlestick/Kline data from Binance API using Python (preferably requests) to get JSON Dat

Question

I am developing a telegram bot that fetches Candlestick Data from Binance API. I am unable to get JSON Data as a response. The following code is something that I tried.

 import requests 

 import json

 import urllib.request

`url = "https://api.binance.com/api/v1/klines"

response = requests.request("GET", url)
print(response.text)`

Desired Output:

[ [ 1499040000000, // Open time "0.01634790", // Open "0.80000000", // High "0.01575800", // Low "0.01577100", // Close "148976.11427815", // Volume 1499644799999, // Close time "2434.19055334", // Quote asset volume 308, // Number of trades "1756.87402397", // Taker buy base asset volume "28.46694368", // Taker buy quote asset volume "17928899.62484339" // Ignore ] ]

Question Edited:

The output that I am getting is:

 `{"code":-1102,"msg":"Mandatory parameter 'symbol' was not sent, was empty/null, or malformed."}'

What error / message do you get? – Gernot Jul 16 '18 at 09:09 — Gernot, Jul 16 '18 at 09:09
The output that I am getting is: `` – Jin Barai Jul 16 '18 at 09:13 — Jin Barai, Jul 16 '18 at 09:13

Domenico · Answer 1 · 2021-03-21T00:16:26.520

31

you are missing the mandatory parameters symbol and interval, the query should be like this:

https://api.binance.com/api/v3/klines?symbol=BTCUSDT&interval=1h

you need to import only requests:

import requests

market = 'BTCUSDT'
tick_interval = '1h'

url = 'https://api.binance.com/api/v3/klines?symbol='+market+'&interval='+tick_interval
data = requests.get(url).json()

print(data)

Please check the official Binance REST API documentation here: https://github.com/binance/binance-spot-api-docs/blob/master/rest-api.md

edited Mar 21 '21 at 00:16

answered Jul 19 '18 at 13:06

Domenico

531
4
5

Is it possible to pass a list of symbols? – H Aßdøµ Mar 17 '21 at 11:16
2

@HAßdøµ No you can't pass a list of symbols, please refer to the API documentation: https://github.com/binance/binance-spot-api-docs/blob/master/rest-api.md#klinecandlestick-data. – Domenico Mar 21 '21 at 00:08
1

@HAßdøµ Via the Exchange-Endpoint of the Binance API, you can get all all symbols that are traded on the Exchange, and then pass them each into your function, e.g. in a for-loop. – Halil Ibrahim Özcan Dec 11 '22 at 19:14
1

@HalilIbrahimÖzcan That is a good idea. – H Aßdøµ Dec 18 '22 at 12:40

carkod · Answer 2 · 2021-06-10T22:26:12.750

4

The requests python package has a params, json argument, so you don't need to import any of those packages you are importing.

import requests

url = 'https://api.binance.com/api/v3/klines'
params = {
  'symbol': 'BTCUSDT',
  'interval': '1h'
}
response = requests.get(url, params=params)
print(response.json())

edited Jun 10 '21 at 22:26

answered May 05 '21 at 00:26

carkod

1,844
19
32

2

the last line should be: print(response.json()) instead of: print(response.json) – Domenico May 09 '21 at 22:54

score 1 · Answer 3 · answered Nov 30 '22 at 13:51

collect data into dataframe

import requests
import datetime
import pandas as pd
import numpy as np

def get_binance_data_request_(ticker, interval='4h', limit=500, start='2018-01-01 00:00:00'):
  """
  interval: str tick interval - 4h/1h/1d ...
  """
  columns = ['open_time','open', 'high', 'low', 'close', 'volume','close_time', 'qav','num_trades','taker_base_vol','taker_quote_vol', 'ignore']
  start = int(datetime.datetime.timestamp(pd.to_datetime(start))*1000)
  url = f'https://www.binance.com/api/v3/klines?symbol={ticker}&interval={interval}&limit={limit}&startTime={start}'
  data = pd.DataFrame(requests.get(url).json(), columns=columns, dtype=np.float)
  data.index = [pd.to_datetime(x, unit='ms').strftime('%Y-%m-%d %H:%M:%S') for x in data.open_time]
  usecols=['open', 'high', 'low', 'close', 'volume', 'qav','num_trades','taker_base_vol','taker_quote_vol']
  data = data[usecols]
  return data

get_binance_data_request_('ETHUSDT', '1h')

result:

Fetch Candlestick/Kline data from Binance API using Python (preferably requests) to get JSON Dat

3 Answers3

Linked