PREVIEW / futures_1hour / 2023-10-01
file: by_date/futures_1hour/2023/2023-10-01.parquet size: 19 KB rows: 422
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 |
|---|---|---|---|---|---|---|---|
| 2023-10-01 18:00:00 | ES | Futures | 4724.03 | 4729.46 | 4711.81 | 4715.34 | 29421.0 |
| 2023-10-01 19:00:00 | ES | Futures | 4715.34 | 4721.04 | 4713.71 | 4719.14 | 13710.0 |
| 2023-10-01 20:00:00 | ES | Futures | 4719.14 | 4726.47 | 4718.87 | 4722.4 | 14771.0 |
| 2023-10-01 21:00:00 | ES | Futures | 4722.4 | 4727.56 | 4722.13 | 4725.93 | 8089.0 |
| 2023-10-01 22:00:00 | ES | Futures | 4725.93 | 4728.65 | 4725.12 | 4725.66 | 8153.0 |
| 2023-10-01 23:00:00 | ES | Futures | 4725.93 | 4727.02 | 4723.21 | 4724.03 | 4476.0 |
| 2023-10-01 18:00:00 | NQ | Futures | 16441.4 | 16490.84 | 16408.16 | 16417.5 | 12723.0 |
| 2023-10-01 19:00:00 | NQ | Futures | 16417.5 | 16438.1 | 16407.61 | 16428.49 | 4385.0 |
| 2023-10-01 20:00:00 | NQ | Futures | 16428.76 | 16460.08 | 16426.02 | 16441.67 | 6997.0 |
| 2023-10-01 21:00:00 | NQ | Futures | 16441.95 | 16470.51 | 16439.75 | 16460.35 | 5090.0 |
| 2023-10-01 22:00:00 | NQ | Futures | 16460.63 | 16473.53 | 16456.51 | 16458.15 | 4323.0 |
| 2023-10-01 23:00:00 | NQ | Futures | 16458.43 | 16461.45 | 16447.72 | 16453.48 | 3010.0 |
| 2023-10-01 18:00:00 | YM | Futures | 36765.8 | 36781.0 | 36673.6 | 36715.9 | 2854.0 |
| 2023-10-01 19:00:00 | YM | Futures | 36718.1 | 36759.3 | 36710.5 | 36749.5 | 1377.0 |
| 2023-10-01 20:00:00 | YM | Futures | 36748.5 | 36797.3 | 36746.3 | 36771.2 | 2287.0 |
| 2023-10-01 21:00:00 | YM | Futures | 36772.3 | 36798.4 | 36770.2 | 36786.4 | 1349.0 |
| 2023-10-01 22:00:00 | YM | Futures | 36785.3 | 36803.8 | 36779.9 | 36785.3 | 958.0 |
| 2023-10-01 23:00:00 | YM | Futures | 36785.3 | 36795.1 | 36764.7 | 36769.1 | 979.0 |
| 2023-10-01 18:00:00 | CL | Futures | 75.05 | 75.39 | 75.05 | 75.33 | 2003.0 |
| 2023-10-01 19:00:00 | CL | Futures | 75.31 | 75.35 | 75.24 | 75.28 | 619.0 |
| 2023-10-01 20:00:00 | CL | Futures | 75.28 | 75.33 | 75.17 | 75.17 | 1165.0 |
| 2023-10-01 21:00:00 | CL | Futures | 75.17 | 75.31 | 75.05 | 75.24 | 1740.0 |
| 2023-10-01 22:00:00 | CL | Futures | 75.25 | 75.28 | 75.21 | 75.25 | 603.0 |
| 2023-10-01 23:00:00 | CL | Futures | 75.25 | 75.35 | 75.24 | 75.28 | 944.0 |
| 2023-10-01 18:00:00 | GC | Futures | 2082.5 | 2082.8 | 2078.9 | 2080.0 | 3086.0 |
| 2023-10-01 19:00:00 | GC | Futures | 2080.0 | 2082.1 | 2079.7 | 2081.9 | 1747.0 |
| 2023-10-01 20:00:00 | GC | Futures | 2082.0 | 2082.6 | 2078.2 | 2078.7 | 2722.0 |
| 2023-10-01 21:00:00 | GC | Futures | 2078.6 | 2080.9 | 2076.7 | 2077.1 | 2948.0 |
| 2023-10-01 22:00:00 | GC | Futures | 2077.0 | 2078.3 | 2076.0 | 2077.3 | 2928.0 |
| 2023-10-01 23:00:00 | GC | Futures | 2077.3 | 2078.4 | 2076.7 | 2076.8 | 1354.0 |
| 2023-10-01 18:00:00 | ZN | Futures | 109.561385 | 109.608993 | 109.370954 | 109.418562 | 35880.0 |
| 2023-10-01 19:00:00 | ZN | Futures | 109.418562 | 109.482039 | 109.386823 | 109.46617 | 11221.0 |
| 2023-10-01 20:00:00 | ZN | Futures | 109.4503 | 109.46617 | 109.355085 | 109.418562 | 19059.0 |
| 2023-10-01 21:00:00 | ZN | Futures | 109.402693 | 109.4503 | 109.402693 | 109.434431 | 9219.0 |
| 2023-10-01 22:00:00 | ZN | Futures | 109.434431 | 109.4503 | 109.402693 | 109.418562 | 3823.0 |
| 2023-10-01 23:00:00 | ZN | Futures | 109.402693 | 109.46617 | 109.402693 | 109.46617 | 6331.0 |
> showing 36 of 422 rows — these rows as CSV