PREVIEW / futures_1hour / 2022-10-30
file: by_date/futures_1hour/2022/2022-10-30.parquet size: 20 KB rows: 430
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-10-30 18:00:00 | ES | Futures | 4410.51 | 4414.17 | 4399.51 | 4406.28 | 15233.0 |
| 2022-10-30 19:00:00 | ES | Futures | 4406.56 | 4410.51 | 4403.18 | 4404.02 | 8047.0 |
| 2022-10-30 20:00:00 | ES | Futures | 4404.02 | 4407.12 | 4393.31 | 4396.98 | 13765.0 |
| 2022-10-30 21:00:00 | ES | Futures | 4396.98 | 4404.31 | 4392.47 | 4402.33 | 14018.0 |
| 2022-10-30 22:00:00 | ES | Futures | 4402.33 | 4405.43 | 4398.39 | 4402.33 | 9084.0 |
| 2022-10-30 23:00:00 | ES | Futures | 4402.33 | 4409.66 | 4399.8 | 4406.0 | 7378.0 |
| 2022-10-30 18:00:00 | NQ | Futures | 13323.3 | 13326.17 | 13269.28 | 13297.15 | 7093.0 |
| 2022-10-30 19:00:00 | NQ | Futures | 13298.3 | 13317.55 | 13279.05 | 13283.08 | 4030.0 |
| 2022-10-30 20:00:00 | NQ | Futures | 13283.08 | 13287.96 | 13238.83 | 13253.77 | 5857.0 |
| 2022-10-30 21:00:00 | NQ | Futures | 13253.77 | 13279.92 | 13236.82 | 13274.17 | 6685.0 |
| 2022-10-30 22:00:00 | NQ | Futures | 13273.59 | 13292.27 | 13264.11 | 13281.35 | 3528.0 |
| 2022-10-30 23:00:00 | NQ | Futures | 13281.64 | 13310.95 | 13277.62 | 13296.29 | 3171.0 |
| 2022-10-30 18:00:00 | YM | Futures | 36943.9 | 36967.5 | 36851.9 | 36901.3 | 2302.0 |
| 2022-10-30 19:00:00 | YM | Futures | 36901.3 | 36928.2 | 36891.2 | 36902.4 | 1291.0 |
| 2022-10-30 20:00:00 | YM | Futures | 36901.3 | 36931.6 | 36837.3 | 36856.4 | 1812.0 |
| 2022-10-30 21:00:00 | YM | Futures | 36855.3 | 36915.9 | 36831.7 | 36906.9 | 1852.0 |
| 2022-10-30 22:00:00 | YM | Futures | 36900.2 | 36911.4 | 36864.3 | 36880.0 | 943.0 |
| 2022-10-30 23:00:00 | YM | Futures | 36880.0 | 36928.2 | 36865.4 | 36904.7 | 1094.0 |
| 2022-10-30 18:00:00 | CL | Futures | 71.91 | 72.12 | 71.83 | 71.87 | 1562.0 |
| 2022-10-30 19:00:00 | CL | Futures | 71.86 | 71.91 | 71.75 | 71.9 | 746.0 |
| 2022-10-30 20:00:00 | CL | Futures | 71.9 | 72.04 | 71.66 | 71.69 | 1731.0 |
| 2022-10-30 21:00:00 | CL | Futures | 71.67 | 71.81 | 71.19 | 71.23 | 4240.0 |
| 2022-10-30 22:00:00 | CL | Futures | 71.22 | 71.32 | 70.76 | 71.28 | 5054.0 |
| 2022-10-30 23:00:00 | CL | Futures | 71.28 | 71.29 | 71.1 | 71.14 | 1283.0 |
| 2022-10-30 18:00:00 | GC | Futures | 1945.6 | 1947.0 | 1940.9 | 1945.5 | 2209.0 |
| 2022-10-30 19:00:00 | GC | Futures | 1945.5 | 1946.9 | 1944.4 | 1944.5 | 1007.0 |
| 2022-10-30 20:00:00 | GC | Futures | 1944.5 | 1946.5 | 1943.1 | 1943.2 | 1531.0 |
| 2022-10-30 21:00:00 | GC | Futures | 1943.0 | 1943.9 | 1941.2 | 1942.3 | 2315.0 |
| 2022-10-30 22:00:00 | GC | Futures | 1942.2 | 1944.9 | 1941.4 | 1942.2 | 1941.0 |
| 2022-10-30 23:00:00 | GC | Futures | 1942.3 | 1945.9 | 1941.8 | 1945.6 | 1695.0 |
| 2022-10-30 18:00:00 | ZN | Futures | 114.403967 | 114.436202 | 114.323378 | 114.420085 | 12521.0 |
| 2022-10-30 19:00:00 | ZN | Futures | 114.420085 | 114.45232 | 114.403967 | 114.436202 | 4989.0 |
| 2022-10-30 20:00:00 | ZN | Futures | 114.420085 | 114.436202 | 114.178318 | 114.194436 | 34313.0 |
| 2022-10-30 21:00:00 | ZN | Futures | 114.194436 | 114.242789 | 114.097729 | 114.242789 | 25508.0 |
| 2022-10-30 22:00:00 | ZN | Futures | 114.226671 | 114.258907 | 114.178318 | 114.226671 | 7196.0 |
| 2022-10-30 23:00:00 | ZN | Futures | 114.242789 | 114.339496 | 114.226671 | 114.339496 | 12213.0 |
> showing 36 of 430 rows — these rows as CSV