PREVIEW / futures_1hour / 2025-11-02
file: by_date/futures_1hour/2025/2025-11-02.parquet size: 19 KB rows: 452
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-02 18:00:00 | ES | Futures | 6929.58 | 6946.7 | 6928.32 | 6944.18 | 13253.0 |
| 2025-11-02 19:00:00 | ES | Futures | 6944.18 | 6950.23 | 6943.68 | 6949.98 | 7648.0 |
| 2025-11-02 20:00:00 | ES | Futures | 6949.98 | 6950.99 | 6942.93 | 6943.18 | 8614.0 |
| 2025-11-02 21:00:00 | ES | Futures | 6943.18 | 6947.71 | 6938.9 | 6940.15 | 8151.0 |
| 2025-11-02 22:00:00 | ES | Futures | 6940.15 | 6940.66 | 6932.35 | 6937.89 | 7630.0 |
| 2025-11-02 23:00:00 | ES | Futures | 6937.64 | 6939.65 | 6935.37 | 6938.64 | 3627.0 |
| 2025-11-02 18:00:00 | NQ | Futures | 26255.76 | 26320.82 | 26240.13 | 26308.72 | 7380.0 |
| 2025-11-02 19:00:00 | NQ | Futures | 26309.73 | 26346.3 | 26306.7 | 26344.28 | 4797.0 |
| 2025-11-02 20:00:00 | NQ | Futures | 26344.53 | 26351.34 | 26315.53 | 26317.55 | 5439.0 |
| 2025-11-02 21:00:00 | NQ | Futures | 26316.79 | 26342.76 | 26297.88 | 26310.99 | 4726.0 |
| 2025-11-02 22:00:00 | NQ | Futures | 26310.99 | 26312.75 | 26278.46 | 26303.93 | 3742.0 |
| 2025-11-02 23:00:00 | NQ | Futures | 26303.42 | 26314.27 | 26293.08 | 26313.26 | 2300.0 |
| 2025-11-02 18:00:00 | YM | Futures | 48408.6 | 48514.1 | 48402.6 | 48498.9 | 848.0 |
| 2025-11-02 19:00:00 | YM | Futures | 48499.9 | 48544.5 | 48493.8 | 48541.5 | 708.0 |
| 2025-11-02 20:00:00 | YM | Futures | 48540.5 | 48543.5 | 48483.7 | 48488.8 | 1159.0 |
| 2025-11-02 21:00:00 | YM | Futures | 48487.7 | 48507.0 | 48460.4 | 48465.4 | 757.0 |
| 2025-11-02 22:00:00 | YM | Futures | 48467.5 | 48468.5 | 48419.8 | 48444.1 | 782.0 |
| 2025-11-02 23:00:00 | YM | Futures | 48443.1 | 48462.4 | 48426.9 | 48453.3 | 413.0 |
| 2025-11-02 18:00:00 | CL | Futures | 60.25 | 60.33 | 59.99 | 60.25 | 5698.0 |
| 2025-11-02 19:00:00 | CL | Futures | 60.25 | 60.27 | 60.08 | 60.12 | 1551.0 |
| 2025-11-02 20:00:00 | CL | Futures | 60.13 | 60.3 | 59.96 | 60.03 | 2350.0 |
| 2025-11-02 21:00:00 | CL | Futures | 60.03 | 60.21 | 60.02 | 60.11 | 1254.0 |
| 2025-11-02 22:00:00 | CL | Futures | 60.1 | 60.13 | 59.99 | 60.13 | 701.0 |
| 2025-11-02 23:00:00 | CL | Futures | 60.12 | 60.13 | 59.96 | 59.99 | 676.0 |
| 2025-11-02 18:00:00 | GC | Futures | 4063.9 | 4072.2 | 4050.7 | 4052.4 | 8175.0 |
| 2025-11-02 19:00:00 | GC | Futures | 4052.7 | 4061.1 | 4033.7 | 4043.4 | 10713.0 |
| 2025-11-02 20:00:00 | GC | Futures | 4043.4 | 4074.5 | 4036.9 | 4069.0 | 12037.0 |
| 2025-11-02 21:00:00 | GC | Futures | 4068.5 | 4080.1 | 4062.8 | 4077.6 | 6514.0 |
| 2025-11-02 22:00:00 | GC | Futures | 4077.9 | 4088.6 | 4075.7 | 4084.5 | 5864.0 |
| 2025-11-02 23:00:00 | GC | Futures | 4084.6 | 4087.8 | 4074.7 | 4076.3 | 4651.0 |
| 2025-11-02 18:00:00 | ZN | Futures | 112.765625 | 112.84375 | 112.75 | 112.75 | 11725.0 |
| 2025-11-02 19:00:00 | ZN | Futures | 112.765625 | 112.78125 | 112.734375 | 112.765625 | 6337.0 |
| 2025-11-02 20:00:00 | ZN | Futures | 112.765625 | 112.796875 | 112.765625 | 112.78125 | 5785.0 |
| 2025-11-02 21:00:00 | ZN | Futures | 112.765625 | 112.78125 | 112.71875 | 112.71875 | 6311.0 |
| 2025-11-02 22:00:00 | ZN | Futures | 112.734375 | 112.75 | 112.703125 | 112.703125 | 6592.0 |
| 2025-11-02 23:00:00 | ZN | Futures | 112.71875 | 112.734375 | 112.703125 | 112.71875 | 7232.0 |
> showing 36 of 452 rows — these rows as CSV