PREVIEW / futures_1hour / 2025-11-09
file: by_date/futures_1hour/2025/2025-11-09.parquet size: 20 KB rows: 456
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-11-09 18:00:00 | ES | Futures | 6838.9 | 6846.46 | 6829.08 | 6836.13 | 19015.0 |
| 2025-11-09 19:00:00 | ES | Futures | 6835.88 | 6838.4 | 6822.78 | 6834.37 | 17733.0 |
| 2025-11-09 20:00:00 | ES | Futures | 6834.12 | 6848.98 | 6833.61 | 6848.22 | 19716.0 |
| 2025-11-09 21:00:00 | ES | Futures | 6847.97 | 6850.74 | 6844.19 | 6847.72 | 8928.0 |
| 2025-11-09 22:00:00 | ES | Futures | 6847.47 | 6855.02 | 6847.47 | 6849.73 | 9500.0 |
| 2025-11-09 23:00:00 | ES | Futures | 6849.48 | 6854.77 | 6849.48 | 6851.75 | 6853.0 |
| 2025-11-09 18:00:00 | NQ | Futures | 25542.08 | 25613.44 | 25518.62 | 25556.7 | 10232.0 |
| 2025-11-09 19:00:00 | NQ | Futures | 25557.46 | 25567.04 | 25489.87 | 25552.16 | 10678.0 |
| 2025-11-09 20:00:00 | NQ | Futures | 25550.65 | 25659.34 | 25547.62 | 25650.77 | 13286.0 |
| 2025-11-09 21:00:00 | NQ | Futures | 25651.02 | 25671.45 | 25631.1 | 25654.3 | 5288.0 |
| 2025-11-09 22:00:00 | NQ | Futures | 25654.05 | 25711.8 | 25653.54 | 25683.55 | 7518.0 |
| 2025-11-09 23:00:00 | NQ | Futures | 25683.3 | 25708.77 | 25677.75 | 25688.34 | 4655.0 |
| 2025-11-09 18:00:00 | YM | Futures | 47874.2 | 48013.1 | 47862.0 | 47892.5 | 974.0 |
| 2025-11-09 19:00:00 | YM | Futures | 47891.4 | 47894.5 | 47834.7 | 47874.2 | 1825.0 |
| 2025-11-09 20:00:00 | YM | Futures | 47871.2 | 47873.2 | 47810.3 | 47849.9 | 3509.0 |
| 2025-11-09 21:00:00 | YM | Futures | 47848.9 | 47874.2 | 47837.7 | 47842.8 | 1195.0 |
| 2025-11-09 22:00:00 | YM | Futures | 47843.8 | 47868.1 | 47810.3 | 47810.3 | 1110.0 |
| 2025-11-09 23:00:00 | YM | Futures | 47810.3 | 47842.8 | 47809.3 | 47824.5 | 817.0 |
| 2025-11-09 18:00:00 | CL | Futures | 58.75 | 58.85 | 58.62 | 58.78 | 1539.0 |
| 2025-11-09 19:00:00 | CL | Futures | 58.77 | 58.87 | 58.64 | 58.84 | 910.0 |
| 2025-11-09 20:00:00 | CL | Futures | 58.84 | 59.12 | 58.84 | 58.96 | 2773.0 |
| 2025-11-09 21:00:00 | CL | Futures | 58.95 | 59.07 | 58.91 | 59.07 | 1473.0 |
| 2025-11-09 22:00:00 | CL | Futures | 59.07 | 59.14 | 59.05 | 59.06 | 1715.0 |
| 2025-11-09 23:00:00 | CL | Futures | 59.06 | 59.15 | 59.06 | 59.1 | 1178.0 |
| 2025-11-09 18:00:00 | GC | Futures | 4070.1 | 4083.6 | 4067.1 | 4082.6 | 5488.0 |
| 2025-11-09 19:00:00 | GC | Futures | 4082.8 | 4095.4 | 4082.3 | 4091.6 | 6556.0 |
| 2025-11-09 20:00:00 | GC | Futures | 4091.2 | 4125.8 | 4090.1 | 4116.6 | 18248.0 |
| 2025-11-09 21:00:00 | GC | Futures | 4116.5 | 4121.6 | 4109.9 | 4120.5 | 7516.0 |
| 2025-11-09 22:00:00 | GC | Futures | 4120.5 | 4125.5 | 4117.2 | 4122.5 | 4996.0 |
| 2025-11-09 23:00:00 | GC | Futures | 4122.3 | 4129.8 | 4122.3 | 4126.6 | 4218.0 |
| 2025-11-09 18:00:00 | ZN | Futures | 112.71875 | 112.71875 | 112.609375 | 112.625 | 33200.0 |
| 2025-11-09 19:00:00 | ZN | Futures | 112.640625 | 112.671875 | 112.609375 | 112.609375 | 22772.0 |
| 2025-11-09 20:00:00 | ZN | Futures | 112.625 | 112.65625 | 112.609375 | 112.65625 | 14045.0 |
| 2025-11-09 21:00:00 | ZN | Futures | 112.640625 | 112.65625 | 112.609375 | 112.609375 | 11100.0 |
| 2025-11-09 22:00:00 | ZN | Futures | 112.609375 | 112.625 | 112.546875 | 112.59375 | 16937.0 |
| 2025-11-09 23:00:00 | ZN | Futures | 112.59375 | 112.59375 | 112.5625 | 112.5625 | 7416.0 |
> showing 36 of 456 rows — these rows as CSV