PREVIEW / futures_1hour / 2025-08-01
file: by_date/futures_1hour/2025/2025-08-01.parquet size: 59 KB rows: 1,669
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-01 00:00:00 | ES | Futures | 6410.21 | 6413.23 | 6408.2 | 6411.97 | 4947.0 |
| 2025-08-01 01:00:00 | ES | Futures | 6411.97 | 6413.23 | 6404.92 | 6405.17 | 5215.0 |
| 2025-08-01 02:00:00 | ES | Futures | 6404.92 | 6405.93 | 6395.85 | 6399.38 | 11571.0 |
| 2025-08-01 03:00:00 | ES | Futures | 6399.38 | 6400.89 | 6359.33 | 6370.16 | 36589.0 |
| 2025-08-01 04:00:00 | ES | Futures | 6369.91 | 6373.94 | 6351.78 | 6362.35 | 40329.0 |
| 2025-08-01 05:00:00 | ES | Futures | 6362.35 | 6367.64 | 6356.06 | 6362.1 | 19919.0 |
| 2025-08-01 06:00:00 | ES | Futures | 6362.1 | 6362.35 | 6342.2 | 6348.0 | 27105.0 |
| 2025-08-01 07:00:00 | ES | Futures | 6348.0 | 6364.37 | 6345.73 | 6363.61 | 26037.0 |
| 2025-08-01 08:00:00 | ES | Futures | 6363.61 | 6378.47 | 6347.24 | 6354.04 | 98914.0 |
| 2025-08-01 09:00:00 | ES | Futures | 6353.79 | 6361.6 | 6304.93 | 6309.21 | 328652.0 |
| 2025-08-01 10:00:00 | ES | Futures | 6309.21 | 6335.15 | 6290.57 | 6313.99 | 403177.0 |
| 2025-08-01 11:00:00 | ES | Futures | 6313.74 | 6334.65 | 6307.45 | 6334.4 | 196714.0 |
| 2025-08-01 12:00:00 | ES | Futures | 6334.14 | 6344.22 | 6305.68 | 6307.19 | 195789.0 |
| 2025-08-01 13:00:00 | ES | Futures | 6306.94 | 6311.98 | 6295.36 | 6299.64 | 182040.0 |
| 2025-08-01 14:00:00 | ES | Futures | 6299.64 | 6325.08 | 6286.29 | 6307.45 | 194611.0 |
| 2025-08-01 15:00:00 | ES | Futures | 6307.7 | 6327.34 | 6301.9 | 6310.47 | 300308.0 |
| 2025-08-01 16:00:00 | ES | Futures | 6310.72 | 6315.25 | 6309.21 | 6310.22 | 71929.0 |
| 2025-08-01 00:00:00 | NQ | Futures | 23507.47 | 23524.62 | 23498.14 | 23521.6 | 2772.0 |
| 2025-08-01 01:00:00 | NQ | Futures | 23520.84 | 23528.15 | 23493.1 | 23495.62 | 2951.0 |
| 2025-08-01 02:00:00 | NQ | Futures | 23495.12 | 23499.4 | 23458.05 | 23472.42 | 5235.0 |
| 2025-08-01 03:00:00 | NQ | Futures | 23471.41 | 23481.25 | 23328.68 | 23371.3 | 18463.0 |
| 2025-08-01 04:00:00 | NQ | Futures | 23371.55 | 23374.32 | 23263.37 | 23315.31 | 22538.0 |
| 2025-08-01 05:00:00 | NQ | Futures | 23315.06 | 23341.79 | 23286.82 | 23329.18 | 12365.0 |
| 2025-08-01 06:00:00 | NQ | Futures | 23328.18 | 23328.93 | 23232.1 | 23255.55 | 15840.0 |
| 2025-08-01 07:00:00 | NQ | Futures | 23256.56 | 23330.95 | 23252.27 | 23327.42 | 12960.0 |
| 2025-08-01 08:00:00 | NQ | Futures | 23327.17 | 23369.28 | 23260.34 | 23269.17 | 39457.0 |
| 2025-08-01 09:00:00 | NQ | Futures | 23269.42 | 23303.46 | 23057.08 | 23082.3 | 118511.0 |
| 2025-08-01 10:00:00 | NQ | Futures | 23079.28 | 23223.27 | 22998.58 | 23129.46 | 136552.0 |
| 2025-08-01 11:00:00 | NQ | Futures | 23129.46 | 23219.24 | 23095.42 | 23207.38 | 70665.0 |
| 2025-08-01 12:00:00 | NQ | Futures | 23206.63 | 23246.22 | 23071.96 | 23078.27 | 63376.0 |
| 2025-08-01 13:00:00 | NQ | Futures | 23078.27 | 23099.2 | 23026.07 | 23043.97 | 60965.0 |
| 2025-08-01 14:00:00 | NQ | Futures | 23043.72 | 23142.57 | 22973.36 | 23069.44 | 67978.0 |
| 2025-08-01 15:00:00 | NQ | Futures | 23069.44 | 23144.34 | 23035.15 | 23079.78 | 79816.0 |
| 2025-08-01 16:00:00 | NQ | Futures | 23080.29 | 23093.65 | 23066.67 | 23069.19 | 18953.0 |
| 2025-08-01 00:00:00 | YM | Futures | 45192.3 | 45209.7 | 45172.9 | 45188.2 | 199.0 |
| 2025-08-01 01:00:00 | YM | Futures | 45196.4 | 45196.4 | 45133.0 | 45144.3 | 436.0 |
| 2025-08-01 02:00:00 | YM | Futures | 45140.2 | 45142.2 | 45069.7 | 45092.2 | 993.0 |
| 2025-08-01 03:00:00 | YM | Futures | 45090.1 | 45093.2 | 44795.9 | 44862.3 | 3613.0 |
| 2025-08-01 04:00:00 | YM | Futures | 44866.4 | 44935.9 | 44793.9 | 44857.2 | 4452.0 |
| 2025-08-01 05:00:00 | YM | Futures | 44856.2 | 44887.9 | 44817.4 | 44849.1 | 1939.0 |
| 2025-08-01 06:00:00 | YM | Futures | 44848.0 | 44848.0 | 44730.5 | 44754.0 | 2445.0 |
| 2025-08-01 07:00:00 | YM | Futures | 44759.2 | 44878.7 | 44752.0 | 44875.6 | 3055.0 |
| 2025-08-01 08:00:00 | YM | Futures | 44876.6 | 44987.0 | 44767.3 | 44848.0 | 7447.0 |
| 2025-08-01 09:00:00 | YM | Futures | 44851.1 | 44893.0 | 44522.1 | 44544.6 | 22678.0 |
| 2025-08-01 10:00:00 | YM | Futures | 44535.4 | 44719.3 | 44401.6 | 44608.0 | 24839.0 |
| 2025-08-01 11:00:00 | YM | Futures | 44608.0 | 44741.8 | 44542.6 | 44738.7 | 11654.0 |
| 2025-08-01 12:00:00 | YM | Futures | 44737.7 | 44810.2 | 44583.4 | 44590.6 | 9618.0 |
| 2025-08-01 13:00:00 | YM | Futures | 44588.5 | 44618.2 | 44527.3 | 44556.9 | 8716.0 |
| 2025-08-01 14:00:00 | YM | Futures | 44553.8 | 44736.7 | 44481.3 | 44634.5 | 9838.0 |
| 2025-08-01 15:00:00 | YM | Futures | 44633.5 | 44753.0 | 44596.7 | 44648.8 | 14597.0 |
> showing 50 of 1,669 rows — these rows as CSV