PREVIEW / futures_1hour / 2025-06-29
file: by_date/futures_1hour/2025/2025-06-29.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 |
|---|---|---|---|---|---|---|---|
| 2025-06-29 18:00:00 | ES | Futures | 6269.92 | 6290.07 | 6269.92 | 6286.04 | 15406.0 |
| 2025-06-29 19:00:00 | ES | Futures | 6285.78 | 6291.83 | 6284.02 | 6284.78 | 9255.0 |
| 2025-06-29 20:00:00 | ES | Futures | 6284.78 | 6288.81 | 6282.51 | 6287.04 | 6389.0 |
| 2025-06-29 21:00:00 | ES | Futures | 6286.79 | 6287.8 | 6283.27 | 6285.53 | 5818.0 |
| 2025-06-29 22:00:00 | ES | Futures | 6285.53 | 6295.61 | 6284.78 | 6293.09 | 8656.0 |
| 2025-06-29 23:00:00 | ES | Futures | 6292.84 | 6296.11 | 6291.58 | 6294.6 | 4218.0 |
| 2025-06-29 18:00:00 | NQ | Futures | 22949.66 | 23041.45 | 22949.66 | 23018.25 | 7661.0 |
| 2025-06-29 19:00:00 | NQ | Futures | 23017.49 | 23045.99 | 23006.9 | 23016.48 | 5297.0 |
| 2025-06-29 20:00:00 | NQ | Futures | 23015.98 | 23041.45 | 23003.12 | 23032.88 | 5035.0 |
| 2025-06-29 21:00:00 | NQ | Futures | 23031.87 | 23035.15 | 23011.44 | 23020.77 | 3948.0 |
| 2025-06-29 22:00:00 | NQ | Futures | 23021.28 | 23072.47 | 23017.49 | 23060.87 | 5892.0 |
| 2025-06-29 23:00:00 | NQ | Futures | 23060.87 | 23079.78 | 23056.08 | 23072.47 | 3436.0 |
| 2025-06-29 18:00:00 | YM | Futures | 45154.5 | 45312.8 | 45154.5 | 45282.2 | 1418.0 |
| 2025-06-29 19:00:00 | YM | Futures | 45278.1 | 45320.0 | 45261.8 | 45266.9 | 615.0 |
| 2025-06-29 20:00:00 | YM | Futures | 45268.9 | 45302.6 | 45260.7 | 45299.6 | 652.0 |
| 2025-06-29 21:00:00 | YM | Futures | 45298.5 | 45309.8 | 45281.2 | 45294.5 | 735.0 |
| 2025-06-29 22:00:00 | YM | Futures | 45292.4 | 45343.5 | 45290.4 | 45323.1 | 662.0 |
| 2025-06-29 23:00:00 | YM | Futures | 45324.1 | 45340.4 | 45316.9 | 45327.1 | 375.0 |
| 2025-06-29 18:00:00 | CL | Futures | 62.47 | 62.53 | 62.07 | 62.12 | 2651.0 |
| 2025-06-29 19:00:00 | CL | Futures | 62.13 | 62.25 | 62.1 | 62.16 | 1012.0 |
| 2025-06-29 20:00:00 | CL | Futures | 62.16 | 62.17 | 61.85 | 62.02 | 2862.0 |
| 2025-06-29 21:00:00 | CL | Futures | 62.02 | 62.2 | 61.99 | 62.17 | 2948.0 |
| 2025-06-29 22:00:00 | CL | Futures | 62.16 | 62.6 | 62.16 | 62.49 | 2902.0 |
| 2025-06-29 23:00:00 | CL | Futures | 62.5 | 62.58 | 62.43 | 62.47 | 1321.0 |
| 2025-06-29 18:00:00 | GC | Futures | 3393.0 | 3402.9 | 3358.0 | 3383.0 | 11872.0 |
| 2025-06-29 19:00:00 | GC | Futures | 3382.9 | 3390.5 | 3381.8 | 3382.8 | 4277.0 |
| 2025-06-29 20:00:00 | GC | Futures | 3382.7 | 3389.0 | 3381.4 | 3383.7 | 3262.0 |
| 2025-06-29 21:00:00 | GC | Futures | 3383.3 | 3396.0 | 3378.0 | 3393.9 | 7315.0 |
| 2025-06-29 22:00:00 | GC | Futures | 3393.9 | 3403.8 | 3393.7 | 3400.5 | 6097.0 |
| 2025-06-29 23:00:00 | GC | Futures | 3400.3 | 3403.2 | 3397.6 | 3399.1 | 2792.0 |
| 2025-06-29 18:00:00 | ZN | Futures | 111.796676 | 111.82793 | 111.702913 | 111.781049 | 11992.0 |
| 2025-06-29 19:00:00 | ZN | Futures | 111.796676 | 111.82793 | 111.781049 | 111.812303 | 5818.0 |
| 2025-06-29 20:00:00 | ZN | Futures | 111.82793 | 111.843557 | 111.796676 | 111.843557 | 6617.0 |
| 2025-06-29 21:00:00 | ZN | Futures | 111.843557 | 111.859184 | 111.796676 | 111.843557 | 7519.0 |
| 2025-06-29 22:00:00 | ZN | Futures | 111.843557 | 111.859184 | 111.796676 | 111.796676 | 8354.0 |
| 2025-06-29 23:00:00 | ZN | Futures | 111.796676 | 111.812303 | 111.765422 | 111.781049 | 7094.0 |
> showing 36 of 422 rows — these rows as CSV