PREVIEW / futures_30min / 2025-07-23
file: by_date/futures_30min/2025/2025-07-23.parquet size: 108 KB rows: 3,929
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-07-23 00:00:00 | ES | Futures | 6406.68 | 6407.44 | 6405.17 | 6406.94 | 1434.0 |
| 2025-07-23 00:30:00 | ES | Futures | 6407.19 | 6410.46 | 6406.68 | 6409.96 | 2038.0 |
| 2025-07-23 01:00:00 | ES | Futures | 6409.96 | 6411.22 | 6409.2 | 6410.71 | 1932.0 |
| 2025-07-23 01:30:00 | ES | Futures | 6410.97 | 6412.48 | 6409.46 | 6410.46 | 2609.0 |
| 2025-07-23 02:00:00 | ES | Futures | 6410.46 | 6410.97 | 6407.94 | 6409.96 | 2270.0 |
| 2025-07-23 02:30:00 | ES | Futures | 6409.96 | 6413.23 | 6407.69 | 6412.73 | 3580.0 |
| 2025-07-23 03:00:00 | ES | Futures | 6412.73 | 6415.25 | 6410.71 | 6412.23 | 6768.0 |
| 2025-07-23 03:30:00 | ES | Futures | 6412.23 | 6413.23 | 6408.2 | 6409.2 | 5572.0 |
| 2025-07-23 04:00:00 | ES | Futures | 6409.2 | 6417.52 | 6408.7 | 6416.26 | 7715.0 |
| 2025-07-23 04:30:00 | ES | Futures | 6416.0 | 6419.53 | 6414.24 | 6419.03 | 5756.0 |
| 2025-07-23 05:00:00 | ES | Futures | 6419.03 | 6421.04 | 6416.26 | 6416.26 | 5512.0 |
| 2025-07-23 05:30:00 | ES | Futures | 6416.26 | 6420.54 | 6415.75 | 6419.53 | 3457.0 |
| 2025-07-23 06:00:00 | ES | Futures | 6419.78 | 6422.05 | 6417.77 | 6420.03 | 3734.0 |
| 2025-07-23 06:30:00 | ES | Futures | 6420.03 | 6422.05 | 6417.52 | 6418.02 | 4813.0 |
| 2025-07-23 07:00:00 | ES | Futures | 6417.77 | 6418.52 | 6410.71 | 6415.0 | 10674.0 |
| 2025-07-23 07:30:00 | ES | Futures | 6415.0 | 6418.77 | 6413.74 | 6417.77 | 4815.0 |
| 2025-07-23 08:00:00 | ES | Futures | 6417.52 | 6420.29 | 6416.51 | 6418.77 | 6579.0 |
| 2025-07-23 08:30:00 | ES | Futures | 6418.77 | 6418.77 | 6413.99 | 6417.26 | 9339.0 |
| 2025-07-23 09:00:00 | ES | Futures | 6417.26 | 6424.57 | 6416.0 | 6420.54 | 21631.0 |
| 2025-07-23 09:30:00 | ES | Futures | 6420.54 | 6421.29 | 6401.65 | 6403.91 | 119312.0 |
| 2025-07-23 10:00:00 | ES | Futures | 6403.91 | 6411.72 | 6401.14 | 6411.72 | 72527.0 |
| 2025-07-23 10:30:00 | ES | Futures | 6411.72 | 6412.23 | 6404.92 | 6411.22 | 50937.0 |
| 2025-07-23 11:00:00 | ES | Futures | 6410.97 | 6413.74 | 6407.19 | 6412.48 | 51425.0 |
| 2025-07-23 11:30:00 | ES | Futures | 6412.48 | 6432.88 | 6408.95 | 6425.58 | 117558.0 |
| 2025-07-23 12:00:00 | ES | Futures | 6425.32 | 6431.12 | 6418.27 | 6421.55 | 85983.0 |
| 2025-07-23 12:30:00 | ES | Futures | 6421.55 | 6425.58 | 6417.77 | 6423.31 | 39037.0 |
| 2025-07-23 13:00:00 | ES | Futures | 6423.31 | 6426.58 | 6419.53 | 6425.83 | 36022.0 |
| 2025-07-23 13:30:00 | ES | Futures | 6425.58 | 6433.64 | 6422.3 | 6429.86 | 70896.0 |
| 2025-07-23 14:00:00 | ES | Futures | 6430.11 | 6441.69 | 6430.11 | 6437.41 | 60160.0 |
| 2025-07-23 14:30:00 | ES | Futures | 6437.41 | 6440.44 | 6435.9 | 6437.41 | 37638.0 |
| 2025-07-23 15:00:00 | ES | Futures | 6437.67 | 6438.92 | 6434.39 | 6438.67 | 37522.0 |
| 2025-07-23 15:30:00 | ES | Futures | 6438.42 | 6447.24 | 6434.39 | 6446.98 | 148007.0 |
| 2025-07-23 16:00:00 | ES | Futures | 6447.24 | 6454.04 | 6440.18 | 6444.97 | 53273.0 |
| 2025-07-23 16:30:00 | ES | Futures | 6444.97 | 6455.3 | 6444.47 | 6453.78 | 15148.0 |
| 2025-07-23 18:00:00 | ES | Futures | 6452.02 | 6452.78 | 6449.0 | 6451.77 | 4041.0 |
| 2025-07-23 18:30:00 | ES | Futures | 6451.77 | 6452.53 | 6448.5 | 6449.25 | 2178.0 |
| 2025-07-23 19:00:00 | ES | Futures | 6449.25 | 6451.77 | 6448.5 | 6449.5 | 1231.0 |
| 2025-07-23 19:30:00 | ES | Futures | 6449.5 | 6453.03 | 6449.25 | 6452.02 | 1482.0 |
| 2025-07-23 20:00:00 | ES | Futures | 6451.77 | 6451.77 | 6448.5 | 6451.52 | 2364.0 |
| 2025-07-23 20:30:00 | ES | Futures | 6451.52 | 6452.53 | 6449.5 | 6450.01 | 1888.0 |
| 2025-07-23 21:00:00 | ES | Futures | 6450.01 | 6454.79 | 6449.5 | 6452.78 | 2457.0 |
| 2025-07-23 21:30:00 | ES | Futures | 6452.53 | 6453.28 | 6451.77 | 6453.03 | 2028.0 |
| 2025-07-23 22:00:00 | ES | Futures | 6453.03 | 6454.79 | 6452.27 | 6453.53 | 1832.0 |
| 2025-07-23 22:30:00 | ES | Futures | 6453.78 | 6454.29 | 6452.53 | 6453.03 | 1083.0 |
| 2025-07-23 23:00:00 | ES | Futures | 6453.03 | 6453.03 | 6451.01 | 6451.52 | 1261.0 |
| 2025-07-23 23:30:00 | ES | Futures | 6451.52 | 6451.77 | 6447.74 | 6448.5 | 2168.0 |
| 2025-07-23 00:00:00 | NQ | Futures | 23440.65 | 23443.42 | 23434.34 | 23443.42 | 648.0 |
| 2025-07-23 00:30:00 | NQ | Futures | 23443.67 | 23454.01 | 23441.4 | 23450.99 | 1098.0 |
| 2025-07-23 01:00:00 | NQ | Futures | 23450.99 | 23456.79 | 23447.2 | 23456.53 | 907.0 |
| 2025-07-23 01:30:00 | NQ | Futures | 23457.04 | 23462.08 | 23447.71 | 23453.0 | 1422.0 |
> showing 50 of 3,929 rows — these rows as CSV