PREVIEW / futures_30min / 2022-07-24
file: by_date/futures_30min/2022/2022-07-24.parquet size: 29 KB rows: 796
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 |
|---|---|---|---|---|---|---|---|
| 2022-07-24 18:00:00 | ES | Futures | 4495.8 | 4496.37 | 4480.79 | 4485.89 | 6547.0 |
| 2022-07-24 18:30:00 | ES | Futures | 4486.17 | 4490.42 | 4485.04 | 4485.6 | 2916.0 |
| 2022-07-24 19:00:00 | ES | Futures | 4485.89 | 4489.85 | 4485.32 | 4488.72 | 1911.0 |
| 2022-07-24 19:30:00 | ES | Futures | 4488.44 | 4490.42 | 4483.05 | 4483.34 | 3037.0 |
| 2022-07-24 20:00:00 | ES | Futures | 4483.62 | 4493.82 | 4482.49 | 4490.99 | 5365.0 |
| 2022-07-24 20:30:00 | ES | Futures | 4490.99 | 4492.12 | 4479.66 | 4480.22 | 4704.0 |
| 2022-07-24 21:00:00 | ES | Futures | 4479.94 | 4484.47 | 4477.67 | 4481.35 | 4582.0 |
| 2022-07-24 21:30:00 | ES | Futures | 4481.35 | 4481.92 | 4477.39 | 4479.37 | 3889.0 |
| 2022-07-24 22:00:00 | ES | Futures | 4479.37 | 4483.34 | 4478.81 | 4481.64 | 2640.0 |
| 2022-07-24 22:30:00 | ES | Futures | 4481.64 | 4487.02 | 4480.22 | 4485.32 | 2474.0 |
| 2022-07-24 23:00:00 | ES | Futures | 4485.6 | 4487.02 | 4482.2 | 4482.77 | 2213.0 |
| 2022-07-24 23:30:00 | ES | Futures | 4482.77 | 4489.0 | 4482.49 | 4488.44 | 2221.0 |
| 2022-07-24 18:00:00 | NQ | Futures | 14397.74 | 14410.76 | 14346.84 | 14361.3 | 2885.0 |
| 2022-07-24 18:30:00 | NQ | Futures | 14362.74 | 14383.28 | 14361.88 | 14367.37 | 1603.0 |
| 2022-07-24 19:00:00 | NQ | Futures | 14367.08 | 14379.81 | 14359.56 | 14369.97 | 1215.0 |
| 2022-07-24 19:30:00 | NQ | Futures | 14369.69 | 14374.31 | 14348.86 | 14350.31 | 1687.0 |
| 2022-07-24 20:00:00 | NQ | Futures | 14350.88 | 14388.77 | 14346.84 | 14377.21 | 3076.0 |
| 2022-07-24 20:30:00 | NQ | Futures | 14376.63 | 14381.83 | 14335.84 | 14337.87 | 2514.0 |
| 2022-07-24 21:00:00 | NQ | Futures | 14337.87 | 14357.83 | 14327.75 | 14350.02 | 2067.0 |
| 2022-07-24 21:30:00 | NQ | Futures | 14349.15 | 14353.49 | 14333.82 | 14342.5 | 2322.0 |
| 2022-07-24 22:00:00 | NQ | Futures | 14344.23 | 14359.56 | 14340.18 | 14348.57 | 1260.0 |
| 2022-07-24 22:30:00 | NQ | Futures | 14348.86 | 14365.64 | 14342.79 | 14359.56 | 1025.0 |
| 2022-07-24 23:00:00 | NQ | Futures | 14361.59 | 14367.37 | 14346.26 | 14347.99 | 1270.0 |
| 2022-07-24 23:30:00 | NQ | Futures | 14348.57 | 14368.24 | 14347.12 | 14366.79 | 985.0 |
| 2022-07-24 18:00:00 | YM | Futures | 35962.6 | 35979.5 | 35887.0 | 35907.3 | 884.0 |
| 2022-07-24 18:30:00 | YM | Futures | 35910.7 | 35935.5 | 35898.3 | 35903.9 | 441.0 |
| 2022-07-24 19:00:00 | YM | Futures | 35907.3 | 35934.4 | 35905.0 | 35931.0 | 266.0 |
| 2022-07-24 19:30:00 | YM | Futures | 35927.6 | 35945.6 | 35897.1 | 35899.4 | 576.0 |
| 2022-07-24 20:00:00 | YM | Futures | 35901.6 | 35971.6 | 35892.6 | 35954.7 | 886.0 |
| 2022-07-24 20:30:00 | YM | Futures | 35954.7 | 35960.3 | 35872.3 | 35879.1 | 643.0 |
| 2022-07-24 21:00:00 | YM | Futures | 35875.7 | 35903.9 | 35859.9 | 35883.6 | 828.0 |
| 2022-07-24 21:30:00 | YM | Futures | 35877.9 | 35883.6 | 35850.9 | 35867.8 | 591.0 |
| 2022-07-24 22:00:00 | YM | Futures | 35866.7 | 35897.1 | 35862.1 | 35884.7 | 434.0 |
| 2022-07-24 22:30:00 | YM | Futures | 35882.5 | 35923.1 | 35874.6 | 35911.8 | 377.0 |
| 2022-07-24 23:00:00 | YM | Futures | 35914.0 | 35925.3 | 35891.5 | 35891.5 | 314.0 |
| 2022-07-24 23:30:00 | YM | Futures | 35894.9 | 35937.7 | 35891.5 | 35935.5 | 385.0 |
| 2022-07-24 18:00:00 | CL | Futures | 75.54 | 75.91 | 75.22 | 75.79 | 1569.0 |
| 2022-07-24 18:30:00 | CL | Futures | 75.8 | 75.87 | 75.74 | 75.79 | 498.0 |
| 2022-07-24 19:00:00 | CL | Futures | 75.8 | 75.82 | 75.49 | 75.5 | 870.0 |
| 2022-07-24 19:30:00 | CL | Futures | 75.52 | 75.58 | 75.38 | 75.39 | 679.0 |
| 2022-07-24 20:00:00 | CL | Futures | 75.39 | 76.06 | 75.3 | 75.94 | 2181.0 |
| 2022-07-24 20:30:00 | CL | Futures | 75.93 | 75.94 | 75.51 | 75.52 | 1439.0 |
| 2022-07-24 21:00:00 | CL | Futures | 75.51 | 75.57 | 74.97 | 75.18 | 4986.0 |
| 2022-07-24 21:30:00 | CL | Futures | 75.17 | 75.2 | 74.54 | 74.56 | 5654.0 |
| 2022-07-24 22:00:00 | CL | Futures | 74.57 | 74.71 | 74.4 | 74.57 | 2218.0 |
| 2022-07-24 22:30:00 | CL | Futures | 74.56 | 74.67 | 74.29 | 74.63 | 2944.0 |
| 2022-07-24 23:00:00 | CL | Futures | 74.63 | 74.79 | 74.44 | 74.6 | 2113.0 |
| 2022-07-24 23:30:00 | CL | Futures | 74.6 | 74.81 | 74.6 | 74.62 | 924.0 |
| 2022-07-24 18:00:00 | GC | Futures | 2060.3 | 2060.6 | 2057.0 | 2057.7 | 872.0 |
| 2022-07-24 18:30:00 | GC | Futures | 2057.7 | 2058.3 | 2057.0 | 2057.7 | 383.0 |
> showing 50 of 796 rows — these rows as CSV