PREVIEW / futures_30min / 2024-10-29
file: by_date/futures_30min/2024/2024-10-29.parquet size: 113 KB rows: 4,044
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 |
|---|---|---|---|---|---|---|---|
| 2024-10-29 00:00:00 | ES | Futures | 6074.66 | 6080.37 | 6073.37 | 6080.11 | 3788.0 |
| 2024-10-29 00:30:00 | ES | Futures | 6080.11 | 6080.63 | 6078.56 | 6080.37 | 1882.0 |
| 2024-10-29 01:00:00 | ES | Futures | 6080.63 | 6081.93 | 6078.3 | 6081.41 | 2974.0 |
| 2024-10-29 01:30:00 | ES | Futures | 6081.41 | 6084.01 | 6081.41 | 6082.71 | 2666.0 |
| 2024-10-29 02:00:00 | ES | Futures | 6082.97 | 6086.86 | 6082.97 | 6085.56 | 2480.0 |
| 2024-10-29 02:30:00 | ES | Futures | 6085.56 | 6090.75 | 6085.3 | 6089.72 | 3110.0 |
| 2024-10-29 03:00:00 | ES | Futures | 6089.46 | 6092.57 | 6088.42 | 6092.05 | 4426.0 |
| 2024-10-29 03:30:00 | ES | Futures | 6092.05 | 6093.09 | 6087.12 | 6087.12 | 4137.0 |
| 2024-10-29 04:00:00 | ES | Futures | 6087.38 | 6088.68 | 6077.78 | 6087.64 | 10657.0 |
| 2024-10-29 04:30:00 | ES | Futures | 6087.38 | 6093.09 | 6085.05 | 6087.64 | 9810.0 |
| 2024-10-29 05:00:00 | ES | Futures | 6087.64 | 6088.42 | 6081.93 | 6086.86 | 7787.0 |
| 2024-10-29 05:30:00 | ES | Futures | 6087.12 | 6088.68 | 6084.01 | 6086.34 | 4964.0 |
| 2024-10-29 06:00:00 | ES | Futures | 6086.34 | 6086.86 | 6078.56 | 6082.45 | 5827.0 |
| 2024-10-29 06:30:00 | ES | Futures | 6082.19 | 6084.79 | 6080.11 | 6082.45 | 4751.0 |
| 2024-10-29 07:00:00 | ES | Futures | 6082.45 | 6083.49 | 6076.74 | 6077.52 | 11442.0 |
| 2024-10-29 07:30:00 | ES | Futures | 6077.52 | 6082.97 | 6076.22 | 6076.74 | 10431.0 |
| 2024-10-29 08:00:00 | ES | Futures | 6076.48 | 6078.04 | 6070.77 | 6075.96 | 19814.0 |
| 2024-10-29 08:30:00 | ES | Futures | 6075.96 | 6076.48 | 6072.33 | 6073.11 | 14191.0 |
| 2024-10-29 09:00:00 | ES | Futures | 6072.85 | 6076.74 | 6071.29 | 6074.92 | 22040.0 |
| 2024-10-29 09:30:00 | ES | Futures | 6074.92 | 6077.26 | 6059.87 | 6075.44 | 135291.0 |
| 2024-10-29 10:00:00 | ES | Futures | 6075.7 | 6095.95 | 6071.03 | 6081.67 | 118729.0 |
| 2024-10-29 10:30:00 | ES | Futures | 6081.67 | 6092.83 | 6080.89 | 6091.53 | 74415.0 |
| 2024-10-29 11:00:00 | ES | Futures | 6091.53 | 6093.61 | 6082.19 | 6087.64 | 58449.0 |
| 2024-10-29 11:30:00 | ES | Futures | 6087.64 | 6093.09 | 6084.27 | 6091.01 | 49495.0 |
| 2024-10-29 12:00:00 | ES | Futures | 6091.01 | 6097.5 | 6090.24 | 6091.27 | 50656.0 |
| 2024-10-29 12:30:00 | ES | Futures | 6091.27 | 6098.54 | 6085.3 | 6097.5 | 52559.0 |
| 2024-10-29 13:00:00 | ES | Futures | 6097.5 | 6105.81 | 6096.2 | 6098.02 | 53846.0 |
| 2024-10-29 13:30:00 | ES | Futures | 6098.02 | 6099.58 | 6092.31 | 6097.24 | 38003.0 |
| 2024-10-29 14:00:00 | ES | Futures | 6097.24 | 6101.65 | 6094.39 | 6101.65 | 32289.0 |
| 2024-10-29 14:30:00 | ES | Futures | 6101.65 | 6107.1 | 6100.88 | 6102.43 | 47079.0 |
| 2024-10-29 15:00:00 | ES | Futures | 6102.17 | 6107.36 | 6101.14 | 6106.59 | 35410.0 |
| 2024-10-29 15:30:00 | ES | Futures | 6106.33 | 6107.1 | 6091.01 | 6095.43 | 124326.0 |
| 2024-10-29 16:00:00 | ES | Futures | 6095.43 | 6107.88 | 6094.65 | 6102.95 | 63884.0 |
| 2024-10-29 16:30:00 | ES | Futures | 6102.95 | 6104.77 | 6101.4 | 6101.91 | 16897.0 |
| 2024-10-29 18:00:00 | ES | Futures | 6107.1 | 6110.48 | 6104.25 | 6107.36 | 4260.0 |
| 2024-10-29 18:30:00 | ES | Futures | 6107.1 | 6111.78 | 6107.1 | 6110.48 | 3152.0 |
| 2024-10-29 19:00:00 | ES | Futures | 6110.48 | 6111.0 | 6105.55 | 6109.44 | 2765.0 |
| 2024-10-29 19:30:00 | ES | Futures | 6109.18 | 6109.7 | 6106.85 | 6108.4 | 1674.0 |
| 2024-10-29 20:00:00 | ES | Futures | 6108.66 | 6113.59 | 6107.62 | 6113.07 | 4225.0 |
| 2024-10-29 20:30:00 | ES | Futures | 6113.33 | 6115.93 | 6112.3 | 6114.89 | 4113.0 |
| 2024-10-29 21:00:00 | ES | Futures | 6114.63 | 6116.19 | 6111.78 | 6114.89 | 3003.0 |
| 2024-10-29 21:30:00 | ES | Futures | 6114.89 | 6117.49 | 6114.63 | 6116.19 | 2921.0 |
| 2024-10-29 22:00:00 | ES | Futures | 6116.19 | 6116.19 | 6112.55 | 6112.81 | 2635.0 |
| 2024-10-29 22:30:00 | ES | Futures | 6112.81 | 6113.07 | 6108.66 | 6109.18 | 3854.0 |
| 2024-10-29 23:00:00 | ES | Futures | 6109.18 | 6109.96 | 6105.81 | 6106.07 | 4290.0 |
| 2024-10-29 23:30:00 | ES | Futures | 6106.07 | 6106.59 | 6103.99 | 6105.55 | 4268.0 |
| 2024-10-29 00:00:00 | NQ | Futures | 21354.37 | 21383.85 | 21343.67 | 21382.29 | 2766.0 |
| 2024-10-29 00:30:00 | NQ | Futures | 21382.55 | 21388.29 | 21374.2 | 21386.46 | 1383.0 |
| 2024-10-29 01:00:00 | NQ | Futures | 21386.2 | 21396.64 | 21376.29 | 21396.11 | 1543.0 |
| 2024-10-29 01:30:00 | NQ | Futures | 21395.59 | 21404.72 | 21393.51 | 21402.12 | 1250.0 |
> showing 50 of 4,044 rows — these rows as CSV