PREVIEW / futures_1hour / 2025-10-21
file: by_date/futures_1hour/2025/2025-10-21.parquet size: 64 KB rows: 2,039
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-21 00:00:00 | ES | Futures | 6828.57 | 6828.57 | 6822.28 | 6824.54 | 4471.0 |
| 2025-10-21 01:00:00 | ES | Futures | 6824.8 | 6826.81 | 6818.25 | 6822.28 | 6139.0 |
| 2025-10-21 02:00:00 | ES | Futures | 6822.53 | 6822.53 | 6815.23 | 6818.25 | 8214.0 |
| 2025-10-21 03:00:00 | ES | Futures | 6818.5 | 6820.01 | 6814.72 | 6817.74 | 10349.0 |
| 2025-10-21 04:00:00 | ES | Futures | 6818.0 | 6819.26 | 6813.97 | 6815.48 | 10450.0 |
| 2025-10-21 05:00:00 | ES | Futures | 6815.48 | 6821.77 | 6814.97 | 6819.26 | 9339.0 |
| 2025-10-21 06:00:00 | ES | Futures | 6819.51 | 6822.78 | 6815.98 | 6822.03 | 12754.0 |
| 2025-10-21 07:00:00 | ES | Futures | 6821.77 | 6827.32 | 6820.26 | 6826.81 | 16034.0 |
| 2025-10-21 08:00:00 | ES | Futures | 6826.81 | 6828.57 | 6823.54 | 6824.8 | 16656.0 |
| 2025-10-21 09:00:00 | ES | Futures | 6824.8 | 6828.32 | 6812.2 | 6815.98 | 147601.0 |
| 2025-10-21 10:00:00 | ES | Futures | 6815.98 | 6837.14 | 6809.94 | 6836.63 | 239283.0 |
| 2025-10-21 11:00:00 | ES | Futures | 6836.38 | 6838.15 | 6824.54 | 6833.61 | 161872.0 |
| 2025-10-21 12:00:00 | ES | Futures | 6833.36 | 6840.66 | 6824.04 | 6825.55 | 140831.0 |
| 2025-10-21 13:00:00 | ES | Futures | 6825.55 | 6833.86 | 6818.0 | 6832.6 | 130656.0 |
| 2025-10-21 14:00:00 | ES | Futures | 6832.86 | 6835.88 | 6828.32 | 6830.34 | 98090.0 |
| 2025-10-21 15:00:00 | ES | Futures | 6830.09 | 6834.87 | 6822.28 | 6822.78 | 148930.0 |
| 2025-10-21 16:00:00 | ES | Futures | 6823.03 | 6826.81 | 6815.48 | 6823.29 | 56432.0 |
| 2025-10-21 18:00:00 | ES | Futures | 6826.81 | 6828.83 | 6822.53 | 6826.31 | 6538.0 |
| 2025-10-21 19:00:00 | ES | Futures | 6826.31 | 6826.56 | 6820.01 | 6820.51 | 4092.0 |
| 2025-10-21 20:00:00 | ES | Futures | 6820.51 | 6823.29 | 6815.98 | 6817.24 | 7129.0 |
| 2025-10-21 21:00:00 | ES | Futures | 6816.99 | 6825.55 | 6814.72 | 6824.8 | 6232.0 |
| 2025-10-21 22:00:00 | ES | Futures | 6825.05 | 6828.07 | 6822.03 | 6826.06 | 4335.0 |
| 2025-10-21 23:00:00 | ES | Futures | 6826.31 | 6830.84 | 6820.01 | 6830.34 | 5077.0 |
| 2025-10-21 00:00:00 | NQ | Futures | 25550.65 | 25552.92 | 25516.35 | 25529.22 | 3252.0 |
| 2025-10-21 01:00:00 | NQ | Futures | 25529.72 | 25538.8 | 25496.68 | 25518.12 | 4327.0 |
| 2025-10-21 02:00:00 | NQ | Futures | 25518.88 | 25519.13 | 25487.1 | 25499.71 | 4888.0 |
| 2025-10-21 03:00:00 | NQ | Futures | 25499.71 | 25512.07 | 25482.06 | 25497.94 | 5655.0 |
| 2025-10-21 04:00:00 | NQ | Futures | 25498.95 | 25505.51 | 25473.73 | 25488.61 | 4466.0 |
| 2025-10-21 05:00:00 | NQ | Futures | 25488.36 | 25517.11 | 25486.6 | 25502.48 | 4158.0 |
| 2025-10-21 06:00:00 | NQ | Futures | 25502.99 | 25509.29 | 25479.53 | 25500.21 | 4160.0 |
| 2025-10-21 07:00:00 | NQ | Futures | 25500.47 | 25529.72 | 25494.92 | 25528.71 | 7042.0 |
| 2025-10-21 08:00:00 | NQ | Futures | 25527.95 | 25536.53 | 25512.07 | 25519.38 | 8150.0 |
| 2025-10-21 09:00:00 | NQ | Futures | 25519.63 | 25526.95 | 25431.87 | 25455.32 | 68980.0 |
| 2025-10-21 10:00:00 | NQ | Futures | 25455.58 | 25523.16 | 25423.55 | 25519.13 | 75710.0 |
| 2025-10-21 11:00:00 | NQ | Futures | 25518.88 | 25548.13 | 25462.39 | 25544.09 | 58351.0 |
| 2025-10-21 12:00:00 | NQ | Futures | 25543.59 | 25570.07 | 25498.45 | 25506.52 | 40705.0 |
| 2025-10-21 13:00:00 | NQ | Futures | 25506.77 | 25538.8 | 25470.71 | 25534.51 | 40182.0 |
| 2025-10-21 14:00:00 | NQ | Futures | 25534.76 | 25548.38 | 25511.06 | 25530.98 | 24462.0 |
| 2025-10-21 15:00:00 | NQ | Futures | 25530.48 | 25555.69 | 25507.78 | 25512.07 | 34293.0 |
| 2025-10-21 16:00:00 | NQ | Futures | 25512.07 | 25520.39 | 25449.27 | 25486.09 | 23830.0 |
| 2025-10-21 18:00:00 | NQ | Futures | 25504.75 | 25506.52 | 25478.53 | 25491.39 | 3836.0 |
| 2025-10-21 19:00:00 | NQ | Futures | 25491.89 | 25492.65 | 25460.87 | 25466.42 | 3027.0 |
| 2025-10-21 20:00:00 | NQ | Futures | 25467.18 | 25476.51 | 25441.45 | 25445.99 | 5197.0 |
| 2025-10-21 21:00:00 | NQ | Futures | 25445.99 | 25489.62 | 25434.9 | 25486.85 | 3655.0 |
| 2025-10-21 22:00:00 | NQ | Futures | 25486.85 | 25503.24 | 25473.73 | 25494.41 | 2552.0 |
| 2025-10-21 23:00:00 | NQ | Futures | 25493.91 | 25513.83 | 25464.66 | 25511.81 | 3220.0 |
| 2025-10-21 00:00:00 | YM | Futures | 47580.1 | 47582.1 | 47543.6 | 47557.8 | 469.0 |
| 2025-10-21 01:00:00 | YM | Futures | 47559.8 | 47572.0 | 47517.2 | 47538.5 | 944.0 |
| 2025-10-21 02:00:00 | YM | Futures | 47540.6 | 47541.6 | 47492.9 | 47508.1 | 1139.0 |
| 2025-10-21 03:00:00 | YM | Futures | 47509.1 | 47514.2 | 47481.7 | 47508.1 | 1324.0 |
> showing 50 of 2,039 rows — these rows as CSV