Getting Historical quotes for List of securities

Developer API
1

I am able to fetch the historical prices for one single stock .However I need to be able to fetch the same for list of stocks . I tried to place multiple comma separated list of instrument keys in the url and also pass as params, but does not work .Can someone please help ?

histurl=‘https://api-v2.upstox.com/historical-candle/NSE_EQ|INE038A01020/day/2023-09-25/2023-09-01’
headers = {
“accept”: “application/json”,
“Api-Version”: “2.0”,
“Authorization”: "Bearer {access token}
#params={‘symbol’:‘NSE_EQ|INE038A01020’,‘interval’:‘1d’,‘to_date’:‘2023-09-25’,‘from_date’:‘2023-09-01’}
response=make_request(‘GET’,histurl,headers=headers,params=params)
json_response=response.json()
candles_data = json_response[‘data’][‘candles’]
columns = [‘Date’, ‘Open’, ‘High’, ‘Low’, ‘Close’, ‘Volume’, ‘Other’]
df = pd.DataFrame(candles_data, columns=columns)
df[‘symbol’]=‘Hindalco’
print(df)

2

The historical API does not accommodate comma-separated lists of symbols. You will need to retrieve data for each instrument individually.

Fetching data using a single instrument key is optimized on the CDN for better performance, ensuring faster responses from the cache.