PREVIEW / futures_1hour / 2022-12-19
file: by_date/futures_1hour/2022/2022-12-19.parquet size: 67 KB rows: 2,034
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-19 00:00:00 | ES | Futures | 4344.53 | 4345.09 | 4335.02 | 4340.05 | 6111.0 |
| 2022-12-19 01:00:00 | ES | Futures | 4340.05 | 4347.88 | 4339.49 | 4347.6 | 5391.0 |
| 2022-12-19 02:00:00 | ES | Futures | 4347.88 | 4349.0 | 4342.85 | 4345.09 | 6717.0 |
| 2022-12-19 03:00:00 | ES | Futures | 4345.09 | 4360.46 | 4343.97 | 4354.31 | 20365.0 |
| 2022-12-19 04:00:00 | ES | Futures | 4354.03 | 4359.63 | 4349.56 | 4350.12 | 11705.0 |
| 2022-12-19 05:00:00 | ES | Futures | 4350.4 | 4360.74 | 4349.28 | 4355.71 | 9420.0 |
| 2022-12-19 06:00:00 | ES | Futures | 4355.71 | 4356.27 | 4345.92 | 4350.96 | 11189.0 |
| 2022-12-19 07:00:00 | ES | Futures | 4350.96 | 4354.87 | 4347.04 | 4351.24 | 15469.0 |
| 2022-12-19 08:00:00 | ES | Futures | 4351.24 | 4353.19 | 4338.1 | 4338.65 | 20230.0 |
| 2022-12-19 09:00:00 | ES | Futures | 4338.93 | 4343.69 | 4321.04 | 4326.91 | 140866.0 |
| 2022-12-19 10:00:00 | ES | Futures | 4327.19 | 4341.45 | 4318.52 | 4319.36 | 185974.0 |
| 2022-12-19 11:00:00 | ES | Futures | 4319.36 | 4321.88 | 4304.54 | 4310.69 | 156350.0 |
| 2022-12-19 12:00:00 | ES | Futures | 4310.69 | 4320.2 | 4308.46 | 4315.73 | 101323.0 |
| 2022-12-19 13:00:00 | ES | Futures | 4316.01 | 4319.92 | 4297.83 | 4298.67 | 106233.0 |
| 2022-12-19 14:00:00 | ES | Futures | 4298.67 | 4299.51 | 4280.78 | 4285.53 | 165541.0 |
| 2022-12-19 15:00:00 | ES | Futures | 4285.53 | 4304.26 | 4280.5 | 4299.51 | 258340.0 |
| 2022-12-19 16:00:00 | ES | Futures | 4299.51 | 4301.19 | 4293.92 | 4296.71 | 60698.0 |
| 2022-12-19 18:00:00 | ES | Futures | 4297.83 | 4309.02 | 4296.99 | 4307.06 | 8517.0 |
| 2022-12-19 19:00:00 | ES | Futures | 4306.78 | 4309.3 | 4303.7 | 4308.18 | 6377.0 |
| 2022-12-19 20:00:00 | ES | Futures | 4308.18 | 4311.25 | 4306.22 | 4310.14 | 7986.0 |
| 2022-12-19 21:00:00 | ES | Futures | 4310.41 | 4311.25 | 4305.38 | 4308.18 | 5980.0 |
| 2022-12-19 22:00:00 | ES | Futures | 4308.18 | 4309.3 | 4264.0 | 4267.91 | 59878.0 |
| 2022-12-19 23:00:00 | ES | Futures | 4267.63 | 4270.15 | 4257.85 | 4265.12 | 23165.0 |
| 2022-12-19 00:00:00 | NQ | Futures | 12932.25 | 12934.24 | 12895.83 | 12912.05 | 3691.0 |
| 2022-12-19 01:00:00 | NQ | Futures | 12911.48 | 12937.37 | 12910.34 | 12937.37 | 2599.0 |
| 2022-12-19 02:00:00 | NQ | Futures | 12937.65 | 12943.34 | 12916.88 | 12920.3 | 3830.0 |
| 2022-12-19 03:00:00 | NQ | Futures | 12920.87 | 12979.47 | 12916.31 | 12965.53 | 9899.0 |
| 2022-12-19 04:00:00 | NQ | Futures | 12964.96 | 12977.48 | 12943.63 | 12946.76 | 6781.0 |
| 2022-12-19 05:00:00 | NQ | Futures | 12947.32 | 12985.45 | 12947.04 | 12973.21 | 5335.0 |
| 2022-12-19 06:00:00 | NQ | Futures | 12973.5 | 12975.77 | 12944.48 | 12961.83 | 5145.0 |
| 2022-12-19 07:00:00 | NQ | Futures | 12960.7 | 12972.36 | 12946.76 | 12961.83 | 5239.0 |
| 2022-12-19 08:00:00 | NQ | Futures | 12962.12 | 12968.66 | 12914.61 | 12922.86 | 10425.0 |
| 2022-12-19 09:00:00 | NQ | Futures | 12923.14 | 12942.77 | 12807.07 | 12823.57 | 71138.0 |
| 2022-12-19 10:00:00 | NQ | Futures | 12824.14 | 12870.23 | 12779.76 | 12785.73 | 94727.0 |
| 2022-12-19 11:00:00 | NQ | Futures | 12785.73 | 12790.0 | 12723.14 | 12754.44 | 69732.0 |
| 2022-12-19 12:00:00 | NQ | Futures | 12754.44 | 12800.24 | 12753.02 | 12781.18 | 45816.0 |
| 2022-12-19 13:00:00 | NQ | Futures | 12781.75 | 12808.49 | 12733.95 | 12736.51 | 48866.0 |
| 2022-12-19 14:00:00 | NQ | Futures | 12736.23 | 12738.22 | 12689.57 | 12703.23 | 61984.0 |
| 2022-12-19 15:00:00 | NQ | Futures | 12703.8 | 12750.17 | 12667.67 | 12731.39 | 75228.0 |
| 2022-12-19 16:00:00 | NQ | Futures | 12731.39 | 12742.2 | 12720.3 | 12728.26 | 15792.0 |
| 2022-12-19 18:00:00 | NQ | Futures | 12725.42 | 12768.95 | 12725.42 | 12760.98 | 4162.0 |
| 2022-12-19 19:00:00 | NQ | Futures | 12760.41 | 12770.37 | 12752.73 | 12767.24 | 3057.0 |
| 2022-12-19 20:00:00 | NQ | Futures | 12766.96 | 12777.77 | 12759.56 | 12772.93 | 3004.0 |
| 2022-12-19 21:00:00 | NQ | Futures | 12772.65 | 12776.34 | 12754.44 | 12762.97 | 2647.0 |
| 2022-12-19 22:00:00 | NQ | Futures | 12762.97 | 12766.67 | 12604.22 | 12618.73 | 24574.0 |
| 2022-12-19 23:00:00 | NQ | Futures | 12618.45 | 12625.56 | 12578.05 | 12607.07 | 10247.0 |
| 2022-12-19 00:00:00 | YM | Futures | 36942.9 | 36947.4 | 36883.9 | 36930.7 | 1190.0 |
| 2022-12-19 01:00:00 | YM | Futures | 36926.2 | 36983.0 | 36924.0 | 36983.0 | 1116.0 |
| 2022-12-19 02:00:00 | YM | Futures | 36984.2 | 36987.5 | 36953.0 | 36977.5 | 1089.0 |
| 2022-12-19 03:00:00 | YM | Futures | 36974.1 | 37078.9 | 36963.0 | 37024.3 | 3459.0 |
> showing 50 of 2,034 rows — these rows as CSV