PREVIEW / futures_1hour / 2025-10-07
file: by_date/futures_1hour/2025/2025-10-07.parquet size: 66 KB rows: 2,089
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-10-07 00:00:00 | ES | Futures | 6832.1 | 6836.89 | 6831.6 | 6836.13 | 3081.0 |
| 2025-10-07 01:00:00 | ES | Futures | 6836.13 | 6836.89 | 6833.11 | 6833.61 | 3537.0 |
| 2025-10-07 02:00:00 | ES | Futures | 6833.61 | 6835.38 | 6826.56 | 6831.6 | 8022.0 |
| 2025-10-07 03:00:00 | ES | Futures | 6831.85 | 6832.6 | 6827.32 | 6830.84 | 10628.0 |
| 2025-10-07 04:00:00 | ES | Futures | 6830.84 | 6834.37 | 6824.8 | 6834.12 | 11709.0 |
| 2025-10-07 05:00:00 | ES | Futures | 6834.12 | 6837.64 | 6833.11 | 6837.14 | 6723.0 |
| 2025-10-07 06:00:00 | ES | Futures | 6837.14 | 6840.41 | 6835.12 | 6836.38 | 8356.0 |
| 2025-10-07 07:00:00 | ES | Futures | 6836.38 | 6842.43 | 6835.63 | 6842.43 | 9002.0 |
| 2025-10-07 08:00:00 | ES | Futures | 6842.43 | 6850.49 | 6839.41 | 6849.73 | 20061.0 |
| 2025-10-07 09:00:00 | ES | Futures | 6849.98 | 6853.76 | 6843.44 | 6844.69 | 133450.0 |
| 2025-10-07 10:00:00 | ES | Futures | 6844.95 | 6846.21 | 6827.57 | 6831.09 | 178320.0 |
| 2025-10-07 11:00:00 | ES | Futures | 6831.35 | 6833.11 | 6797.85 | 6803.64 | 339124.0 |
| 2025-10-07 12:00:00 | ES | Futures | 6803.64 | 6816.99 | 6797.85 | 6805.15 | 169631.0 |
| 2025-10-07 13:00:00 | ES | Futures | 6804.9 | 6815.48 | 6803.14 | 6804.39 | 101767.0 |
| 2025-10-07 14:00:00 | ES | Futures | 6804.65 | 6812.2 | 6799.11 | 6811.95 | 104989.0 |
| 2025-10-07 15:00:00 | ES | Futures | 6811.95 | 6815.98 | 6806.41 | 6813.21 | 183824.0 |
| 2025-10-07 16:00:00 | ES | Futures | 6813.46 | 6818.5 | 6812.96 | 6815.73 | 50431.0 |
| 2025-10-07 18:00:00 | ES | Futures | 6816.74 | 6821.02 | 6815.48 | 6820.26 | 4882.0 |
| 2025-10-07 19:00:00 | ES | Futures | 6820.26 | 6820.26 | 6809.18 | 6810.19 | 6039.0 |
| 2025-10-07 20:00:00 | ES | Futures | 6809.94 | 6816.99 | 6808.93 | 6815.98 | 5689.0 |
| 2025-10-07 21:00:00 | ES | Futures | 6815.73 | 6820.77 | 6815.48 | 6819.26 | 5766.0 |
| 2025-10-07 22:00:00 | ES | Futures | 6819.26 | 6823.29 | 6818.75 | 6822.03 | 4580.0 |
| 2025-10-07 23:00:00 | ES | Futures | 6822.03 | 6823.03 | 6820.26 | 6822.28 | 2554.0 |
| 2025-10-07 00:00:00 | NQ | Futures | 25378.91 | 25403.63 | 25377.4 | 25401.61 | 2229.0 |
| 2025-10-07 01:00:00 | NQ | Futures | 25401.1 | 25406.4 | 25389.25 | 25392.03 | 2175.0 |
| 2025-10-07 02:00:00 | NQ | Futures | 25391.52 | 25398.33 | 25357.73 | 25381.94 | 4357.0 |
| 2025-10-07 03:00:00 | NQ | Futures | 25382.95 | 25385.97 | 25355.96 | 25379.67 | 4739.0 |
| 2025-10-07 04:00:00 | NQ | Futures | 25380.17 | 25393.79 | 25347.39 | 25392.53 | 5081.0 |
| 2025-10-07 05:00:00 | NQ | Futures | 25393.03 | 25412.2 | 25388.75 | 25409.17 | 4188.0 |
| 2025-10-07 06:00:00 | NQ | Futures | 25409.68 | 25415.98 | 25392.53 | 25394.04 | 4419.0 |
| 2025-10-07 07:00:00 | NQ | Futures | 25394.3 | 25432.12 | 25390.01 | 25432.12 | 4664.0 |
| 2025-10-07 08:00:00 | NQ | Futures | 25431.62 | 25478.27 | 25415.98 | 25474.74 | 12192.0 |
| 2025-10-07 09:00:00 | NQ | Futures | 25475.0 | 25495.93 | 25437.42 | 25461.88 | 60265.0 |
| 2025-10-07 10:00:00 | NQ | Futures | 25462.64 | 25478.27 | 25392.28 | 25406.15 | 73518.0 |
| 2025-10-07 11:00:00 | NQ | Futures | 25406.65 | 25411.7 | 25203.14 | 25248.28 | 129185.0 |
| 2025-10-07 12:00:00 | NQ | Futures | 25248.53 | 25311.33 | 25216.51 | 25243.49 | 69832.0 |
| 2025-10-07 13:00:00 | NQ | Futures | 25243.24 | 25284.09 | 25232.14 | 25234.16 | 40652.0 |
| 2025-10-07 14:00:00 | NQ | Futures | 25234.66 | 25272.24 | 25209.44 | 25272.24 | 35609.0 |
| 2025-10-07 15:00:00 | NQ | Futures | 25271.99 | 25292.16 | 25245.76 | 25264.17 | 47754.0 |
| 2025-10-07 16:00:00 | NQ | Futures | 25264.42 | 25288.13 | 25264.17 | 25273.75 | 11980.0 |
| 2025-10-07 18:00:00 | NQ | Futures | 25278.8 | 25302.5 | 25273.5 | 25299.98 | 3275.0 |
| 2025-10-07 19:00:00 | NQ | Futures | 25298.47 | 25299.47 | 25248.28 | 25252.57 | 4161.0 |
| 2025-10-07 20:00:00 | NQ | Futures | 25252.06 | 25285.86 | 25246.26 | 25280.56 | 3791.0 |
| 2025-10-07 21:00:00 | NQ | Futures | 25280.06 | 25304.27 | 25278.04 | 25292.67 | 4553.0 |
| 2025-10-07 22:00:00 | NQ | Futures | 25292.92 | 25311.58 | 25291.4 | 25307.29 | 2723.0 |
| 2025-10-07 23:00:00 | NQ | Futures | 25307.29 | 25310.32 | 25298.47 | 25306.03 | 1811.0 |
| 2025-10-07 00:00:00 | YM | Futures | 47525.3 | 47556.8 | 47522.3 | 47554.8 | 574.0 |
| 2025-10-07 01:00:00 | YM | Futures | 47552.7 | 47555.8 | 47531.4 | 47533.5 | 386.0 |
| 2025-10-07 02:00:00 | YM | Futures | 47531.4 | 47540.6 | 47487.8 | 47532.4 | 1016.0 |
| 2025-10-07 03:00:00 | YM | Futures | 47534.5 | 47539.5 | 47493.9 | 47503.0 | 1104.0 |
> showing 50 of 2,089 rows — these rows as CSV