PREVIEW / futures_30min / 2025-06-24
file: by_date/futures_30min/2025/2025-06-24.parquet size: 108 KB rows: 3,907
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-24 00:00:00 | ES | Futures | 6157.58 | 6158.59 | 6151.79 | 6156.32 | 3325.0 |
| 2025-06-24 00:30:00 | ES | Futures | 6156.07 | 6158.34 | 6155.82 | 6157.33 | 1157.0 |
| 2025-06-24 01:00:00 | ES | Futures | 6157.33 | 6159.85 | 6157.08 | 6159.6 | 1575.0 |
| 2025-06-24 01:30:00 | ES | Futures | 6159.34 | 6170.43 | 6159.09 | 6168.41 | 5887.0 |
| 2025-06-24 02:00:00 | ES | Futures | 6168.41 | 6185.03 | 6168.41 | 6184.28 | 10662.0 |
| 2025-06-24 02:30:00 | ES | Futures | 6184.28 | 6185.54 | 6178.23 | 6183.52 | 7553.0 |
| 2025-06-24 03:00:00 | ES | Futures | 6183.52 | 6189.82 | 6174.71 | 6174.71 | 15194.0 |
| 2025-06-24 03:30:00 | ES | Futures | 6174.71 | 6176.22 | 6160.35 | 6171.69 | 19771.0 |
| 2025-06-24 04:00:00 | ES | Futures | 6171.94 | 6177.48 | 6165.64 | 6176.97 | 11483.0 |
| 2025-06-24 04:30:00 | ES | Futures | 6176.97 | 6176.97 | 6168.91 | 6171.43 | 5149.0 |
| 2025-06-24 05:00:00 | ES | Futures | 6171.43 | 6179.24 | 6170.93 | 6178.99 | 4642.0 |
| 2025-06-24 05:30:00 | ES | Futures | 6178.74 | 6182.01 | 6172.69 | 6173.45 | 4889.0 |
| 2025-06-24 06:00:00 | ES | Futures | 6173.45 | 6175.97 | 6168.16 | 6169.67 | 6005.0 |
| 2025-06-24 06:30:00 | ES | Futures | 6169.92 | 6172.94 | 6166.65 | 6169.17 | 5065.0 |
| 2025-06-24 07:00:00 | ES | Futures | 6168.91 | 6172.69 | 6161.36 | 6171.69 | 8997.0 |
| 2025-06-24 07:30:00 | ES | Futures | 6171.43 | 6174.2 | 6166.4 | 6170.68 | 9877.0 |
| 2025-06-24 08:00:00 | ES | Futures | 6170.68 | 6172.94 | 6163.12 | 6165.89 | 9113.0 |
| 2025-06-24 08:30:00 | ES | Futures | 6165.64 | 6169.42 | 6159.09 | 6165.14 | 13258.0 |
| 2025-06-24 09:00:00 | ES | Futures | 6165.14 | 6171.94 | 6163.63 | 6164.38 | 18176.0 |
| 2025-06-24 09:30:00 | ES | Futures | 6164.38 | 6176.22 | 6159.34 | 6162.37 | 101961.0 |
| 2025-06-24 10:00:00 | ES | Futures | 6162.37 | 6171.43 | 6154.81 | 6167.66 | 71186.0 |
| 2025-06-24 10:30:00 | ES | Futures | 6167.91 | 6175.72 | 6167.15 | 6171.69 | 59949.0 |
| 2025-06-24 11:00:00 | ES | Futures | 6171.43 | 6180.5 | 6171.43 | 6180.0 | 57358.0 |
| 2025-06-24 11:30:00 | ES | Futures | 6180.0 | 6184.28 | 6178.74 | 6180.25 | 43874.0 |
| 2025-06-24 12:00:00 | ES | Futures | 6180.25 | 6188.56 | 6178.99 | 6187.55 | 31377.0 |
| 2025-06-24 12:30:00 | ES | Futures | 6187.81 | 6194.86 | 6186.29 | 6189.32 | 44368.0 |
| 2025-06-24 13:00:00 | ES | Futures | 6189.32 | 6192.59 | 6185.79 | 6186.29 | 40412.0 |
| 2025-06-24 13:30:00 | ES | Futures | 6186.29 | 6196.62 | 6186.04 | 6194.61 | 35508.0 |
| 2025-06-24 14:00:00 | ES | Futures | 6194.86 | 6197.63 | 6192.34 | 6192.84 | 27193.0 |
| 2025-06-24 14:30:00 | ES | Futures | 6193.09 | 6196.37 | 6191.33 | 6195.87 | 28048.0 |
| 2025-06-24 15:00:00 | ES | Futures | 6195.87 | 6199.9 | 6195.61 | 6198.13 | 45537.0 |
| 2025-06-24 15:30:00 | ES | Futures | 6198.13 | 6201.41 | 6189.82 | 6189.82 | 140469.0 |
| 2025-06-24 16:00:00 | ES | Futures | 6189.82 | 6191.84 | 6188.31 | 6189.82 | 36336.0 |
| 2025-06-24 16:30:00 | ES | Futures | 6189.82 | 6192.34 | 6189.57 | 6189.57 | 6349.0 |
| 2025-06-24 18:00:00 | ES | Futures | 6190.83 | 6190.83 | 6184.28 | 6188.31 | 3773.0 |
| 2025-06-24 18:30:00 | ES | Futures | 6188.31 | 6188.56 | 6185.03 | 6187.05 | 1353.0 |
| 2025-06-24 19:00:00 | ES | Futures | 6187.05 | 6190.07 | 6184.28 | 6187.3 | 1849.0 |
| 2025-06-24 19:30:00 | ES | Futures | 6187.3 | 6193.6 | 6186.29 | 6192.09 | 2055.0 |
| 2025-06-24 20:00:00 | ES | Futures | 6192.34 | 6194.86 | 6190.32 | 6194.35 | 2867.0 |
| 2025-06-24 20:30:00 | ES | Futures | 6194.35 | 6194.61 | 6190.07 | 6193.85 | 1709.0 |
| 2025-06-24 21:00:00 | ES | Futures | 6193.6 | 6193.6 | 6187.81 | 6187.81 | 1890.0 |
| 2025-06-24 21:30:00 | ES | Futures | 6187.81 | 6190.07 | 6186.55 | 6187.81 | 2232.0 |
| 2025-06-24 22:00:00 | ES | Futures | 6188.06 | 6188.31 | 6186.55 | 6187.81 | 1258.0 |
| 2025-06-24 22:30:00 | ES | Futures | 6187.55 | 6189.32 | 6187.55 | 6188.56 | 1253.0 |
| 2025-06-24 23:00:00 | ES | Futures | 6188.56 | 6192.34 | 6188.56 | 6191.58 | 1496.0 |
| 2025-06-24 23:30:00 | ES | Futures | 6191.58 | 6192.59 | 6189.06 | 6189.32 | 1087.0 |
| 2025-06-24 00:00:00 | NQ | Futures | 22439.25 | 22442.02 | 22413.78 | 22429.92 | 1889.0 |
| 2025-06-24 00:30:00 | NQ | Futures | 22430.68 | 22443.03 | 22427.4 | 22436.73 | 869.0 |
| 2025-06-24 01:00:00 | NQ | Futures | 22437.23 | 22452.87 | 22435.47 | 22451.61 | 1456.0 |
| 2025-06-24 01:30:00 | NQ | Futures | 22450.85 | 22497.25 | 22449.09 | 22488.68 | 4204.0 |
> showing 50 of 3,907 rows — these rows as CSV