PREVIEW / futures_1hour / 2025-08-17
file: by_date/futures_1hour/2025/2025-08-17.parquet size: 19 KB rows: 423
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-17 18:00:00 | ES | Futures | 6515.49 | 6528.59 | 6514.74 | 6527.84 | 6793.0 |
| 2025-08-17 19:00:00 | ES | Futures | 6527.84 | 6531.36 | 6526.32 | 6529.1 | 3462.0 |
| 2025-08-17 20:00:00 | ES | Futures | 6529.1 | 6531.61 | 6528.09 | 6528.84 | 4786.0 |
| 2025-08-17 21:00:00 | ES | Futures | 6528.84 | 6532.87 | 6528.09 | 6532.87 | 4052.0 |
| 2025-08-17 22:00:00 | ES | Futures | 6532.62 | 6532.87 | 6529.85 | 6531.11 | 2353.0 |
| 2025-08-17 23:00:00 | ES | Futures | 6531.11 | 6532.37 | 6528.34 | 6529.1 | 2516.0 |
| 2025-08-17 18:00:00 | NQ | Futures | 24002.25 | 24061.26 | 24002.25 | 24055.46 | 4039.0 |
| 2025-08-17 19:00:00 | NQ | Futures | 24055.71 | 24067.81 | 24048.14 | 24058.73 | 2831.0 |
| 2025-08-17 20:00:00 | NQ | Futures | 24058.48 | 24074.87 | 24053.44 | 24064.79 | 3027.0 |
| 2025-08-17 21:00:00 | NQ | Futures | 24065.04 | 24089.5 | 24063.02 | 24089.5 | 2839.0 |
| 2025-08-17 22:00:00 | NQ | Futures | 24088.99 | 24089.75 | 24075.63 | 24085.46 | 1844.0 |
| 2025-08-17 23:00:00 | NQ | Futures | 24085.21 | 24087.48 | 24063.78 | 24065.54 | 1604.0 |
| 2025-08-17 18:00:00 | YM | Futures | 46000.4 | 46061.7 | 45988.1 | 46057.6 | 573.0 |
| 2025-08-17 19:00:00 | YM | Futures | 46057.6 | 46081.1 | 46051.4 | 46065.7 | 260.0 |
| 2025-08-17 20:00:00 | YM | Futures | 46065.7 | 46083.1 | 46061.7 | 46071.9 | 455.0 |
| 2025-08-17 21:00:00 | YM | Futures | 46068.8 | 46089.2 | 46060.6 | 46085.2 | 445.0 |
| 2025-08-17 22:00:00 | YM | Futures | 46086.2 | 46086.2 | 46065.7 | 46068.8 | 180.0 |
| 2025-08-17 23:00:00 | YM | Futures | 46069.8 | 46081.1 | 46062.7 | 46069.8 | 136.0 |
| 2025-08-17 18:00:00 | CL | Futures | 60.31 | 60.31 | 59.79 | 59.96 | 2360.0 |
| 2025-08-17 19:00:00 | CL | Futures | 59.95 | 59.97 | 59.87 | 59.88 | 757.0 |
| 2025-08-17 20:00:00 | CL | Futures | 59.89 | 60.12 | 59.85 | 60.1 | 1630.0 |
| 2025-08-17 21:00:00 | CL | Futures | 60.1 | 60.13 | 59.84 | 60.09 | 2458.0 |
| 2025-08-17 22:00:00 | CL | Futures | 60.11 | 60.15 | 60.03 | 60.08 | 1464.0 |
| 2025-08-17 23:00:00 | CL | Futures | 60.09 | 60.22 | 60.0 | 60.19 | 1461.0 |
| 2025-08-17 18:00:00 | GC | Futures | 3435.5 | 3437.7 | 3430.5 | 3432.5 | 1741.0 |
| 2025-08-17 19:00:00 | GC | Futures | 3432.4 | 3432.4 | 3420.9 | 3424.8 | 5300.0 |
| 2025-08-17 20:00:00 | GC | Futures | 3425.0 | 3440.9 | 3424.5 | 3438.5 | 5743.0 |
| 2025-08-17 21:00:00 | GC | Futures | 3438.4 | 3446.2 | 3438.0 | 3445.8 | 4631.0 |
| 2025-08-17 22:00:00 | GC | Futures | 3445.6 | 3446.8 | 3440.7 | 3441.7 | 2309.0 |
| 2025-08-17 23:00:00 | GC | Futures | 3441.8 | 3451.4 | 3441.7 | 3446.3 | 4447.0 |
| 2025-08-17 18:00:00 | ZN | Futures | 111.656031 | 111.687286 | 111.60915 | 111.671659 | 4704.0 |
| 2025-08-17 19:00:00 | ZN | Futures | 111.687286 | 111.687286 | 111.640404 | 111.687286 | 5268.0 |
| 2025-08-17 20:00:00 | ZN | Futures | 111.687286 | 111.734167 | 111.656031 | 111.71854 | 12008.0 |
| 2025-08-17 21:00:00 | ZN | Futures | 111.734167 | 111.749794 | 111.702913 | 111.749794 | 9309.0 |
| 2025-08-17 22:00:00 | ZN | Futures | 111.734167 | 111.749794 | 111.71854 | 111.71854 | 5855.0 |
| 2025-08-17 23:00:00 | ZN | Futures | 111.71854 | 111.749794 | 111.71854 | 111.749794 | 3939.0 |
> showing 36 of 423 rows — these rows as CSV