PREVIEW / futures_30min / 2024-10-27
file: by_date/futures_30min/2024/2024-10-27.parquet size: 31 KB rows: 844
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-27 18:00:00 | ES | Futures | 6080.11 | 6097.76 | 6080.11 | 6096.46 | 12633.0 |
| 2024-10-27 18:30:00 | ES | Futures | 6096.46 | 6098.8 | 6094.39 | 6095.95 | 3908.0 |
| 2024-10-27 19:00:00 | ES | Futures | 6095.95 | 6098.02 | 6093.87 | 6096.72 | 2604.0 |
| 2024-10-27 19:30:00 | ES | Futures | 6096.46 | 6096.98 | 6092.05 | 6094.13 | 3212.0 |
| 2024-10-27 20:00:00 | ES | Futures | 6094.39 | 6102.17 | 6093.35 | 6100.62 | 6899.0 |
| 2024-10-27 20:30:00 | ES | Futures | 6100.62 | 6105.29 | 6097.76 | 6098.54 | 5767.0 |
| 2024-10-27 21:00:00 | ES | Futures | 6098.28 | 6104.51 | 6097.5 | 6101.65 | 7034.0 |
| 2024-10-27 21:30:00 | ES | Futures | 6101.91 | 6102.69 | 6099.06 | 6099.58 | 3370.0 |
| 2024-10-27 22:00:00 | ES | Futures | 6099.32 | 6101.91 | 6097.24 | 6097.5 | 4237.0 |
| 2024-10-27 22:30:00 | ES | Futures | 6097.24 | 6100.88 | 6097.24 | 6100.36 | 1813.0 |
| 2024-10-27 23:00:00 | ES | Futures | 6100.1 | 6101.65 | 6098.54 | 6098.8 | 2543.0 |
| 2024-10-27 23:30:00 | ES | Futures | 6098.8 | 6098.8 | 6093.61 | 6096.2 | 4715.0 |
| 2024-10-27 18:00:00 | NQ | Futures | 21421.42 | 21510.66 | 21421.16 | 21507.52 | 5084.0 |
| 2024-10-27 18:30:00 | NQ | Futures | 21506.22 | 21522.4 | 21494.48 | 21507.52 | 2085.0 |
| 2024-10-27 19:00:00 | NQ | Futures | 21507.52 | 21515.35 | 21490.04 | 21502.31 | 2036.0 |
| 2024-10-27 19:30:00 | NQ | Futures | 21501.78 | 21507.26 | 21484.83 | 21497.35 | 1974.0 |
| 2024-10-27 20:00:00 | NQ | Futures | 21496.83 | 21532.05 | 21490.83 | 21526.31 | 3101.0 |
| 2024-10-27 20:30:00 | NQ | Futures | 21527.09 | 21550.31 | 21512.74 | 21514.57 | 3318.0 |
| 2024-10-27 21:00:00 | NQ | Futures | 21514.57 | 21547.7 | 21512.22 | 21538.83 | 3585.0 |
| 2024-10-27 21:30:00 | NQ | Futures | 21539.09 | 21545.88 | 21520.57 | 21526.05 | 1768.0 |
| 2024-10-27 22:00:00 | NQ | Futures | 21526.31 | 21538.31 | 21513.79 | 21514.83 | 1836.0 |
| 2024-10-27 22:30:00 | NQ | Futures | 21514.57 | 21533.62 | 21513.79 | 21527.09 | 1133.0 |
| 2024-10-27 23:00:00 | NQ | Futures | 21527.09 | 21535.44 | 21518.74 | 21521.61 | 982.0 |
| 2024-10-27 23:30:00 | NQ | Futures | 21523.18 | 21523.18 | 21499.96 | 21514.05 | 2024.0 |
| 2024-10-27 18:00:00 | YM | Futures | 44086.3 | 44220.5 | 44086.3 | 44204.9 | 1185.0 |
| 2024-10-27 18:30:00 | YM | Futures | 44203.9 | 44221.6 | 44191.4 | 44198.7 | 595.0 |
| 2024-10-27 19:00:00 | YM | Futures | 44197.6 | 44214.3 | 44190.3 | 44206.0 | 369.0 |
| 2024-10-27 19:30:00 | YM | Futures | 44207.0 | 44210.1 | 44164.3 | 44177.9 | 591.0 |
| 2024-10-27 20:00:00 | YM | Futures | 44176.8 | 44245.5 | 44171.6 | 44240.3 | 972.0 |
| 2024-10-27 20:30:00 | YM | Futures | 44241.3 | 44270.5 | 44227.8 | 44230.9 | 828.0 |
| 2024-10-27 21:00:00 | YM | Futures | 44229.9 | 44258.0 | 44224.7 | 44236.1 | 661.0 |
| 2024-10-27 21:30:00 | YM | Futures | 44237.2 | 44242.4 | 44221.6 | 44227.8 | 312.0 |
| 2024-10-27 22:00:00 | YM | Futures | 44228.9 | 44242.4 | 44218.4 | 44218.4 | 398.0 |
| 2024-10-27 22:30:00 | YM | Futures | 44217.4 | 44240.3 | 44217.4 | 44238.2 | 180.0 |
| 2024-10-27 23:00:00 | YM | Futures | 44240.3 | 44249.7 | 44229.9 | 44229.9 | 305.0 |
| 2024-10-27 23:30:00 | YM | Futures | 44227.8 | 44228.9 | 44195.5 | 44212.2 | 452.0 |
| 2024-10-27 18:00:00 | CL | Futures | 62.43 | 62.45 | 61.35 | 62.0 | 20571.0 |
| 2024-10-27 18:30:00 | CL | Futures | 61.99 | 62.14 | 61.85 | 62.06 | 4020.0 |
| 2024-10-27 19:00:00 | CL | Futures | 62.06 | 62.25 | 62.03 | 62.17 | 2689.0 |
| 2024-10-27 19:30:00 | CL | Futures | 62.17 | 62.27 | 62.14 | 62.22 | 1372.0 |
| 2024-10-27 20:00:00 | CL | Futures | 62.23 | 62.29 | 62.19 | 62.22 | 2200.0 |
| 2024-10-27 20:30:00 | CL | Futures | 62.23 | 62.34 | 62.12 | 62.31 | 2033.0 |
| 2024-10-27 21:00:00 | CL | Futures | 62.31 | 62.31 | 61.85 | 61.93 | 7341.0 |
| 2024-10-27 21:30:00 | CL | Futures | 61.93 | 62.09 | 61.93 | 62.07 | 2836.0 |
| 2024-10-27 22:00:00 | CL | Futures | 62.06 | 62.11 | 61.98 | 62.09 | 1502.0 |
| 2024-10-27 22:30:00 | CL | Futures | 62.08 | 62.08 | 61.91 | 61.98 | 1448.0 |
| 2024-10-27 23:00:00 | CL | Futures | 61.98 | 62.02 | 61.96 | 62.01 | 1019.0 |
| 2024-10-27 23:30:00 | CL | Futures | 62.01 | 62.17 | 61.98 | 61.98 | 1804.0 |
| 2024-10-27 18:00:00 | GC | Futures | 2894.8 | 2895.7 | 2887.2 | 2890.6 | 5562.0 |
| 2024-10-27 18:30:00 | GC | Futures | 2890.6 | 2893.7 | 2889.1 | 2892.2 | 1472.0 |
> showing 50 of 844 rows — these rows as CSV