PREVIEW / futures_1hour / 2026-08-09
file: by_date/futures_1hour/2026/2026-08-09.parquet size: 19 KB rows: 478
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 |
|---|---|---|---|---|---|---|---|
| 2026-08-09 18:00:00 | ES | Futures | 7776.75 | 7779.25 | 7763.0 | 7768.5 | 8637.0 |
| 2026-08-09 19:00:00 | ES | Futures | 7769.0 | 7773.25 | 7766.75 | 7767.0 | 4870.0 |
| 2026-08-09 20:00:00 | ES | Futures | 7767.0 | 7778.0 | 7765.25 | 7770.75 | 8833.0 |
| 2026-08-09 21:00:00 | ES | Futures | 7770.75 | 7781.5 | 7769.75 | 7780.5 | 6624.0 |
| 2026-08-09 22:00:00 | ES | Futures | 7780.5 | 7783.25 | 7777.5 | 7782.25 | 3526.0 |
| 2026-08-09 23:00:00 | ES | Futures | 7782.0 | 7786.25 | 7780.5 | 7783.75 | 3576.0 |
| 2026-08-09 18:00:00 | NQ | Futures | 29851.25 | 29896.75 | 29805.25 | 29844.25 | 7755.0 |
| 2026-08-09 19:00:00 | NQ | Futures | 29845.25 | 29882.25 | 29828.25 | 29829.5 | 4678.0 |
| 2026-08-09 20:00:00 | NQ | Futures | 29830.25 | 29906.5 | 29788.5 | 29802.0 | 9614.0 |
| 2026-08-09 21:00:00 | NQ | Futures | 29803.25 | 29895.0 | 29791.0 | 29885.0 | 6151.0 |
| 2026-08-09 22:00:00 | NQ | Futures | 29886.0 | 29899.5 | 29848.25 | 29880.25 | 3612.0 |
| 2026-08-09 23:00:00 | NQ | Futures | 29881.25 | 29899.0 | 29869.25 | 29878.0 | 2625.0 |
| 2026-08-09 18:00:00 | YM | Futures | 54133.0 | 54133.0 | 54004.0 | 54035.0 | 458.0 |
| 2026-08-09 19:00:00 | YM | Futures | 54040.0 | 54050.0 | 54002.0 | 54007.0 | 202.0 |
| 2026-08-09 20:00:00 | YM | Futures | 54004.0 | 54057.0 | 54000.0 | 54055.0 | 624.0 |
| 2026-08-09 21:00:00 | YM | Futures | 54055.0 | 54085.0 | 54049.0 | 54065.0 | 404.0 |
| 2026-08-09 22:00:00 | YM | Futures | 54070.0 | 54099.0 | 54061.0 | 54084.0 | 246.0 |
| 2026-08-09 23:00:00 | YM | Futures | 54085.0 | 54107.0 | 54077.0 | 54094.0 | 226.0 |
| 2026-08-09 18:00:00 | CL | Futures | 78.42 | 79.43 | 78.32 | 78.85 | 6195.0 |
| 2026-08-09 19:00:00 | CL | Futures | 78.85 | 78.93 | 78.6 | 78.77 | 1159.0 |
| 2026-08-09 20:00:00 | CL | Futures | 78.76 | 78.96 | 78.5 | 78.66 | 2163.0 |
| 2026-08-09 21:00:00 | CL | Futures | 78.65 | 79.16 | 78.18 | 78.88 | 3473.0 |
| 2026-08-09 22:00:00 | CL | Futures | 78.88 | 79.01 | 78.59 | 78.82 | 1138.0 |
| 2026-08-09 23:00:00 | CL | Futures | 78.85 | 78.86 | 78.55 | 78.81 | 961.0 |
| 2026-08-09 18:00:00 | GC | Futures | 4400.0 | 4411.5 | 4392.1 | 4400.2 | 2157.0 |
| 2026-08-09 19:00:00 | GC | Futures | 4400.4 | 4408.0 | 4390.8 | 4392.0 | 1568.0 |
| 2026-08-09 20:00:00 | GC | Futures | 4391.9 | 4406.0 | 4389.8 | 4391.3 | 1990.0 |
| 2026-08-09 21:00:00 | GC | Futures | 4391.5 | 4400.0 | 4373.9 | 4383.0 | 7647.0 |
| 2026-08-09 22:00:00 | GC | Futures | 4382.8 | 4392.5 | 4379.0 | 4380.0 | 3270.0 |
| 2026-08-09 23:00:00 | GC | Futures | 4379.6 | 4390.3 | 4377.4 | 4387.3 | 2127.0 |
| 2026-08-09 18:00:00 | ZN | Futures | 108.640625 | 108.640625 | 108.578125 | 108.609375 | 12949.0 |
| 2026-08-09 19:00:00 | ZN | Futures | 108.625 | 108.640625 | 108.609375 | 108.609375 | 5042.0 |
| 2026-08-09 20:00:00 | ZN | Futures | 108.609375 | 108.625 | 108.53125 | 108.578125 | 22638.0 |
| 2026-08-09 21:00:00 | ZN | Futures | 108.59375 | 108.625 | 108.5625 | 108.625 | 12839.0 |
| 2026-08-09 22:00:00 | ZN | Futures | 108.625 | 108.640625 | 108.609375 | 108.625 | 4140.0 |
| 2026-08-09 23:00:00 | ZN | Futures | 108.625 | 108.65625 | 108.625 | 108.640625 | 8880.0 |
> showing 36 of 478 rows — these rows as CSV