PREVIEW / futures_1hour / 2025-06-22
file: by_date/futures_1hour/2025/2025-06-22.parquet size: 20 KB rows: 437
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-06-22 18:00:00 | ES | Futures | 6008.72 | 6052.8 | 6003.68 | 6046.0 | 35177.0 |
| 2025-06-22 19:00:00 | ES | Futures | 6045.75 | 6047.51 | 6038.19 | 6044.24 | 7392.0 |
| 2025-06-22 20:00:00 | ES | Futures | 6044.24 | 6044.74 | 6033.91 | 6038.44 | 7749.0 |
| 2025-06-22 21:00:00 | ES | Futures | 6038.7 | 6043.23 | 6034.92 | 6041.21 | 5756.0 |
| 2025-06-22 22:00:00 | ES | Futures | 6041.21 | 6047.51 | 6040.71 | 6045.24 | 4459.0 |
| 2025-06-22 23:00:00 | ES | Futures | 6044.99 | 6048.52 | 6044.24 | 6047.01 | 3178.0 |
| 2025-06-22 18:00:00 | NQ | Futures | 21836.8 | 21976.76 | 21754.59 | 21948.77 | 14484.0 |
| 2025-06-22 19:00:00 | NQ | Futures | 21947.76 | 21960.87 | 21916.23 | 21950.03 | 5371.0 |
| 2025-06-22 20:00:00 | NQ | Futures | 21950.53 | 21950.78 | 21896.06 | 21920.52 | 6672.0 |
| 2025-06-22 21:00:00 | NQ | Futures | 21919.76 | 21942.46 | 21900.1 | 21929.35 | 4255.0 |
| 2025-06-22 22:00:00 | NQ | Futures | 21928.59 | 21961.37 | 21926.83 | 21948.77 | 3837.0 |
| 2025-06-22 23:00:00 | NQ | Futures | 21948.01 | 21963.64 | 21945.23 | 21956.33 | 2210.0 |
| 2025-06-22 18:00:00 | YM | Futures | 43173.7 | 43368.8 | 43004.1 | 43318.7 | 1783.0 |
| 2025-06-22 19:00:00 | YM | Futures | 43312.6 | 43320.8 | 43264.6 | 43303.4 | 728.0 |
| 2025-06-22 20:00:00 | YM | Futures | 43301.4 | 43308.5 | 43237.0 | 43258.5 | 1406.0 |
| 2025-06-22 21:00:00 | YM | Futures | 43255.4 | 43286.0 | 43239.1 | 43276.9 | 741.0 |
| 2025-06-22 22:00:00 | YM | Futures | 43276.9 | 43302.4 | 43269.7 | 43288.1 | 476.0 |
| 2025-06-22 23:00:00 | YM | Futures | 43288.1 | 43308.5 | 43283.0 | 43297.3 | 481.0 |
| 2025-06-22 18:00:00 | CL | Futures | 74.8 | 75.18 | 72.13 | 72.25 | 34992.0 |
| 2025-06-22 19:00:00 | CL | Futures | 72.22 | 72.74 | 72.17 | 72.66 | 7704.0 |
| 2025-06-22 20:00:00 | CL | Futures | 72.65 | 73.03 | 72.51 | 72.76 | 7514.0 |
| 2025-06-22 21:00:00 | CL | Futures | 72.76 | 72.93 | 71.92 | 72.2 | 9605.0 |
| 2025-06-22 22:00:00 | CL | Futures | 72.21 | 72.42 | 71.99 | 72.16 | 5097.0 |
| 2025-06-22 23:00:00 | CL | Futures | 72.14 | 72.28 | 71.83 | 72.2 | 4101.0 |
| 2025-06-22 18:00:00 | GC | Futures | 3513.2 | 3526.8 | 3498.9 | 3506.4 | 12454.0 |
| 2025-06-22 19:00:00 | GC | Futures | 3506.5 | 3508.4 | 3498.9 | 3500.5 | 3764.0 |
| 2025-06-22 20:00:00 | GC | Futures | 3500.6 | 3501.4 | 3484.6 | 3493.3 | 8379.0 |
| 2025-06-22 21:00:00 | GC | Futures | 3493.3 | 3496.0 | 3478.9 | 3482.5 | 8690.0 |
| 2025-06-22 22:00:00 | GC | Futures | 3482.2 | 3492.1 | 3481.9 | 3488.3 | 4150.0 |
| 2025-06-22 23:00:00 | GC | Futures | 3488.2 | 3493.5 | 3487.0 | 3490.3 | 3545.0 |
| 2025-06-22 18:00:00 | ZN | Futures | 111.124708 | 111.140335 | 110.952809 | 111.030945 | 29449.0 |
| 2025-06-22 19:00:00 | ZN | Futures | 111.030945 | 111.046572 | 110.968437 | 110.984064 | 6862.0 |
| 2025-06-22 20:00:00 | ZN | Futures | 110.984064 | 111.030945 | 110.843419 | 110.843419 | 20853.0 |
| 2025-06-22 21:00:00 | ZN | Futures | 110.843419 | 110.874674 | 110.812165 | 110.874674 | 14800.0 |
| 2025-06-22 22:00:00 | ZN | Futures | 110.874674 | 110.905928 | 110.874674 | 110.874674 | 5228.0 |
| 2025-06-22 23:00:00 | ZN | Futures | 110.874674 | 110.905928 | 110.859046 | 110.874674 | 4309.0 |
> showing 36 of 437 rows — these rows as CSV