PREVIEW / futures_1hour / 2025-10-22
file: by_date/futures_1hour/2025/2025-10-22.parquet size: 65 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-10-22 00:00:00 | ES | Futures | 6830.34 | 6838.9 | 6829.83 | 6835.63 | 7024.0 |
| 2025-10-22 01:00:00 | ES | Futures | 6835.63 | 6837.39 | 6831.6 | 6833.11 | 3822.0 |
| 2025-10-22 02:00:00 | ES | Futures | 6833.11 | 6839.66 | 6830.09 | 6836.38 | 6465.0 |
| 2025-10-22 03:00:00 | ES | Futures | 6836.38 | 6836.89 | 6826.06 | 6832.6 | 10047.0 |
| 2025-10-22 04:00:00 | ES | Futures | 6832.86 | 6832.86 | 6822.78 | 6826.56 | 9735.0 |
| 2025-10-22 05:00:00 | ES | Futures | 6826.31 | 6829.58 | 6819.26 | 6829.33 | 9068.0 |
| 2025-10-22 06:00:00 | ES | Futures | 6829.33 | 6833.61 | 6827.57 | 6829.33 | 10658.0 |
| 2025-10-22 07:00:00 | ES | Futures | 6829.08 | 6830.09 | 6816.23 | 6820.01 | 20422.0 |
| 2025-10-22 08:00:00 | ES | Futures | 6820.01 | 6831.6 | 6819.26 | 6830.09 | 25559.0 |
| 2025-10-22 09:00:00 | ES | Futures | 6830.09 | 6832.6 | 6814.22 | 6822.28 | 142485.0 |
| 2025-10-22 10:00:00 | ES | Futures | 6822.28 | 6826.06 | 6790.04 | 6810.44 | 327248.0 |
| 2025-10-22 11:00:00 | ES | Futures | 6810.19 | 6813.97 | 6782.73 | 6799.36 | 266354.0 |
| 2025-10-22 12:00:00 | ES | Futures | 6799.61 | 6801.37 | 6748.23 | 6782.48 | 291625.0 |
| 2025-10-22 13:00:00 | ES | Futures | 6782.23 | 6785.76 | 6740.92 | 6755.53 | 217275.0 |
| 2025-10-22 14:00:00 | ES | Futures | 6755.78 | 6774.42 | 6745.46 | 6773.67 | 168143.0 |
| 2025-10-22 15:00:00 | ES | Futures | 6773.67 | 6792.81 | 6763.84 | 6787.52 | 245669.0 |
| 2025-10-22 16:00:00 | ES | Futures | 6787.52 | 6795.33 | 6782.23 | 6788.02 | 48392.0 |
| 2025-10-22 18:00:00 | ES | Futures | 6783.99 | 6790.04 | 6779.96 | 6787.27 | 6408.0 |
| 2025-10-22 19:00:00 | ES | Futures | 6787.27 | 6791.05 | 6776.94 | 6777.44 | 5667.0 |
| 2025-10-22 20:00:00 | ES | Futures | 6777.44 | 6788.27 | 6767.87 | 6787.52 | 10956.0 |
| 2025-10-22 21:00:00 | ES | Futures | 6787.27 | 6798.85 | 6786.76 | 6797.59 | 8617.0 |
| 2025-10-22 22:00:00 | ES | Futures | 6797.85 | 6800.36 | 6796.33 | 6797.59 | 4836.0 |
| 2025-10-22 23:00:00 | ES | Futures | 6797.85 | 6800.87 | 6793.31 | 6795.58 | 7645.0 |
| 2025-10-22 00:00:00 | NQ | Futures | 25511.81 | 25554.43 | 25510.05 | 25538.29 | 4525.0 |
| 2025-10-22 01:00:00 | NQ | Futures | 25538.8 | 25547.37 | 25518.88 | 25528.71 | 2839.0 |
| 2025-10-22 02:00:00 | NQ | Futures | 25530.22 | 25559.73 | 25515.09 | 25539.3 | 4385.0 |
| 2025-10-22 03:00:00 | NQ | Futures | 25539.81 | 25542.33 | 25490.88 | 25518.88 | 6352.0 |
| 2025-10-22 04:00:00 | NQ | Futures | 25518.62 | 25520.14 | 25471.72 | 25488.11 | 4917.0 |
| 2025-10-22 05:00:00 | NQ | Futures | 25487.6 | 25494.92 | 25452.05 | 25492.4 | 5500.0 |
| 2025-10-22 06:00:00 | NQ | Futures | 25492.9 | 25526.69 | 25484.33 | 25507.27 | 5239.0 |
| 2025-10-22 07:00:00 | NQ | Futures | 25507.53 | 25511.56 | 25426.83 | 25445.49 | 11847.0 |
| 2025-10-22 08:00:00 | NQ | Futures | 25445.24 | 25489.12 | 25438.68 | 25481.3 | 8762.0 |
| 2025-10-22 09:00:00 | NQ | Futures | 25481.55 | 25510.3 | 25392.28 | 25478.78 | 68511.0 |
| 2025-10-22 10:00:00 | NQ | Futures | 25478.78 | 25501.73 | 25269.46 | 25393.03 | 126162.0 |
| 2025-10-22 11:00:00 | NQ | Futures | 25393.79 | 25412.45 | 25221.8 | 25320.15 | 91718.0 |
| 2025-10-22 12:00:00 | NQ | Futures | 25320.41 | 25329.48 | 25084.36 | 25211.21 | 99107.0 |
| 2025-10-22 13:00:00 | NQ | Futures | 25209.95 | 25229.87 | 25021.57 | 25091.42 | 72162.0 |
| 2025-10-22 14:00:00 | NQ | Futures | 25091.17 | 25178.17 | 25044.01 | 25175.65 | 63913.0 |
| 2025-10-22 15:00:00 | NQ | Futures | 25175.9 | 25277.28 | 25141.1 | 25259.38 | 68574.0 |
| 2025-10-22 16:00:00 | NQ | Futures | 25259.88 | 25295.69 | 25242.23 | 25258.87 | 17813.0 |
| 2025-10-22 18:00:00 | NQ | Futures | 25230.88 | 25278.54 | 25218.77 | 25263.41 | 5184.0 |
| 2025-10-22 19:00:00 | NQ | Futures | 25263.16 | 25283.59 | 25210.45 | 25215.5 | 4194.0 |
| 2025-10-22 20:00:00 | NQ | Futures | 25214.49 | 25274.0 | 25169.35 | 25267.45 | 8227.0 |
| 2025-10-22 21:00:00 | NQ | Futures | 25267.7 | 25324.44 | 25266.19 | 25318.39 | 5618.0 |
| 2025-10-22 22:00:00 | NQ | Futures | 25318.39 | 25331.0 | 25309.56 | 25318.39 | 2873.0 |
| 2025-10-22 23:00:00 | NQ | Futures | 25319.14 | 25332.76 | 25293.17 | 25305.53 | 4198.0 |
| 2025-10-22 00:00:00 | YM | Futures | 47813.4 | 47863.0 | 47810.3 | 47853.9 | 1000.0 |
| 2025-10-22 01:00:00 | YM | Futures | 47853.9 | 47862.0 | 47817.4 | 47827.6 | 427.0 |
| 2025-10-22 02:00:00 | YM | Futures | 47828.6 | 47868.1 | 47813.4 | 47850.9 | 1022.0 |
| 2025-10-22 03:00:00 | YM | Futures | 47848.9 | 47851.9 | 47796.1 | 47828.6 | 1537.0 |
> showing 50 of 2,087 rows — these rows as CSV