PREVIEW / futures_1hour / 2023-01-08
file: by_date/futures_1hour/2023/2023-01-08.parquet size: 19 KB rows: 433
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 | 4387.59 | 12124.0 |
| 2023-01-08 19:00:00 | ES | Futures | 4387.31 | 4392.06 | 4383.39 | 4391.5 | 8331.0 |
| 2023-01-08 20:00:00 | ES | Futures | 4391.5 | 4392.06 | 4385.35 | 4385.91 | 8443.0 |
| 2023-01-08 21:00:00 | ES | Futures | 4385.91 | 4390.38 | 4385.35 | 4389.26 | 6946.0 |
| 2023-01-08 22:00:00 | ES | Futures | 4388.98 | 4389.54 | 4387.03 | 4388.42 | 3658.0 |
| 2023-01-08 23:00:00 | ES | Futures | 4388.7 | 4396.53 | 4388.42 | 4395.14 | 6182.0 |
| 2023-01-08 18:00:00 | NQ | Futures | 12661.69 | 12700.67 | 12657.99 | 12680.18 | 6558.0 |
| 2023-01-08 19:00:00 | NQ | Futures | 12680.75 | 12691.56 | 12658.28 | 12689.57 | 5162.0 |
| 2023-01-08 20:00:00 | NQ | Futures | 12689.57 | 12691.28 | 12666.81 | 12675.06 | 4173.0 |
| 2023-01-08 21:00:00 | NQ | Futures | 12675.06 | 12690.14 | 12674.78 | 12683.88 | 2509.0 |
| 2023-01-08 22:00:00 | NQ | Futures | 12683.88 | 12687.3 | 12674.49 | 12685.87 | 1733.0 |
| 2023-01-08 23:00:00 | NQ | Futures | 12685.31 | 12720.3 | 12683.31 | 12715.75 | 4005.0 |
| 2023-01-08 18:00:00 | YM | Futures | 37648.2 | 37693.9 | 37640.4 | 37677.2 | 1744.0 |
| 2023-01-08 19:00:00 | YM | Futures | 37677.2 | 37713.9 | 37657.1 | 37709.5 | 1007.0 |
| 2023-01-08 20:00:00 | YM | Futures | 37709.5 | 37719.5 | 37673.8 | 37673.8 | 987.0 |
| 2023-01-08 21:00:00 | YM | Futures | 37677.2 | 37703.9 | 37668.3 | 37698.3 | 882.0 |
| 2023-01-08 22:00:00 | YM | Futures | 37698.3 | 37700.6 | 37678.3 | 37687.2 | 507.0 |
| 2023-01-08 23:00:00 | YM | Futures | 37686.1 | 37742.9 | 37685.0 | 37730.7 | 962.0 |
| 2023-01-08 18:00:00 | CL | Futures | 60.13 | 60.68 | 60.13 | 60.64 | 2685.0 |
| 2023-01-08 19:00:00 | CL | Futures | 60.65 | 60.78 | 60.61 | 60.77 | 1259.0 |
| 2023-01-08 20:00:00 | CL | Futures | 60.77 | 60.95 | 60.67 | 60.88 | 3196.0 |
| 2023-01-08 21:00:00 | CL | Futures | 60.87 | 61.19 | 60.85 | 61.14 | 3245.0 |
| 2023-01-08 22:00:00 | CL | Futures | 61.15 | 61.28 | 60.96 | 61.09 | 2376.0 |
| 2023-01-08 23:00:00 | CL | Futures | 61.09 | 61.22 | 61.06 | 61.17 | 1595.0 |
| 2023-01-08 18:00:00 | GC | Futures | 2193.6 | 2196.7 | 2189.5 | 2195.1 | 3648.0 |
| 2023-01-08 19:00:00 | GC | Futures | 2195.5 | 2196.6 | 2192.3 | 2193.9 | 3266.0 |
| 2023-01-08 20:00:00 | GC | Futures | 2194.1 | 2202.5 | 2193.7 | 2200.8 | 8433.0 |
| 2023-01-08 21:00:00 | GC | Futures | 2201.0 | 2207.2 | 2200.7 | 2206.8 | 6241.0 |
| 2023-01-08 22:00:00 | GC | Futures | 2206.8 | 2207.2 | 2203.8 | 2204.4 | 2979.0 |
| 2023-01-08 23:00:00 | GC | Futures | 2204.2 | 2205.2 | 2203.9 | 2203.9 | 1285.0 |
| 2023-01-08 18:00:00 | ZN | Futures | 117.676554 | 117.789225 | 117.628266 | 117.69265 | 15693.0 |
| 2023-01-08 19:00:00 | ZN | Futures | 117.69265 | 117.740937 | 117.644362 | 117.69265 | 12888.0 |
| 2023-01-08 20:00:00 | ZN | Futures | 117.708745 | 117.708745 | 117.612171 | 117.660458 | 15512.0 |
| 2023-01-08 21:00:00 | ZN | Futures | 117.676554 | 117.708745 | 117.644362 | 117.69265 | 10636.0 |
| 2023-01-08 22:00:00 | ZN | Futures | 117.69265 | 117.724841 | 117.644362 | 117.676554 | 4137.0 |
| 2023-01-08 23:00:00 | ZN | Futures | 117.676554 | 117.708745 | 117.644362 | 117.676554 | 4196.0 |
> showing 36 of 433 rows — these rows as CSV