Guest User

Untitled

a guest
May 8th, 2020
162
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 1.52 KB | None | 0 0
  1.  
  2.  
  3.  
  4. data_sheet=pd.DataFrame(columns =["Ticker", 'open', 'close', 'high', 'low', 'value', 'volume', 'begin', 'end'])
  5.  
  6. for h in range(160000,370000+1, 5000):
  7.             url=f'https://iss.moex.com/iss/engines/futures/markets/options/\
  8. securities/MX{h}BA0/candles.csv?from=\
  9. 2019-01-01&till=2020-01-01&interval=24&iss.meta=on'
  10.             data_sheet=data_sheet.append(pd.read_csv(url, sep=";", skiprows=2), ignore_index=True, sort=False)
  11.            
  12.             data_sheet['Ticker'][len(data_sheet['Ticker'])-1]=f'MX{h}BA0'
  13.  
  14. Вывод
  15.  
  16. Ticker  open    close   high    low value   volume  begin   end
  17. 0   NaN 6750    6750    6750    6750    0   1   2019-11-27 00:00:00 2019-11-27 19:20:21
  18. 1   MX300000BA0 8000    8000    8000    8000    0   1   2019-12-27 00:00:00 2019-12-27 19:20:21
  19. 2   MX320000BA0 4225    4225    4225    4225    0   1   2019-12-20 00:00:00 2019-12-20 23:59:59
  20. 3   NaN 375 375 375 375 0   1   2019-12-20 00:00:00 2019-12-20 23:59:59
  21. 4   MX325000BA0 250 250 250 250 0   1   2019-12-30 00:00:00 2019-12-30 23:59:59
  22. 5   NaN 325 325 325 325 0   1   2019-12-19 00:00:00 2019-12-19 23:59:59
  23. 6   MX330000BA0 125 100 125 100 0   2   2019-12-30 00:00:00 2019-12-30 23:59:59
  24. 7   NaN 325 325 325 325 0   1   2019-12-19 00:00:00 2019-12-19 23:59:59
  25. 8   MX335000BA0 75  75  75  75  0   1   2019-12-23 00:00:00 2019-12-23 23:59:59
  26. 9   MX340000BA0 125 125 125 125 0   1   2019-12-19 00:00:00 2019-12-19 23:59:59
  27. 10  MX350000BA0 325 125 325 125 0   2   2019-12-19 00:00:00 2019-12-19 23:59:59
  28. 11  MX355000BA0 325 125 325 125 0   2   2019-12-19 00:00:00 2019-12-19 23:59:59
  29. 12  MX370000BA0 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