PREVIEW / futures_30min / 2023-01-08
file: by_date/futures_30min/2023/2023-01-08.parquet size: 29 KB rows: 818
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-01-08 18:00:00 | ES | Futures | 4382.55 | 4389.82 | 4381.99 | 4384.79 | 8764.0 |
| 2023-01-08 18:30:00 | ES | Futures | 4385.07 | 4389.26 | 4385.07 | 4387.59 | 3360.0 |
| 2023-01-08 19:00:00 | ES | Futures | 4387.31 | 4388.7 | 4383.39 | 4384.79 | 3421.0 |
| 2023-01-08 19:30:00 | ES | Futures | 4384.79 | 4392.06 | 4384.51 | 4391.5 | 4910.0 |
| 2023-01-08 20:00:00 | ES | Futures | 4391.5 | 4392.06 | 4387.03 | 4387.31 | 4373.0 |
| 2023-01-08 20:30:00 | ES | Futures | 4387.31 | 4388.7 | 4385.35 | 4385.91 | 4070.0 |
| 2023-01-08 21:00:00 | ES | Futures | 4385.91 | 4388.7 | 4385.35 | 4387.59 | 3216.0 |
| 2023-01-08 21:30:00 | ES | Futures | 4387.87 | 4390.38 | 4386.75 | 4389.26 | 3730.0 |
| 2023-01-08 22:00:00 | ES | Futures | 4388.98 | 4389.54 | 4387.03 | 4388.7 | 1873.0 |
| 2023-01-08 22:30:00 | ES | Futures | 4388.7 | 4389.54 | 4387.59 | 4388.42 | 1785.0 |
| 2023-01-08 23:00:00 | ES | Futures | 4388.7 | 4392.06 | 4388.42 | 4392.06 | 1677.0 |
| 2023-01-08 23:30:00 | ES | Futures | 4391.78 | 4396.53 | 4390.94 | 4395.14 | 4505.0 |
| 2023-01-08 18:00:00 | NQ | Futures | 12661.69 | 12700.67 | 12657.99 | 12676.2 | 4728.0 |
| 2023-01-08 18:30:00 | NQ | Futures | 12676.49 | 12691.28 | 12670.8 | 12680.18 | 1830.0 |
| 2023-01-08 19:00:00 | NQ | Futures | 12680.75 | 12688.72 | 12658.28 | 12662.55 | 2405.0 |
| 2023-01-08 19:30:00 | NQ | Futures | 12662.26 | 12691.56 | 12660.27 | 12689.57 | 2757.0 |
| 2023-01-08 20:00:00 | NQ | Futures | 12689.57 | 12691.28 | 12673.36 | 12675.63 | 2261.0 |
| 2023-01-08 20:30:00 | NQ | Futures | 12675.92 | 12683.6 | 12666.81 | 12675.06 | 1912.0 |
| 2023-01-08 21:00:00 | NQ | Futures | 12675.06 | 12690.14 | 12674.78 | 12683.31 | 1329.0 |
| 2023-01-08 21:30:00 | NQ | Futures | 12683.31 | 12689.86 | 12678.48 | 12683.88 | 1180.0 |
| 2023-01-08 22:00:00 | NQ | Futures | 12683.88 | 12685.87 | 12674.49 | 12680.47 | 948.0 |
| 2023-01-08 22:30:00 | NQ | Futures | 12681.04 | 12687.3 | 12680.75 | 12685.87 | 785.0 |
| 2023-01-08 23:00:00 | NQ | Futures | 12685.31 | 12700.1 | 12683.31 | 12700.1 | 1036.0 |
| 2023-01-08 23:30:00 | NQ | Futures | 12700.1 | 12720.3 | 12694.98 | 12715.75 | 2969.0 |
| 2023-01-08 18:00:00 | YM | Futures | 37648.2 | 37693.9 | 37640.4 | 37646.0 | 1184.0 |
| 2023-01-08 18:30:00 | YM | Futures | 37648.2 | 37683.9 | 37648.2 | 37677.2 | 560.0 |
| 2023-01-08 19:00:00 | YM | Futures | 37677.2 | 37681.6 | 37657.1 | 37671.6 | 339.0 |
| 2023-01-08 19:30:00 | YM | Futures | 37670.5 | 37713.9 | 37668.3 | 37709.5 | 668.0 |
| 2023-01-08 20:00:00 | YM | Futures | 37709.5 | 37719.5 | 37683.9 | 37687.2 | 515.0 |
| 2023-01-08 20:30:00 | YM | Futures | 37683.9 | 37692.8 | 37673.8 | 37673.8 | 472.0 |
| 2023-01-08 21:00:00 | YM | Futures | 37677.2 | 37691.7 | 37668.3 | 37689.4 | 425.0 |
| 2023-01-08 21:30:00 | YM | Futures | 37686.1 | 37703.9 | 37679.4 | 37698.3 | 457.0 |
| 2023-01-08 22:00:00 | YM | Futures | 37698.3 | 37700.6 | 37678.3 | 37691.7 | 321.0 |
| 2023-01-08 22:30:00 | YM | Futures | 37690.5 | 37693.9 | 37681.6 | 37687.2 | 186.0 |
| 2023-01-08 23:00:00 | YM | Futures | 37686.1 | 37709.5 | 37685.0 | 37706.1 | 221.0 |
| 2023-01-08 23:30:00 | YM | Futures | 37707.3 | 37742.9 | 37703.9 | 37730.7 | 741.0 |
| 2023-01-08 18:00:00 | CL | Futures | 60.13 | 60.68 | 60.13 | 60.58 | 2062.0 |
| 2023-01-08 18:30:00 | CL | Futures | 60.57 | 60.66 | 60.55 | 60.64 | 623.0 |
| 2023-01-08 19:00:00 | CL | Futures | 60.65 | 60.71 | 60.61 | 60.65 | 554.0 |
| 2023-01-08 19:30:00 | CL | Futures | 60.65 | 60.78 | 60.64 | 60.77 | 705.0 |
| 2023-01-08 20:00:00 | CL | Futures | 60.77 | 60.95 | 60.68 | 60.79 | 2129.0 |
| 2023-01-08 20:30:00 | CL | Futures | 60.78 | 60.91 | 60.67 | 60.88 | 1067.0 |
| 2023-01-08 21:00:00 | CL | Futures | 60.87 | 61.01 | 60.85 | 61.01 | 1463.0 |
| 2023-01-08 21:30:00 | CL | Futures | 61.01 | 61.19 | 61.01 | 61.14 | 1782.0 |
| 2023-01-08 22:00:00 | CL | Futures | 61.15 | 61.28 | 60.96 | 61.02 | 1750.0 |
| 2023-01-08 22:30:00 | CL | Futures | 61.02 | 61.09 | 60.99 | 61.09 | 626.0 |
| 2023-01-08 23:00:00 | CL | Futures | 61.09 | 61.14 | 61.06 | 61.11 | 627.0 |
| 2023-01-08 23:30:00 | CL | Futures | 61.11 | 61.22 | 61.09 | 61.17 | 968.0 |
| 2023-01-08 18:00:00 | GC | Futures | 2193.6 | 2195.0 | 2189.5 | 2193.5 | 1791.0 |
| 2023-01-08 18:30:00 | GC | Futures | 2193.6 | 2196.7 | 2192.6 | 2195.1 | 1857.0 |
> showing 50 of 818 rows — these rows as CSV