PREVIEW / futures_1hour / 2022-06-16
file: by_date/futures_1hour/2022/2022-06-16.parquet size: 72 KB rows: 2,072
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-06-16 00:00:00 | ES | Futures | 4316.49 | 4319.04 | 4304.59 | 4305.16 | 9225.0 |
| 2022-06-16 01:00:00 | ES | Futures | 4305.16 | 4306.86 | 4281.08 | 4281.37 | 16244.0 |
| 2022-06-16 02:00:00 | ES | Futures | 4281.08 | 4289.3 | 4251.34 | 4258.7 | 27469.0 |
| 2022-06-16 03:00:00 | ES | Futures | 4258.42 | 4263.8 | 4206.3 | 4217.06 | 58720.0 |
| 2022-06-16 04:00:00 | ES | Futures | 4217.06 | 4229.24 | 4200.63 | 4201.2 | 37607.0 |
| 2022-06-16 05:00:00 | ES | Futures | 4201.2 | 4207.43 | 4186.75 | 4205.17 | 40416.0 |
| 2022-06-16 06:00:00 | ES | Futures | 4205.73 | 4214.51 | 4192.98 | 4196.1 | 29015.0 |
| 2022-06-16 07:00:00 | ES | Futures | 4196.1 | 4209.41 | 4191.85 | 4203.18 | 39638.0 |
| 2022-06-16 08:00:00 | ES | Futures | 4202.9 | 4230.09 | 4200.92 | 4210.83 | 61402.0 |
| 2022-06-16 09:00:00 | ES | Futures | 4210.55 | 4217.35 | 4172.87 | 4181.09 | 272333.0 |
| 2022-06-16 10:00:00 | ES | Futures | 4181.09 | 4184.77 | 4145.68 | 4148.79 | 314706.0 |
| 2022-06-16 11:00:00 | ES | Futures | 4148.79 | 4180.52 | 4147.66 | 4170.04 | 203788.0 |
| 2022-06-16 12:00:00 | ES | Futures | 4169.76 | 4172.87 | 4151.63 | 4167.77 | 150515.0 |
| 2022-06-16 13:00:00 | ES | Futures | 4167.77 | 4182.22 | 4146.53 | 4146.53 | 198925.0 |
| 2022-06-16 14:00:00 | ES | Futures | 4146.53 | 4153.04 | 4126.7 | 4135.2 | 189818.0 |
| 2022-06-16 15:00:00 | ES | Futures | 4134.91 | 4165.22 | 4132.93 | 4162.39 | 415699.0 |
| 2022-06-16 16:00:00 | ES | Futures | 4162.67 | 4171.74 | 4153.04 | 4169.76 | 96805.0 |
| 2022-06-16 18:00:00 | ES | Futures | 4170.32 | 4176.55 | 4165.79 | 4167.21 | 9119.0 |
| 2022-06-16 19:00:00 | ES | Futures | 4167.49 | 4170.89 | 4158.14 | 4166.92 | 8902.0 |
| 2022-06-16 20:00:00 | ES | Futures | 4166.92 | 4178.54 | 4156.73 | 4170.04 | 16510.0 |
| 2022-06-16 21:00:00 | ES | Futures | 4169.76 | 4186.47 | 4167.21 | 4185.05 | 11946.0 |
| 2022-06-16 22:00:00 | ES | Futures | 4184.77 | 4192.42 | 4175.99 | 4179.39 | 13827.0 |
| 2022-06-16 23:00:00 | ES | Futures | 4179.39 | 4190.72 | 4175.14 | 4180.24 | 10737.0 |
| 2022-06-16 00:00:00 | NQ | Futures | 13518.45 | 13526.26 | 13466.97 | 13470.15 | 4604.0 |
| 2022-06-16 01:00:00 | NQ | Futures | 13470.44 | 13476.51 | 13384.54 | 13388.3 | 8420.0 |
| 2022-06-16 02:00:00 | NQ | Futures | 13387.14 | 13417.8 | 13268.84 | 13285.91 | 14481.0 |
| 2022-06-16 03:00:00 | NQ | Futures | 13284.46 | 13303.55 | 13100.79 | 13161.24 | 28795.0 |
| 2022-06-16 04:00:00 | NQ | Futures | 13161.53 | 13186.99 | 13069.84 | 13070.71 | 20607.0 |
| 2022-06-16 05:00:00 | NQ | Futures | 13069.84 | 13108.31 | 13037.16 | 13101.37 | 17432.0 |
| 2022-06-16 06:00:00 | NQ | Futures | 13102.53 | 13136.08 | 13063.19 | 13080.26 | 14392.0 |
| 2022-06-16 07:00:00 | NQ | Futures | 13079.68 | 13123.93 | 13055.09 | 13099.93 | 16947.0 |
| 2022-06-16 08:00:00 | NQ | Futures | 13099.35 | 13217.94 | 13093.56 | 13140.13 | 31373.0 |
| 2022-06-16 09:00:00 | NQ | Futures | 13140.42 | 13160.38 | 13018.94 | 13035.14 | 87671.0 |
| 2022-06-16 10:00:00 | NQ | Futures | 13035.71 | 13035.71 | 12875.48 | 12891.67 | 110791.0 |
| 2022-06-16 11:00:00 | NQ | Futures | 12892.25 | 13004.19 | 12887.05 | 12948.36 | 74581.0 |
| 2022-06-16 12:00:00 | NQ | Futures | 12948.36 | 12974.11 | 12892.25 | 12951.84 | 56486.0 |
| 2022-06-16 13:00:00 | NQ | Futures | 12953.28 | 12998.11 | 12856.96 | 12858.12 | 63961.0 |
| 2022-06-16 14:00:00 | NQ | Futures | 12858.41 | 12886.18 | 12805.77 | 12838.16 | 65016.0 |
| 2022-06-16 15:00:00 | NQ | Futures | 12837.59 | 12936.22 | 12830.93 | 12918.57 | 112562.0 |
| 2022-06-16 16:00:00 | NQ | Futures | 12919.15 | 12968.03 | 12894.28 | 12962.83 | 28520.0 |
| 2022-06-16 18:00:00 | NQ | Futures | 12965.72 | 12990.3 | 12943.16 | 12943.16 | 5471.0 |
| 2022-06-16 19:00:00 | NQ | Futures | 12944.03 | 12960.8 | 12916.26 | 12950.39 | 4626.0 |
| 2022-06-16 20:00:00 | NQ | Futures | 12948.65 | 12992.62 | 12914.52 | 12959.93 | 7890.0 |
| 2022-06-16 21:00:00 | NQ | Futures | 12959.36 | 13015.47 | 12951.55 | 13007.66 | 6263.0 |
| 2022-06-16 22:00:00 | NQ | Futures | 13007.66 | 13037.45 | 12977.29 | 12993.2 | 6769.0 |
| 2022-06-16 23:00:00 | NQ | Futures | 12994.93 | 13026.46 | 12977.87 | 12989.15 | 4737.0 |
| 2022-06-16 00:00:00 | YM | Futures | 34725.9 | 34739.4 | 34649.2 | 34653.7 | 1248.0 |
| 2022-06-16 01:00:00 | YM | Futures | 34650.3 | 34661.6 | 34484.4 | 34486.7 | 2884.0 |
| 2022-06-16 02:00:00 | YM | Futures | 34486.7 | 34539.7 | 34282.5 | 34352.4 | 4705.0 |
| 2022-06-16 03:00:00 | YM | Futures | 34349.0 | 34382.9 | 33950.7 | 34034.2 | 11471.0 |
> showing 50 of 2,072 rows — these rows as CSV