PREVIEW / futures_30min / 2025-06-25
file: by_date/futures_30min/2025/2025-06-25.parquet size: 108 KB rows: 3,888
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-06-25 00:00:00 | ES | Futures | 6189.57 | 6192.34 | 6189.32 | 6192.09 | 622.0 |
| 2025-06-25 00:30:00 | ES | Futures | 6192.34 | 6194.1 | 6191.84 | 6194.1 | 666.0 |
| 2025-06-25 01:00:00 | ES | Futures | 6193.85 | 6195.87 | 6192.59 | 6195.11 | 1603.0 |
| 2025-06-25 01:30:00 | ES | Futures | 6195.11 | 6195.61 | 6194.1 | 6194.35 | 1445.0 |
| 2025-06-25 02:00:00 | ES | Futures | 6194.35 | 6195.87 | 6192.09 | 6193.85 | 2741.0 |
| 2025-06-25 02:30:00 | ES | Futures | 6194.1 | 6194.35 | 6191.58 | 6191.58 | 1674.0 |
| 2025-06-25 03:00:00 | ES | Futures | 6191.58 | 6194.86 | 6190.83 | 6194.61 | 3987.0 |
| 2025-06-25 03:30:00 | ES | Futures | 6194.61 | 6195.11 | 6189.06 | 6192.59 | 4967.0 |
| 2025-06-25 04:00:00 | ES | Futures | 6192.59 | 6194.61 | 6188.81 | 6190.32 | 5696.0 |
| 2025-06-25 04:30:00 | ES | Futures | 6190.32 | 6194.1 | 6187.3 | 6194.1 | 2917.0 |
| 2025-06-25 05:00:00 | ES | Futures | 6194.35 | 6197.88 | 6192.59 | 6193.6 | 4440.0 |
| 2025-06-25 05:30:00 | ES | Futures | 6193.6 | 6194.1 | 6190.32 | 6190.58 | 3303.0 |
| 2025-06-25 06:00:00 | ES | Futures | 6190.83 | 6192.34 | 6187.81 | 6191.08 | 4293.0 |
| 2025-06-25 06:30:00 | ES | Futures | 6190.83 | 6195.61 | 6190.07 | 6193.6 | 5152.0 |
| 2025-06-25 07:00:00 | ES | Futures | 6193.6 | 6194.35 | 6191.58 | 6193.6 | 4980.0 |
| 2025-06-25 07:30:00 | ES | Futures | 6193.85 | 6202.92 | 6193.85 | 6202.16 | 8566.0 |
| 2025-06-25 08:00:00 | ES | Futures | 6201.91 | 6203.17 | 6199.39 | 6201.91 | 7155.0 |
| 2025-06-25 08:30:00 | ES | Futures | 6201.91 | 6203.42 | 6198.64 | 6203.17 | 8660.0 |
| 2025-06-25 09:00:00 | ES | Futures | 6202.92 | 6203.93 | 6199.9 | 6201.15 | 13186.0 |
| 2025-06-25 09:30:00 | ES | Futures | 6201.15 | 6206.44 | 6195.87 | 6203.17 | 96117.0 |
| 2025-06-25 10:00:00 | ES | Futures | 6203.17 | 6205.18 | 6194.35 | 6198.38 | 72511.0 |
| 2025-06-25 10:30:00 | ES | Futures | 6198.38 | 6205.69 | 6196.62 | 6199.14 | 57394.0 |
| 2025-06-25 11:00:00 | ES | Futures | 6199.14 | 6199.64 | 6190.07 | 6193.09 | 56027.0 |
| 2025-06-25 11:30:00 | ES | Futures | 6193.35 | 6193.6 | 6186.04 | 6190.83 | 45950.0 |
| 2025-06-25 12:00:00 | ES | Futures | 6190.58 | 6194.61 | 6189.82 | 6191.33 | 28589.0 |
| 2025-06-25 12:30:00 | ES | Futures | 6191.58 | 6192.84 | 6186.04 | 6189.06 | 33119.0 |
| 2025-06-25 13:00:00 | ES | Futures | 6189.06 | 6193.35 | 6184.53 | 6192.09 | 35079.0 |
| 2025-06-25 13:30:00 | ES | Futures | 6192.34 | 6192.84 | 6176.72 | 6184.53 | 57470.0 |
| 2025-06-25 14:00:00 | ES | Futures | 6184.53 | 6187.55 | 6182.26 | 6185.79 | 28936.0 |
| 2025-06-25 14:30:00 | ES | Futures | 6185.54 | 6187.05 | 6182.52 | 6186.04 | 29071.0 |
| 2025-06-25 15:00:00 | ES | Futures | 6186.29 | 6195.87 | 6185.79 | 6191.84 | 45695.0 |
| 2025-06-25 15:30:00 | ES | Futures | 6192.09 | 6194.86 | 6185.54 | 6193.6 | 125739.0 |
| 2025-06-25 16:00:00 | ES | Futures | 6193.6 | 6194.1 | 6189.57 | 6190.07 | 32281.0 |
| 2025-06-25 16:30:00 | ES | Futures | 6189.82 | 6192.09 | 6189.57 | 6192.09 | 4614.0 |
| 2025-06-25 18:00:00 | ES | Futures | 6190.83 | 6196.62 | 6188.81 | 6191.58 | 3452.0 |
| 2025-06-25 18:30:00 | ES | Futures | 6191.58 | 6193.35 | 6190.58 | 6192.59 | 1162.0 |
| 2025-06-25 19:00:00 | ES | Futures | 6192.84 | 6193.09 | 6187.3 | 6189.06 | 3647.0 |
| 2025-06-25 19:30:00 | ES | Futures | 6188.81 | 6193.85 | 6187.3 | 6192.59 | 1818.0 |
| 2025-06-25 20:00:00 | ES | Futures | 6192.84 | 6195.11 | 6190.58 | 6194.86 | 1933.0 |
| 2025-06-25 20:30:00 | ES | Futures | 6194.61 | 6195.87 | 6193.6 | 6194.86 | 1765.0 |
| 2025-06-25 21:00:00 | ES | Futures | 6194.86 | 6195.11 | 6191.58 | 6192.09 | 1762.0 |
| 2025-06-25 21:30:00 | ES | Futures | 6192.09 | 6193.35 | 6190.83 | 6192.34 | 1251.0 |
| 2025-06-25 22:00:00 | ES | Futures | 6192.59 | 6196.87 | 6192.09 | 6195.11 | 1676.0 |
| 2025-06-25 22:30:00 | ES | Futures | 6195.11 | 6195.87 | 6193.35 | 6195.11 | 899.0 |
| 2025-06-25 23:00:00 | ES | Futures | 6195.36 | 6199.64 | 6195.36 | 6198.89 | 1891.0 |
| 2025-06-25 23:30:00 | ES | Futures | 6198.89 | 6201.15 | 6197.88 | 6198.89 | 1437.0 |
| 2025-06-25 00:00:00 | NQ | Futures | 22601.4 | 22614.51 | 22601.4 | 22613.25 | 500.0 |
| 2025-06-25 00:30:00 | NQ | Futures | 22613.5 | 22622.33 | 22611.74 | 22620.31 | 537.0 |
| 2025-06-25 01:00:00 | NQ | Futures | 22621.07 | 22630.91 | 22615.27 | 22628.64 | 1316.0 |
| 2025-06-25 01:30:00 | NQ | Futures | 22628.13 | 22632.17 | 22621.57 | 22621.83 | 863.0 |
> showing 50 of 3,888 rows — these rows as CSV