PREVIEW / futures_1hour / 2025-08-22
file: by_date/futures_1hour/2025/2025-08-22.parquet size: 55 KB rows: 1,625
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-08-22 00:00:00 | ES | Futures | 6434.39 | 6438.42 | 6433.89 | 6436.91 | 2084.0 |
| 2025-08-22 01:00:00 | ES | Futures | 6436.91 | 6437.67 | 6430.61 | 6433.13 | 3477.0 |
| 2025-08-22 02:00:00 | ES | Futures | 6433.13 | 6433.13 | 6411.72 | 6424.57 | 12393.0 |
| 2025-08-22 03:00:00 | ES | Futures | 6424.57 | 6439.43 | 6422.8 | 6438.42 | 9994.0 |
| 2025-08-22 04:00:00 | ES | Futures | 6438.17 | 6450.76 | 6436.66 | 6450.01 | 13242.0 |
| 2025-08-22 05:00:00 | ES | Futures | 6450.01 | 6450.51 | 6446.48 | 6450.01 | 7352.0 |
| 2025-08-22 06:00:00 | ES | Futures | 6450.26 | 6454.04 | 6449.25 | 6452.02 | 7764.0 |
| 2025-08-22 07:00:00 | ES | Futures | 6452.02 | 6454.04 | 6445.98 | 6447.99 | 9013.0 |
| 2025-08-22 08:00:00 | ES | Futures | 6447.74 | 6453.78 | 6447.24 | 6448.24 | 15960.0 |
| 2025-08-22 09:00:00 | ES | Futures | 6448.24 | 6475.95 | 6447.24 | 6462.35 | 147543.0 |
| 2025-08-22 10:00:00 | ES | Futures | 6462.35 | 6541.44 | 6462.35 | 6535.9 | 395793.0 |
| 2025-08-22 11:00:00 | ES | Futures | 6536.15 | 6544.96 | 6532.62 | 6533.63 | 141836.0 |
| 2025-08-22 12:00:00 | ES | Futures | 6533.88 | 6538.67 | 6522.29 | 6526.58 | 106243.0 |
| 2025-08-22 13:00:00 | ES | Futures | 6526.32 | 6543.7 | 6526.32 | 6537.66 | 96235.0 |
| 2025-08-22 14:00:00 | ES | Futures | 6537.66 | 6540.18 | 6532.37 | 6534.38 | 76560.0 |
| 2025-08-22 15:00:00 | ES | Futures | 6534.38 | 6536.4 | 6522.55 | 6531.87 | 225755.0 |
| 2025-08-22 16:00:00 | ES | Futures | 6531.61 | 6535.39 | 6528.59 | 6533.38 | 47302.0 |
| 2025-08-22 00:00:00 | NQ | Futures | 23396.52 | 23417.95 | 23395.0 | 23411.65 | 1098.0 |
| 2025-08-22 01:00:00 | NQ | Futures | 23411.9 | 23414.42 | 23382.9 | 23393.24 | 2314.0 |
| 2025-08-22 02:00:00 | NQ | Futures | 23392.23 | 23393.49 | 23277.74 | 23341.04 | 8677.0 |
| 2025-08-22 03:00:00 | NQ | Futures | 23340.78 | 23402.32 | 23335.74 | 23398.53 | 5814.0 |
| 2025-08-22 04:00:00 | NQ | Futures | 23398.28 | 23459.06 | 23392.99 | 23455.53 | 6857.0 |
| 2025-08-22 05:00:00 | NQ | Futures | 23456.28 | 23456.79 | 23433.08 | 23454.26 | 2892.0 |
| 2025-08-22 06:00:00 | NQ | Futures | 23455.53 | 23477.46 | 23453.51 | 23468.13 | 3673.0 |
| 2025-08-22 07:00:00 | NQ | Futures | 23468.39 | 23483.52 | 23443.17 | 23455.78 | 4533.0 |
| 2025-08-22 08:00:00 | NQ | Futures | 23454.77 | 23477.72 | 23441.91 | 23445.19 | 7065.0 |
| 2025-08-22 09:00:00 | NQ | Futures | 23444.43 | 23545.55 | 23407.61 | 23471.16 | 58626.0 |
| 2025-08-22 10:00:00 | NQ | Futures | 23471.41 | 23853.46 | 23471.41 | 23808.32 | 119393.0 |
| 2025-08-22 11:00:00 | NQ | Futures | 23809.33 | 23855.98 | 23770.24 | 23774.28 | 52640.0 |
| 2025-08-22 12:00:00 | NQ | Futures | 23774.53 | 23796.97 | 23711.99 | 23733.42 | 46469.0 |
| 2025-08-22 13:00:00 | NQ | Futures | 23733.17 | 23830.77 | 23732.67 | 23811.35 | 42403.0 |
| 2025-08-22 14:00:00 | NQ | Futures | 23811.85 | 23822.44 | 23787.64 | 23791.93 | 28880.0 |
| 2025-08-22 15:00:00 | NQ | Futures | 23791.43 | 23799.24 | 23736.2 | 23770.24 | 55613.0 |
| 2025-08-22 16:00:00 | NQ | Futures | 23769.99 | 23792.94 | 23754.36 | 23788.15 | 13574.0 |
| 2025-08-22 00:00:00 | YM | Futures | 45832.8 | 45856.3 | 45829.8 | 45846.1 | 225.0 |
| 2025-08-22 01:00:00 | YM | Futures | 45845.1 | 45850.2 | 45806.3 | 45825.7 | 340.0 |
| 2025-08-22 02:00:00 | YM | Futures | 45821.6 | 45824.7 | 45711.3 | 45782.8 | 1766.0 |
| 2025-08-22 03:00:00 | YM | Futures | 45785.8 | 45887.0 | 45775.6 | 45882.9 | 1183.0 |
| 2025-08-22 04:00:00 | YM | Futures | 45881.9 | 45954.4 | 45875.7 | 45950.3 | 2519.0 |
| 2025-08-22 05:00:00 | YM | Futures | 45948.3 | 45977.9 | 45938.0 | 45965.6 | 1035.0 |
| 2025-08-22 06:00:00 | YM | Futures | 45966.6 | 45988.1 | 45958.5 | 45976.9 | 946.0 |
| 2025-08-22 07:00:00 | YM | Futures | 45976.9 | 45982.0 | 45935.0 | 45947.2 | 906.0 |
| 2025-08-22 08:00:00 | YM | Futures | 45947.2 | 45982.0 | 45945.2 | 45954.4 | 1580.0 |
| 2025-08-22 09:00:00 | YM | Futures | 45954.4 | 46220.0 | 45947.2 | 46174.0 | 18301.0 |
| 2025-08-22 10:00:00 | YM | Futures | 46174.0 | 46761.4 | 46174.0 | 46732.8 | 36061.0 |
| 2025-08-22 11:00:00 | YM | Futures | 46732.8 | 46810.5 | 46663.4 | 46768.6 | 15166.0 |
| 2025-08-22 12:00:00 | YM | Futures | 46770.6 | 46829.9 | 46717.5 | 46739.0 | 9956.0 |
| 2025-08-22 13:00:00 | YM | Futures | 46737.9 | 46790.0 | 46730.8 | 46735.9 | 5736.0 |
| 2025-08-22 14:00:00 | YM | Futures | 46735.9 | 46754.3 | 46672.6 | 46709.3 | 5112.0 |
| 2025-08-22 15:00:00 | YM | Futures | 46710.4 | 46729.8 | 46657.2 | 46701.2 | 11649.0 |
> showing 50 of 1,625 rows — these rows as CSV