PREVIEW / futures_1hour / 2022-07-24
file: by_date/futures_1hour/2022/2022-07-24.parquet size: 19 KB rows: 416
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.6 | 9463.0 |
| 2022-07-24 19:00:00 | ES | Futures | 4485.89 | 4490.42 | 4483.05 | 4483.34 | 4948.0 |
| 2022-07-24 20:00:00 | ES | Futures | 4483.62 | 4493.82 | 4479.66 | 4480.22 | 10069.0 |
| 2022-07-24 21:00:00 | ES | Futures | 4479.94 | 4484.47 | 4477.39 | 4479.37 | 8471.0 |
| 2022-07-24 22:00:00 | ES | Futures | 4479.37 | 4487.02 | 4478.81 | 4485.32 | 5114.0 |
| 2022-07-24 23:00:00 | ES | Futures | 4485.6 | 4489.0 | 4482.2 | 4488.44 | 4434.0 |
| 2022-07-24 18:00:00 | NQ | Futures | 14397.74 | 14410.76 | 14346.84 | 14367.37 | 4488.0 |
| 2022-07-24 19:00:00 | NQ | Futures | 14367.08 | 14379.81 | 14348.86 | 14350.31 | 2902.0 |
| 2022-07-24 20:00:00 | NQ | Futures | 14350.88 | 14388.77 | 14335.84 | 14337.87 | 5590.0 |
| 2022-07-24 21:00:00 | NQ | Futures | 14337.87 | 14357.83 | 14327.75 | 14342.5 | 4389.0 |
| 2022-07-24 22:00:00 | NQ | Futures | 14344.23 | 14365.64 | 14340.18 | 14359.56 | 2285.0 |
| 2022-07-24 23:00:00 | NQ | Futures | 14361.59 | 14368.24 | 14346.26 | 14366.79 | 2255.0 |
| 2022-07-24 18:00:00 | YM | Futures | 35962.6 | 35979.5 | 35887.0 | 35903.9 | 1325.0 |
| 2022-07-24 19:00:00 | YM | Futures | 35907.3 | 35945.6 | 35897.1 | 35899.4 | 842.0 |
| 2022-07-24 20:00:00 | YM | Futures | 35901.6 | 35971.6 | 35872.3 | 35879.1 | 1529.0 |
| 2022-07-24 21:00:00 | YM | Futures | 35875.7 | 35903.9 | 35850.9 | 35867.8 | 1419.0 |
| 2022-07-24 22:00:00 | YM | Futures | 35866.7 | 35923.1 | 35862.1 | 35911.8 | 811.0 |
| 2022-07-24 23:00:00 | YM | Futures | 35914.0 | 35937.7 | 35891.5 | 35935.5 | 699.0 |
| 2022-07-24 18:00:00 | CL | Futures | 75.54 | 75.91 | 75.22 | 75.79 | 2067.0 |
| 2022-07-24 19:00:00 | CL | Futures | 75.8 | 75.82 | 75.38 | 75.39 | 1549.0 |
| 2022-07-24 20:00:00 | CL | Futures | 75.39 | 76.06 | 75.3 | 75.52 | 3620.0 |
| 2022-07-24 21:00:00 | CL | Futures | 75.51 | 75.57 | 74.54 | 74.56 | 10640.0 |
| 2022-07-24 22:00:00 | CL | Futures | 74.57 | 74.71 | 74.29 | 74.63 | 5162.0 |
| 2022-07-24 23:00:00 | CL | Futures | 74.63 | 74.81 | 74.44 | 74.62 | 3037.0 |
| 2022-07-24 18:00:00 | GC | Futures | 2060.3 | 2060.6 | 2057.0 | 2057.7 | 1255.0 |
| 2022-07-24 19:00:00 | GC | Futures | 2057.6 | 2057.8 | 2055.5 | 2056.0 | 778.0 |
| 2022-07-24 20:00:00 | GC | Futures | 2056.1 | 2056.1 | 2051.1 | 2051.2 | 1765.0 |
| 2022-07-24 21:00:00 | GC | Futures | 2051.2 | 2056.6 | 2050.3 | 2056.3 | 3378.0 |
| 2022-07-24 22:00:00 | GC | Futures | 2056.4 | 2059.7 | 2055.2 | 2059.2 | 1911.0 |
| 2022-07-24 23:00:00 | GC | Futures | 2059.2 | 2061.2 | 2058.3 | 2059.5 | 2854.0 |
| 2022-07-24 18:00:00 | ZN | Futures | 123.848983 | 123.865101 | 123.607216 | 123.623334 | 9337.0 |
| 2022-07-24 19:00:00 | ZN | Futures | 123.607216 | 123.65557 | 123.558863 | 123.607216 | 6944.0 |
| 2022-07-24 20:00:00 | ZN | Futures | 123.623334 | 123.623334 | 123.51051 | 123.558863 | 13323.0 |
| 2022-07-24 21:00:00 | ZN | Futures | 123.558863 | 123.736159 | 123.542745 | 123.720041 | 17231.0 |
| 2022-07-24 22:00:00 | ZN | Futures | 123.720041 | 123.736159 | 123.671687 | 123.671687 | 8792.0 |
| 2022-07-24 23:00:00 | ZN | Futures | 123.687805 | 123.703923 | 123.65557 | 123.671687 | 5751.0 |
> showing 36 of 416 rows — these rows as CSV