PREVIEW / futures_1hour / 2022-12-18
file: by_date/futures_1hour/2022/2022-12-18.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-12-18 18:00:00 | ES | Futures | 4332.78 | 4347.04 | 4331.39 | 4340.05 | 16109.0 |
| 2022-12-18 19:00:00 | ES | Futures | 4340.05 | 4345.65 | 4339.77 | 4342.85 | 9818.0 |
| 2022-12-18 20:00:00 | ES | Futures | 4342.85 | 4349.84 | 4341.73 | 4346.2 | 9191.0 |
| 2022-12-18 21:00:00 | ES | Futures | 4346.2 | 4347.88 | 4342.29 | 4345.09 | 5810.0 |
| 2022-12-18 22:00:00 | ES | Futures | 4345.09 | 4347.32 | 4343.41 | 4345.37 | 2928.0 |
| 2022-12-18 23:00:00 | ES | Futures | 4345.37 | 4347.32 | 4344.25 | 4344.53 | 2573.0 |
| 2022-12-18 18:00:00 | NQ | Futures | 12891.85 | 12934.52 | 12882.46 | 12918.88 | 5231.0 |
| 2022-12-18 19:00:00 | NQ | Futures | 12919.16 | 12939.93 | 12918.88 | 12928.83 | 3600.0 |
| 2022-12-18 20:00:00 | NQ | Futures | 12929.12 | 12954.15 | 12925.99 | 12941.92 | 4092.0 |
| 2022-12-18 21:00:00 | NQ | Futures | 12941.35 | 12949.32 | 12931.39 | 12939.93 | 2781.0 |
| 2022-12-18 22:00:00 | NQ | Futures | 12938.79 | 12949.32 | 12933.38 | 12937.65 | 1628.0 |
| 2022-12-18 23:00:00 | NQ | Futures | 12938.22 | 12945.33 | 12930.26 | 12931.96 | 1878.0 |
| 2022-12-18 18:00:00 | YM | Futures | 36885.0 | 36966.3 | 36867.2 | 36907.3 | 2425.0 |
| 2022-12-18 19:00:00 | YM | Futures | 36908.4 | 36953.0 | 36906.2 | 36936.2 | 1212.0 |
| 2022-12-18 20:00:00 | YM | Futures | 36935.1 | 36977.5 | 36927.3 | 36951.8 | 1793.0 |
| 2022-12-18 21:00:00 | YM | Futures | 36950.7 | 36966.3 | 36926.2 | 36951.8 | 991.0 |
| 2022-12-18 22:00:00 | YM | Futures | 36951.8 | 36965.2 | 36926.2 | 36945.2 | 1004.0 |
| 2022-12-18 23:00:00 | YM | Futures | 36945.2 | 36958.5 | 36937.4 | 36944.0 | 462.0 |
| 2022-12-18 18:00:00 | CL | Futures | 61.07 | 61.5 | 60.87 | 61.47 | 2704.0 |
| 2022-12-18 19:00:00 | CL | Futures | 61.48 | 61.67 | 61.31 | 61.45 | 2022.0 |
| 2022-12-18 20:00:00 | CL | Futures | 61.45 | 62.15 | 61.36 | 61.93 | 5184.0 |
| 2022-12-18 21:00:00 | CL | Futures | 61.92 | 62.03 | 61.68 | 61.81 | 1828.0 |
| 2022-12-18 22:00:00 | CL | Futures | 61.81 | 61.83 | 61.62 | 61.63 | 1223.0 |
| 2022-12-18 23:00:00 | CL | Futures | 61.62 | 61.66 | 61.53 | 61.58 | 932.0 |
| 2022-12-18 18:00:00 | GC | Futures | 2110.2 | 2112.3 | 2108.8 | 2108.9 | 1847.0 |
| 2022-12-18 19:00:00 | GC | Futures | 2109.0 | 2113.7 | 2108.4 | 2111.6 | 2662.0 |
| 2022-12-18 20:00:00 | GC | Futures | 2111.7 | 2114.1 | 2110.8 | 2113.0 | 2913.0 |
| 2022-12-18 21:00:00 | GC | Futures | 2112.9 | 2114.9 | 2112.3 | 2113.5 | 2753.0 |
| 2022-12-18 22:00:00 | GC | Futures | 2113.5 | 2116.5 | 2111.0 | 2112.6 | 3017.0 |
| 2022-12-18 23:00:00 | GC | Futures | 2112.8 | 2113.7 | 2111.2 | 2111.7 | 1090.0 |
| 2022-12-18 18:00:00 | ZN | Futures | 118.159428 | 118.175524 | 117.99847 | 118.014566 | 16360.0 |
| 2022-12-18 19:00:00 | ZN | Futures | 118.014566 | 118.143333 | 118.014566 | 118.062854 | 8229.0 |
| 2022-12-18 20:00:00 | ZN | Futures | 118.046758 | 118.062854 | 117.966279 | 118.046758 | 9665.0 |
| 2022-12-18 21:00:00 | ZN | Futures | 118.046758 | 118.062854 | 117.982374 | 117.982374 | 8007.0 |
| 2022-12-18 22:00:00 | ZN | Futures | 117.982374 | 118.078949 | 117.966279 | 118.046758 | 6306.0 |
| 2022-12-18 23:00:00 | ZN | Futures | 118.046758 | 118.095045 | 118.030662 | 118.030662 | 4331.0 |
> showing 36 of 423 rows — these rows as CSV