PREVIEW / futures_30min / 2024-10-24
file: by_date/futures_30min/2024/2024-10-24.parquet size: 108 KB rows: 3,982
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-24 00:00:00 | ES | Futures | 6072.33 | 6073.37 | 6070.77 | 6072.59 | 1384.0 |
| 2024-10-24 00:30:00 | ES | Futures | 6072.59 | 6072.59 | 6069.99 | 6072.33 | 1389.0 |
| 2024-10-24 01:00:00 | ES | Futures | 6072.33 | 6073.11 | 6069.47 | 6069.73 | 1651.0 |
| 2024-10-24 01:30:00 | ES | Futures | 6069.99 | 6072.85 | 6069.73 | 6072.33 | 1724.0 |
| 2024-10-24 02:00:00 | ES | Futures | 6072.07 | 6076.22 | 6072.07 | 6074.92 | 3087.0 |
| 2024-10-24 02:30:00 | ES | Futures | 6074.66 | 6077.52 | 6072.07 | 6072.33 | 2717.0 |
| 2024-10-24 03:00:00 | ES | Futures | 6072.59 | 6084.01 | 6071.81 | 6083.23 | 8746.0 |
| 2024-10-24 03:30:00 | ES | Futures | 6083.49 | 6086.6 | 6082.71 | 6085.05 | 5796.0 |
| 2024-10-24 04:00:00 | ES | Futures | 6085.05 | 6090.24 | 6084.53 | 6088.42 | 6733.0 |
| 2024-10-24 04:30:00 | ES | Futures | 6088.42 | 6089.98 | 6081.15 | 6085.3 | 7404.0 |
| 2024-10-24 05:00:00 | ES | Futures | 6085.3 | 6087.64 | 6083.49 | 6085.3 | 4211.0 |
| 2024-10-24 05:30:00 | ES | Futures | 6085.05 | 6086.34 | 6083.49 | 6085.3 | 2332.0 |
| 2024-10-24 06:00:00 | ES | Futures | 6085.56 | 6089.72 | 6083.75 | 6088.42 | 4802.0 |
| 2024-10-24 06:30:00 | ES | Futures | 6088.42 | 6089.46 | 6084.79 | 6085.3 | 3022.0 |
| 2024-10-24 07:00:00 | ES | Futures | 6085.3 | 6091.79 | 6084.27 | 6088.94 | 7355.0 |
| 2024-10-24 07:30:00 | ES | Futures | 6088.68 | 6092.05 | 6087.38 | 6091.01 | 6048.0 |
| 2024-10-24 08:00:00 | ES | Futures | 6091.27 | 6091.27 | 6086.6 | 6088.94 | 8844.0 |
| 2024-10-24 08:30:00 | ES | Futures | 6088.94 | 6093.61 | 6084.53 | 6086.08 | 15437.0 |
| 2024-10-24 09:00:00 | ES | Futures | 6086.08 | 6090.24 | 6079.6 | 6080.37 | 23714.0 |
| 2024-10-24 09:30:00 | ES | Futures | 6080.11 | 6080.89 | 6065.32 | 6073.89 | 111802.0 |
| 2024-10-24 10:00:00 | ES | Futures | 6073.63 | 6079.6 | 6067.92 | 6068.95 | 89937.0 |
| 2024-10-24 10:30:00 | ES | Futures | 6068.95 | 6078.56 | 6064.8 | 6067.66 | 78543.0 |
| 2024-10-24 11:00:00 | ES | Futures | 6067.66 | 6073.89 | 6061.95 | 6066.1 | 65851.0 |
| 2024-10-24 11:30:00 | ES | Futures | 6066.1 | 6067.14 | 6049.23 | 6059.61 | 85410.0 |
| 2024-10-24 12:00:00 | ES | Futures | 6059.61 | 6060.91 | 6044.3 | 6059.09 | 76000.0 |
| 2024-10-24 12:30:00 | ES | Futures | 6059.35 | 6069.99 | 6059.09 | 6068.7 | 61031.0 |
| 2024-10-24 13:00:00 | ES | Futures | 6068.7 | 6075.44 | 6066.62 | 6070.77 | 45579.0 |
| 2024-10-24 13:30:00 | ES | Futures | 6070.77 | 6075.96 | 6063.76 | 6064.54 | 45380.0 |
| 2024-10-24 14:00:00 | ES | Futures | 6064.8 | 6073.63 | 6060.13 | 6068.44 | 48544.0 |
| 2024-10-24 14:30:00 | ES | Futures | 6068.7 | 6069.21 | 6062.47 | 6067.92 | 34355.0 |
| 2024-10-24 15:00:00 | ES | Futures | 6067.66 | 6075.44 | 6062.21 | 6074.4 | 49891.0 |
| 2024-10-24 15:30:00 | ES | Futures | 6074.66 | 6079.34 | 6069.73 | 6071.81 | 124088.0 |
| 2024-10-24 16:00:00 | ES | Futures | 6072.07 | 6079.85 | 6070.51 | 6077.26 | 40768.0 |
| 2024-10-24 16:30:00 | ES | Futures | 6077.52 | 6078.04 | 6073.11 | 6075.7 | 10540.0 |
| 2024-10-24 18:00:00 | ES | Futures | 6076.22 | 6077.52 | 6072.59 | 6074.66 | 2769.0 |
| 2024-10-24 18:30:00 | ES | Futures | 6074.66 | 6074.66 | 6071.81 | 6073.37 | 1586.0 |
| 2024-10-24 19:00:00 | ES | Futures | 6073.37 | 6073.37 | 6071.03 | 6071.29 | 1493.0 |
| 2024-10-24 19:30:00 | ES | Futures | 6071.29 | 6073.63 | 6069.73 | 6073.37 | 2331.0 |
| 2024-10-24 20:00:00 | ES | Futures | 6073.63 | 6075.18 | 6070.77 | 6072.59 | 3355.0 |
| 2024-10-24 20:30:00 | ES | Futures | 6072.85 | 6077.0 | 6072.59 | 6075.96 | 2357.0 |
| 2024-10-24 21:00:00 | ES | Futures | 6075.7 | 6078.56 | 6075.18 | 6077.0 | 2161.0 |
| 2024-10-24 21:30:00 | ES | Futures | 6077.0 | 6077.52 | 6074.15 | 6074.4 | 2355.0 |
| 2024-10-24 22:00:00 | ES | Futures | 6074.4 | 6077.0 | 6073.63 | 6077.0 | 1931.0 |
| 2024-10-24 22:30:00 | ES | Futures | 6076.74 | 6077.26 | 6075.18 | 6075.18 | 1109.0 |
| 2024-10-24 23:00:00 | ES | Futures | 6075.44 | 6075.96 | 6071.29 | 6072.85 | 2150.0 |
| 2024-10-24 23:30:00 | ES | Futures | 6072.85 | 6073.37 | 6069.21 | 6069.73 | 1844.0 |
| 2024-10-24 00:00:00 | NQ | Futures | 21206.95 | 21213.22 | 21200.43 | 21209.04 | 1036.0 |
| 2024-10-24 00:30:00 | NQ | Futures | 21209.04 | 21213.48 | 21197.04 | 21209.56 | 906.0 |
| 2024-10-24 01:00:00 | NQ | Futures | 21210.35 | 21212.43 | 21192.6 | 21193.39 | 1074.0 |
| 2024-10-24 01:30:00 | NQ | Futures | 21194.43 | 21216.87 | 21193.13 | 21211.13 | 944.0 |
> showing 50 of 3,982 rows — these rows as CSV