PREVIEW / futures_1hour / 2022-06-22
file: by_date/futures_1hour/2022/2022-06-22.parquet size: 70 KB rows: 2,082
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-22 00:00:00 | ES | Futures | 4229.24 | 4232.08 | 4224.71 | 4230.94 | 5416.0 |
| 2022-06-22 01:00:00 | ES | Futures | 4231.23 | 4236.33 | 4216.21 | 4217.91 | 11451.0 |
| 2022-06-22 02:00:00 | ES | Futures | 4217.91 | 4223.29 | 4210.55 | 4217.91 | 17633.0 |
| 2022-06-22 03:00:00 | ES | Futures | 4217.63 | 4218.48 | 4188.17 | 4191.0 | 38381.0 |
| 2022-06-22 04:00:00 | ES | Futures | 4191.28 | 4199.5 | 4184.77 | 4196.67 | 22784.0 |
| 2022-06-22 05:00:00 | ES | Futures | 4196.95 | 4206.58 | 4194.97 | 4204.6 | 13861.0 |
| 2022-06-22 06:00:00 | ES | Futures | 4204.32 | 4213.1 | 4202.62 | 4207.43 | 17208.0 |
| 2022-06-22 07:00:00 | ES | Futures | 4207.71 | 4220.46 | 4207.71 | 4209.7 | 19374.0 |
| 2022-06-22 08:00:00 | ES | Futures | 4209.98 | 4212.53 | 4196.38 | 4210.83 | 33678.0 |
| 2022-06-22 09:00:00 | ES | Futures | 4210.55 | 4263.24 | 4200.07 | 4252.47 | 234268.0 |
| 2022-06-22 10:00:00 | ES | Futures | 4252.19 | 4303.18 | 4243.69 | 4289.58 | 253846.0 |
| 2022-06-22 11:00:00 | ES | Futures | 4289.58 | 4300.06 | 4264.37 | 4265.5 | 209113.0 |
| 2022-06-22 12:00:00 | ES | Futures | 4265.5 | 4286.46 | 4258.99 | 4285.9 | 130336.0 |
| 2022-06-22 13:00:00 | ES | Futures | 4285.61 | 4296.95 | 4274.85 | 4293.26 | 106178.0 |
| 2022-06-22 14:00:00 | ES | Futures | 4293.26 | 4311.96 | 4286.18 | 4294.96 | 134287.0 |
| 2022-06-22 15:00:00 | ES | Futures | 4294.96 | 4298.93 | 4259.55 | 4261.25 | 240603.0 |
| 2022-06-22 16:00:00 | ES | Futures | 4261.25 | 4269.47 | 4259.27 | 4260.69 | 65524.0 |
| 2022-06-22 18:00:00 | ES | Futures | 4261.82 | 4264.37 | 4253.32 | 4257.29 | 5765.0 |
| 2022-06-22 19:00:00 | ES | Futures | 4257.0 | 4257.57 | 4235.19 | 4242.84 | 10649.0 |
| 2022-06-22 20:00:00 | ES | Futures | 4242.56 | 4275.98 | 4241.71 | 4269.18 | 18816.0 |
| 2022-06-22 21:00:00 | ES | Futures | 4268.9 | 4272.58 | 4243.41 | 4244.54 | 18827.0 |
| 2022-06-22 22:00:00 | ES | Futures | 4244.82 | 4256.72 | 4238.31 | 4250.77 | 12854.0 |
| 2022-06-22 23:00:00 | ES | Futures | 4250.77 | 4258.42 | 4247.37 | 4250.49 | 7167.0 |
| 2022-06-22 00:00:00 | NQ | Futures | 13264.79 | 13280.99 | 13249.75 | 13272.6 | 3521.0 |
| 2022-06-22 01:00:00 | NQ | Futures | 13272.6 | 13290.82 | 13213.89 | 13221.7 | 6035.0 |
| 2022-06-22 02:00:00 | NQ | Futures | 13222.85 | 13243.1 | 13202.32 | 13227.19 | 7289.0 |
| 2022-06-22 03:00:00 | NQ | Futures | 13225.74 | 13227.77 | 13112.36 | 13120.75 | 19033.0 |
| 2022-06-22 04:00:00 | NQ | Futures | 13121.62 | 13148.81 | 13097.32 | 13136.66 | 12825.0 |
| 2022-06-22 05:00:00 | NQ | Futures | 13135.79 | 13169.34 | 13132.9 | 13163.27 | 8315.0 |
| 2022-06-22 06:00:00 | NQ | Futures | 13164.43 | 13188.14 | 13159.22 | 13170.5 | 7445.0 |
| 2022-06-22 07:00:00 | NQ | Futures | 13171.08 | 13222.27 | 13171.08 | 13188.14 | 10387.0 |
| 2022-06-22 08:00:00 | NQ | Futures | 13188.43 | 13210.42 | 13148.81 | 13208.97 | 18638.0 |
| 2022-06-22 09:00:00 | NQ | Futures | 13208.39 | 13442.67 | 13176.0 | 13411.15 | 105634.0 |
| 2022-06-22 10:00:00 | NQ | Futures | 13411.44 | 13589.32 | 13372.39 | 13532.63 | 101682.0 |
| 2022-06-22 11:00:00 | NQ | Futures | 13533.5 | 13554.9 | 13401.02 | 13405.94 | 74169.0 |
| 2022-06-22 12:00:00 | NQ | Futures | 13406.23 | 13487.51 | 13382.51 | 13482.01 | 55265.0 |
| 2022-06-22 13:00:00 | NQ | Futures | 13481.43 | 13515.56 | 13441.81 | 13489.24 | 39193.0 |
| 2022-06-22 14:00:00 | NQ | Futures | 13489.82 | 13557.21 | 13468.71 | 13500.81 | 46926.0 |
| 2022-06-22 15:00:00 | NQ | Futures | 13501.68 | 13515.56 | 13350.7 | 13372.39 | 65196.0 |
| 2022-06-22 16:00:00 | NQ | Futures | 13371.81 | 13384.83 | 13351.85 | 13356.77 | 15543.0 |
| 2022-06-22 18:00:00 | NQ | Futures | 13354.46 | 13371.23 | 13329.29 | 13341.15 | 3435.0 |
| 2022-06-22 19:00:00 | NQ | Futures | 13341.15 | 13341.73 | 13259.3 | 13289.09 | 6392.0 |
| 2022-06-22 20:00:00 | NQ | Futures | 13287.35 | 13426.19 | 13285.04 | 13404.49 | 9253.0 |
| 2022-06-22 21:00:00 | NQ | Futures | 13404.78 | 13414.04 | 13307.31 | 13314.54 | 9318.0 |
| 2022-06-22 22:00:00 | NQ | Futures | 13314.25 | 13361.11 | 13293.14 | 13339.7 | 7486.0 |
| 2022-06-22 23:00:00 | NQ | Futures | 13339.7 | 13366.89 | 13325.82 | 13336.23 | 3840.0 |
| 2022-06-22 00:00:00 | YM | Futures | 34142.5 | 34160.6 | 34115.5 | 34150.4 | 1421.0 |
| 2022-06-22 01:00:00 | YM | Futures | 34151.6 | 34186.6 | 34059.1 | 34069.2 | 2571.0 |
| 2022-06-22 02:00:00 | YM | Futures | 34068.1 | 34103.1 | 33989.1 | 34062.4 | 3948.0 |
| 2022-06-22 03:00:00 | YM | Futures | 34060.2 | 34066.9 | 33853.7 | 33893.2 | 10537.0 |
> showing 50 of 2,082 rows — these rows as CSV