PREVIEW / futures_1hour / 2025-09-22
file: by_date/futures_1hour/2025/2025-09-22.parquet size: 63 KB rows: 2,053
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-22 00:00:00 | ES | Futures | 6768.38 | 6768.88 | 6765.86 | 6766.11 | 2385.0 |
| 2025-09-22 01:00:00 | ES | Futures | 6766.11 | 6768.63 | 6765.1 | 6765.1 | 3232.0 |
| 2025-09-22 02:00:00 | ES | Futures | 6765.35 | 6766.11 | 6759.56 | 6760.57 | 7675.0 |
| 2025-09-22 03:00:00 | ES | Futures | 6760.82 | 6763.34 | 6745.46 | 6752.26 | 17515.0 |
| 2025-09-22 04:00:00 | ES | Futures | 6752.51 | 6761.83 | 6751.5 | 6754.52 | 11892.0 |
| 2025-09-22 05:00:00 | ES | Futures | 6754.78 | 6756.03 | 6749.49 | 6753.01 | 8151.0 |
| 2025-09-22 06:00:00 | ES | Futures | 6753.01 | 6758.81 | 6751.0 | 6751.75 | 8219.0 |
| 2025-09-22 07:00:00 | ES | Futures | 6751.75 | 6754.27 | 6749.23 | 6754.02 | 11034.0 |
| 2025-09-22 08:00:00 | ES | Futures | 6753.77 | 6755.03 | 6748.73 | 6753.52 | 17854.0 |
| 2025-09-22 09:00:00 | ES | Futures | 6753.26 | 6769.64 | 6750.24 | 6768.12 | 124794.0 |
| 2025-09-22 10:00:00 | ES | Futures | 6768.38 | 6785.25 | 6765.86 | 6784.75 | 148457.0 |
| 2025-09-22 11:00:00 | ES | Futures | 6784.5 | 6788.02 | 6778.96 | 6780.21 | 110843.0 |
| 2025-09-22 12:00:00 | ES | Futures | 6780.21 | 6799.86 | 6779.96 | 6798.85 | 123327.0 |
| 2025-09-22 13:00:00 | ES | Futures | 6798.6 | 6802.63 | 6795.83 | 6798.1 | 73460.0 |
| 2025-09-22 14:00:00 | ES | Futures | 6798.1 | 6803.14 | 6795.08 | 6802.88 | 68708.0 |
| 2025-09-22 15:00:00 | ES | Futures | 6802.63 | 6807.42 | 6801.62 | 6802.38 | 189864.0 |
| 2025-09-22 16:00:00 | ES | Futures | 6802.38 | 6802.88 | 6795.33 | 6800.36 | 58458.0 |
| 2025-09-22 18:00:00 | ES | Futures | 6800.11 | 6801.62 | 6796.33 | 6798.85 | 5270.0 |
| 2025-09-22 19:00:00 | ES | Futures | 6798.85 | 6803.14 | 6798.1 | 6801.62 | 3223.0 |
| 2025-09-22 20:00:00 | ES | Futures | 6801.62 | 6803.14 | 6799.11 | 6800.36 | 4160.0 |
| 2025-09-22 21:00:00 | ES | Futures | 6800.36 | 6803.89 | 6799.61 | 6801.12 | 3985.0 |
| 2025-09-22 22:00:00 | ES | Futures | 6801.12 | 6803.14 | 6800.87 | 6801.12 | 2454.0 |
| 2025-09-22 23:00:00 | ES | Futures | 6801.12 | 6803.14 | 6800.87 | 6801.88 | 2160.0 |
| 2025-09-22 00:00:00 | NQ | Futures | 25075.53 | 25076.79 | 25065.45 | 25069.48 | 1671.0 |
| 2025-09-22 01:00:00 | NQ | Futures | 25069.99 | 25079.06 | 25057.12 | 25058.13 | 2634.0 |
| 2025-09-22 02:00:00 | NQ | Futures | 25058.39 | 25064.44 | 25032.91 | 25035.18 | 5229.0 |
| 2025-09-22 03:00:00 | NQ | Futures | 25035.44 | 25048.05 | 24965.08 | 25002.4 | 11121.0 |
| 2025-09-22 04:00:00 | NQ | Futures | 25002.4 | 25041.49 | 24995.09 | 24997.86 | 6957.0 |
| 2025-09-22 05:00:00 | NQ | Futures | 24998.37 | 25008.96 | 24976.68 | 25001.14 | 4982.0 |
| 2025-09-22 06:00:00 | NQ | Futures | 25000.89 | 25024.59 | 24988.78 | 24992.82 | 4448.0 |
| 2025-09-22 07:00:00 | NQ | Futures | 24992.31 | 25006.69 | 24984.49 | 25006.18 | 5264.0 |
| 2025-09-22 08:00:00 | NQ | Futures | 25005.68 | 25022.83 | 24982.23 | 25015.77 | 8302.0 |
| 2025-09-22 09:00:00 | NQ | Futures | 25015.26 | 25097.98 | 24999.63 | 25089.66 | 63317.0 |
| 2025-09-22 10:00:00 | NQ | Futures | 25089.91 | 25148.92 | 25072.26 | 25144.63 | 63379.0 |
| 2025-09-22 11:00:00 | NQ | Futures | 25144.38 | 25155.73 | 25114.87 | 25129.0 | 45054.0 |
| 2025-09-22 12:00:00 | NQ | Futures | 25129.0 | 25212.97 | 25127.74 | 25205.16 | 66457.0 |
| 2025-09-22 13:00:00 | NQ | Futures | 25204.9 | 25219.03 | 25191.54 | 25207.17 | 38596.0 |
| 2025-09-22 14:00:00 | NQ | Futures | 25206.92 | 25237.94 | 25204.9 | 25231.38 | 36771.0 |
| 2025-09-22 15:00:00 | NQ | Futures | 25231.13 | 25246.01 | 25208.18 | 25217.26 | 60715.0 |
| 2025-09-22 16:00:00 | NQ | Futures | 25217.26 | 25220.29 | 25198.85 | 25214.74 | 20187.0 |
| 2025-09-22 18:00:00 | NQ | Futures | 25213.48 | 25220.79 | 25192.3 | 25205.91 | 3841.0 |
| 2025-09-22 19:00:00 | NQ | Futures | 25205.41 | 25224.83 | 25202.38 | 25215.75 | 3302.0 |
| 2025-09-22 20:00:00 | NQ | Futures | 25217.01 | 25223.57 | 25204.65 | 25207.93 | 3300.0 |
| 2025-09-22 21:00:00 | NQ | Futures | 25207.93 | 25226.34 | 25203.39 | 25213.48 | 3378.0 |
| 2025-09-22 22:00:00 | NQ | Futures | 25213.73 | 25223.57 | 25212.47 | 25218.52 | 2059.0 |
| 2025-09-22 23:00:00 | NQ | Futures | 25217.26 | 25225.08 | 25214.74 | 25221.04 | 1659.0 |
| 2025-09-22 00:00:00 | YM | Futures | 47259.7 | 47266.8 | 47237.3 | 47239.4 | 178.0 |
| 2025-09-22 01:00:00 | YM | Futures | 47239.4 | 47258.6 | 47238.4 | 47238.4 | 357.0 |
| 2025-09-22 02:00:00 | YM | Futures | 47239.4 | 47243.4 | 47210.0 | 47218.1 | 943.0 |
| 2025-09-22 03:00:00 | YM | Futures | 47219.1 | 47234.3 | 47115.6 | 47164.3 | 2076.0 |
> showing 50 of 2,053 rows — these rows as CSV