Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- data_sheet=pd.DataFrame(columns =["Ticker", 'open', 'close', 'high', 'low', 'value', 'volume', 'begin', 'end'])
- for h in range(160000,370000+1, 5000):
- url=f'https://iss.moex.com/iss/engines/futures/markets/options/\
- securities/MX{h}BA0/candles.csv?from=\
- 2019-01-01&till=2020-01-01&interval=24&iss.meta=on'
- data1=pd.DataFrame(pd.read_csv(url, sep=";", skiprows=2))
- try:
- if pd.isnull(data1['open'][0]):
- pass
- else:
- data1.columns.name = 'Ticker'
- data1["Ticker"]=f'MX{h}BA0'
- except Exception:
- pass
- data_sheet=data_sheet.append(data1, ignore_index=True, sort=False)
- data_sheet
- Вывод
- Ticker open close high low value volume begin end
- 0 MX300000BA0 6750 6750 6750 6750 0 1 2019-11-27 00:00:00 2019-11-27 19:20:21
- 1 MX300000BA0 8000 8000 8000 8000 0 1 2019-12-27 00:00:00 2019-12-27 19:20:21
- 2 MX305000BA0 4225 4225 4225 4225 0 1 2019-12-20 00:00:00 2019-12-20 23:59:59
- 3 MX325000BA0 375 375 375 375 0 1 2019-12-20 00:00:00 2019-12-20 23:59:59
- 4 MX325000BA0 250 250 250 250 0 1 2019-12-30 00:00:00 2019-12-30 23:59:59
- 5 MX330000BA0 325 325 325 325 0 1 2019-12-19 00:00:00 2019-12-19 23:59:59
- 6 MX330000BA0 125 100 125 100 0 2 2019-12-30 00:00:00 2019-12-30 23:59:59
- 7 MX335000BA0 325 325 325 325 0 1 2019-12-19 00:00:00 2019-12-19 23:59:59
- 8 MX335000BA0 75 75 75 75 0 1 2019-12-23 00:00:00 2019-12-23 23:59:59
- 9 MX340000BA0 125 125 125 125 0 1 2019-12-19 00:00:00 2019-12-19 23:59:59
- 10 MX345000BA0 325 125 325 125 0 2 2019-12-19 00:00:00 2019-12-19 23:59:59
- 11 MX355000BA0 325 125 325 125 0 2 2019-12-19 00:00:00 2019-12-19 23:59:59
- 12 MX360000BA0 325 125 325 125 0 4 2019-12-19 00:00:00 2019-12-19 23:59:59
Add Comment
Please, Sign In to add comment