PREVIEW / futures_30min / 2024-06-23
file: by_date/futures_30min/2024/2024-06-23.parquet size: 28 KB rows: 793
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-06-23 18:00:00 | ES | Futures | 5807.98 | 5809.29 | 5805.88 | 5807.19 | 3503.0 |
| 2024-06-23 18:30:00 | ES | Futures | 5807.46 | 5808.24 | 5806.41 | 5806.93 | 1029.0 |
| 2024-06-23 19:00:00 | ES | Futures | 5806.93 | 5809.03 | 5806.93 | 5808.5 | 1475.0 |
| 2024-06-23 19:30:00 | ES | Futures | 5808.5 | 5808.5 | 5805.62 | 5806.14 | 1324.0 |
| 2024-06-23 20:00:00 | ES | Futures | 5806.14 | 5806.93 | 5804.83 | 5806.93 | 2582.0 |
| 2024-06-23 20:30:00 | ES | Futures | 5806.93 | 5807.72 | 5805.62 | 5806.14 | 1361.0 |
| 2024-06-23 21:00:00 | ES | Futures | 5805.88 | 5806.41 | 5788.32 | 5793.82 | 13898.0 |
| 2024-06-23 21:30:00 | ES | Futures | 5793.82 | 5795.66 | 5790.68 | 5794.87 | 3514.0 |
| 2024-06-23 22:00:00 | ES | Futures | 5794.87 | 5795.92 | 5792.77 | 5794.61 | 2229.0 |
| 2024-06-23 22:30:00 | ES | Futures | 5794.87 | 5796.97 | 5792.51 | 5793.82 | 2275.0 |
| 2024-06-23 23:00:00 | ES | Futures | 5793.82 | 5796.71 | 5793.56 | 5796.71 | 1497.0 |
| 2024-06-23 23:30:00 | ES | Futures | 5796.71 | 5797.76 | 5795.4 | 5795.92 | 1677.0 |
| 2024-06-23 18:00:00 | NQ | Futures | 21134.18 | 21146.58 | 21119.13 | 21138.66 | 2216.0 |
| 2024-06-23 18:30:00 | NQ | Futures | 21139.19 | 21144.73 | 21130.22 | 21135.76 | 1152.0 |
| 2024-06-23 19:00:00 | NQ | Futures | 21135.23 | 21150.54 | 21134.44 | 21143.94 | 1566.0 |
| 2024-06-23 19:30:00 | NQ | Futures | 21143.94 | 21143.94 | 21124.41 | 21127.84 | 1336.0 |
| 2024-06-23 20:00:00 | NQ | Futures | 21127.84 | 21135.76 | 21119.13 | 21135.76 | 1893.0 |
| 2024-06-23 20:30:00 | NQ | Futures | 21135.5 | 21138.4 | 21126.52 | 21127.05 | 1015.0 |
| 2024-06-23 21:00:00 | NQ | Futures | 21127.58 | 21129.95 | 21032.54 | 21062.64 | 7968.0 |
| 2024-06-23 21:30:00 | NQ | Futures | 21062.64 | 21071.08 | 21044.95 | 21068.18 | 2743.0 |
| 2024-06-23 22:00:00 | NQ | Futures | 21068.71 | 21073.72 | 21057.09 | 21067.92 | 2024.0 |
| 2024-06-23 22:30:00 | NQ | Futures | 21068.71 | 21081.64 | 21061.84 | 21065.8 | 1818.0 |
| 2024-06-23 23:00:00 | NQ | Futures | 21065.54 | 21081.11 | 21065.54 | 21080.59 | 1109.0 |
| 2024-06-23 23:30:00 | NQ | Futures | 21081.38 | 21087.19 | 21076.63 | 21079.79 | 1286.0 |
| 2024-06-23 18:00:00 | YM | Futures | 41597.3 | 41616.2 | 41586.8 | 41587.8 | 609.0 |
| 2024-06-23 18:30:00 | YM | Futures | 41587.8 | 41596.2 | 41587.8 | 41588.9 | 202.0 |
| 2024-06-23 19:00:00 | YM | Futures | 41588.9 | 41593.1 | 41588.9 | 41588.9 | 496.0 |
| 2024-06-23 19:30:00 | YM | Futures | 41589.9 | 41592.0 | 41580.5 | 41582.6 | 157.0 |
| 2024-06-23 20:00:00 | YM | Futures | 41582.6 | 41585.7 | 41573.1 | 41574.1 | 427.0 |
| 2024-06-23 20:30:00 | YM | Futures | 41574.1 | 41582.6 | 41568.9 | 41573.1 | 254.0 |
| 2024-06-23 21:00:00 | YM | Futures | 41571.0 | 41575.2 | 41464.9 | 41499.5 | 1587.0 |
| 2024-06-23 21:30:00 | YM | Futures | 41498.5 | 41505.8 | 41483.8 | 41502.7 | 499.0 |
| 2024-06-23 22:00:00 | YM | Futures | 41502.7 | 41510.1 | 41485.9 | 41498.5 | 256.0 |
| 2024-06-23 22:30:00 | YM | Futures | 41498.5 | 41510.1 | 41485.9 | 41493.2 | 226.0 |
| 2024-06-23 23:00:00 | YM | Futures | 41493.2 | 41506.9 | 41492.2 | 41505.8 | 281.0 |
| 2024-06-23 23:30:00 | YM | Futures | 41505.8 | 41513.2 | 41499.5 | 41500.6 | 147.0 |
| 2024-06-23 18:00:00 | CL | Futures | 68.8 | 69.03 | 68.75 | 68.93 | 829.0 |
| 2024-06-23 18:30:00 | CL | Futures | 68.93 | 68.95 | 68.77 | 68.83 | 582.0 |
| 2024-06-23 19:00:00 | CL | Futures | 68.83 | 68.83 | 68.75 | 68.79 | 435.0 |
| 2024-06-23 19:30:00 | CL | Futures | 68.78 | 68.8 | 68.62 | 68.63 | 907.0 |
| 2024-06-23 20:00:00 | CL | Futures | 68.63 | 68.75 | 68.62 | 68.69 | 1089.0 |
| 2024-06-23 20:30:00 | CL | Futures | 68.69 | 68.8 | 68.69 | 68.78 | 699.0 |
| 2024-06-23 21:00:00 | CL | Futures | 68.78 | 68.8 | 68.68 | 68.78 | 1588.0 |
| 2024-06-23 21:30:00 | CL | Futures | 68.79 | 68.87 | 68.77 | 68.86 | 683.0 |
| 2024-06-23 22:00:00 | CL | Futures | 68.86 | 68.9 | 68.8 | 68.9 | 589.0 |
| 2024-06-23 22:30:00 | CL | Futures | 68.91 | 68.94 | 68.86 | 68.89 | 572.0 |
| 2024-06-23 23:00:00 | CL | Futures | 68.89 | 68.98 | 68.88 | 68.98 | 619.0 |
| 2024-06-23 23:30:00 | CL | Futures | 68.98 | 68.99 | 68.97 | 68.98 | 292.0 |
| 2024-06-23 18:00:00 | GC | Futures | 2505.8 | 2508.6 | 2502.2 | 2505.6 | 2107.0 |
| 2024-06-23 18:30:00 | GC | Futures | 2505.6 | 2506.8 | 2505.5 | 2506.1 | 305.0 |
> showing 50 of 793 rows — these rows as CSV