PREVIEW / futures_1hour / 2025-09-28
file: by_date/futures_1hour/2025/2025-09-28.parquet size: 19 KB rows: 422
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-28 18:00:00 | ES | Futures | 6747.22 | 6756.03 | 6746.97 | 6753.26 | 6498.0 |
| 2025-09-28 19:00:00 | ES | Futures | 6753.01 | 6757.8 | 6752.51 | 6756.03 | 4836.0 |
| 2025-09-28 20:00:00 | ES | Futures | 6756.03 | 6763.84 | 6754.27 | 6761.32 | 8602.0 |
| 2025-09-28 21:00:00 | ES | Futures | 6761.32 | 6763.59 | 6757.29 | 6761.58 | 7002.0 |
| 2025-09-28 22:00:00 | ES | Futures | 6761.58 | 6765.1 | 6760.06 | 6764.85 | 4566.0 |
| 2025-09-28 23:00:00 | ES | Futures | 6764.6 | 6767.12 | 6763.84 | 6766.11 | 3740.0 |
| 2025-09-28 18:00:00 | NQ | Futures | 24942.63 | 24986.26 | 24937.84 | 24972.39 | 5335.0 |
| 2025-09-28 19:00:00 | NQ | Futures | 24971.63 | 24994.33 | 24971.63 | 24988.28 | 3651.0 |
| 2025-09-28 20:00:00 | NQ | Futures | 24989.03 | 25023.84 | 24981.47 | 25010.22 | 5400.0 |
| 2025-09-28 21:00:00 | NQ | Futures | 25009.97 | 25021.82 | 24991.56 | 25010.47 | 5111.0 |
| 2025-09-28 22:00:00 | NQ | Futures | 25009.71 | 25030.64 | 25002.9 | 25030.39 | 3013.0 |
| 2025-09-28 23:00:00 | NQ | Futures | 25029.89 | 25034.93 | 25021.57 | 25031.4 | 2017.0 |
| 2025-09-28 18:00:00 | YM | Futures | 47222.1 | 47265.7 | 47218.1 | 47249.5 | 378.0 |
| 2025-09-28 19:00:00 | YM | Futures | 47248.5 | 47279.9 | 47246.5 | 47266.8 | 235.0 |
| 2025-09-28 20:00:00 | YM | Futures | 47265.7 | 47302.2 | 47251.5 | 47289.1 | 1050.0 |
| 2025-09-28 21:00:00 | YM | Futures | 47289.1 | 47311.4 | 47269.8 | 47308.3 | 522.0 |
| 2025-09-28 22:00:00 | YM | Futures | 47302.2 | 47324.6 | 47297.2 | 47319.5 | 333.0 |
| 2025-09-28 23:00:00 | YM | Futures | 47322.5 | 47342.8 | 47315.4 | 47329.6 | 497.0 |
| 2025-09-28 18:00:00 | CL | Futures | 63.39 | 63.46 | 63.2 | 63.43 | 2396.0 |
| 2025-09-28 19:00:00 | CL | Futures | 63.43 | 63.5 | 63.32 | 63.46 | 1058.0 |
| 2025-09-28 20:00:00 | CL | Futures | 63.45 | 63.47 | 63.35 | 63.46 | 1230.0 |
| 2025-09-28 21:00:00 | CL | Futures | 63.46 | 63.59 | 63.37 | 63.42 | 1866.0 |
| 2025-09-28 22:00:00 | CL | Futures | 63.42 | 63.65 | 63.36 | 63.6 | 1702.0 |
| 2025-09-28 23:00:00 | CL | Futures | 63.6 | 63.65 | 63.51 | 63.56 | 1113.0 |
| 2025-09-28 18:00:00 | GC | Futures | 3848.3 | 3860.2 | 3845.0 | 3859.8 | 4730.0 |
| 2025-09-28 19:00:00 | GC | Futures | 3859.7 | 3861.3 | 3854.7 | 3855.5 | 3115.0 |
| 2025-09-28 20:00:00 | GC | Futures | 3855.4 | 3876.4 | 3852.5 | 3876.0 | 9230.0 |
| 2025-09-28 21:00:00 | GC | Futures | 3875.9 | 3877.7 | 3855.8 | 3867.8 | 16418.0 |
| 2025-09-28 22:00:00 | GC | Futures | 3867.6 | 3887.9 | 3866.1 | 3882.1 | 13311.0 |
| 2025-09-28 23:00:00 | GC | Futures | 3882.3 | 3888.6 | 3881.5 | 3884.2 | 6143.0 |
| 2025-09-28 18:00:00 | ZN | Futures | 112.28125 | 112.375 | 112.265625 | 112.34375 | 8831.0 |
| 2025-09-28 19:00:00 | ZN | Futures | 112.34375 | 112.390625 | 112.328125 | 112.375 | 6552.0 |
| 2025-09-28 20:00:00 | ZN | Futures | 112.375 | 112.421875 | 112.359375 | 112.421875 | 8854.0 |
| 2025-09-28 21:00:00 | ZN | Futures | 112.421875 | 112.4375 | 112.390625 | 112.40625 | 12237.0 |
| 2025-09-28 22:00:00 | ZN | Futures | 112.421875 | 112.421875 | 112.390625 | 112.40625 | 4317.0 |
| 2025-09-28 23:00:00 | ZN | Futures | 112.40625 | 112.421875 | 112.40625 | 112.421875 | 2275.0 |
> showing 36 of 422 rows — these rows as CSV