PREVIEW / futures_1hour / 2025-08-10
file: by_date/futures_1hour/2025/2025-08-10.parquet size: 19 KB rows: 419
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-08-10 18:00:00 | ES | Futures | 6470.91 | 6473.68 | 6465.87 | 6468.65 | 8194.0 |
| 2025-08-10 19:00:00 | ES | Futures | 6468.65 | 6470.66 | 6461.09 | 6462.85 | 6087.0 |
| 2025-08-10 20:00:00 | ES | Futures | 6462.85 | 6471.42 | 6462.6 | 6469.9 | 5688.0 |
| 2025-08-10 21:00:00 | ES | Futures | 6469.9 | 6476.71 | 6469.15 | 6475.7 | 6120.0 |
| 2025-08-10 22:00:00 | ES | Futures | 6475.95 | 6477.71 | 6473.43 | 6474.44 | 4718.0 |
| 2025-08-10 23:00:00 | ES | Futures | 6474.44 | 6477.46 | 6471.92 | 6473.18 | 3380.0 |
| 2025-08-10 18:00:00 | NQ | Futures | 23970.98 | 23977.78 | 23931.64 | 23938.45 | 5689.0 |
| 2025-08-10 19:00:00 | NQ | Futures | 23938.45 | 23949.04 | 23907.43 | 23914.49 | 3782.0 |
| 2025-08-10 20:00:00 | NQ | Futures | 23914.24 | 23944.25 | 23913.23 | 23939.71 | 4140.0 |
| 2025-08-10 21:00:00 | NQ | Futures | 23939.2 | 23969.72 | 23932.64 | 23965.18 | 4310.0 |
| 2025-08-10 22:00:00 | NQ | Futures | 23964.92 | 23977.53 | 23956.85 | 23963.66 | 3558.0 |
| 2025-08-10 23:00:00 | NQ | Futures | 23963.91 | 23980.05 | 23957.11 | 23961.65 | 3660.0 |
| 2025-08-10 18:00:00 | YM | Futures | 45267.9 | 45322.0 | 45266.9 | 45292.4 | 496.0 |
| 2025-08-10 19:00:00 | YM | Futures | 45294.5 | 45305.7 | 45249.5 | 45267.9 | 431.0 |
| 2025-08-10 20:00:00 | YM | Futures | 45265.9 | 45333.3 | 45264.8 | 45327.1 | 648.0 |
| 2025-08-10 21:00:00 | YM | Futures | 45325.1 | 45371.1 | 45324.1 | 45357.8 | 608.0 |
| 2025-08-10 22:00:00 | YM | Futures | 45359.8 | 45364.9 | 45330.2 | 45335.3 | 349.0 |
| 2025-08-10 23:00:00 | YM | Futures | 45337.4 | 45347.6 | 45311.8 | 45315.9 | 461.0 |
| 2025-08-10 18:00:00 | CL | Futures | 60.87 | 61.08 | 60.56 | 60.97 | 1860.0 |
| 2025-08-10 19:00:00 | CL | Futures | 60.97 | 61.03 | 60.83 | 60.84 | 557.0 |
| 2025-08-10 20:00:00 | CL | Futures | 60.83 | 60.84 | 60.43 | 60.51 | 2432.0 |
| 2025-08-10 21:00:00 | CL | Futures | 60.52 | 60.9 | 60.52 | 60.88 | 2061.0 |
| 2025-08-10 22:00:00 | CL | Futures | 60.88 | 60.94 | 60.78 | 60.91 | 1061.0 |
| 2025-08-10 23:00:00 | CL | Futures | 60.91 | 60.97 | 60.87 | 60.91 | 842.0 |
| 2025-08-10 18:00:00 | GC | Futures | 3512.4 | 3520.8 | 3510.4 | 3514.5 | 4679.0 |
| 2025-08-10 19:00:00 | GC | Futures | 3514.7 | 3516.4 | 3508.9 | 3509.7 | 2496.0 |
| 2025-08-10 20:00:00 | GC | Futures | 3509.9 | 3509.9 | 3497.2 | 3497.8 | 5931.0 |
| 2025-08-10 21:00:00 | GC | Futures | 3498.0 | 3501.7 | 3484.9 | 3496.3 | 10504.0 |
| 2025-08-10 22:00:00 | GC | Futures | 3496.3 | 3497.4 | 3486.2 | 3494.2 | 6027.0 |
| 2025-08-10 23:00:00 | GC | Futures | 3494.2 | 3497.9 | 3490.8 | 3494.3 | 3231.0 |
| 2025-08-10 18:00:00 | ZN | Futures | 111.82793 | 111.859184 | 111.812303 | 111.82793 | 5446.0 |
| 2025-08-10 19:00:00 | ZN | Futures | 111.82793 | 111.890439 | 111.82793 | 111.890439 | 5633.0 |
| 2025-08-10 20:00:00 | ZN | Futures | 111.890439 | 111.906066 | 111.843557 | 111.874812 | 5657.0 |
| 2025-08-10 21:00:00 | ZN | Futures | 111.890439 | 111.906066 | 111.859184 | 111.890439 | 7100.0 |
| 2025-08-10 22:00:00 | ZN | Futures | 111.890439 | 111.906066 | 111.874812 | 111.906066 | 3313.0 |
| 2025-08-10 23:00:00 | ZN | Futures | 111.906066 | 111.93732 | 111.890439 | 111.921693 | 4539.0 |
> showing 36 of 419 rows — these rows as CSV