PREVIEW / futures_30min / 2025-07-18
file: by_date/futures_30min/2025/2025-07-18.parquet size: 88 KB rows: 3,095
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-18 00:00:00 | ES | Futures | 6397.62 | 6399.13 | 6396.61 | 6398.88 | 1246.0 |
| 2025-07-18 00:30:00 | ES | Futures | 6398.62 | 6399.13 | 6397.11 | 6398.37 | 1263.0 |
| 2025-07-18 01:00:00 | ES | Futures | 6398.62 | 6402.4 | 6398.62 | 6401.65 | 2865.0 |
| 2025-07-18 01:30:00 | ES | Futures | 6401.9 | 6403.91 | 6401.9 | 6403.41 | 2176.0 |
| 2025-07-18 02:00:00 | ES | Futures | 6403.41 | 6404.67 | 6401.4 | 6401.65 | 2702.0 |
| 2025-07-18 02:30:00 | ES | Futures | 6401.9 | 6403.16 | 6400.64 | 6401.9 | 3163.0 |
| 2025-07-18 03:00:00 | ES | Futures | 6401.9 | 6402.65 | 6395.85 | 6396.36 | 5688.0 |
| 2025-07-18 03:30:00 | ES | Futures | 6396.61 | 6397.11 | 6392.58 | 6393.84 | 5979.0 |
| 2025-07-18 04:00:00 | ES | Futures | 6393.59 | 6398.12 | 6393.59 | 6396.61 | 3596.0 |
| 2025-07-18 04:30:00 | ES | Futures | 6396.86 | 6398.12 | 6394.59 | 6396.36 | 3520.0 |
| 2025-07-18 05:00:00 | ES | Futures | 6396.11 | 6397.87 | 6395.6 | 6396.86 | 2499.0 |
| 2025-07-18 05:30:00 | ES | Futures | 6397.11 | 6397.62 | 6395.1 | 6395.85 | 2432.0 |
| 2025-07-18 06:00:00 | ES | Futures | 6395.85 | 6396.36 | 6388.3 | 6390.06 | 4813.0 |
| 2025-07-18 06:30:00 | ES | Futures | 6390.06 | 6391.57 | 6388.8 | 6390.31 | 3389.0 |
| 2025-07-18 07:00:00 | ES | Futures | 6390.56 | 6392.33 | 6387.04 | 6389.56 | 5436.0 |
| 2025-07-18 07:30:00 | ES | Futures | 6389.31 | 6392.58 | 6388.55 | 6390.82 | 5318.0 |
| 2025-07-18 08:00:00 | ES | Futures | 6390.82 | 6395.6 | 6390.31 | 6393.59 | 8951.0 |
| 2025-07-18 08:30:00 | ES | Futures | 6393.34 | 6396.36 | 6391.32 | 6395.6 | 11304.0 |
| 2025-07-18 09:00:00 | ES | Futures | 6395.35 | 6401.14 | 6393.34 | 6399.63 | 38357.0 |
| 2025-07-18 09:30:00 | ES | Futures | 6399.63 | 6399.88 | 6390.06 | 6392.58 | 98133.0 |
| 2025-07-18 10:00:00 | ES | Futures | 6392.33 | 6401.14 | 6378.73 | 6379.99 | 103229.0 |
| 2025-07-18 10:30:00 | ES | Futures | 6379.73 | 6385.28 | 6376.96 | 6377.22 | 65279.0 |
| 2025-07-18 11:00:00 | ES | Futures | 6377.22 | 6383.26 | 6374.7 | 6382.25 | 57503.0 |
| 2025-07-18 11:30:00 | ES | Futures | 6382.25 | 6387.79 | 6381.75 | 6387.54 | 44000.0 |
| 2025-07-18 12:00:00 | ES | Futures | 6387.54 | 6388.05 | 6371.67 | 6375.7 | 71012.0 |
| 2025-07-18 12:30:00 | ES | Futures | 6375.96 | 6380.24 | 6370.92 | 6372.68 | 61604.0 |
| 2025-07-18 13:00:00 | ES | Futures | 6372.68 | 6378.22 | 6370.67 | 6375.45 | 52584.0 |
| 2025-07-18 13:30:00 | ES | Futures | 6375.45 | 6381.75 | 6374.19 | 6377.22 | 36878.0 |
| 2025-07-18 14:00:00 | ES | Futures | 6377.22 | 6380.49 | 6371.93 | 6377.47 | 34021.0 |
| 2025-07-18 14:30:00 | ES | Futures | 6377.22 | 6380.49 | 6376.71 | 6378.73 | 31102.0 |
| 2025-07-18 15:00:00 | ES | Futures | 6378.47 | 6382.5 | 6376.46 | 6380.49 | 38927.0 |
| 2025-07-18 15:30:00 | ES | Futures | 6380.49 | 6384.52 | 6376.71 | 6382.25 | 105353.0 |
| 2025-07-18 16:00:00 | ES | Futures | 6382.25 | 6383.51 | 6380.74 | 6381.75 | 31335.0 |
| 2025-07-18 16:30:00 | ES | Futures | 6381.75 | 6383.51 | 6380.99 | 6382.76 | 6846.0 |
| 2025-07-18 00:00:00 | NQ | Futures | 23478.47 | 23482.51 | 23474.19 | 23480.49 | 662.0 |
| 2025-07-18 00:30:00 | NQ | Futures | 23481.0 | 23484.78 | 23476.46 | 23481.5 | 639.0 |
| 2025-07-18 01:00:00 | NQ | Futures | 23481.75 | 23499.15 | 23480.49 | 23498.9 | 1655.0 |
| 2025-07-18 01:30:00 | NQ | Futures | 23499.15 | 23512.27 | 23498.14 | 23506.97 | 1757.0 |
| 2025-07-18 02:00:00 | NQ | Futures | 23505.96 | 23512.52 | 23498.4 | 23499.15 | 1221.0 |
| 2025-07-18 02:30:00 | NQ | Futures | 23499.4 | 23502.43 | 23485.53 | 23486.8 | 2076.0 |
| 2025-07-18 03:00:00 | NQ | Futures | 23486.29 | 23495.62 | 23474.44 | 23478.73 | 2607.0 |
| 2025-07-18 03:30:00 | NQ | Futures | 23478.98 | 23486.29 | 23463.34 | 23472.42 | 2608.0 |
| 2025-07-18 04:00:00 | NQ | Futures | 23471.92 | 23489.57 | 23468.64 | 23483.77 | 2006.0 |
| 2025-07-18 04:30:00 | NQ | Futures | 23484.27 | 23488.56 | 23476.2 | 23484.27 | 1208.0 |
| 2025-07-18 05:00:00 | NQ | Futures | 23484.02 | 23493.35 | 23481.5 | 23486.8 | 1048.0 |
| 2025-07-18 05:30:00 | NQ | Futures | 23487.3 | 23490.83 | 23477.72 | 23481.5 | 1382.0 |
| 2025-07-18 06:00:00 | NQ | Futures | 23480.49 | 23484.27 | 23454.77 | 23462.33 | 2570.0 |
| 2025-07-18 06:30:00 | NQ | Futures | 23462.59 | 23470.66 | 23455.53 | 23468.89 | 2044.0 |
| 2025-07-18 07:00:00 | NQ | Futures | 23469.65 | 23475.45 | 23453.76 | 23463.34 | 2474.0 |
| 2025-07-18 07:30:00 | NQ | Futures | 23463.09 | 23475.2 | 23461.83 | 23466.87 | 2224.0 |
> showing 50 of 3,095 rows — these rows as CSV