PREVIEW / futures_1hour / 2018-07-29
file: by_date/futures_1hour/2018/2018-07-29.parquet size: 15 KB rows: 291
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-29 18:00:00 | ES | Futures | 3069.06 | 3070.97 | 3065.52 | 3068.79 | 4999.0 |
| 2018-07-29 19:00:00 | ES | Futures | 3068.52 | 3069.88 | 3067.15 | 3068.24 | 4250.0 |
| 2018-07-29 20:00:00 | ES | Futures | 3067.97 | 3069.06 | 3062.25 | 3064.7 | 9773.0 |
| 2018-07-29 21:00:00 | ES | Futures | 3064.7 | 3066.88 | 3063.61 | 3065.79 | 6959.0 |
| 2018-07-29 22:00:00 | ES | Futures | 3066.06 | 3066.06 | 3058.71 | 3060.07 | 8007.0 |
| 2018-07-29 23:00:00 | ES | Futures | 3060.34 | 3063.07 | 3059.52 | 3062.25 | 4318.0 |
| 2018-07-29 18:00:00 | NQ | Futures | 8588.77 | 8596.72 | 8584.64 | 8589.36 | 1708.0 |
| 2018-07-29 19:00:00 | NQ | Futures | 8588.77 | 8595.54 | 8585.23 | 8587.0 | 1523.0 |
| 2018-07-29 20:00:00 | NQ | Futures | 8586.71 | 8589.36 | 8565.8 | 8569.92 | 4304.0 |
| 2018-07-29 21:00:00 | NQ | Futures | 8569.33 | 8580.52 | 8566.98 | 8576.11 | 3312.0 |
| 2018-07-29 22:00:00 | NQ | Futures | 8576.4 | 8578.17 | 8549.9 | 8554.32 | 3406.0 |
| 2018-07-29 23:00:00 | NQ | Futures | 8554.02 | 8563.15 | 8551.38 | 8560.5 | 2409.0 |
| 2018-07-29 18:00:00 | YM | Futures | 27637.3 | 27648.1 | 27611.2 | 27632.9 | 690.0 |
| 2018-07-29 19:00:00 | YM | Futures | 27631.8 | 27639.4 | 27606.8 | 27619.9 | 657.0 |
| 2018-07-29 20:00:00 | YM | Futures | 27616.6 | 27627.5 | 27562.2 | 27584.0 | 2014.0 |
| 2018-07-29 21:00:00 | YM | Futures | 27582.9 | 27622.0 | 27576.4 | 27612.3 | 1692.0 |
| 2018-07-29 22:00:00 | YM | Futures | 27612.3 | 27618.8 | 27552.5 | 27563.3 | 1623.0 |
| 2018-07-29 23:00:00 | YM | Futures | 27562.2 | 27587.2 | 27559.0 | 27581.8 | 908.0 |
| 2018-07-29 18:00:00 | CL | Futures | 62.72 | 62.76 | 62.63 | 62.68 | 2188.0 |
| 2018-07-29 19:00:00 | CL | Futures | 62.68 | 62.7 | 62.65 | 62.67 | 938.0 |
| 2018-07-29 20:00:00 | CL | Futures | 62.66 | 62.71 | 62.59 | 62.62 | 3589.0 |
| 2018-07-29 21:00:00 | CL | Futures | 62.62 | 62.68 | 62.56 | 62.67 | 5087.0 |
| 2018-07-29 22:00:00 | CL | Futures | 62.67 | 62.67 | 62.53 | 62.57 | 3347.0 |
| 2018-07-29 23:00:00 | CL | Futures | 62.56 | 62.62 | 62.53 | 62.61 | 9458.0 |
| 2018-07-29 18:00:00 | GC | Futures | 1603.9 | 1606.4 | 1603.8 | 1605.5 | 1201.0 |
| 2018-07-29 19:00:00 | GC | Futures | 1605.4 | 1606.2 | 1603.9 | 1604.5 | 1704.0 |
| 2018-07-29 20:00:00 | GC | Futures | 1604.5 | 1606.4 | 1604.2 | 1604.6 | 3402.0 |
| 2018-07-29 21:00:00 | GC | Futures | 1604.7 | 1605.9 | 1602.5 | 1603.7 | 6453.0 |
| 2018-07-29 22:00:00 | GC | Futures | 1603.7 | 1603.8 | 1600.0 | 1600.9 | 5955.0 |
| 2018-07-29 23:00:00 | GC | Futures | 1600.9 | 1602.1 | 1600.6 | 1601.5 | 4316.0 |
| 2018-07-29 18:00:00 | ZN | Futures | 120.180879 | 120.180879 | 120.102299 | 120.180879 | 9542.0 |
| 2018-07-29 19:00:00 | ZN | Futures | 120.180879 | 120.180879 | 120.149447 | 120.149447 | 5933.0 |
| 2018-07-29 20:00:00 | ZN | Futures | 120.165163 | 120.165163 | 120.133731 | 120.149447 | 14134.0 |
| 2018-07-29 21:00:00 | ZN | Futures | 120.149447 | 120.165163 | 120.118015 | 120.133731 | 5405.0 |
| 2018-07-29 22:00:00 | ZN | Futures | 120.149447 | 120.165163 | 120.133731 | 120.165163 | 4817.0 |
| 2018-07-29 23:00:00 | ZN | Futures | 120.165163 | 120.165163 | 120.149447 | 120.149447 | 850.0 |
> showing 36 of 291 rows — these rows as CSV