PREVIEW / futures_1hour / 2025-09-29
file: by_date/futures_1hour/2025/2025-09-29.parquet size: 61 KB rows: 2,040
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-29 00:00:00 | ES | Futures | 6766.36 | 6769.38 | 6765.86 | 6767.62 | 3613.0 |
| 2025-09-29 01:00:00 | ES | Futures | 6767.62 | 6770.39 | 6766.61 | 6767.37 | 4395.0 |
| 2025-09-29 02:00:00 | ES | Futures | 6767.37 | 6775.18 | 6765.35 | 6772.41 | 10069.0 |
| 2025-09-29 03:00:00 | ES | Futures | 6772.66 | 6776.94 | 6767.37 | 6774.42 | 14157.0 |
| 2025-09-29 04:00:00 | ES | Futures | 6774.17 | 6781.98 | 6773.41 | 6781.47 | 12142.0 |
| 2025-09-29 05:00:00 | ES | Futures | 6781.73 | 6784.75 | 6779.21 | 6779.46 | 11689.0 |
| 2025-09-29 06:00:00 | ES | Futures | 6779.46 | 6786.51 | 6778.45 | 6783.74 | 11575.0 |
| 2025-09-29 07:00:00 | ES | Futures | 6783.74 | 6784.5 | 6773.92 | 6778.7 | 18616.0 |
| 2025-09-29 08:00:00 | ES | Futures | 6778.7 | 6785.25 | 6776.18 | 6783.74 | 19689.0 |
| 2025-09-29 09:00:00 | ES | Futures | 6783.74 | 6786.26 | 6766.11 | 6774.17 | 149738.0 |
| 2025-09-29 10:00:00 | ES | Futures | 6774.17 | 6781.73 | 6768.88 | 6773.67 | 150565.0 |
| 2025-09-29 11:00:00 | ES | Futures | 6773.67 | 6775.68 | 6756.54 | 6761.32 | 160439.0 |
| 2025-09-29 12:00:00 | ES | Futures | 6761.32 | 6766.36 | 6756.54 | 6758.81 | 95112.0 |
| 2025-09-29 13:00:00 | ES | Futures | 6758.81 | 6759.31 | 6749.74 | 6757.55 | 101318.0 |
| 2025-09-29 14:00:00 | ES | Futures | 6757.55 | 6764.35 | 6757.29 | 6761.83 | 68929.0 |
| 2025-09-29 15:00:00 | ES | Futures | 6762.08 | 6766.61 | 6746.46 | 6764.6 | 227411.0 |
| 2025-09-29 16:00:00 | ES | Futures | 6764.6 | 6766.36 | 6757.04 | 6758.81 | 46779.0 |
| 2025-09-29 18:00:00 | ES | Futures | 6758.3 | 6764.35 | 6757.55 | 6763.84 | 3661.0 |
| 2025-09-29 19:00:00 | ES | Futures | 6763.84 | 6765.35 | 6761.07 | 6761.58 | 2587.0 |
| 2025-09-29 20:00:00 | ES | Futures | 6761.58 | 6765.86 | 6757.04 | 6765.1 | 6169.0 |
| 2025-09-29 21:00:00 | ES | Futures | 6764.85 | 6764.85 | 6757.8 | 6760.06 | 5849.0 |
| 2025-09-29 22:00:00 | ES | Futures | 6760.06 | 6766.36 | 6759.06 | 6765.1 | 4104.0 |
| 2025-09-29 23:00:00 | ES | Futures | 6765.35 | 6767.37 | 6762.84 | 6763.84 | 4196.0 |
| 2025-09-29 00:00:00 | NQ | Futures | 25031.91 | 25051.32 | 25030.14 | 25045.27 | 2831.0 |
| 2025-09-29 01:00:00 | NQ | Futures | 25045.52 | 25054.85 | 25038.46 | 25042.75 | 2528.0 |
| 2025-09-29 02:00:00 | NQ | Futures | 25043.25 | 25072.76 | 25030.39 | 25061.92 | 4975.0 |
| 2025-09-29 03:00:00 | NQ | Futures | 25062.17 | 25081.59 | 25040.23 | 25070.74 | 6345.0 |
| 2025-09-29 04:00:00 | NQ | Futures | 25069.99 | 25112.35 | 25068.22 | 25111.09 | 6484.0 |
| 2025-09-29 05:00:00 | NQ | Futures | 25112.1 | 25116.39 | 25088.9 | 25089.4 | 4773.0 |
| 2025-09-29 06:00:00 | NQ | Futures | 25089.4 | 25119.92 | 25082.59 | 25106.05 | 4418.0 |
| 2025-09-29 07:00:00 | NQ | Futures | 25107.31 | 25111.34 | 25070.99 | 25093.94 | 7797.0 |
| 2025-09-29 08:00:00 | NQ | Futures | 25093.94 | 25127.23 | 25081.59 | 25117.65 | 10475.0 |
| 2025-09-29 09:00:00 | NQ | Futures | 25116.89 | 25173.63 | 25063.68 | 25160.02 | 71270.0 |
| 2025-09-29 10:00:00 | NQ | Futures | 25160.02 | 25193.81 | 25135.3 | 25146.9 | 70285.0 |
| 2025-09-29 11:00:00 | NQ | Futures | 25147.15 | 25160.77 | 25047.79 | 25066.46 | 76613.0 |
| 2025-09-29 12:00:00 | NQ | Futures | 25066.2 | 25084.86 | 25038.97 | 25051.83 | 47132.0 |
| 2025-09-29 13:00:00 | NQ | Futures | 25052.08 | 25066.46 | 25017.03 | 25061.92 | 41998.0 |
| 2025-09-29 14:00:00 | NQ | Futures | 25062.17 | 25087.39 | 25051.32 | 25060.15 | 32175.0 |
| 2025-09-29 15:00:00 | NQ | Futures | 25059.9 | 25065.45 | 24997.1 | 25054.35 | 72757.0 |
| 2025-09-29 16:00:00 | NQ | Futures | 25054.6 | 25063.43 | 25022.07 | 25028.12 | 13730.0 |
| 2025-09-29 18:00:00 | NQ | Futures | 25034.68 | 25054.85 | 25024.59 | 25050.82 | 2767.0 |
| 2025-09-29 19:00:00 | NQ | Futures | 25051.83 | 25059.14 | 25038.46 | 25040.98 | 2172.0 |
| 2025-09-29 20:00:00 | NQ | Futures | 25039.47 | 25057.63 | 25022.57 | 25054.35 | 3627.0 |
| 2025-09-29 21:00:00 | NQ | Futures | 25053.59 | 25054.1 | 25027.62 | 25036.45 | 2877.0 |
| 2025-09-29 22:00:00 | NQ | Futures | 25036.45 | 25071.25 | 25034.18 | 25066.46 | 2571.0 |
| 2025-09-29 23:00:00 | NQ | Futures | 25066.2 | 25074.02 | 25056.12 | 25059.9 | 2241.0 |
| 2025-09-29 00:00:00 | YM | Futures | 47329.6 | 47351.9 | 47325.6 | 47337.7 | 373.0 |
| 2025-09-29 01:00:00 | YM | Futures | 47338.8 | 47349.9 | 47319.5 | 47321.5 | 491.0 |
| 2025-09-29 02:00:00 | YM | Futures | 47323.5 | 47384.4 | 47316.4 | 47366.1 | 910.0 |
| 2025-09-29 03:00:00 | YM | Futures | 47368.2 | 47403.7 | 47325.6 | 47375.3 | 1113.0 |
> showing 50 of 2,040 rows — these rows as CSV