PREVIEW / futures_1hour / 2022-10-16
file: by_date/futures_1hour/2022/2022-10-16.parquet size: 19 KB rows: 423
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-16 18:00:00 | ES | Futures | 4049.12 | 4073.36 | 4048.56 | 4070.54 | 14151.0 |
| 2022-10-16 19:00:00 | ES | Futures | 4070.54 | 4077.87 | 4064.62 | 4076.18 | 10857.0 |
| 2022-10-16 20:00:00 | ES | Futures | 4075.9 | 4077.87 | 4066.03 | 4072.52 | 15190.0 |
| 2022-10-16 21:00:00 | ES | Futures | 4072.8 | 4077.59 | 4067.16 | 4071.95 | 12189.0 |
| 2022-10-16 22:00:00 | ES | Futures | 4071.67 | 4075.9 | 4069.42 | 4073.08 | 9267.0 |
| 2022-10-16 23:00:00 | ES | Futures | 4072.8 | 4077.59 | 4071.67 | 4073.36 | 6599.0 |
| 2022-10-16 18:00:00 | NQ | Futures | 12320.53 | 12415.93 | 12312.49 | 12402.71 | 7217.0 |
| 2022-10-16 19:00:00 | NQ | Futures | 12403.28 | 12410.18 | 12381.73 | 12403.57 | 5244.0 |
| 2022-10-16 20:00:00 | NQ | Futures | 12403.86 | 12411.33 | 12368.8 | 12397.54 | 6892.0 |
| 2022-10-16 21:00:00 | NQ | Futures | 12398.11 | 12417.08 | 12380.3 | 12393.51 | 7492.0 |
| 2022-10-16 22:00:00 | NQ | Futures | 12393.8 | 12406.16 | 12379.72 | 12389.2 | 4711.0 |
| 2022-10-16 23:00:00 | NQ | Futures | 12388.92 | 12403.57 | 12380.87 | 12394.95 | 2663.0 |
| 2022-10-16 18:00:00 | YM | Futures | 33283.2 | 33441.4 | 33263.0 | 33423.5 | 1680.0 |
| 2022-10-16 19:00:00 | YM | Futures | 33425.7 | 33508.8 | 33382.0 | 33495.3 | 1666.0 |
| 2022-10-16 20:00:00 | YM | Futures | 33494.2 | 33515.5 | 33420.1 | 33458.3 | 1704.0 |
| 2022-10-16 21:00:00 | YM | Futures | 33460.5 | 33496.4 | 33422.4 | 33460.5 | 1237.0 |
| 2022-10-16 22:00:00 | YM | Futures | 33462.8 | 33495.3 | 33448.2 | 33479.6 | 951.0 |
| 2022-10-16 23:00:00 | YM | Futures | 33476.2 | 33508.8 | 33471.7 | 33476.2 | 611.0 |
| 2022-10-16 18:00:00 | CL | Futures | 68.85 | 69.36 | 68.75 | 69.34 | 1765.0 |
| 2022-10-16 19:00:00 | CL | Futures | 69.36 | 69.38 | 69.23 | 69.32 | 288.0 |
| 2022-10-16 20:00:00 | CL | Futures | 69.32 | 69.55 | 69.31 | 69.35 | 1101.0 |
| 2022-10-16 21:00:00 | CL | Futures | 69.34 | 69.54 | 69.12 | 69.29 | 1427.0 |
| 2022-10-16 22:00:00 | CL | Futures | 69.29 | 69.35 | 69.05 | 69.17 | 892.0 |
| 2022-10-16 23:00:00 | CL | Futures | 69.17 | 69.36 | 69.11 | 69.33 | 637.0 |
| 2022-10-16 18:00:00 | GC | Futures | 1948.8 | 1952.2 | 1947.8 | 1949.9 | 1932.0 |
| 2022-10-16 19:00:00 | GC | Futures | 1949.8 | 1952.5 | 1949.5 | 1952.3 | 1039.0 |
| 2022-10-16 20:00:00 | GC | Futures | 1952.3 | 1954.0 | 1951.0 | 1953.0 | 2327.0 |
| 2022-10-16 21:00:00 | GC | Futures | 1953.3 | 1958.1 | 1951.2 | 1957.2 | 3589.0 |
| 2022-10-16 22:00:00 | GC | Futures | 1957.3 | 1958.0 | 1954.4 | 1955.4 | 2199.0 |
| 2022-10-16 23:00:00 | GC | Futures | 1955.3 | 1956.0 | 1954.0 | 1955.0 | 1168.0 |
| 2022-10-16 18:00:00 | ZN | Futures | 114.194436 | 114.242789 | 114.049376 | 114.146082 | 9412.0 |
| 2022-10-16 19:00:00 | ZN | Futures | 114.129965 | 114.226671 | 114.113847 | 114.194436 | 4537.0 |
| 2022-10-16 20:00:00 | ZN | Futures | 114.194436 | 114.275025 | 114.097729 | 114.226671 | 11054.0 |
| 2022-10-16 21:00:00 | ZN | Futures | 114.226671 | 114.242789 | 114.146082 | 114.178318 | 7659.0 |
| 2022-10-16 22:00:00 | ZN | Futures | 114.178318 | 114.291142 | 114.178318 | 114.226671 | 8117.0 |
| 2022-10-16 23:00:00 | ZN | Futures | 114.210554 | 114.275025 | 114.194436 | 114.226671 | 3272.0 |
> showing 36 of 423 rows — these rows as CSV