PREVIEW / futures_1hour / 2022-01-10
file: by_date/futures_1hour/2022/2022-01-10.parquet size: 67 KB rows: 2,038
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-01-10 00:00:00 | ES | Futures | 5287.83 | 5288.12 | 5283.59 | 5284.72 | 4124.0 |
| 2022-01-10 01:00:00 | ES | Futures | 5284.72 | 5287.83 | 5282.18 | 5286.42 | 4279.0 |
| 2022-01-10 02:00:00 | ES | Futures | 5286.7 | 5296.03 | 5286.7 | 5293.21 | 10042.0 |
| 2022-01-10 03:00:00 | ES | Futures | 5293.21 | 5294.9 | 5267.19 | 5277.65 | 33598.0 |
| 2022-01-10 04:00:00 | ES | Futures | 5277.94 | 5289.25 | 5276.24 | 5281.89 | 19790.0 |
| 2022-01-10 05:00:00 | ES | Futures | 5281.89 | 5289.25 | 5275.11 | 5277.65 | 12630.0 |
| 2022-01-10 06:00:00 | ES | Futures | 5277.37 | 5279.35 | 5267.47 | 5275.39 | 14155.0 |
| 2022-01-10 07:00:00 | ES | Futures | 5275.11 | 5277.09 | 5242.02 | 5242.59 | 45179.0 |
| 2022-01-10 08:00:00 | ES | Futures | 5242.59 | 5251.63 | 5240.89 | 5244.28 | 44179.0 |
| 2022-01-10 09:00:00 | ES | Futures | 5244.56 | 5248.81 | 5200.45 | 5204.41 | 305925.0 |
| 2022-01-10 10:00:00 | ES | Futures | 5204.41 | 5206.95 | 5172.73 | 5186.31 | 373693.0 |
| 2022-01-10 11:00:00 | ES | Futures | 5186.02 | 5213.74 | 5178.39 | 5205.54 | 251070.0 |
| 2022-01-10 12:00:00 | ES | Futures | 5205.54 | 5213.46 | 5188.29 | 5202.71 | 174666.0 |
| 2022-01-10 13:00:00 | ES | Futures | 5202.99 | 5236.36 | 5201.01 | 5232.97 | 218350.0 |
| 2022-01-10 14:00:00 | ES | Futures | 5232.97 | 5255.31 | 5229.86 | 5245.13 | 185096.0 |
| 2022-01-10 15:00:00 | ES | Futures | 5245.13 | 5277.09 | 5229.58 | 5273.98 | 323254.0 |
| 2022-01-10 16:00:00 | ES | Futures | 5274.26 | 5277.37 | 5271.43 | 5274.26 | 61622.0 |
| 2022-01-10 18:00:00 | ES | Futures | 5275.39 | 5281.33 | 5271.71 | 5277.09 | 10805.0 |
| 2022-01-10 19:00:00 | ES | Futures | 5277.09 | 5281.89 | 5268.6 | 5278.78 | 14340.0 |
| 2022-01-10 20:00:00 | ES | Futures | 5279.07 | 5279.63 | 5265.78 | 5268.6 | 13203.0 |
| 2022-01-10 21:00:00 | ES | Futures | 5268.6 | 5281.33 | 5267.47 | 5280.2 | 8826.0 |
| 2022-01-10 22:00:00 | ES | Futures | 5280.2 | 5281.05 | 5274.54 | 5275.96 | 5610.0 |
| 2022-01-10 23:00:00 | ES | Futures | 5275.96 | 5276.52 | 5268.89 | 5273.13 | 6217.0 |
| 2022-01-10 00:00:00 | NQ | Futures | 18132.41 | 18137.92 | 18111.83 | 18117.05 | 3320.0 |
| 2022-01-10 01:00:00 | NQ | Futures | 18118.5 | 18134.73 | 18105.46 | 18128.35 | 2752.0 |
| 2022-01-10 02:00:00 | NQ | Futures | 18128.06 | 18164.58 | 18119.66 | 18143.13 | 6126.0 |
| 2022-01-10 03:00:00 | NQ | Futures | 18143.71 | 18150.67 | 17991.56 | 18049.23 | 22561.0 |
| 2022-01-10 04:00:00 | NQ | Futures | 18049.81 | 18091.55 | 18042.28 | 18057.93 | 11147.0 |
| 2022-01-10 05:00:00 | NQ | Futures | 18058.22 | 18085.17 | 18001.41 | 18016.48 | 10026.0 |
| 2022-01-10 06:00:00 | NQ | Futures | 18015.9 | 18031.26 | 17968.66 | 18009.24 | 14189.0 |
| 2022-01-10 07:00:00 | NQ | Futures | 18008.66 | 18021.12 | 17815.93 | 17817.38 | 29115.0 |
| 2022-01-10 08:00:00 | NQ | Futures | 17817.96 | 17874.76 | 17810.13 | 17835.35 | 24184.0 |
| 2022-01-10 09:00:00 | NQ | Futures | 17835.93 | 17870.13 | 17669.28 | 17689.57 | 120547.0 |
| 2022-01-10 10:00:00 | NQ | Futures | 17689.57 | 17704.64 | 17565.82 | 17617.98 | 141869.0 |
| 2022-01-10 11:00:00 | NQ | Futures | 17616.83 | 17770.14 | 17594.51 | 17737.68 | 106319.0 |
| 2022-01-10 12:00:00 | NQ | Futures | 17736.81 | 17755.07 | 17625.23 | 17710.73 | 78981.0 |
| 2022-01-10 13:00:00 | NQ | Futures | 17711.31 | 17886.65 | 17699.71 | 17863.46 | 79549.0 |
| 2022-01-10 14:00:00 | NQ | Futures | 17863.46 | 17979.68 | 17856.21 | 17924.9 | 71304.0 |
| 2022-01-10 15:00:00 | NQ | Futures | 17924.9 | 18104.3 | 17857.95 | 18089.23 | 100045.0 |
| 2022-01-10 16:00:00 | NQ | Futures | 18088.94 | 18111.83 | 18075.9 | 18102.56 | 16967.0 |
| 2022-01-10 18:00:00 | NQ | Futures | 18110.38 | 18134.15 | 18085.75 | 18116.76 | 6279.0 |
| 2022-01-10 19:00:00 | NQ | Futures | 18116.76 | 18132.12 | 18079.37 | 18121.4 | 7692.0 |
| 2022-01-10 20:00:00 | NQ | Futures | 18121.98 | 18125.16 | 18053.87 | 18066.33 | 7715.0 |
| 2022-01-10 21:00:00 | NQ | Futures | 18066.33 | 18130.09 | 18061.69 | 18115.6 | 6618.0 |
| 2022-01-10 22:00:00 | NQ | Futures | 18115.02 | 18119.37 | 18086.62 | 18093.28 | 2611.0 |
| 2022-01-10 23:00:00 | NQ | Futures | 18093.57 | 18097.92 | 18064.3 | 18083.14 | 3819.0 |
| 2022-01-10 00:00:00 | YM | Futures | 40580.4 | 40583.8 | 40551.2 | 40564.7 | 880.0 |
| 2022-01-10 01:00:00 | YM | Futures | 40563.6 | 40574.8 | 40544.5 | 40571.4 | 817.0 |
| 2022-01-10 02:00:00 | YM | Futures | 40569.2 | 40647.9 | 40569.2 | 40636.6 | 2905.0 |
| 2022-01-10 03:00:00 | YM | Futures | 40636.6 | 40649.0 | 40498.4 | 40570.3 | 11015.0 |
> showing 50 of 2,038 rows — these rows as CSV