PREVIEW / futures_1hour / 2025-08-24
file: by_date/futures_1hour/2025/2025-08-24.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-24 18:00:00 | ES | Futures | 6541.69 | 6542.7 | 6527.58 | 6531.87 | 7031.0 |
| 2025-08-24 19:00:00 | ES | Futures | 6531.87 | 6535.39 | 6529.35 | 6531.61 | 4243.0 |
| 2025-08-24 20:00:00 | ES | Futures | 6531.87 | 6535.9 | 6526.32 | 6527.84 | 6698.0 |
| 2025-08-24 21:00:00 | ES | Futures | 6527.84 | 6528.59 | 6523.05 | 6523.05 | 4971.0 |
| 2025-08-24 22:00:00 | ES | Futures | 6523.05 | 6525.82 | 6520.28 | 6520.53 | 5911.0 |
| 2025-08-24 23:00:00 | ES | Futures | 6520.28 | 6526.83 | 6520.03 | 6526.32 | 7297.0 |
| 2025-08-24 18:00:00 | NQ | Futures | 23807.56 | 23813.11 | 23750.07 | 23777.81 | 5722.0 |
| 2025-08-24 19:00:00 | NQ | Futures | 23776.55 | 23794.7 | 23766.46 | 23780.08 | 4293.0 |
| 2025-08-24 20:00:00 | NQ | Futures | 23780.58 | 23803.53 | 23755.11 | 23761.42 | 5580.0 |
| 2025-08-24 21:00:00 | NQ | Futures | 23760.91 | 23763.69 | 23738.97 | 23739.22 | 3473.0 |
| 2025-08-24 22:00:00 | NQ | Futures | 23740.74 | 23755.11 | 23727.12 | 23729.64 | 4056.0 |
| 2025-08-24 23:00:00 | NQ | Futures | 23728.63 | 23757.38 | 23725.36 | 23752.59 | 3436.0 |
| 2025-08-24 18:00:00 | YM | Futures | 46707.3 | 46753.3 | 46683.8 | 46699.1 | 850.0 |
| 2025-08-24 19:00:00 | YM | Futures | 46701.2 | 46721.6 | 46687.9 | 46700.1 | 391.0 |
| 2025-08-24 20:00:00 | YM | Futures | 46702.2 | 46718.5 | 46667.4 | 46678.7 | 599.0 |
| 2025-08-24 21:00:00 | YM | Futures | 46679.7 | 46683.8 | 46634.8 | 46646.0 | 608.0 |
| 2025-08-24 22:00:00 | YM | Futures | 46646.0 | 46661.3 | 46620.5 | 46621.5 | 750.0 |
| 2025-08-24 23:00:00 | YM | Futures | 46621.5 | 46653.1 | 46615.3 | 46648.0 | 563.0 |
| 2025-08-24 18:00:00 | CL | Futures | 61.95 | 61.96 | 61.8 | 61.82 | 792.0 |
| 2025-08-24 19:00:00 | CL | Futures | 61.82 | 61.85 | 61.81 | 61.82 | 177.0 |
| 2025-08-24 20:00:00 | CL | Futures | 61.83 | 61.88 | 61.81 | 61.87 | 625.0 |
| 2025-08-24 21:00:00 | CL | Futures | 61.87 | 61.88 | 61.61 | 61.7 | 1995.0 |
| 2025-08-24 22:00:00 | CL | Futures | 61.7 | 61.95 | 61.68 | 61.8 | 2111.0 |
| 2025-08-24 23:00:00 | CL | Futures | 61.8 | 61.87 | 61.76 | 61.87 | 890.0 |
| 2025-08-24 18:00:00 | GC | Futures | 3471.3 | 3471.5 | 3465.3 | 3466.7 | 2176.0 |
| 2025-08-24 19:00:00 | GC | Futures | 3466.7 | 3470.6 | 3465.8 | 3468.5 | 2284.0 |
| 2025-08-24 20:00:00 | GC | Futures | 3468.4 | 3469.2 | 3462.3 | 3463.7 | 3242.0 |
| 2025-08-24 21:00:00 | GC | Futures | 3463.8 | 3466.8 | 3459.0 | 3461.3 | 4115.0 |
| 2025-08-24 22:00:00 | GC | Futures | 3461.4 | 3463.8 | 3459.1 | 3463.0 | 3701.0 |
| 2025-08-24 23:00:00 | GC | Futures | 3463.0 | 3466.7 | 3462.7 | 3465.9 | 2106.0 |
| 2025-08-24 18:00:00 | ZN | Futures | 112.1561 | 112.171728 | 112.124846 | 112.140473 | 6447.0 |
| 2025-08-24 19:00:00 | ZN | Futures | 112.140473 | 112.140473 | 112.093592 | 112.124846 | 9876.0 |
| 2025-08-24 20:00:00 | ZN | Futures | 112.109219 | 112.124846 | 112.062337 | 112.093592 | 20432.0 |
| 2025-08-24 21:00:00 | ZN | Futures | 112.093592 | 112.109219 | 112.077965 | 112.077965 | 10890.0 |
| 2025-08-24 22:00:00 | ZN | Futures | 112.093592 | 112.093592 | 112.04671 | 112.062337 | 7546.0 |
| 2025-08-24 23:00:00 | ZN | Futures | 112.077965 | 112.093592 | 112.062337 | 112.062337 | 7281.0 |
> showing 36 of 419 rows — these rows as CSV