PREVIEW / futures_1hour / 2025-10-23
file: by_date/futures_1hour/2025/2025-10-23.parquet size: 66 KB rows: 2,109
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-23 00:00:00 | ES | Futures | 6795.58 | 6797.34 | 6790.29 | 6792.05 | 4419.0 |
| 2025-10-23 01:00:00 | ES | Futures | 6792.3 | 6797.85 | 6788.78 | 6796.84 | 5449.0 |
| 2025-10-23 02:00:00 | ES | Futures | 6796.84 | 6800.36 | 6793.31 | 6798.85 | 7085.0 |
| 2025-10-23 03:00:00 | ES | Futures | 6798.85 | 6802.38 | 6790.04 | 6797.09 | 12547.0 |
| 2025-10-23 04:00:00 | ES | Futures | 6797.09 | 6800.36 | 6792.81 | 6795.33 | 9944.0 |
| 2025-10-23 05:00:00 | ES | Futures | 6795.33 | 6797.34 | 6782.99 | 6789.79 | 11503.0 |
| 2025-10-23 06:00:00 | ES | Futures | 6790.04 | 6792.81 | 6787.77 | 6790.54 | 9206.0 |
| 2025-10-23 07:00:00 | ES | Futures | 6790.29 | 6790.79 | 6773.92 | 6776.18 | 17547.0 |
| 2025-10-23 08:00:00 | ES | Futures | 6776.18 | 6787.77 | 6769.89 | 6786.51 | 32362.0 |
| 2025-10-23 09:00:00 | ES | Futures | 6786.51 | 6816.74 | 6774.42 | 6808.68 | 170219.0 |
| 2025-10-23 10:00:00 | ES | Futures | 6808.93 | 6812.96 | 6789.53 | 6811.2 | 227598.0 |
| 2025-10-23 11:00:00 | ES | Futures | 6811.2 | 6816.23 | 6795.83 | 6811.7 | 152441.0 |
| 2025-10-23 12:00:00 | ES | Futures | 6811.45 | 6824.8 | 6810.44 | 6823.54 | 123857.0 |
| 2025-10-23 13:00:00 | ES | Futures | 6823.79 | 6834.37 | 6813.21 | 6833.11 | 179555.0 |
| 2025-10-23 14:00:00 | ES | Futures | 6833.36 | 6836.63 | 6827.57 | 6834.87 | 87962.0 |
| 2025-10-23 15:00:00 | ES | Futures | 6834.87 | 6836.63 | 6822.28 | 6825.55 | 175881.0 |
| 2025-10-23 16:00:00 | ES | Futures | 6825.3 | 6829.08 | 6824.29 | 6828.57 | 45272.0 |
| 2025-10-23 18:00:00 | ES | Futures | 6829.08 | 6832.6 | 6827.32 | 6830.59 | 4746.0 |
| 2025-10-23 19:00:00 | ES | Futures | 6830.59 | 6832.86 | 6830.34 | 6831.6 | 2268.0 |
| 2025-10-23 20:00:00 | ES | Futures | 6831.85 | 6832.6 | 6827.57 | 6831.85 | 4421.0 |
| 2025-10-23 21:00:00 | ES | Futures | 6831.85 | 6836.38 | 6831.6 | 6835.63 | 5308.0 |
| 2025-10-23 22:00:00 | ES | Futures | 6835.63 | 6837.89 | 6832.6 | 6834.12 | 4769.0 |
| 2025-10-23 23:00:00 | ES | Futures | 6834.12 | 6839.15 | 6833.61 | 6838.65 | 4345.0 |
| 2025-10-23 00:00:00 | NQ | Futures | 25305.78 | 25314.1 | 25281.06 | 25290.4 | 3017.0 |
| 2025-10-23 01:00:00 | NQ | Futures | 25291.91 | 25313.09 | 25272.49 | 25310.32 | 2769.0 |
| 2025-10-23 02:00:00 | NQ | Futures | 25310.32 | 25331.75 | 25294.43 | 25324.19 | 4257.0 |
| 2025-10-23 03:00:00 | NQ | Futures | 25323.94 | 25347.64 | 25288.13 | 25311.07 | 6346.0 |
| 2025-10-23 04:00:00 | NQ | Futures | 25311.07 | 25335.03 | 25288.63 | 25303.26 | 4885.0 |
| 2025-10-23 05:00:00 | NQ | Futures | 25303.0 | 25311.83 | 25243.99 | 25278.04 | 8762.0 |
| 2025-10-23 06:00:00 | NQ | Futures | 25278.54 | 25286.61 | 25254.08 | 25267.7 | 4924.0 |
| 2025-10-23 07:00:00 | NQ | Futures | 25267.95 | 25271.99 | 25180.95 | 25191.54 | 12533.0 |
| 2025-10-23 08:00:00 | NQ | Futures | 25191.54 | 25230.38 | 25154.97 | 25226.84 | 16103.0 |
| 2025-10-23 09:00:00 | NQ | Futures | 25226.59 | 25399.84 | 25158.75 | 25380.43 | 86041.0 |
| 2025-10-23 10:00:00 | NQ | Futures | 25380.68 | 25418.76 | 25303.26 | 25410.18 | 89665.0 |
| 2025-10-23 11:00:00 | NQ | Futures | 25409.93 | 25436.92 | 25339.07 | 25413.97 | 67552.0 |
| 2025-10-23 12:00:00 | NQ | Futures | 25414.98 | 25461.88 | 25403.88 | 25460.62 | 42210.0 |
| 2025-10-23 13:00:00 | NQ | Futures | 25460.62 | 25504.25 | 25409.68 | 25499.71 | 53424.0 |
| 2025-10-23 14:00:00 | NQ | Futures | 25500.47 | 25509.04 | 25466.17 | 25494.67 | 30427.0 |
| 2025-10-23 15:00:00 | NQ | Futures | 25495.17 | 25503.49 | 25451.04 | 25473.73 | 41851.0 |
| 2025-10-23 16:00:00 | NQ | Futures | 25473.23 | 25517.11 | 25468.19 | 25498.95 | 16808.0 |
| 2025-10-23 18:00:00 | NQ | Futures | 25504.25 | 25524.17 | 25496.94 | 25512.82 | 3850.0 |
| 2025-10-23 19:00:00 | NQ | Futures | 25512.82 | 25525.68 | 25512.07 | 25518.37 | 1732.0 |
| 2025-10-23 20:00:00 | NQ | Futures | 25519.38 | 25526.69 | 25505.76 | 25522.15 | 3190.0 |
| 2025-10-23 21:00:00 | NQ | Futures | 25521.4 | 25542.58 | 25518.12 | 25539.55 | 4082.0 |
| 2025-10-23 22:00:00 | NQ | Futures | 25538.8 | 25547.62 | 25524.17 | 25530.73 | 3054.0 |
| 2025-10-23 23:00:00 | NQ | Futures | 25531.23 | 25551.41 | 25525.68 | 25550.4 | 2420.0 |
| 2025-10-23 00:00:00 | YM | Futures | 47403.7 | 47413.8 | 47377.3 | 47389.5 | 543.0 |
| 2025-10-23 01:00:00 | YM | Futures | 47391.5 | 47410.8 | 47364.1 | 47405.7 | 714.0 |
| 2025-10-23 02:00:00 | YM | Futures | 47403.7 | 47418.9 | 47380.3 | 47414.8 | 1162.0 |
| 2025-10-23 03:00:00 | YM | Futures | 47413.8 | 47425.0 | 47350.9 | 47410.8 | 1716.0 |
> showing 50 of 2,109 rows — these rows as CSV