search

santiment / sanpy

Santiment API Python Client
MIT License
94 stars 29 forks source link

Fix missing rows ohlcv #55

Closed tspenov closed 5 years ago

tspenov commented 5 years ago

before:

                           openPriceUsd  closePriceUsd  highPriceUsd  lowPriceUsd      volume     marketcap
datetime
2018-05-14 00:00:00+00:00       8713.10        8410.70       8748.37      8367.97  6281080000  1.460972e+11
2018-05-14 06:00:00+00:00       8418.49        8465.31       8489.37      8379.68  6532800000  1.437266e+11
2018-05-14 12:00:00+00:00       8463.31        8777.05       8825.43      8397.10  7345270000  1.476873e+11
2018-05-14 18:00:00+00:00       8770.14        8769.89       8780.19      8763.18  7301810000  1.494018e+11
2018-05-15 18:00:00+00:00       8522.81        8510.38       8559.63      8456.45  6705710000  1.452402e+11
2018-05-16 00:00:00+00:00       8504.41        8229.27       8508.43      8175.49  7007450000  1.415157e+11
2018-05-16 06:00:00+00:00       8238.41        8418.14       8440.89      8238.41  7249610000  1.413704e+11
2018-05-16 12:00:00+00:00       8411.77        8329.17       8411.77      8190.12  7000540000  1.414858e+11
2018-05-16 18:00:00+00:00       8333.88        8368.83       8368.83      8288.48  6760220000  1.418366e+11
2018-05-17 00:00:00+00:00       8370.05        8383.29       8445.54      8351.17  6363490000  1.428692e+11
2018-05-17 06:00:00+00:00       8378.71        8317.62       8386.58      8283.11  5989060000  1.418817e+11

now:

                           openPriceUsd  closePriceUsd  highPriceUsd  lowPriceUsd        volume     marketcap
datetime
2018-05-14 00:00:00+00:00       8713.10        8410.70       8748.37      8367.97  6.281080e+09  1.460972e+11
2018-05-14 06:00:00+00:00       8418.49        8465.31       8489.37      8379.68  6.532800e+09  1.437266e+11
2018-05-14 12:00:00+00:00       8463.31        8777.05       8825.43      8397.10  7.345270e+09  1.476873e+11
2018-05-14 18:00:00+00:00       8770.14        8769.89       8780.19      8763.18  7.301810e+09  1.494018e+11
2018-05-15 00:00:00+00:00          0.00           0.00          0.00         0.00           NaN           NaN
2018-05-15 06:00:00+00:00          0.00           0.00          0.00         0.00           NaN           NaN
2018-05-15 12:00:00+00:00          0.00           0.00          0.00         0.00           NaN           NaN
2018-05-15 18:00:00+00:00       8522.81        8510.38       8559.63      8456.45  6.705710e+09  1.452402e+11
2018-05-16 00:00:00+00:00       8504.41        8229.27       8508.43      8175.49  7.007450e+09  1.415157e+11
2018-05-16 06:00:00+00:00       8238.41        8418.14       8440.89      8238.41  7.249610e+09  1.413704e+11
2018-05-16 12:00:00+00:00       8411.77        8329.17       8411.77      8190.12  7.000540e+09  1.414858e+11
2018-05-16 18:00:00+00:00       8333.88        8368.83       8368.83      8288.48  6.760220e+09  1.418366e+11
2018-05-17 00:00:00+00:00       8370.05        8383.29       8445.54      8351.17  6.363490e+09  1.428692e+11
2018-05-17 06:00:00+00:00       8378.71        8317.62       8386.58      8283.11  5.989060e+09  1.418817e+11