It is easy to get data of every coin from Binance with URL " https://www.binance.com/api/v3/ticker/24hr" using Power Query tool in Excel. I can get data, analyze and make crypto coin trade very efficiently. But with this I can get only daily data which contains only 24 hour OPEN, LOW, HIGH and CLOSE prices. In order to upgrade my work, I need hourly, two hours or 30 minutes OPEN, LOW, HIGH and CLOSE prices.
Binance calls this data as Klines but gives only one coin’s data at one query with this path "“https://api.binance.com/api/v3/kline?symbol=BNBBTC&interval=30m” . Thanks a lot
Is it possible to get kline data of every listed coins in one query like 24h. (please look at the picture.
No, you will need to iterate over the set of symbols and call the endpoint for each symbol.
Thanks