PREVIEW / futures_1hour / 2025-07-25
file: by_date/futures_1hour/2025/2025-07-25.parquet size: 54 KB rows: 1,636
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-07-25 00:00:00 | ES | Futures | 6466.63 | 6467.13 | 6458.57 | 6459.33 | 4117.0 |
| 2025-07-25 01:00:00 | ES | Futures | 6459.58 | 6461.84 | 6459.33 | 6460.84 | 2603.0 |
| 2025-07-25 02:00:00 | ES | Futures | 6460.59 | 6462.6 | 6456.3 | 6456.81 | 4516.0 |
| 2025-07-25 03:00:00 | ES | Futures | 6457.06 | 6457.81 | 6450.76 | 6452.78 | 12062.0 |
| 2025-07-25 04:00:00 | ES | Futures | 6452.53 | 6456.05 | 6449.0 | 6454.29 | 8201.0 |
| 2025-07-25 05:00:00 | ES | Futures | 6454.29 | 6456.56 | 6451.77 | 6455.55 | 4469.0 |
| 2025-07-25 06:00:00 | ES | Futures | 6455.8 | 6458.07 | 6453.53 | 6457.31 | 4975.0 |
| 2025-07-25 07:00:00 | ES | Futures | 6457.31 | 6457.31 | 6452.02 | 6453.53 | 6079.0 |
| 2025-07-25 08:00:00 | ES | Futures | 6453.53 | 6458.32 | 6452.53 | 6455.04 | 12371.0 |
| 2025-07-25 09:00:00 | ES | Futures | 6455.04 | 6458.57 | 6450.01 | 6454.79 | 111003.0 |
| 2025-07-25 10:00:00 | ES | Futures | 6454.79 | 6464.11 | 6450.76 | 6460.84 | 107384.0 |
| 2025-07-25 11:00:00 | ES | Futures | 6460.84 | 6463.61 | 6458.57 | 6461.84 | 66252.0 |
| 2025-07-25 12:00:00 | ES | Futures | 6461.84 | 6472.68 | 6460.33 | 6471.42 | 77381.0 |
| 2025-07-25 13:00:00 | ES | Futures | 6471.42 | 6476.96 | 6469.65 | 6474.44 | 54572.0 |
| 2025-07-25 14:00:00 | ES | Futures | 6474.69 | 6478.72 | 6472.93 | 6475.45 | 56575.0 |
| 2025-07-25 15:00:00 | ES | Futures | 6475.19 | 6479.22 | 6469.4 | 6473.93 | 160565.0 |
| 2025-07-25 16:00:00 | ES | Futures | 6473.93 | 6476.96 | 6469.9 | 6476.45 | 53608.0 |
| 2025-07-25 00:00:00 | NQ | Futures | 23632.55 | 23635.83 | 23596.24 | 23601.54 | 3155.0 |
| 2025-07-25 01:00:00 | NQ | Futures | 23601.54 | 23613.39 | 23599.27 | 23611.62 | 1993.0 |
| 2025-07-25 02:00:00 | NQ | Futures | 23611.88 | 23616.41 | 23592.71 | 23594.48 | 2549.0 |
| 2025-07-25 03:00:00 | NQ | Futures | 23595.23 | 23597.75 | 23558.41 | 23569.76 | 7539.0 |
| 2025-07-25 04:00:00 | NQ | Futures | 23570.52 | 23584.89 | 23552.11 | 23578.59 | 5794.0 |
| 2025-07-25 05:00:00 | NQ | Futures | 23579.09 | 23580.86 | 23559.67 | 23577.58 | 3370.0 |
| 2025-07-25 06:00:00 | NQ | Futures | 23577.83 | 23594.98 | 23574.05 | 23591.45 | 3352.0 |
| 2025-07-25 07:00:00 | NQ | Futures | 23591.7 | 23592.71 | 23564.21 | 23568.75 | 4457.0 |
| 2025-07-25 08:00:00 | NQ | Futures | 23568.75 | 23590.19 | 23562.95 | 23574.81 | 7462.0 |
| 2025-07-25 09:00:00 | NQ | Futures | 23574.81 | 23611.88 | 23533.95 | 23592.96 | 64295.0 |
| 2025-07-25 10:00:00 | NQ | Futures | 23593.21 | 23627.51 | 23587.67 | 23609.1 | 62024.0 |
| 2025-07-25 11:00:00 | NQ | Futures | 23609.1 | 23633.31 | 23596.49 | 23624.99 | 39047.0 |
| 2025-07-25 12:00:00 | NQ | Futures | 23624.99 | 23680.47 | 23619.94 | 23654.75 | 44682.0 |
| 2025-07-25 13:00:00 | NQ | Futures | 23654.49 | 23659.28 | 23636.08 | 23643.15 | 28971.0 |
| 2025-07-25 14:00:00 | NQ | Futures | 23643.65 | 23664.08 | 23628.01 | 23647.18 | 30638.0 |
| 2025-07-25 15:00:00 | NQ | Futures | 23647.18 | 23659.79 | 23612.13 | 23626.75 | 44543.0 |
| 2025-07-25 16:00:00 | NQ | Futures | 23626.75 | 23652.98 | 23610.87 | 23651.97 | 18185.0 |
| 2025-07-25 00:00:00 | YM | Futures | 45994.2 | 45996.3 | 45942.1 | 45945.2 | 379.0 |
| 2025-07-25 01:00:00 | YM | Futures | 45947.2 | 45955.4 | 45928.9 | 45937.0 | 323.0 |
| 2025-07-25 02:00:00 | YM | Futures | 45936.0 | 45956.4 | 45905.4 | 45907.4 | 663.0 |
| 2025-07-25 03:00:00 | YM | Futures | 45908.4 | 45915.6 | 45870.6 | 45887.0 | 1618.0 |
| 2025-07-25 04:00:00 | YM | Futures | 45889.0 | 45935.0 | 45884.9 | 45919.7 | 1372.0 |
| 2025-07-25 05:00:00 | YM | Futures | 45919.7 | 45943.2 | 45904.3 | 45927.8 | 495.0 |
| 2025-07-25 06:00:00 | YM | Futures | 45926.8 | 45938.0 | 45904.3 | 45923.7 | 1111.0 |
| 2025-07-25 07:00:00 | YM | Futures | 45923.7 | 45925.8 | 45879.8 | 45899.2 | 824.0 |
| 2025-07-25 08:00:00 | YM | Futures | 45899.2 | 45946.2 | 45889.0 | 45916.6 | 1343.0 |
| 2025-07-25 09:00:00 | YM | Futures | 45914.5 | 45956.4 | 45852.2 | 45873.7 | 11199.0 |
| 2025-07-25 10:00:00 | YM | Futures | 45874.7 | 45982.0 | 45784.8 | 45937.0 | 13758.0 |
| 2025-07-25 11:00:00 | YM | Futures | 45938.0 | 45966.6 | 45878.8 | 45895.1 | 6907.0 |
| 2025-07-25 12:00:00 | YM | Futures | 45896.2 | 45976.9 | 45883.9 | 45969.7 | 4769.0 |
| 2025-07-25 13:00:00 | YM | Futures | 45969.7 | 46052.5 | 45957.5 | 46045.3 | 4764.0 |
| 2025-07-25 14:00:00 | YM | Futures | 46046.3 | 46083.1 | 46033.1 | 46054.5 | 4586.0 |
| 2025-07-25 15:00:00 | YM | Futures | 46053.5 | 46099.5 | 46033.1 | 46057.6 | 8660.0 |
> showing 50 of 1,636 rows — these rows as CSV