PREVIEW / futures_1hour / 2018-07-15
file: by_date/futures_1hour/2018/2018-07-15.parquet size: 14 KB rows: 290
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 |
|---|---|---|---|---|---|---|---|
| 2018-07-15 18:00:00 | ES | Futures | 3056.8 | 3061.43 | 3056.8 | 3060.34 | 5551.0 |
| 2018-07-15 19:00:00 | ES | Futures | 3060.61 | 3061.16 | 3058.98 | 3059.25 | 1483.0 |
| 2018-07-15 20:00:00 | ES | Futures | 3059.52 | 3060.61 | 3058.98 | 3059.52 | 2531.0 |
| 2018-07-15 21:00:00 | ES | Futures | 3059.52 | 3061.43 | 3057.62 | 3057.62 | 6397.0 |
| 2018-07-15 22:00:00 | ES | Futures | 3057.62 | 3058.98 | 3055.71 | 3056.53 | 5039.0 |
| 2018-07-15 23:00:00 | ES | Futures | 3056.53 | 3058.71 | 3056.25 | 3057.89 | 2588.0 |
| 2018-07-15 18:00:00 | NQ | Futures | 8714.19 | 8730.97 | 8713.01 | 8726.85 | 2136.0 |
| 2018-07-15 19:00:00 | NQ | Futures | 8726.55 | 8728.91 | 8721.84 | 8723.61 | 1036.0 |
| 2018-07-15 20:00:00 | NQ | Futures | 8723.9 | 8729.5 | 8722.43 | 8725.67 | 1301.0 |
| 2018-07-15 21:00:00 | NQ | Futures | 8725.67 | 8730.68 | 8715.66 | 8715.66 | 3690.0 |
| 2018-07-15 22:00:00 | NQ | Futures | 8715.66 | 8720.37 | 8706.83 | 8711.24 | 2654.0 |
| 2018-07-15 23:00:00 | NQ | Futures | 8711.24 | 8720.08 | 8710.95 | 8716.54 | 1109.0 |
| 2018-07-15 18:00:00 | YM | Futures | 27205.7 | 27262.2 | 27205.7 | 27257.8 | 1390.0 |
| 2018-07-15 19:00:00 | YM | Futures | 27256.8 | 27263.3 | 27237.2 | 27243.7 | 668.0 |
| 2018-07-15 20:00:00 | YM | Futures | 27245.9 | 27258.9 | 27239.4 | 27251.3 | 670.0 |
| 2018-07-15 21:00:00 | YM | Futures | 27251.3 | 27276.3 | 27237.2 | 27237.2 | 1479.0 |
| 2018-07-15 22:00:00 | YM | Futures | 27236.1 | 27251.3 | 27214.4 | 27222.0 | 1232.0 |
| 2018-07-15 23:00:00 | YM | Futures | 27222.0 | 27247.0 | 27222.0 | 27236.1 | 654.0 |
| 2018-07-15 18:00:00 | CL | Futures | 63.19 | 63.42 | 63.04 | 63.33 | 721.0 |
| 2018-07-15 19:00:00 | CL | Futures | 63.33 | 63.38 | 63.27 | 63.29 | 202.0 |
| 2018-07-15 20:00:00 | CL | Futures | 63.28 | 63.35 | 63.21 | 63.32 | 627.0 |
| 2018-07-15 21:00:00 | CL | Futures | 63.33 | 63.42 | 63.17 | 63.23 | 1692.0 |
| 2018-07-15 22:00:00 | CL | Futures | 63.23 | 63.27 | 63.11 | 63.18 | 996.0 |
| 2018-07-15 23:00:00 | CL | Futures | 63.19 | 63.26 | 63.17 | 63.2 | 539.0 |
| 2018-07-15 18:00:00 | GC | Futures | 1629.4 | 1631.0 | 1628.8 | 1630.6 | 1264.0 |
| 2018-07-15 19:00:00 | GC | Futures | 1630.4 | 1631.2 | 1629.7 | 1629.7 | 1162.0 |
| 2018-07-15 20:00:00 | GC | Futures | 1629.7 | 1631.9 | 1629.3 | 1631.4 | 3225.0 |
| 2018-07-15 21:00:00 | GC | Futures | 1631.4 | 1634.3 | 1631.3 | 1632.2 | 7332.0 |
| 2018-07-15 22:00:00 | GC | Futures | 1632.2 | 1632.9 | 1630.2 | 1631.5 | 6863.0 |
| 2018-07-15 23:00:00 | GC | Futures | 1631.4 | 1633.5 | 1631.3 | 1632.7 | 2931.0 |
| 2018-07-15 18:00:00 | ZN | Futures | 121.092412 | 121.092412 | 121.013832 | 121.029548 | 5553.0 |
| 2018-07-15 19:00:00 | ZN | Futures | 121.029548 | 121.045264 | 121.029548 | 121.045264 | 2340.0 |
| 2018-07-15 20:00:00 | ZN | Futures | 121.045264 | 121.045264 | 121.029548 | 121.029548 | 2137.0 |
| 2018-07-15 21:00:00 | ZN | Futures | 121.045264 | 121.045264 | 121.029548 | 121.029548 | 4866.0 |
| 2018-07-15 22:00:00 | ZN | Futures | 121.045264 | 121.076696 | 121.045264 | 121.076696 | 4243.0 |
| 2018-07-15 23:00:00 | ZN | Futures | 121.076696 | 121.076696 | 121.045264 | 121.06098 | 2672.0 |
> showing 36 of 290 rows — these rows as CSV