PREVIEW / futures_30min / 2025-07-31
file: by_date/futures_30min/2025/2025-07-31.parquet size: 110 KB rows: 3,911
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-31 00:00:00 | ES | Futures | 6503.66 | 6506.17 | 6502.65 | 6502.9 | 3019.0 |
| 2025-07-31 00:30:00 | ES | Futures | 6502.9 | 6507.69 | 6502.14 | 6506.43 | 2702.0 |
| 2025-07-31 01:00:00 | ES | Futures | 6506.43 | 6506.43 | 6502.9 | 6502.9 | 2175.0 |
| 2025-07-31 01:30:00 | ES | Futures | 6503.15 | 6506.93 | 6501.64 | 6505.67 | 2747.0 |
| 2025-07-31 02:00:00 | ES | Futures | 6505.92 | 6507.69 | 6502.4 | 6503.15 | 3578.0 |
| 2025-07-31 02:30:00 | ES | Futures | 6503.15 | 6504.16 | 6500.38 | 6502.9 | 4455.0 |
| 2025-07-31 03:00:00 | ES | Futures | 6503.15 | 6509.95 | 6500.13 | 6509.45 | 9487.0 |
| 2025-07-31 03:30:00 | ES | Futures | 6509.45 | 6517.01 | 6508.19 | 6513.73 | 9213.0 |
| 2025-07-31 04:00:00 | ES | Futures | 6513.73 | 6513.98 | 6509.2 | 6511.97 | 7319.0 |
| 2025-07-31 04:30:00 | ES | Futures | 6511.97 | 6515.49 | 6508.95 | 6509.95 | 6129.0 |
| 2025-07-31 05:00:00 | ES | Futures | 6510.2 | 6510.96 | 6507.18 | 6508.19 | 4050.0 |
| 2025-07-31 05:30:00 | ES | Futures | 6508.19 | 6508.19 | 6503.91 | 6505.17 | 5038.0 |
| 2025-07-31 06:00:00 | ES | Futures | 6505.17 | 6508.69 | 6504.16 | 6507.43 | 4910.0 |
| 2025-07-31 06:30:00 | ES | Futures | 6507.69 | 6509.95 | 6499.63 | 6500.13 | 5996.0 |
| 2025-07-31 07:00:00 | ES | Futures | 6499.88 | 6504.41 | 6497.11 | 6499.37 | 11678.0 |
| 2025-07-31 07:30:00 | ES | Futures | 6499.37 | 6502.9 | 6497.61 | 6499.37 | 8492.0 |
| 2025-07-31 08:00:00 | ES | Futures | 6499.37 | 6504.66 | 6498.62 | 6502.65 | 11237.0 |
| 2025-07-31 08:30:00 | ES | Futures | 6502.4 | 6506.93 | 6498.62 | 6504.41 | 19903.0 |
| 2025-07-31 09:00:00 | ES | Futures | 6504.16 | 6504.66 | 6494.34 | 6495.09 | 22075.0 |
| 2025-07-31 09:30:00 | ES | Futures | 6495.09 | 6499.37 | 6475.7 | 6493.83 | 190261.0 |
| 2025-07-31 10:00:00 | ES | Futures | 6493.83 | 6498.37 | 6485.02 | 6488.29 | 113358.0 |
| 2025-07-31 10:30:00 | ES | Futures | 6488.29 | 6491.82 | 6465.12 | 6466.13 | 107552.0 |
| 2025-07-31 11:00:00 | ES | Futures | 6465.87 | 6474.19 | 6450.26 | 6461.59 | 133156.0 |
| 2025-07-31 11:30:00 | ES | Futures | 6461.59 | 6475.7 | 6460.59 | 6475.7 | 70513.0 |
| 2025-07-31 12:00:00 | ES | Futures | 6475.45 | 6482.5 | 6471.92 | 6480.99 | 45398.0 |
| 2025-07-31 12:30:00 | ES | Futures | 6481.24 | 6483.51 | 6474.94 | 6478.22 | 46611.0 |
| 2025-07-31 13:00:00 | ES | Futures | 6478.22 | 6478.22 | 6443.46 | 6448.24 | 85862.0 |
| 2025-07-31 13:30:00 | ES | Futures | 6447.99 | 6456.56 | 6430.36 | 6434.39 | 123829.0 |
| 2025-07-31 14:00:00 | ES | Futures | 6434.39 | 6442.45 | 6413.23 | 6441.95 | 114326.0 |
| 2025-07-31 14:30:00 | ES | Futures | 6441.69 | 6451.01 | 6439.18 | 6441.19 | 69697.0 |
| 2025-07-31 15:00:00 | ES | Futures | 6441.19 | 6447.99 | 6425.32 | 6427.09 | 72456.0 |
| 2025-07-31 15:30:00 | ES | Futures | 6427.34 | 6436.15 | 6405.93 | 6418.77 | 286555.0 |
| 2025-07-31 16:00:00 | ES | Futures | 6419.03 | 6442.7 | 6405.17 | 6413.49 | 77575.0 |
| 2025-07-31 16:30:00 | ES | Futures | 6413.49 | 6431.37 | 6413.49 | 6416.51 | 25101.0 |
| 2025-07-31 18:00:00 | ES | Futures | 6407.19 | 6421.29 | 6407.19 | 6410.71 | 7063.0 |
| 2025-07-31 18:30:00 | ES | Futures | 6410.97 | 6412.23 | 6397.87 | 6406.43 | 9370.0 |
| 2025-07-31 19:00:00 | ES | Futures | 6406.68 | 6411.47 | 6402.65 | 6405.93 | 6318.0 |
| 2025-07-31 19:30:00 | ES | Futures | 6405.68 | 6411.47 | 6404.67 | 6410.46 | 4283.0 |
| 2025-07-31 20:00:00 | ES | Futures | 6410.21 | 6411.22 | 6393.84 | 6398.62 | 7605.0 |
| 2025-07-31 20:30:00 | ES | Futures | 6398.62 | 6407.44 | 6398.12 | 6404.42 | 4813.0 |
| 2025-07-31 21:00:00 | ES | Futures | 6404.42 | 6412.98 | 6402.91 | 6411.72 | 4691.0 |
| 2025-07-31 21:30:00 | ES | Futures | 6411.72 | 6414.49 | 6410.71 | 6412.73 | 4019.0 |
| 2025-07-31 22:00:00 | ES | Futures | 6412.73 | 6416.0 | 6410.21 | 6414.49 | 2966.0 |
| 2025-07-31 22:30:00 | ES | Futures | 6414.24 | 6417.26 | 6411.72 | 6415.75 | 2298.0 |
| 2025-07-31 23:00:00 | ES | Futures | 6416.0 | 6418.77 | 6415.25 | 6418.52 | 2443.0 |
| 2025-07-31 23:30:00 | ES | Futures | 6418.52 | 6420.29 | 6409.71 | 6409.96 | 3290.0 |
| 2025-07-31 00:00:00 | NQ | Futures | 24005.52 | 24008.3 | 23993.92 | 23995.94 | 1612.0 |
| 2025-07-31 00:30:00 | NQ | Futures | 23995.18 | 24016.37 | 23990.65 | 24012.59 | 2142.0 |
| 2025-07-31 01:00:00 | NQ | Futures | 24013.09 | 24017.12 | 23996.7 | 23997.96 | 2127.0 |
| 2025-07-31 01:30:00 | NQ | Futures | 23998.46 | 24009.81 | 23991.65 | 24007.54 | 1743.0 |
> showing 50 of 3,911 rows — these rows as CSV