PREVIEW / futures_30min / 2025-07-21
file: by_date/futures_30min/2025/2025-07-21.parquet size: 105 KB rows: 3,855
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-21 00:00:00 | ES | Futures | 6387.29 | 6390.56 | 6386.79 | 6390.31 | 1133.0 |
| 2025-07-21 00:30:00 | ES | Futures | 6390.06 | 6390.82 | 6390.06 | 6390.82 | 785.0 |
| 2025-07-21 01:00:00 | ES | Futures | 6390.56 | 6391.57 | 6388.8 | 6390.31 | 1007.0 |
| 2025-07-21 01:30:00 | ES | Futures | 6390.31 | 6391.32 | 6389.05 | 6389.31 | 1314.0 |
| 2025-07-21 02:00:00 | ES | Futures | 6389.31 | 6396.61 | 6388.8 | 6396.11 | 3079.0 |
| 2025-07-21 02:30:00 | ES | Futures | 6396.36 | 6397.37 | 6392.83 | 6393.84 | 3088.0 |
| 2025-07-21 03:00:00 | ES | Futures | 6393.84 | 6398.88 | 6393.59 | 6397.87 | 3972.0 |
| 2025-07-21 03:30:00 | ES | Futures | 6397.87 | 6399.13 | 6396.11 | 6396.86 | 2912.0 |
| 2025-07-21 04:00:00 | ES | Futures | 6396.61 | 6402.15 | 6396.61 | 6400.89 | 5846.0 |
| 2025-07-21 04:30:00 | ES | Futures | 6400.89 | 6400.89 | 6397.87 | 6399.63 | 2582.0 |
| 2025-07-21 05:00:00 | ES | Futures | 6399.63 | 6401.14 | 6399.63 | 6400.64 | 1823.0 |
| 2025-07-21 05:30:00 | ES | Futures | 6400.64 | 6400.89 | 6398.12 | 6398.88 | 1773.0 |
| 2025-07-21 06:00:00 | ES | Futures | 6399.13 | 6401.65 | 6397.62 | 6399.38 | 2818.0 |
| 2025-07-21 06:30:00 | ES | Futures | 6399.63 | 6399.88 | 6395.35 | 6398.37 | 3818.0 |
| 2025-07-21 07:00:00 | ES | Futures | 6398.37 | 6398.62 | 6395.6 | 6397.62 | 4587.0 |
| 2025-07-21 07:30:00 | ES | Futures | 6397.62 | 6399.13 | 6395.85 | 6396.36 | 4412.0 |
| 2025-07-21 08:00:00 | ES | Futures | 6396.61 | 6397.62 | 6394.85 | 6396.11 | 4405.0 |
| 2025-07-21 08:30:00 | ES | Futures | 6395.85 | 6397.62 | 6389.31 | 6390.06 | 10272.0 |
| 2025-07-21 09:00:00 | ES | Futures | 6389.81 | 6393.34 | 6387.29 | 6392.83 | 21478.0 |
| 2025-07-21 09:30:00 | ES | Futures | 6393.08 | 6413.23 | 6392.08 | 6412.23 | 102614.0 |
| 2025-07-21 10:00:00 | ES | Futures | 6411.97 | 6420.03 | 6409.96 | 6419.03 | 71536.0 |
| 2025-07-21 10:30:00 | ES | Futures | 6419.03 | 6420.29 | 6412.48 | 6416.51 | 51752.0 |
| 2025-07-21 11:00:00 | ES | Futures | 6416.51 | 6419.78 | 6415.0 | 6418.77 | 35534.0 |
| 2025-07-21 11:30:00 | ES | Futures | 6418.77 | 6421.8 | 6417.26 | 6418.27 | 42438.0 |
| 2025-07-21 12:00:00 | ES | Futures | 6418.02 | 6418.27 | 6411.22 | 6413.74 | 48565.0 |
| 2025-07-21 12:30:00 | ES | Futures | 6413.74 | 6419.53 | 6413.23 | 6418.52 | 29503.0 |
| 2025-07-21 13:00:00 | ES | Futures | 6418.77 | 6421.29 | 6418.52 | 6420.03 | 25592.0 |
| 2025-07-21 13:30:00 | ES | Futures | 6420.03 | 6421.55 | 6417.01 | 6417.77 | 23916.0 |
| 2025-07-21 14:00:00 | ES | Futures | 6417.52 | 6418.52 | 6416.26 | 6417.77 | 25584.0 |
| 2025-07-21 14:30:00 | ES | Futures | 6417.77 | 6418.02 | 6408.7 | 6409.2 | 50041.0 |
| 2025-07-21 15:00:00 | ES | Futures | 6409.2 | 6409.71 | 6396.36 | 6399.88 | 94632.0 |
| 2025-07-21 15:30:00 | ES | Futures | 6399.88 | 6402.4 | 6388.55 | 6392.83 | 145729.0 |
| 2025-07-21 16:00:00 | ES | Futures | 6393.08 | 6396.36 | 6391.32 | 6393.84 | 35917.0 |
| 2025-07-21 16:30:00 | ES | Futures | 6393.84 | 6396.36 | 6393.84 | 6396.11 | 6256.0 |
| 2025-07-21 18:00:00 | ES | Futures | 6394.59 | 6397.11 | 6393.59 | 6397.11 | 2637.0 |
| 2025-07-21 18:30:00 | ES | Futures | 6396.86 | 6397.11 | 6394.59 | 6395.1 | 961.0 |
| 2025-07-21 19:00:00 | ES | Futures | 6395.35 | 6396.36 | 6394.59 | 6396.11 | 953.0 |
| 2025-07-21 19:30:00 | ES | Futures | 6396.11 | 6396.61 | 6393.59 | 6395.85 | 1503.0 |
| 2025-07-21 20:00:00 | ES | Futures | 6395.6 | 6399.13 | 6395.35 | 6398.88 | 2642.0 |
| 2025-07-21 20:30:00 | ES | Futures | 6398.62 | 6398.88 | 6394.85 | 6395.35 | 2365.0 |
| 2025-07-21 21:00:00 | ES | Futures | 6395.35 | 6396.86 | 6394.34 | 6396.61 | 2870.0 |
| 2025-07-21 21:30:00 | ES | Futures | 6396.86 | 6399.63 | 6396.36 | 6399.13 | 2811.0 |
| 2025-07-21 22:00:00 | ES | Futures | 6399.38 | 6399.63 | 6395.85 | 6395.85 | 1464.0 |
| 2025-07-21 22:30:00 | ES | Futures | 6395.85 | 6396.86 | 6394.34 | 6394.85 | 1311.0 |
| 2025-07-21 23:00:00 | ES | Futures | 6395.1 | 6396.11 | 6393.59 | 6393.84 | 1388.0 |
| 2025-07-21 23:30:00 | ES | Futures | 6393.84 | 6394.34 | 6391.32 | 6392.58 | 2441.0 |
| 2025-07-21 00:00:00 | NQ | Futures | 23449.47 | 23467.88 | 23448.72 | 23467.38 | 1097.0 |
| 2025-07-21 00:30:00 | NQ | Futures | 23467.38 | 23473.18 | 23466.12 | 23472.67 | 611.0 |
| 2025-07-21 01:00:00 | NQ | Futures | 23472.67 | 23478.47 | 23465.11 | 23473.43 | 1026.0 |
| 2025-07-21 01:30:00 | NQ | Futures | 23472.93 | 23478.47 | 23469.14 | 23471.16 | 967.0 |
> showing 50 of 3,855 rows — these rows as CSV