PREVIEW / futures_1hour / 2019-11-17
file: by_date/futures_1hour/2019/2019-11-17.parquet size: 16 KB rows: 358
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2019-11-17 18:00:00 | ES | Futures | 3388.87 | 3389.14 | 3383.16 | 3383.71 | 11259.0 |
| 2019-11-17 19:00:00 | ES | Futures | 3384.25 | 3385.61 | 3383.16 | 3384.79 | 8889.0 |
| 2019-11-17 20:00:00 | ES | Futures | 3385.07 | 3387.51 | 3383.71 | 3386.97 | 11798.0 |
| 2019-11-17 21:00:00 | ES | Futures | 3387.24 | 3388.05 | 3385.61 | 3387.51 | 6378.0 |
| 2019-11-17 22:00:00 | ES | Futures | 3387.24 | 3388.32 | 3386.97 | 3387.24 | 5599.0 |
| 2019-11-17 23:00:00 | ES | Futures | 3386.97 | 3387.24 | 3385.88 | 3386.42 | 2963.0 |
| 2019-11-17 18:00:00 | NQ | Futures | 9666.13 | 9671.07 | 9652.77 | 9656.55 | 3957.0 |
| 2019-11-17 19:00:00 | NQ | Futures | 9656.55 | 9660.61 | 9651.9 | 9657.71 | 2672.0 |
| 2019-11-17 20:00:00 | NQ | Futures | 9657.71 | 9667.29 | 9653.35 | 9666.13 | 4105.0 |
| 2019-11-17 21:00:00 | NQ | Futures | 9666.13 | 9669.62 | 9660.32 | 9666.13 | 2866.0 |
| 2019-11-17 22:00:00 | NQ | Futures | 9666.42 | 9669.04 | 9664.1 | 9664.97 | 13814.0 |
| 2019-11-17 23:00:00 | NQ | Futures | 9664.68 | 9664.97 | 9660.03 | 9661.19 | 3223.0 |
| 2019-11-17 18:00:00 | YM | Futures | 30430.3 | 30432.5 | 30394.4 | 30403.1 | 1988.0 |
| 2019-11-17 19:00:00 | YM | Futures | 30402.0 | 30412.9 | 30393.3 | 30405.3 | 1345.0 |
| 2019-11-17 20:00:00 | YM | Futures | 30405.3 | 30432.5 | 30398.8 | 30426.0 | 2069.0 |
| 2019-11-17 21:00:00 | YM | Futures | 30427.1 | 30433.6 | 30411.8 | 30426.0 | 1121.0 |
| 2019-11-17 22:00:00 | YM | Futures | 30429.2 | 30435.8 | 30422.7 | 30423.8 | 938.0 |
| 2019-11-17 23:00:00 | YM | Futures | 30423.8 | 30424.9 | 30414.0 | 30418.4 | 404.0 |
| 2019-11-17 18:00:00 | CL | Futures | 51.41 | 51.44 | 51.21 | 51.29 | 3693.0 |
| 2019-11-17 19:00:00 | CL | Futures | 51.29 | 51.34 | 51.26 | 51.31 | 1574.0 |
| 2019-11-17 20:00:00 | CL | Futures | 51.3 | 51.34 | 51.23 | 51.3 | 3979.0 |
| 2019-11-17 21:00:00 | CL | Futures | 51.31 | 51.37 | 51.3 | 51.33 | 3619.0 |
| 2019-11-17 22:00:00 | CL | Futures | 51.34 | 51.37 | 51.26 | 51.27 | 2267.0 |
| 2019-11-17 23:00:00 | CL | Futures | 51.28 | 51.3 | 51.26 | 51.28 | 883.0 |
| 2019-11-17 18:00:00 | GC | Futures | 1859.5 | 1862.5 | 1859.5 | 1861.8 | 2698.0 |
| 2019-11-17 19:00:00 | GC | Futures | 1861.8 | 1862.3 | 1859.8 | 1859.8 | 3476.0 |
| 2019-11-17 20:00:00 | GC | Futures | 1859.8 | 1860.3 | 1857.1 | 1857.3 | 6864.0 |
| 2019-11-17 21:00:00 | GC | Futures | 1857.2 | 1858.6 | 1856.6 | 1857.7 | 4198.0 |
| 2019-11-17 22:00:00 | GC | Futures | 1857.7 | 1858.1 | 1856.3 | 1857.9 | 3480.0 |
| 2019-11-17 23:00:00 | GC | Futures | 1857.9 | 1858.4 | 1857.2 | 1858.2 | 1517.0 |
| 2019-11-17 18:00:00 | ZN | Futures | 129.216532 | 129.325971 | 129.216532 | 129.310337 | 10480.0 |
| 2019-11-17 19:00:00 | ZN | Futures | 129.294703 | 129.357239 | 129.263434 | 129.325971 | 13706.0 |
| 2019-11-17 20:00:00 | ZN | Futures | 129.310337 | 129.325971 | 129.263434 | 129.263434 | 17228.0 |
| 2019-11-17 21:00:00 | ZN | Futures | 129.263434 | 129.310337 | 129.263434 | 129.294703 | 6102.0 |
| 2019-11-17 22:00:00 | ZN | Futures | 129.294703 | 129.310337 | 129.279069 | 129.294703 | 3362.0 |
| 2019-11-17 23:00:00 | ZN | Futures | 129.294703 | 129.325971 | 129.294703 | 129.310337 | 6251.0 |
> showing 36 of 358 rows — these rows as CSV