PREVIEW / futures_1hour / 2022-08-07
file: by_date/futures_1hour/2022/2022-08-07.parquet size: 19 KB rows: 417
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-08-07 18:00:00 | ES | Futures | 4702.02 | 4703.16 | 4680.49 | 4683.89 | 9132.0 |
| 2022-08-07 19:00:00 | ES | Futures | 4683.89 | 4685.88 | 4682.19 | 4683.33 | 4607.0 |
| 2022-08-07 20:00:00 | ES | Futures | 4683.33 | 4691.54 | 4682.48 | 4687.58 | 8349.0 |
| 2022-08-07 21:00:00 | ES | Futures | 4687.29 | 4687.86 | 4682.19 | 4687.58 | 6594.0 |
| 2022-08-07 22:00:00 | ES | Futures | 4687.58 | 4693.81 | 4686.44 | 4692.11 | 5766.0 |
| 2022-08-07 23:00:00 | ES | Futures | 4692.11 | 4694.66 | 4689.84 | 4690.41 | 3342.0 |
| 2022-08-07 18:00:00 | NQ | Futures | 15303.93 | 15378.26 | 15234.51 | 15252.73 | 6081.0 |
| 2022-08-07 19:00:00 | NQ | Futures | 15252.15 | 15257.36 | 15243.19 | 15246.37 | 2280.0 |
| 2022-08-07 20:00:00 | NQ | Futures | 15246.08 | 15269.22 | 15244.34 | 15262.86 | 3283.0 |
| 2022-08-07 21:00:00 | NQ | Futures | 15263.14 | 15270.66 | 15248.97 | 15268.64 | 2783.0 |
| 2022-08-07 22:00:00 | NQ | Futures | 15267.77 | 15293.8 | 15264.01 | 15289.18 | 3099.0 |
| 2022-08-07 23:00:00 | NQ | Futures | 15289.75 | 15300.17 | 15283.39 | 15287.44 | 2276.0 |
| 2022-08-07 18:00:00 | YM | Futures | 36953.3 | 37015.3 | 36857.3 | 36874.3 | 1865.0 |
| 2022-08-07 19:00:00 | YM | Futures | 36875.4 | 36884.4 | 36861.9 | 36865.2 | 521.0 |
| 2022-08-07 20:00:00 | YM | Futures | 36864.1 | 36935.2 | 36859.6 | 36899.1 | 1276.0 |
| 2022-08-07 21:00:00 | YM | Futures | 36898.0 | 36908.1 | 36860.7 | 36904.7 | 1215.0 |
| 2022-08-07 22:00:00 | YM | Futures | 36903.6 | 36946.5 | 36896.8 | 36932.9 | 1135.0 |
| 2022-08-07 23:00:00 | YM | Futures | 36931.8 | 36953.3 | 36920.5 | 36921.7 | 775.0 |
| 2022-08-07 18:00:00 | CL | Futures | 70.27 | 70.41 | 69.98 | 70.0 | 2690.0 |
| 2022-08-07 19:00:00 | CL | Futures | 70.02 | 70.02 | 69.79 | 69.96 | 1724.0 |
| 2022-08-07 20:00:00 | CL | Futures | 69.97 | 70.21 | 69.93 | 70.2 | 2427.0 |
| 2022-08-07 21:00:00 | CL | Futures | 70.19 | 70.74 | 69.95 | 70.74 | 5452.0 |
| 2022-08-07 22:00:00 | CL | Futures | 70.73 | 70.91 | 70.49 | 70.77 | 3311.0 |
| 2022-08-07 23:00:00 | CL | Futures | 70.76 | 71.04 | 70.66 | 71.01 | 2351.0 |
| 2022-08-07 18:00:00 | GC | Futures | 2114.6 | 2116.7 | 2111.4 | 2114.2 | 1735.0 |
| 2022-08-07 19:00:00 | GC | Futures | 2114.1 | 2115.4 | 2114.0 | 2114.8 | 515.0 |
| 2022-08-07 20:00:00 | GC | Futures | 2114.8 | 2114.8 | 2110.8 | 2114.0 | 1895.0 |
| 2022-08-07 21:00:00 | GC | Futures | 2114.4 | 2115.9 | 2113.4 | 2115.3 | 1738.0 |
| 2022-08-07 22:00:00 | GC | Futures | 2115.4 | 2115.5 | 2113.7 | 2113.8 | 1467.0 |
| 2022-08-07 23:00:00 | GC | Futures | 2113.8 | 2113.8 | 2111.5 | 2113.2 | 1418.0 |
| 2022-08-07 18:00:00 | ZN | Futures | 123.07533 | 123.188154 | 123.026976 | 123.139801 | 9035.0 |
| 2022-08-07 19:00:00 | ZN | Futures | 123.139801 | 123.236507 | 123.123683 | 123.204272 | 6733.0 |
| 2022-08-07 20:00:00 | ZN | Futures | 123.204272 | 123.236507 | 123.043094 | 123.22039 | 17766.0 |
| 2022-08-07 21:00:00 | ZN | Futures | 123.22039 | 123.300979 | 123.188154 | 123.204272 | 9607.0 |
| 2022-08-07 22:00:00 | ZN | Futures | 123.204272 | 123.252625 | 123.188154 | 123.22039 | 5572.0 |
| 2022-08-07 23:00:00 | ZN | Futures | 123.22039 | 123.333214 | 123.204272 | 123.317096 | 8621.0 |
> showing 36 of 417 rows — these rows as CSV