PREVIEW / futures_30min / 2025-06-18
file: by_date/futures_30min/2025/2025-06-18.parquet size: 106 KB rows: 3,789
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-18 00:00:00 | ES | Futures | 6086.05 | 6089.57 | 6081.77 | 6083.78 | 1608.0 |
| 2025-06-18 00:30:00 | ES | Futures | 6084.03 | 6090.58 | 6083.53 | 6088.57 | 1351.0 |
| 2025-06-18 01:00:00 | ES | Futures | 6088.57 | 6092.34 | 6088.31 | 6090.58 | 1475.0 |
| 2025-06-18 01:30:00 | ES | Futures | 6090.83 | 6093.1 | 6089.07 | 6091.09 | 1403.0 |
| 2025-06-18 02:00:00 | ES | Futures | 6091.09 | 6099.15 | 6089.57 | 6099.15 | 4160.0 |
| 2025-06-18 02:30:00 | ES | Futures | 6098.64 | 6102.42 | 6094.36 | 6094.86 | 3373.0 |
| 2025-06-18 03:00:00 | ES | Futures | 6094.86 | 6100.91 | 6094.11 | 6097.38 | 4847.0 |
| 2025-06-18 03:30:00 | ES | Futures | 6097.63 | 6102.42 | 6094.36 | 6097.38 | 3665.0 |
| 2025-06-18 04:00:00 | ES | Futures | 6097.38 | 6101.41 | 6093.35 | 6095.87 | 4487.0 |
| 2025-06-18 04:30:00 | ES | Futures | 6096.12 | 6101.66 | 6095.62 | 6100.4 | 3384.0 |
| 2025-06-18 05:00:00 | ES | Futures | 6100.4 | 6108.21 | 6100.4 | 6102.92 | 4689.0 |
| 2025-06-18 05:30:00 | ES | Futures | 6102.92 | 6104.43 | 6099.9 | 6100.4 | 4025.0 |
| 2025-06-18 06:00:00 | ES | Futures | 6100.15 | 6100.91 | 6089.07 | 6092.85 | 6501.0 |
| 2025-06-18 06:30:00 | ES | Futures | 6092.85 | 6094.11 | 6079.75 | 6081.26 | 8447.0 |
| 2025-06-18 07:00:00 | ES | Futures | 6081.01 | 6088.31 | 6079.75 | 6087.06 | 8290.0 |
| 2025-06-18 07:30:00 | ES | Futures | 6087.06 | 6099.15 | 6085.8 | 6093.35 | 10260.0 |
| 2025-06-18 08:00:00 | ES | Futures | 6093.35 | 6096.37 | 6090.08 | 6092.34 | 6882.0 |
| 2025-06-18 08:30:00 | ES | Futures | 6092.34 | 6094.11 | 6086.3 | 6087.31 | 9423.0 |
| 2025-06-18 09:00:00 | ES | Futures | 6087.56 | 6094.61 | 6086.55 | 6090.58 | 14594.0 |
| 2025-06-18 09:30:00 | ES | Futures | 6090.33 | 6102.42 | 6079.75 | 6097.89 | 97978.0 |
| 2025-06-18 10:00:00 | ES | Futures | 6097.63 | 6117.78 | 6093.6 | 6114.76 | 97687.0 |
| 2025-06-18 10:30:00 | ES | Futures | 6114.51 | 6119.3 | 6112.49 | 6115.52 | 58926.0 |
| 2025-06-18 11:00:00 | ES | Futures | 6115.52 | 6116.02 | 6105.95 | 6108.21 | 43306.0 |
| 2025-06-18 11:30:00 | ES | Futures | 6108.21 | 6112.49 | 6102.92 | 6104.18 | 51092.0 |
| 2025-06-18 12:00:00 | ES | Futures | 6104.43 | 6110.48 | 6101.16 | 6101.92 | 43145.0 |
| 2025-06-18 12:30:00 | ES | Futures | 6101.92 | 6108.21 | 6100.4 | 6101.41 | 32534.0 |
| 2025-06-18 13:00:00 | ES | Futures | 6101.41 | 6104.18 | 6094.86 | 6095.37 | 35933.0 |
| 2025-06-18 13:30:00 | ES | Futures | 6095.62 | 6107.21 | 6086.8 | 6103.68 | 57308.0 |
| 2025-06-18 14:00:00 | ES | Futures | 6103.68 | 6117.78 | 6091.34 | 6100.66 | 59735.0 |
| 2025-06-18 14:30:00 | ES | Futures | 6100.91 | 6116.78 | 6073.45 | 6079.5 | 102539.0 |
| 2025-06-18 15:00:00 | ES | Futures | 6079.25 | 6096.63 | 6071.44 | 6075.72 | 110383.0 |
| 2025-06-18 15:30:00 | ES | Futures | 6075.47 | 6095.12 | 6072.7 | 6080.76 | 135963.0 |
| 2025-06-18 16:00:00 | ES | Futures | 6080.76 | 6088.82 | 6080.0 | 6085.29 | 32141.0 |
| 2025-06-18 16:30:00 | ES | Futures | 6085.29 | 6086.55 | 6081.01 | 6081.26 | 6423.0 |
| 2025-06-18 18:00:00 | ES | Futures | 6083.53 | 6083.53 | 6072.19 | 6076.73 | 4508.0 |
| 2025-06-18 18:30:00 | ES | Futures | 6076.73 | 6077.48 | 6071.69 | 6076.48 | 1938.0 |
| 2025-06-18 19:00:00 | ES | Futures | 6076.22 | 6079.5 | 6074.46 | 6075.72 | 1646.0 |
| 2025-06-18 19:30:00 | ES | Futures | 6075.47 | 6080.0 | 6073.71 | 6079.0 | 2104.0 |
| 2025-06-18 20:00:00 | ES | Futures | 6079.0 | 6080.0 | 6058.85 | 6067.91 | 6469.0 |
| 2025-06-18 20:30:00 | ES | Futures | 6068.16 | 6071.44 | 6066.15 | 6068.67 | 2136.0 |
| 2025-06-18 21:00:00 | ES | Futures | 6068.67 | 6069.17 | 6044.74 | 6060.86 | 13292.0 |
| 2025-06-18 21:30:00 | ES | Futures | 6060.86 | 6064.13 | 6055.07 | 6058.85 | 4370.0 |
| 2025-06-18 22:00:00 | ES | Futures | 6058.59 | 6063.13 | 6055.32 | 6061.87 | 1856.0 |
| 2025-06-18 22:30:00 | ES | Futures | 6061.87 | 6066.15 | 6060.61 | 6061.11 | 2428.0 |
| 2025-06-18 23:00:00 | ES | Futures | 6061.36 | 6070.18 | 6061.36 | 6068.42 | 2007.0 |
| 2025-06-18 23:30:00 | ES | Futures | 6068.42 | 6071.69 | 6065.9 | 6070.18 | 1358.0 |
| 2025-06-18 00:00:00 | NQ | Futures | 22161.1 | 22174.21 | 22135.88 | 22147.99 | 1403.0 |
| 2025-06-18 00:30:00 | NQ | Futures | 22148.74 | 22179.0 | 22146.72 | 22171.19 | 1044.0 |
| 2025-06-18 01:00:00 | NQ | Futures | 22171.44 | 22185.81 | 22169.92 | 22177.74 | 845.0 |
| 2025-06-18 01:30:00 | NQ | Futures | 22178.5 | 22188.59 | 22169.92 | 22180.01 | 972.0 |
> showing 50 of 3,789 rows — these rows as CSV