PREVIEW / futures_1hour / 2018-08-19
file: by_date/futures_1hour/2018/2018-08-19.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-08-19 18:00:00 | ES | Futures | 3108.02 | 3111.84 | 3107.75 | 3111.57 | 5380.0 |
| 2018-08-19 19:00:00 | ES | Futures | 3111.57 | 3111.84 | 3109.11 | 3109.39 | 3699.0 |
| 2018-08-19 20:00:00 | ES | Futures | 3109.39 | 3111.57 | 3109.11 | 3109.11 | 7032.0 |
| 2018-08-19 21:00:00 | ES | Futures | 3109.11 | 3111.02 | 3106.39 | 3108.84 | 13397.0 |
| 2018-08-19 22:00:00 | ES | Futures | 3109.11 | 3111.29 | 3107.75 | 3108.02 | 6147.0 |
| 2018-08-19 23:00:00 | ES | Futures | 3108.02 | 3109.66 | 3106.93 | 3109.11 | 3906.0 |
| 2018-08-19 18:00:00 | NQ | Futures | 8703.59 | 8714.78 | 8700.06 | 8714.19 | 1689.0 |
| 2018-08-19 19:00:00 | NQ | Futures | 8714.19 | 8714.48 | 8707.71 | 8708.59 | 1611.0 |
| 2018-08-19 20:00:00 | NQ | Futures | 8708.89 | 8717.72 | 8706.83 | 8707.71 | 1980.0 |
| 2018-08-19 21:00:00 | NQ | Futures | 8708.01 | 8716.25 | 8698.29 | 8708.59 | 3299.0 |
| 2018-08-19 22:00:00 | NQ | Futures | 8708.59 | 8718.9 | 8707.12 | 8708.3 | 1782.0 |
| 2018-08-19 23:00:00 | NQ | Futures | 8708.3 | 8713.6 | 8704.47 | 8712.72 | 953.0 |
| 2018-08-19 18:00:00 | YM | Futures | 27942.7 | 27950.4 | 27917.7 | 27949.3 | 959.0 |
| 2018-08-19 19:00:00 | YM | Futures | 27949.3 | 27950.4 | 27924.3 | 27926.4 | 790.0 |
| 2018-08-19 20:00:00 | YM | Futures | 27926.4 | 27947.1 | 27921.0 | 27922.1 | 1651.0 |
| 2018-08-19 21:00:00 | YM | Futures | 27922.1 | 27947.1 | 27899.3 | 27919.9 | 2511.0 |
| 2018-08-19 22:00:00 | YM | Futures | 27921.0 | 27944.9 | 27915.6 | 27916.6 | 1439.0 |
| 2018-08-19 23:00:00 | YM | Futures | 27916.6 | 27935.1 | 27908.0 | 27931.9 | 961.0 |
| 2018-08-19 18:00:00 | CL | Futures | 59.87 | 59.9 | 59.79 | 59.83 | 1781.0 |
| 2018-08-19 19:00:00 | CL | Futures | 59.83 | 59.83 | 59.73 | 59.75 | 1445.0 |
| 2018-08-19 20:00:00 | CL | Futures | 59.75 | 59.86 | 59.73 | 59.84 | 2965.0 |
| 2018-08-19 21:00:00 | CL | Futures | 59.84 | 59.85 | 59.67 | 59.74 | 6592.0 |
| 2018-08-19 22:00:00 | CL | Futures | 59.74 | 59.78 | 59.65 | 59.67 | 4124.0 |
| 2018-08-19 23:00:00 | CL | Futures | 59.67 | 59.7 | 59.54 | 59.62 | 5046.0 |
| 2018-08-19 18:00:00 | GC | Futures | 1550.9 | 1551.6 | 1549.9 | 1550.5 | 2450.0 |
| 2018-08-19 19:00:00 | GC | Futures | 1550.5 | 1551.3 | 1550.1 | 1550.9 | 2070.0 |
| 2018-08-19 20:00:00 | GC | Futures | 1550.8 | 1553.0 | 1550.7 | 1551.2 | 5952.0 |
| 2018-08-19 21:00:00 | GC | Futures | 1551.0 | 1552.7 | 1549.9 | 1551.7 | 8757.0 |
| 2018-08-19 22:00:00 | GC | Futures | 1551.7 | 1554.7 | 1551.6 | 1552.9 | 8661.0 |
| 2018-08-19 23:00:00 | GC | Futures | 1552.9 | 1554.6 | 1552.7 | 1553.5 | 3744.0 |
| 2018-08-19 18:00:00 | ZN | Futures | 121.029548 | 121.029548 | 120.9824 | 121.013832 | 7966.0 |
| 2018-08-19 19:00:00 | ZN | Futures | 121.013832 | 121.029548 | 120.998116 | 121.013832 | 6106.0 |
| 2018-08-19 20:00:00 | ZN | Futures | 121.013832 | 121.013832 | 120.9824 | 121.013832 | 6701.0 |
| 2018-08-19 21:00:00 | ZN | Futures | 121.013832 | 121.06098 | 121.013832 | 121.029548 | 7870.0 |
| 2018-08-19 22:00:00 | ZN | Futures | 121.029548 | 121.045264 | 120.998116 | 121.045264 | 4380.0 |
| 2018-08-19 23:00:00 | ZN | Futures | 121.045264 | 121.045264 | 121.013832 | 121.013832 | 3623.0 |
> showing 36 of 290 rows — these rows as CSV