PREVIEW / futures_1hour / 2025-10-06
file: by_date/futures_1hour/2025/2025-10-06.parquet size: 64 KB rows: 2,080
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-06 00:00:00 | ES | Futures | 6834.12 | 6838.4 | 6830.09 | 6836.89 | 5050.0 |
| 2025-10-06 01:00:00 | ES | Futures | 6836.89 | 6837.14 | 6832.1 | 6833.36 | 3198.0 |
| 2025-10-06 02:00:00 | ES | Futures | 6833.36 | 6836.63 | 6831.35 | 6835.38 | 6533.0 |
| 2025-10-06 03:00:00 | ES | Futures | 6835.38 | 6835.88 | 6822.53 | 6829.08 | 17306.0 |
| 2025-10-06 04:00:00 | ES | Futures | 6829.08 | 6835.63 | 6828.83 | 6833.36 | 11088.0 |
| 2025-10-06 05:00:00 | ES | Futures | 6833.61 | 6839.91 | 6832.6 | 6839.41 | 7948.0 |
| 2025-10-06 06:00:00 | ES | Futures | 6839.41 | 6844.69 | 6837.14 | 6840.66 | 14512.0 |
| 2025-10-06 07:00:00 | ES | Futures | 6840.41 | 6840.92 | 6832.35 | 6838.9 | 18574.0 |
| 2025-10-06 08:00:00 | ES | Futures | 6839.15 | 6844.95 | 6833.36 | 6833.36 | 27869.0 |
| 2025-10-06 09:00:00 | ES | Futures | 6833.36 | 6841.17 | 6821.77 | 6823.29 | 156765.0 |
| 2025-10-06 10:00:00 | ES | Futures | 6823.03 | 6831.6 | 6817.24 | 6830.84 | 165709.0 |
| 2025-10-06 11:00:00 | ES | Futures | 6830.59 | 6842.68 | 6830.09 | 6841.42 | 107371.0 |
| 2025-10-06 12:00:00 | ES | Futures | 6841.17 | 6842.18 | 6836.13 | 6840.66 | 77005.0 |
| 2025-10-06 13:00:00 | ES | Futures | 6840.66 | 6846.96 | 6836.63 | 6846.21 | 90354.0 |
| 2025-10-06 14:00:00 | ES | Futures | 6845.95 | 6848.72 | 6843.18 | 6844.44 | 72669.0 |
| 2025-10-06 15:00:00 | ES | Futures | 6844.19 | 6844.69 | 6838.9 | 6839.41 | 171314.0 |
| 2025-10-06 16:00:00 | ES | Futures | 6839.41 | 6842.43 | 6837.89 | 6841.17 | 56562.0 |
| 2025-10-06 18:00:00 | ES | Futures | 6840.41 | 6843.94 | 6828.07 | 6829.33 | 7099.0 |
| 2025-10-06 19:00:00 | ES | Futures | 6829.58 | 6832.35 | 6827.06 | 6829.33 | 5742.0 |
| 2025-10-06 20:00:00 | ES | Futures | 6829.08 | 6830.84 | 6826.06 | 6828.07 | 6796.0 |
| 2025-10-06 21:00:00 | ES | Futures | 6828.07 | 6831.09 | 6826.06 | 6830.84 | 4629.0 |
| 2025-10-06 22:00:00 | ES | Futures | 6830.84 | 6832.35 | 6829.08 | 6831.09 | 2612.0 |
| 2025-10-06 23:00:00 | ES | Futures | 6830.84 | 6833.11 | 6829.83 | 6832.1 | 2192.0 |
| 2025-10-06 00:00:00 | NQ | Futures | 25308.3 | 25328.73 | 25287.37 | 25320.91 | 2823.0 |
| 2025-10-06 01:00:00 | NQ | Futures | 25320.91 | 25322.17 | 25299.22 | 25307.8 | 1945.0 |
| 2025-10-06 02:00:00 | NQ | Futures | 25307.8 | 25326.71 | 25301.24 | 25320.91 | 2349.0 |
| 2025-10-06 03:00:00 | NQ | Futures | 25320.41 | 25325.7 | 25264.42 | 25299.47 | 7378.0 |
| 2025-10-06 04:00:00 | NQ | Futures | 25300.48 | 25334.28 | 25297.46 | 25326.21 | 5171.0 |
| 2025-10-06 05:00:00 | NQ | Futures | 25325.95 | 25359.24 | 25323.68 | 25354.2 | 3917.0 |
| 2025-10-06 06:00:00 | NQ | Futures | 25354.2 | 25405.14 | 25343.86 | 25391.27 | 8319.0 |
| 2025-10-06 07:00:00 | NQ | Futures | 25391.02 | 25406.15 | 25348.15 | 25404.38 | 10362.0 |
| 2025-10-06 08:00:00 | NQ | Futures | 25405.14 | 25462.13 | 25399.09 | 25411.44 | 14611.0 |
| 2025-10-06 09:00:00 | NQ | Futures | 25411.95 | 25442.21 | 25336.29 | 25375.38 | 67248.0 |
| 2025-10-06 10:00:00 | NQ | Futures | 25375.89 | 25405.14 | 25327.97 | 25372.1 | 65863.0 |
| 2025-10-06 11:00:00 | NQ | Futures | 25371.85 | 25436.41 | 25362.77 | 25428.34 | 43433.0 |
| 2025-10-06 12:00:00 | NQ | Futures | 25428.09 | 25431.87 | 25402.87 | 25422.54 | 27783.0 |
| 2025-10-06 13:00:00 | NQ | Futures | 25422.79 | 25452.3 | 25403.12 | 25448.01 | 33550.0 |
| 2025-10-06 14:00:00 | NQ | Futures | 25448.26 | 25473.48 | 25438.93 | 25459.36 | 30507.0 |
| 2025-10-06 15:00:00 | NQ | Futures | 25458.86 | 25459.61 | 25400.6 | 25404.38 | 51801.0 |
| 2025-10-06 16:00:00 | NQ | Futures | 25404.38 | 25410.18 | 25394.04 | 25404.13 | 13744.0 |
| 2025-10-06 18:00:00 | NQ | Futures | 25404.64 | 25417.24 | 25354.96 | 25361.01 | 4802.0 |
| 2025-10-06 19:00:00 | NQ | Futures | 25361.01 | 25372.86 | 25350.92 | 25361.76 | 3451.0 |
| 2025-10-06 20:00:00 | NQ | Futures | 25361.01 | 25367.31 | 25342.09 | 25350.67 | 3742.0 |
| 2025-10-06 21:00:00 | NQ | Futures | 25351.17 | 25368.57 | 25345.88 | 25366.56 | 2931.0 |
| 2025-10-06 22:00:00 | NQ | Futures | 25367.56 | 25374.37 | 25358.74 | 25371.35 | 2135.0 |
| 2025-10-06 23:00:00 | NQ | Futures | 25371.35 | 25384.21 | 25367.31 | 25379.16 | 2235.0 |
| 2025-10-06 00:00:00 | YM | Futures | 47791.0 | 47827.6 | 47765.7 | 47817.4 | 716.0 |
| 2025-10-06 01:00:00 | YM | Futures | 47817.4 | 47817.4 | 47782.9 | 47785.0 | 464.0 |
| 2025-10-06 02:00:00 | YM | Futures | 47785.0 | 47796.1 | 47766.7 | 47792.1 | 790.0 |
| 2025-10-06 03:00:00 | YM | Futures | 47793.1 | 47796.1 | 47711.9 | 47746.4 | 2574.0 |
> showing 50 of 2,080 rows — these rows as CSV