PREVIEW / futures_30min / 2025-08-01
file: by_date/futures_30min/2025/2025-08-01.parquet size: 98 KB rows: 3,180
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.47 | 2870.0 |
| 2025-08-01 00:30:00 | ES | Futures | 6411.72 | 6412.73 | 6408.95 | 6411.97 | 2077.0 |
| 2025-08-01 01:00:00 | ES | Futures | 6411.97 | 6413.23 | 6408.45 | 6409.2 | 1618.0 |
| 2025-08-01 01:30:00 | ES | Futures | 6409.2 | 6411.22 | 6404.92 | 6405.17 | 3597.0 |
| 2025-08-01 02:00:00 | ES | Futures | 6404.92 | 6405.93 | 6397.87 | 6398.12 | 4902.0 |
| 2025-08-01 02:30:00 | ES | Futures | 6398.12 | 6402.4 | 6395.85 | 6399.38 | 6669.0 |
| 2025-08-01 03:00:00 | ES | Futures | 6399.38 | 6400.89 | 6376.71 | 6376.96 | 16194.0 |
| 2025-08-01 03:30:00 | ES | Futures | 6376.71 | 6380.49 | 6359.33 | 6370.16 | 20395.0 |
| 2025-08-01 04:00:00 | ES | Futures | 6369.91 | 6373.94 | 6355.3 | 6358.07 | 22470.0 |
| 2025-08-01 04:30:00 | ES | Futures | 6357.82 | 6364.37 | 6351.78 | 6362.35 | 17859.0 |
| 2025-08-01 05:00:00 | ES | Futures | 6362.35 | 6367.64 | 6357.57 | 6357.82 | 11582.0 |
| 2025-08-01 05:30:00 | ES | Futures | 6357.57 | 6364.37 | 6356.06 | 6362.1 | 8337.0 |
| 2025-08-01 06:00:00 | ES | Futures | 6362.1 | 6362.35 | 6354.8 | 6359.58 | 10420.0 |
| 2025-08-01 06:30:00 | ES | Futures | 6359.33 | 6359.58 | 6342.2 | 6348.0 | 16685.0 |
| 2025-08-01 07:00:00 | ES | Futures | 6348.0 | 6359.58 | 6345.73 | 6357.57 | 13966.0 |
| 2025-08-01 07:30:00 | ES | Futures | 6357.57 | 6364.37 | 6357.07 | 6363.61 | 12071.0 |
| 2025-08-01 08:00:00 | ES | Futures | 6363.61 | 6367.14 | 6360.59 | 6364.87 | 19041.0 |
| 2025-08-01 08:30:00 | ES | Futures | 6364.37 | 6378.47 | 6347.24 | 6354.04 | 79873.0 |
| 2025-08-01 09:00:00 | ES | Futures | 6353.79 | 6361.6 | 6347.75 | 6358.07 | 46866.0 |
| 2025-08-01 09:30:00 | ES | Futures | 6358.32 | 6358.83 | 6304.93 | 6309.21 | 281786.0 |
| 2025-08-01 10:00:00 | ES | Futures | 6309.21 | 6329.86 | 6290.57 | 6328.1 | 240036.0 |
| 2025-08-01 10:30:00 | ES | Futures | 6328.1 | 6335.15 | 6311.98 | 6313.99 | 163141.0 |
| 2025-08-01 11:00:00 | ES | Futures | 6313.74 | 6324.07 | 6307.45 | 6309.21 | 100366.0 |
| 2025-08-01 11:30:00 | ES | Futures | 6308.96 | 6334.65 | 6307.95 | 6334.4 | 96348.0 |
| 2025-08-01 12:00:00 | ES | Futures | 6334.14 | 6344.22 | 6333.14 | 6336.16 | 91671.0 |
| 2025-08-01 12:30:00 | ES | Futures | 6336.16 | 6338.93 | 6305.68 | 6307.19 | 104118.0 |
| 2025-08-01 13:00:00 | ES | Futures | 6306.94 | 6311.98 | 6296.87 | 6299.39 | 102612.0 |
| 2025-08-01 13:30:00 | ES | Futures | 6299.13 | 6307.7 | 6295.36 | 6299.64 | 79428.0 |
| 2025-08-01 14:00:00 | ES | Futures | 6299.64 | 6311.98 | 6286.29 | 6309.96 | 92975.0 |
| 2025-08-01 14:30:00 | ES | Futures | 6310.22 | 6325.08 | 6302.91 | 6307.45 | 101636.0 |
| 2025-08-01 15:00:00 | ES | Futures | 6307.7 | 6317.02 | 6303.16 | 6311.73 | 78044.0 |
| 2025-08-01 15:30:00 | ES | Futures | 6311.48 | 6327.34 | 6301.9 | 6310.47 | 222264.0 |
| 2025-08-01 16:00:00 | ES | Futures | 6310.72 | 6315.25 | 6309.21 | 6314.5 | 58132.0 |
| 2025-08-01 16:30:00 | ES | Futures | 6314.5 | 6314.75 | 6309.96 | 6310.22 | 13797.0 |
| 2025-08-01 00:00:00 | NQ | Futures | 23507.47 | 23524.62 | 23498.14 | 23517.56 | 1803.0 |
| 2025-08-01 00:30:00 | NQ | Futures | 23518.82 | 23523.61 | 23509.49 | 23521.6 | 969.0 |
| 2025-08-01 01:00:00 | NQ | Futures | 23520.84 | 23528.15 | 23507.98 | 23510.0 | 1105.0 |
| 2025-08-01 01:30:00 | NQ | Futures | 23509.49 | 23518.07 | 23493.1 | 23495.62 | 1846.0 |
| 2025-08-01 02:00:00 | NQ | Futures | 23495.12 | 23499.4 | 23462.84 | 23465.11 | 2431.0 |
| 2025-08-01 02:30:00 | NQ | Futures | 23464.35 | 23482.51 | 23458.05 | 23472.42 | 2804.0 |
| 2025-08-01 03:00:00 | NQ | Futures | 23471.41 | 23481.25 | 23386.93 | 23387.94 | 8045.0 |
| 2025-08-01 03:30:00 | NQ | Futures | 23386.93 | 23405.09 | 23328.68 | 23371.3 | 10418.0 |
| 2025-08-01 04:00:00 | NQ | Futures | 23371.55 | 23374.32 | 23271.94 | 23283.79 | 13114.0 |
| 2025-08-01 04:30:00 | NQ | Futures | 23283.54 | 23329.18 | 23263.37 | 23315.31 | 9424.0 |
| 2025-08-01 05:00:00 | NQ | Futures | 23315.06 | 23341.79 | 23293.63 | 23295.64 | 7271.0 |
| 2025-08-01 05:30:00 | NQ | Futures | 23295.14 | 23336.5 | 23286.82 | 23329.18 | 5094.0 |
| 2025-08-01 06:00:00 | NQ | Futures | 23328.18 | 23328.93 | 23283.79 | 23304.72 | 7329.0 |
| 2025-08-01 06:30:00 | NQ | Futures | 23303.71 | 23306.24 | 23232.1 | 23255.55 | 8511.0 |
| 2025-08-01 07:00:00 | NQ | Futures | 23256.56 | 23313.55 | 23252.27 | 23304.47 | 6579.0 |
| 2025-08-01 07:30:00 | NQ | Futures | 23304.72 | 23330.95 | 23299.93 | 23327.42 | 6381.0 |
> showing 50 of 3,180 rows — these rows as CSV