PREVIEW / futures_1hour / 2025-07-29
file: by_date/futures_1hour/2025/2025-07-29.parquet size: 66 KB rows: 2,087
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-29 00:00:00 | ES | Futures | 6479.48 | 6481.74 | 6478.72 | 6479.98 | 2466.0 |
| 2025-07-29 01:00:00 | ES | Futures | 6479.98 | 6482.5 | 6479.48 | 6480.99 | 1959.0 |
| 2025-07-29 02:00:00 | ES | Futures | 6481.24 | 6483.0 | 6476.96 | 6477.46 | 4544.0 |
| 2025-07-29 03:00:00 | ES | Futures | 6477.71 | 6487.79 | 6477.46 | 6486.02 | 10711.0 |
| 2025-07-29 04:00:00 | ES | Futures | 6486.28 | 6487.79 | 6483.76 | 6485.02 | 7284.0 |
| 2025-07-29 05:00:00 | ES | Futures | 6485.27 | 6489.05 | 6484.51 | 6488.29 | 10403.0 |
| 2025-07-29 06:00:00 | ES | Futures | 6488.29 | 6489.8 | 6486.78 | 6488.54 | 7702.0 |
| 2025-07-29 07:00:00 | ES | Futures | 6488.54 | 6490.81 | 6483.51 | 6486.53 | 10186.0 |
| 2025-07-29 08:00:00 | ES | Futures | 6486.78 | 6488.54 | 6480.74 | 6482.5 | 13335.0 |
| 2025-07-29 09:00:00 | ES | Futures | 6482.25 | 6488.29 | 6473.68 | 6480.99 | 129797.0 |
| 2025-07-29 10:00:00 | ES | Futures | 6481.24 | 6482.75 | 6466.38 | 6468.39 | 139516.0 |
| 2025-07-29 11:00:00 | ES | Futures | 6468.39 | 6471.42 | 6447.99 | 6460.33 | 201607.0 |
| 2025-07-29 12:00:00 | ES | Futures | 6460.08 | 6463.61 | 6452.02 | 6463.1 | 102085.0 |
| 2025-07-29 13:00:00 | ES | Futures | 6463.1 | 6467.39 | 6450.26 | 6457.06 | 113327.0 |
| 2025-07-29 14:00:00 | ES | Futures | 6457.31 | 6459.83 | 6452.53 | 6454.54 | 77039.0 |
| 2025-07-29 15:00:00 | ES | Futures | 6454.29 | 6457.31 | 6444.21 | 6454.04 | 187573.0 |
| 2025-07-29 16:00:00 | ES | Futures | 6454.29 | 6455.3 | 6450.01 | 6451.52 | 35673.0 |
| 2025-07-29 18:00:00 | ES | Futures | 6452.02 | 6457.31 | 6451.27 | 6455.55 | 4646.0 |
| 2025-07-29 19:00:00 | ES | Futures | 6455.8 | 6457.56 | 6453.78 | 6455.8 | 2407.0 |
| 2025-07-29 20:00:00 | ES | Futures | 6455.8 | 6461.09 | 6455.04 | 6460.08 | 4531.0 |
| 2025-07-29 21:00:00 | ES | Futures | 6460.08 | 6462.1 | 6455.8 | 6460.33 | 4098.0 |
| 2025-07-29 22:00:00 | ES | Futures | 6460.33 | 6462.1 | 6458.57 | 6460.84 | 3070.0 |
| 2025-07-29 23:00:00 | ES | Futures | 6460.84 | 6463.61 | 6460.84 | 6461.84 | 3123.0 |
| 2025-07-29 00:00:00 | NQ | Futures | 23748.81 | 23757.13 | 23744.27 | 23747.8 | 1702.0 |
| 2025-07-29 01:00:00 | NQ | Futures | 23747.04 | 23759.15 | 23746.03 | 23752.34 | 1107.0 |
| 2025-07-29 02:00:00 | NQ | Futures | 23752.84 | 23760.16 | 23746.54 | 23750.32 | 2748.0 |
| 2025-07-29 03:00:00 | NQ | Futures | 23750.57 | 23804.03 | 23750.07 | 23793.95 | 7333.0 |
| 2025-07-29 04:00:00 | NQ | Futures | 23793.7 | 23798.74 | 23780.83 | 23787.9 | 4769.0 |
| 2025-07-29 05:00:00 | NQ | Futures | 23788.15 | 23812.61 | 23785.12 | 23804.79 | 5172.0 |
| 2025-07-29 06:00:00 | NQ | Futures | 23804.03 | 23814.63 | 23797.73 | 23804.54 | 5322.0 |
| 2025-07-29 07:00:00 | NQ | Futures | 23804.54 | 23812.36 | 23783.86 | 23805.8 | 6486.0 |
| 2025-07-29 08:00:00 | NQ | Futures | 23806.3 | 23819.17 | 23777.81 | 23784.36 | 8704.0 |
| 2025-07-29 09:00:00 | NQ | Futures | 23784.62 | 23858.5 | 23760.91 | 23786.38 | 79775.0 |
| 2025-07-29 10:00:00 | NQ | Futures | 23793.95 | 23798.99 | 23719.3 | 23733.17 | 81326.0 |
| 2025-07-29 11:00:00 | NQ | Futures | 23732.42 | 23747.55 | 23642.39 | 23708.46 | 91832.0 |
| 2025-07-29 12:00:00 | NQ | Futures | 23708.46 | 23718.55 | 23652.73 | 23711.99 | 52708.0 |
| 2025-07-29 13:00:00 | NQ | Futures | 23712.24 | 23730.65 | 23666.35 | 23696.1 | 48800.0 |
| 2025-07-29 14:00:00 | NQ | Futures | 23696.1 | 23712.24 | 23672.15 | 23683.49 | 36656.0 |
| 2025-07-29 15:00:00 | NQ | Futures | 23682.74 | 23690.55 | 23625.24 | 23661.05 | 66258.0 |
| 2025-07-29 16:00:00 | NQ | Futures | 23661.55 | 23666.85 | 23649.7 | 23656.26 | 13974.0 |
| 2025-07-29 18:00:00 | NQ | Futures | 23656.26 | 23679.21 | 23653.48 | 23674.92 | 3224.0 |
| 2025-07-29 19:00:00 | NQ | Futures | 23674.92 | 23686.02 | 23669.62 | 23679.46 | 2496.0 |
| 2025-07-29 20:00:00 | NQ | Futures | 23679.21 | 23695.35 | 23675.93 | 23690.81 | 2906.0 |
| 2025-07-29 21:00:00 | NQ | Futures | 23690.05 | 23698.37 | 23670.63 | 23689.8 | 3172.0 |
| 2025-07-29 22:00:00 | NQ | Futures | 23690.55 | 23701.15 | 23684.75 | 23698.12 | 2379.0 |
| 2025-07-29 23:00:00 | NQ | Futures | 23698.37 | 23711.49 | 23697.62 | 23703.16 | 2037.0 |
| 2025-07-29 00:00:00 | YM | Futures | 46023.9 | 46049.4 | 46023.9 | 46041.2 | 395.0 |
| 2025-07-29 01:00:00 | YM | Futures | 46039.2 | 46063.7 | 46039.2 | 46055.5 | 312.0 |
| 2025-07-29 02:00:00 | YM | Futures | 46055.5 | 46069.8 | 45994.2 | 46000.4 | 782.0 |
| 2025-07-29 03:00:00 | YM | Futures | 46002.4 | 46063.7 | 45997.3 | 46056.5 | 2006.0 |
> showing 50 of 2,087 rows — these rows as CSV