PREVIEW / futures_1hour / 2025-09-23
file: by_date/futures_1hour/2025/2025-09-23.parquet size: 63 KB rows: 2,070
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-09-23 00:00:00 | ES | Futures | 6801.88 | 6802.13 | 6796.84 | 6798.1 | 3401.0 |
| 2025-09-23 01:00:00 | ES | Futures | 6797.85 | 6804.65 | 6797.34 | 6801.12 | 4134.0 |
| 2025-09-23 02:00:00 | ES | Futures | 6800.87 | 6804.39 | 6800.36 | 6803.89 | 4507.0 |
| 2025-09-23 03:00:00 | ES | Futures | 6803.89 | 6803.89 | 6797.85 | 6800.36 | 14820.0 |
| 2025-09-23 04:00:00 | ES | Futures | 6800.11 | 6805.4 | 6800.11 | 6801.12 | 12220.0 |
| 2025-09-23 05:00:00 | ES | Futures | 6801.37 | 6803.89 | 6800.11 | 6803.14 | 5774.0 |
| 2025-09-23 06:00:00 | ES | Futures | 6803.14 | 6803.64 | 6796.33 | 6799.86 | 8200.0 |
| 2025-09-23 07:00:00 | ES | Futures | 6799.61 | 6802.38 | 6794.57 | 6801.62 | 9448.0 |
| 2025-09-23 08:00:00 | ES | Futures | 6801.62 | 6803.39 | 6798.6 | 6802.38 | 15523.0 |
| 2025-09-23 09:00:00 | ES | Futures | 6802.63 | 6807.17 | 6799.11 | 6802.38 | 120422.0 |
| 2025-09-23 10:00:00 | ES | Futures | 6802.63 | 6806.16 | 6794.82 | 6796.33 | 138254.0 |
| 2025-09-23 11:00:00 | ES | Futures | 6796.33 | 6798.1 | 6787.77 | 6788.53 | 105479.0 |
| 2025-09-23 12:00:00 | ES | Futures | 6788.53 | 6791.8 | 6781.73 | 6784.5 | 118913.0 |
| 2025-09-23 13:00:00 | ES | Futures | 6784.5 | 6785.76 | 6752.26 | 6764.35 | 218816.0 |
| 2025-09-23 14:00:00 | ES | Futures | 6764.6 | 6766.11 | 6752.0 | 6753.26 | 135696.0 |
| 2025-09-23 15:00:00 | ES | Futures | 6753.26 | 6768.88 | 6753.01 | 6766.11 | 226920.0 |
| 2025-09-23 16:00:00 | ES | Futures | 6766.36 | 6769.13 | 6763.34 | 6766.87 | 46737.0 |
| 2025-09-23 18:00:00 | ES | Futures | 6768.12 | 6772.91 | 6766.87 | 6770.14 | 5341.0 |
| 2025-09-23 19:00:00 | ES | Futures | 6770.14 | 6770.39 | 6767.62 | 6768.12 | 2147.0 |
| 2025-09-23 20:00:00 | ES | Futures | 6768.12 | 6769.38 | 6762.08 | 6767.87 | 9638.0 |
| 2025-09-23 21:00:00 | ES | Futures | 6767.87 | 6768.38 | 6763.09 | 6765.1 | 5141.0 |
| 2025-09-23 22:00:00 | ES | Futures | 6764.85 | 6768.38 | 6763.84 | 6767.62 | 3275.0 |
| 2025-09-23 23:00:00 | ES | Futures | 6767.62 | 6769.13 | 6767.37 | 6768.63 | 2372.0 |
| 2025-09-23 00:00:00 | NQ | Futures | 25221.55 | 25221.55 | 25195.83 | 25206.17 | 2456.0 |
| 2025-09-23 01:00:00 | NQ | Futures | 25205.41 | 25233.65 | 25201.88 | 25215.5 | 3277.0 |
| 2025-09-23 02:00:00 | NQ | Futures | 25215.5 | 25233.65 | 25212.22 | 25231.38 | 2738.0 |
| 2025-09-23 03:00:00 | NQ | Futures | 25231.13 | 25231.38 | 25198.35 | 25219.03 | 5670.0 |
| 2025-09-23 04:00:00 | NQ | Futures | 25217.51 | 25244.75 | 25216.76 | 25221.04 | 5502.0 |
| 2025-09-23 05:00:00 | NQ | Futures | 25221.55 | 25232.65 | 25214.49 | 25232.14 | 3322.0 |
| 2025-09-23 06:00:00 | NQ | Futures | 25232.9 | 25235.42 | 25206.17 | 25219.03 | 4278.0 |
| 2025-09-23 07:00:00 | NQ | Futures | 25220.04 | 25222.56 | 25191.29 | 25218.77 | 5767.0 |
| 2025-09-23 08:00:00 | NQ | Futures | 25219.03 | 25229.62 | 25202.13 | 25228.11 | 7261.0 |
| 2025-09-23 09:00:00 | NQ | Futures | 25227.85 | 25229.37 | 25150.43 | 25158.0 | 67976.0 |
| 2025-09-23 10:00:00 | NQ | Futures | 25158.5 | 25193.56 | 25147.41 | 25162.54 | 74545.0 |
| 2025-09-23 11:00:00 | NQ | Futures | 25162.54 | 25188.01 | 25147.41 | 25164.3 | 52551.0 |
| 2025-09-23 12:00:00 | NQ | Futures | 25163.8 | 25172.63 | 25132.78 | 25146.65 | 53298.0 |
| 2025-09-23 13:00:00 | NQ | Futures | 25146.65 | 25148.42 | 24997.1 | 25052.84 | 102043.0 |
| 2025-09-23 14:00:00 | NQ | Futures | 25052.33 | 25063.43 | 25000.63 | 25006.94 | 58909.0 |
| 2025-09-23 15:00:00 | NQ | Futures | 25007.44 | 25060.15 | 25006.44 | 25048.55 | 68827.0 |
| 2025-09-23 16:00:00 | NQ | Futures | 25048.55 | 25073.52 | 25041.24 | 25050.82 | 15368.0 |
| 2025-09-23 18:00:00 | NQ | Futures | 25056.62 | 25080.33 | 25053.09 | 25070.74 | 3074.0 |
| 2025-09-23 19:00:00 | NQ | Futures | 25069.99 | 25072.51 | 25056.87 | 25058.39 | 2170.0 |
| 2025-09-23 20:00:00 | NQ | Futures | 25058.64 | 25064.19 | 25027.37 | 25054.85 | 5212.0 |
| 2025-09-23 21:00:00 | NQ | Futures | 25054.35 | 25056.37 | 25034.43 | 25039.98 | 3190.0 |
| 2025-09-23 22:00:00 | NQ | Futures | 25040.98 | 25054.85 | 25034.18 | 25052.33 | 2115.0 |
| 2025-09-23 23:00:00 | NQ | Futures | 25052.33 | 25059.14 | 25049.56 | 25054.35 | 2012.0 |
| 2025-09-23 00:00:00 | YM | Futures | 47383.4 | 47384.4 | 47356.0 | 47367.1 | 339.0 |
| 2025-09-23 01:00:00 | YM | Futures | 47366.1 | 47418.9 | 47361.1 | 47391.5 | 485.0 |
| 2025-09-23 02:00:00 | YM | Futures | 47392.5 | 47411.8 | 47381.3 | 47409.7 | 638.0 |
| 2025-09-23 03:00:00 | YM | Futures | 47407.7 | 47411.8 | 47375.3 | 47389.5 | 1380.0 |
> showing 50 of 2,070 rows — these rows as CSV