PREVIEW / futures_30min / 2024-01-07
file: by_date/futures_30min/2024/2024-01-07.parquet size: 30 KB rows: 837
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-01-07 18:00:00 | ES | Futures | 5087.91 | 5094.09 | 5085.49 | 5090.87 | 6672.0 |
| 2024-01-07 18:30:00 | ES | Futures | 5090.87 | 5091.94 | 5088.99 | 5091.4 | 2265.0 |
| 2024-01-07 19:00:00 | ES | Futures | 5091.13 | 5094.36 | 5091.13 | 5093.55 | 2762.0 |
| 2024-01-07 19:30:00 | ES | Futures | 5093.55 | 5095.16 | 5093.01 | 5093.82 | 2040.0 |
| 2024-01-07 20:00:00 | ES | Futures | 5093.82 | 5095.97 | 5092.21 | 5094.36 | 3401.0 |
| 2024-01-07 20:30:00 | ES | Futures | 5094.09 | 5094.9 | 5088.18 | 5088.72 | 4301.0 |
| 2024-01-07 21:00:00 | ES | Futures | 5088.45 | 5088.45 | 5084.96 | 5086.57 | 4456.0 |
| 2024-01-07 21:30:00 | ES | Futures | 5086.57 | 5087.64 | 5085.49 | 5086.84 | 2131.0 |
| 2024-01-07 22:00:00 | ES | Futures | 5087.11 | 5087.11 | 5083.61 | 5084.69 | 2959.0 |
| 2024-01-07 22:30:00 | ES | Futures | 5084.42 | 5084.96 | 5082.0 | 5083.08 | 3280.0 |
| 2024-01-07 23:00:00 | ES | Futures | 5082.81 | 5084.69 | 5082.0 | 5083.88 | 1643.0 |
| 2024-01-07 23:30:00 | ES | Futures | 5084.15 | 5084.42 | 5083.35 | 5084.15 | 587.0 |
| 2024-01-07 18:00:00 | NQ | Futures | 17867.03 | 17888.72 | 17854.82 | 17876.25 | 3838.0 |
| 2024-01-07 18:30:00 | NQ | Futures | 17875.98 | 17883.03 | 17867.03 | 17880.86 | 2102.0 |
| 2024-01-07 19:00:00 | NQ | Futures | 17880.32 | 17896.86 | 17880.04 | 17893.88 | 2058.0 |
| 2024-01-07 19:30:00 | NQ | Futures | 17893.6 | 17897.13 | 17888.18 | 17892.25 | 1617.0 |
| 2024-01-07 20:00:00 | NQ | Futures | 17891.71 | 17899.84 | 17887.1 | 17891.16 | 1643.0 |
| 2024-01-07 20:30:00 | NQ | Futures | 17890.89 | 17897.94 | 17864.86 | 17866.21 | 2974.0 |
| 2024-01-07 21:00:00 | NQ | Futures | 17865.94 | 17865.94 | 17852.92 | 17860.25 | 2930.0 |
| 2024-01-07 21:30:00 | NQ | Futures | 17860.25 | 17861.6 | 17853.47 | 17857.26 | 1145.0 |
| 2024-01-07 22:00:00 | NQ | Futures | 17858.08 | 17859.43 | 17846.41 | 17846.41 | 2049.0 |
| 2024-01-07 22:30:00 | NQ | Futures | 17846.41 | 17846.96 | 17832.31 | 17835.84 | 2632.0 |
| 2024-01-07 23:00:00 | NQ | Futures | 17835.84 | 17845.87 | 17833.67 | 17841.53 | 1368.0 |
| 2024-01-07 23:30:00 | NQ | Futures | 17841.26 | 17845.06 | 17838.28 | 17843.7 | 845.0 |
| 2024-01-07 18:00:00 | YM | Futures | 40464.8 | 40502.4 | 40442.2 | 40468.0 | 1912.0 |
| 2024-01-07 18:30:00 | YM | Futures | 40468.0 | 40474.5 | 40457.3 | 40462.7 | 751.0 |
| 2024-01-07 19:00:00 | YM | Futures | 40460.5 | 40476.6 | 40453.0 | 40472.3 | 475.0 |
| 2024-01-07 19:30:00 | YM | Futures | 40471.2 | 40474.5 | 40445.5 | 40450.8 | 865.0 |
| 2024-01-07 20:00:00 | YM | Futures | 40450.8 | 40454.1 | 40426.1 | 40426.1 | 802.0 |
| 2024-01-07 20:30:00 | YM | Futures | 40427.2 | 40429.4 | 40375.7 | 40379.9 | 848.0 |
| 2024-01-07 21:00:00 | YM | Futures | 40379.9 | 40383.2 | 40353.1 | 40370.3 | 988.0 |
| 2024-01-07 21:30:00 | YM | Futures | 40369.2 | 40385.3 | 40363.8 | 40381.0 | 371.0 |
| 2024-01-07 22:00:00 | YM | Futures | 40378.9 | 40379.9 | 40357.4 | 40366.0 | 289.0 |
| 2024-01-07 22:30:00 | YM | Futures | 40364.9 | 40368.1 | 40349.9 | 40356.3 | 406.0 |
| 2024-01-07 23:00:00 | YM | Futures | 40356.3 | 40368.1 | 40352.0 | 40364.9 | 236.0 |
| 2024-01-07 23:30:00 | YM | Futures | 40364.9 | 40373.5 | 40363.8 | 40372.4 | 113.0 |
| 2024-01-07 18:00:00 | CL | Futures | 61.46 | 61.83 | 61.28 | 61.77 | 2297.0 |
| 2024-01-07 18:30:00 | CL | Futures | 61.77 | 61.78 | 61.64 | 61.69 | 698.0 |
| 2024-01-07 19:00:00 | CL | Futures | 61.68 | 61.74 | 61.67 | 61.71 | 600.0 |
| 2024-01-07 19:30:00 | CL | Futures | 61.71 | 61.71 | 61.56 | 61.63 | 924.0 |
| 2024-01-07 20:00:00 | CL | Futures | 61.63 | 61.64 | 61.4 | 61.47 | 2115.0 |
| 2024-01-07 20:30:00 | CL | Futures | 61.47 | 61.48 | 61.3 | 61.31 | 1659.0 |
| 2024-01-07 21:00:00 | CL | Futures | 61.31 | 61.33 | 61.13 | 61.18 | 2317.0 |
| 2024-01-07 21:30:00 | CL | Futures | 61.18 | 61.18 | 60.95 | 60.98 | 1858.0 |
| 2024-01-07 22:00:00 | CL | Futures | 60.99 | 61.04 | 60.91 | 61.02 | 1614.0 |
| 2024-01-07 22:30:00 | CL | Futures | 61.02 | 61.03 | 60.97 | 61.01 | 918.0 |
| 2024-01-07 23:00:00 | CL | Futures | 61.01 | 61.02 | 60.93 | 60.96 | 949.0 |
| 2024-01-07 23:30:00 | CL | Futures | 60.95 | 60.98 | 60.87 | 60.89 | 972.0 |
| 2024-01-07 18:00:00 | GC | Futures | 2270.8 | 2270.8 | 2268.5 | 2269.1 | 1461.0 |
| 2024-01-07 18:30:00 | GC | Futures | 2269.4 | 2269.7 | 2267.7 | 2269.1 | 1165.0 |
> showing 50 of 837 rows — these rows as CSV