PREVIEW / futures_1hour / 2025-09-07
file: by_date/futures_1hour/2025/2025-09-07.parquet size: 18 KB rows: 415
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-09-07 18:00:00 | ES | Futures | 6532.37 | 6551.26 | 6528.84 | 6547.48 | 14655.0 |
| 2025-09-07 19:00:00 | ES | Futures | 6547.48 | 6554.79 | 6546.98 | 6553.78 | 6937.0 |
| 2025-09-07 20:00:00 | ES | Futures | 6553.78 | 6556.3 | 6548.74 | 6548.99 | 7847.0 |
| 2025-09-07 21:00:00 | ES | Futures | 6548.99 | 6552.52 | 6547.99 | 6550.25 | 5176.0 |
| 2025-09-07 22:00:00 | ES | Futures | 6550.5 | 6551.01 | 6543.96 | 6545.47 | 3650.0 |
| 2025-09-07 23:00:00 | ES | Futures | 6545.22 | 6550.25 | 6545.22 | 6547.99 | 4432.0 |
| 2025-09-07 18:00:00 | NQ | Futures | 23879.69 | 23954.84 | 23856.24 | 23947.52 | 8107.0 |
| 2025-09-07 19:00:00 | NQ | Futures | 23947.52 | 23991.4 | 23947.52 | 23985.1 | 6602.0 |
| 2025-09-07 20:00:00 | NQ | Futures | 23985.35 | 23998.46 | 23970.98 | 23971.73 | 5655.0 |
| 2025-09-07 21:00:00 | NQ | Futures | 23971.73 | 23987.12 | 23963.91 | 23974.25 | 3846.0 |
| 2025-09-07 22:00:00 | NQ | Futures | 23975.26 | 23978.04 | 23942.48 | 23948.03 | 3455.0 |
| 2025-09-07 23:00:00 | NQ | Futures | 23948.03 | 23970.47 | 23948.03 | 23961.14 | 2414.0 |
| 2025-09-07 18:00:00 | YM | Futures | 46456.0 | 46516.3 | 46385.5 | 46498.9 | 1006.0 |
| 2025-09-07 19:00:00 | YM | Futures | 46499.9 | 46542.8 | 46499.9 | 46527.5 | 682.0 |
| 2025-09-07 20:00:00 | YM | Futures | 46523.4 | 46541.8 | 46481.5 | 46482.5 | 669.0 |
| 2025-09-07 21:00:00 | YM | Futures | 46482.5 | 46506.0 | 46475.4 | 46490.7 | 349.0 |
| 2025-09-07 22:00:00 | YM | Futures | 46489.7 | 46491.7 | 46447.8 | 46470.3 | 467.0 |
| 2025-09-07 23:00:00 | YM | Futures | 46472.3 | 46504.0 | 46466.2 | 46487.7 | 342.0 |
| 2025-09-07 18:00:00 | CL | Futures | 60.13 | 60.51 | 59.98 | 60.1 | 4002.0 |
| 2025-09-07 19:00:00 | CL | Futures | 60.09 | 60.35 | 60.05 | 60.34 | 1540.0 |
| 2025-09-07 20:00:00 | CL | Futures | 60.34 | 60.41 | 60.25 | 60.33 | 1455.0 |
| 2025-09-07 21:00:00 | CL | Futures | 60.32 | 60.81 | 60.24 | 60.71 | 4517.0 |
| 2025-09-07 22:00:00 | CL | Futures | 60.72 | 60.76 | 60.62 | 60.73 | 1493.0 |
| 2025-09-07 23:00:00 | CL | Futures | 60.74 | 60.76 | 60.69 | 60.73 | 981.0 |
| 2025-09-07 18:00:00 | GC | Futures | 3692.1 | 3694.5 | 3679.9 | 3689.5 | 15232.0 |
| 2025-09-07 19:00:00 | GC | Futures | 3689.6 | 3691.2 | 3684.4 | 3687.8 | 4568.0 |
| 2025-09-07 20:00:00 | GC | Futures | 3687.9 | 3691.6 | 3684.0 | 3691.5 | 5855.0 |
| 2025-09-07 21:00:00 | GC | Futures | 3691.6 | 3695.0 | 3681.9 | 3688.1 | 10685.0 |
| 2025-09-07 22:00:00 | GC | Futures | 3688.4 | 3693.1 | 3684.8 | 3690.0 | 8104.0 |
| 2025-09-07 23:00:00 | GC | Futures | 3690.0 | 3691.5 | 3683.1 | 3683.8 | 4768.0 |
| 2025-09-07 18:00:00 | ZN | Futures | 113.437527 | 113.453154 | 113.328137 | 113.359391 | 12369.0 |
| 2025-09-07 19:00:00 | ZN | Futures | 113.359391 | 113.375019 | 113.281256 | 113.296883 | 16181.0 |
| 2025-09-07 20:00:00 | ZN | Futures | 113.296883 | 113.31251 | 113.281256 | 113.296883 | 20815.0 |
| 2025-09-07 21:00:00 | ZN | Futures | 113.296883 | 113.296883 | 113.265628 | 113.281256 | 15731.0 |
| 2025-09-07 22:00:00 | ZN | Futures | 113.281256 | 113.296883 | 113.265628 | 113.281256 | 9205.0 |
| 2025-09-07 23:00:00 | ZN | Futures | 113.296883 | 113.296883 | 113.265628 | 113.265628 | 8577.0 |
> showing 36 of 415 rows — these rows as CSV