PREVIEW / futures_30min / 2025-06-23
file: by_date/futures_30min/2025/2025-06-23.parquet size: 117 KB rows: 3,975
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-23 00:00:00 | ES | Futures | 6047.01 | 6048.77 | 6045.5 | 6047.01 | 1569.0 |
| 2025-06-23 00:30:00 | ES | Futures | 6047.26 | 6047.76 | 6045.5 | 6046.76 | 1318.0 |
| 2025-06-23 01:00:00 | ES | Futures | 6046.76 | 6057.33 | 6046.5 | 6052.55 | 3585.0 |
| 2025-06-23 01:30:00 | ES | Futures | 6052.8 | 6054.31 | 6050.28 | 6054.06 | 2371.0 |
| 2025-06-23 02:00:00 | ES | Futures | 6054.06 | 6059.1 | 6051.29 | 6053.3 | 3333.0 |
| 2025-06-23 02:30:00 | ES | Futures | 6053.81 | 6060.86 | 6052.04 | 6056.33 | 3911.0 |
| 2025-06-23 03:00:00 | ES | Futures | 6056.33 | 6071.19 | 6056.07 | 6066.4 | 9129.0 |
| 2025-06-23 03:30:00 | ES | Futures | 6066.4 | 6075.22 | 6065.14 | 6073.45 | 7017.0 |
| 2025-06-23 04:00:00 | ES | Futures | 6073.45 | 6084.54 | 6070.94 | 6077.48 | 10771.0 |
| 2025-06-23 04:30:00 | ES | Futures | 6077.48 | 6080.0 | 6075.72 | 6078.24 | 3716.0 |
| 2025-06-23 05:00:00 | ES | Futures | 6078.24 | 6083.28 | 6072.19 | 6076.48 | 6535.0 |
| 2025-06-23 05:30:00 | ES | Futures | 6076.48 | 6078.74 | 6074.46 | 6074.46 | 3423.0 |
| 2025-06-23 06:00:00 | ES | Futures | 6074.46 | 6083.28 | 6069.68 | 6070.18 | 11325.0 |
| 2025-06-23 06:30:00 | ES | Futures | 6070.18 | 6072.95 | 6065.65 | 6066.65 | 5703.0 |
| 2025-06-23 07:00:00 | ES | Futures | 6067.16 | 6068.67 | 6052.04 | 6056.07 | 8303.0 |
| 2025-06-23 07:30:00 | ES | Futures | 6056.07 | 6058.85 | 6047.51 | 6057.84 | 9831.0 |
| 2025-06-23 08:00:00 | ES | Futures | 6058.09 | 6063.88 | 6056.33 | 6060.1 | 7837.0 |
| 2025-06-23 08:30:00 | ES | Futures | 6060.36 | 6072.95 | 6059.6 | 6071.94 | 8913.0 |
| 2025-06-23 09:00:00 | ES | Futures | 6071.94 | 6074.21 | 6063.38 | 6070.43 | 23402.0 |
| 2025-06-23 09:30:00 | ES | Futures | 6070.18 | 6087.06 | 6055.57 | 6086.8 | 100040.0 |
| 2025-06-23 10:00:00 | ES | Futures | 6086.8 | 6103.68 | 6086.8 | 6096.12 | 98020.0 |
| 2025-06-23 10:30:00 | ES | Futures | 6096.37 | 6098.64 | 6084.54 | 6085.04 | 58958.0 |
| 2025-06-23 11:00:00 | ES | Futures | 6085.29 | 6097.38 | 6083.78 | 6084.54 | 52602.0 |
| 2025-06-23 11:30:00 | ES | Futures | 6084.28 | 6087.81 | 6077.74 | 6078.74 | 59148.0 |
| 2025-06-23 12:00:00 | ES | Futures | 6079.0 | 6081.26 | 6061.36 | 6062.88 | 64709.0 |
| 2025-06-23 12:30:00 | ES | Futures | 6062.88 | 6074.71 | 6038.19 | 6055.82 | 170614.0 |
| 2025-06-23 13:00:00 | ES | Futures | 6055.82 | 6101.16 | 6051.54 | 6098.14 | 106941.0 |
| 2025-06-23 13:30:00 | ES | Futures | 6098.14 | 6115.27 | 6098.14 | 6106.95 | 87275.0 |
| 2025-06-23 14:00:00 | ES | Futures | 6106.95 | 6113.0 | 6104.69 | 6105.19 | 45324.0 |
| 2025-06-23 14:30:00 | ES | Futures | 6105.19 | 6110.23 | 6101.16 | 6106.7 | 40569.0 |
| 2025-06-23 15:00:00 | ES | Futures | 6106.45 | 6116.02 | 6105.69 | 6114.01 | 48947.0 |
| 2025-06-23 15:30:00 | ES | Futures | 6113.75 | 6127.1 | 6110.23 | 6122.32 | 124801.0 |
| 2025-06-23 16:00:00 | ES | Futures | 6122.57 | 6123.33 | 6117.78 | 6121.81 | 38238.0 |
| 2025-06-23 16:30:00 | ES | Futures | 6121.81 | 6124.58 | 6121.31 | 6123.07 | 7158.0 |
| 2025-06-23 18:00:00 | ES | Futures | 6123.58 | 6151.28 | 6120.81 | 6146.5 | 15678.0 |
| 2025-06-23 18:30:00 | ES | Futures | 6146.25 | 6148.76 | 6138.69 | 6147.25 | 8597.0 |
| 2025-06-23 19:00:00 | ES | Futures | 6147.25 | 6158.84 | 6146.5 | 6155.06 | 8091.0 |
| 2025-06-23 19:30:00 | ES | Futures | 6155.06 | 6158.59 | 6151.28 | 6154.31 | 4023.0 |
| 2025-06-23 20:00:00 | ES | Futures | 6154.81 | 6156.57 | 6149.27 | 6152.79 | 4891.0 |
| 2025-06-23 20:30:00 | ES | Futures | 6152.79 | 6157.08 | 6144.99 | 6152.79 | 7680.0 |
| 2025-06-23 21:00:00 | ES | Futures | 6152.54 | 6158.34 | 6149.02 | 6155.57 | 3853.0 |
| 2025-06-23 21:30:00 | ES | Futures | 6155.82 | 6162.37 | 6155.06 | 6160.85 | 3899.0 |
| 2025-06-23 22:00:00 | ES | Futures | 6160.6 | 6161.11 | 6149.77 | 6154.81 | 6102.0 |
| 2025-06-23 22:30:00 | ES | Futures | 6154.56 | 6154.81 | 6149.77 | 6153.3 | 2354.0 |
| 2025-06-23 23:00:00 | ES | Futures | 6153.05 | 6156.57 | 6152.54 | 6155.82 | 1805.0 |
| 2025-06-23 23:30:00 | ES | Futures | 6156.07 | 6158.59 | 6155.57 | 6157.58 | 2655.0 |
| 2025-06-23 00:00:00 | NQ | Futures | 21956.33 | 21963.64 | 21947.0 | 21956.58 | 1062.0 |
| 2025-06-23 00:30:00 | NQ | Futures | 21956.58 | 21958.85 | 21948.51 | 21954.57 | 787.0 |
| 2025-06-23 01:00:00 | NQ | Futures | 21954.57 | 22006.01 | 21953.3 | 21987.85 | 3014.0 |
| 2025-06-23 01:30:00 | NQ | Futures | 21988.1 | 22000.21 | 21979.78 | 21999.71 | 1814.0 |
> showing 50 of 3,975 rows — these rows as CSV