Guest User

Untitled

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