PREVIEW / futures_30min / 2023-05-14
file: by_date/futures_30min/2023/2023-05-14.parquet size: 28 KB rows: 776
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 |
|---|---|---|---|---|---|---|---|
| 2023-05-14 18:00:00 | ES | Futures | 4584.37 | 4585.76 | 4581.6 | 4581.6 | 3320.0 |
| 2023-05-14 18:30:00 | ES | Futures | 4581.88 | 4582.16 | 4580.77 | 4580.77 | 1382.0 |
| 2023-05-14 19:00:00 | ES | Futures | 4581.05 | 4583.26 | 4580.77 | 4582.43 | 1300.0 |
| 2023-05-14 19:30:00 | ES | Futures | 4582.43 | 4585.21 | 4582.43 | 4584.37 | 2158.0 |
| 2023-05-14 20:00:00 | ES | Futures | 4584.1 | 4585.48 | 4581.6 | 4583.54 | 3674.0 |
| 2023-05-14 20:30:00 | ES | Futures | 4583.82 | 4584.1 | 4578.27 | 4580.49 | 4403.0 |
| 2023-05-14 21:00:00 | ES | Futures | 4580.77 | 4588.53 | 4580.21 | 4587.15 | 5542.0 |
| 2023-05-14 21:30:00 | ES | Futures | 4587.15 | 4589.09 | 4586.04 | 4588.26 | 3711.0 |
| 2023-05-14 22:00:00 | ES | Futures | 4588.26 | 4588.53 | 4586.87 | 4587.7 | 2065.0 |
| 2023-05-14 22:30:00 | ES | Futures | 4587.98 | 4589.09 | 4586.87 | 4588.81 | 1590.0 |
| 2023-05-14 23:00:00 | ES | Futures | 4588.81 | 4590.75 | 4588.53 | 4589.92 | 2467.0 |
| 2023-05-14 23:30:00 | ES | Futures | 4589.64 | 4590.48 | 4588.81 | 4589.92 | 1992.0 |
| 2023-05-14 18:00:00 | NQ | Futures | 15067.31 | 15067.31 | 15046.47 | 15046.47 | 1988.0 |
| 2023-05-14 18:30:00 | NQ | Futures | 15047.32 | 15052.39 | 15043.1 | 15044.22 | 873.0 |
| 2023-05-14 19:00:00 | NQ | Futures | 15044.79 | 15052.11 | 15041.69 | 15047.6 | 922.0 |
| 2023-05-14 19:30:00 | NQ | Futures | 15047.6 | 15057.74 | 15047.6 | 15053.51 | 1109.0 |
| 2023-05-14 20:00:00 | NQ | Futures | 15053.23 | 15059.14 | 15046.47 | 15053.23 | 1845.0 |
| 2023-05-14 20:30:00 | NQ | Futures | 15053.23 | 15054.92 | 15034.93 | 15044.5 | 2260.0 |
| 2023-05-14 21:00:00 | NQ | Futures | 15043.94 | 15078.01 | 15043.38 | 15070.41 | 3165.0 |
| 2023-05-14 21:30:00 | NQ | Futures | 15070.13 | 15077.16 | 15065.62 | 15072.66 | 1940.0 |
| 2023-05-14 22:00:00 | NQ | Futures | 15073.22 | 15073.22 | 15067.87 | 15070.69 | 987.0 |
| 2023-05-14 22:30:00 | NQ | Futures | 15070.69 | 15076.04 | 15066.18 | 15073.22 | 1419.0 |
| 2023-05-14 23:00:00 | NQ | Futures | 15074.07 | 15084.77 | 15073.79 | 15081.11 | 1490.0 |
| 2023-05-14 23:30:00 | NQ | Futures | 15080.82 | 15084.2 | 15076.04 | 15080.54 | 1058.0 |
| 2023-05-14 18:00:00 | YM | Futures | 36830.0 | 36830.0 | 36801.2 | 36801.2 | 373.0 |
| 2023-05-14 18:30:00 | YM | Futures | 36801.2 | 36802.3 | 36786.9 | 36790.2 | 287.0 |
| 2023-05-14 19:00:00 | YM | Futures | 36790.2 | 36804.6 | 36788.0 | 36800.1 | 196.0 |
| 2023-05-14 19:30:00 | YM | Futures | 36800.1 | 36825.6 | 36800.1 | 36821.1 | 411.0 |
| 2023-05-14 20:00:00 | YM | Futures | 36821.1 | 36832.2 | 36812.3 | 36824.5 | 457.0 |
| 2023-05-14 20:30:00 | YM | Futures | 36825.6 | 36830.0 | 36788.0 | 36801.2 | 552.0 |
| 2023-05-14 21:00:00 | YM | Futures | 36801.2 | 36846.6 | 36800.1 | 36838.8 | 766.0 |
| 2023-05-14 21:30:00 | YM | Futures | 36839.9 | 36854.3 | 36833.3 | 36849.9 | 373.0 |
| 2023-05-14 22:00:00 | YM | Futures | 36849.9 | 36849.9 | 36833.3 | 36838.8 | 307.0 |
| 2023-05-14 22:30:00 | YM | Futures | 36839.9 | 36848.8 | 36836.6 | 36846.6 | 188.0 |
| 2023-05-14 23:00:00 | YM | Futures | 36847.7 | 36859.8 | 36847.7 | 36854.3 | 328.0 |
| 2023-05-14 23:30:00 | YM | Futures | 36853.2 | 36862.0 | 36849.9 | 36858.7 | 298.0 |
| 2023-05-14 18:00:00 | CL | Futures | 56.96 | 57.07 | 56.95 | 56.98 | 300.0 |
| 2023-05-14 18:30:00 | CL | Futures | 57.0 | 57.03 | 56.94 | 57.01 | 203.0 |
| 2023-05-14 19:00:00 | CL | Futures | 57.01 | 57.02 | 56.89 | 56.9 | 126.0 |
| 2023-05-14 19:30:00 | CL | Futures | 56.9 | 56.98 | 56.9 | 56.98 | 57.0 |
| 2023-05-14 20:00:00 | CL | Futures | 56.96 | 57.04 | 56.94 | 56.99 | 234.0 |
| 2023-05-14 20:30:00 | CL | Futures | 56.99 | 57.11 | 56.98 | 57.04 | 287.0 |
| 2023-05-14 21:00:00 | CL | Futures | 57.06 | 57.11 | 56.56 | 56.65 | 1169.0 |
| 2023-05-14 21:30:00 | CL | Futures | 56.7 | 56.81 | 56.66 | 56.69 | 457.0 |
| 2023-05-14 22:00:00 | CL | Futures | 56.69 | 56.75 | 56.65 | 56.69 | 211.0 |
| 2023-05-14 22:30:00 | CL | Futures | 56.7 | 56.72 | 56.57 | 56.58 | 210.0 |
| 2023-05-14 23:00:00 | CL | Futures | 56.58 | 56.64 | 56.48 | 56.56 | 564.0 |
| 2023-05-14 23:30:00 | CL | Futures | 56.54 | 56.59 | 56.46 | 56.47 | 242.0 |
| 2023-05-14 18:00:00 | GC | Futures | 2315.4 | 2318.6 | 2312.9 | 2318.5 | 2000.0 |
| 2023-05-14 18:30:00 | GC | Futures | 2318.4 | 2318.4 | 2317.5 | 2317.7 | 345.0 |
> showing 50 of 776 rows — these rows as CSV