PREVIEW / futures_1hour / 2022-10-28
file: by_date/futures_1hour/2022/2022-10-28.parquet size: 59 KB rows: 1,683
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-10-28 00:00:00 | ES | Futures | 4289.57 | 4290.98 | 4281.96 | 4284.22 | 5155.0 |
| 2022-10-28 01:00:00 | ES | Futures | 4284.5 | 4284.5 | 4271.82 | 4274.35 | 12290.0 |
| 2022-10-28 02:00:00 | ES | Futures | 4274.35 | 4277.45 | 4264.2 | 4266.46 | 18606.0 |
| 2022-10-28 03:00:00 | ES | Futures | 4266.74 | 4274.92 | 4258.57 | 4264.49 | 34350.0 |
| 2022-10-28 04:00:00 | ES | Futures | 4264.77 | 4279.14 | 4260.82 | 4275.48 | 19255.0 |
| 2022-10-28 05:00:00 | ES | Futures | 4275.48 | 4281.12 | 4267.02 | 4280.55 | 22883.0 |
| 2022-10-28 06:00:00 | ES | Futures | 4280.55 | 4283.94 | 4274.63 | 4281.12 | 13426.0 |
| 2022-10-28 07:00:00 | ES | Futures | 4281.12 | 4290.98 | 4274.07 | 4284.22 | 24934.0 |
| 2022-10-28 08:00:00 | ES | Futures | 4284.5 | 4316.35 | 4270.12 | 4291.83 | 128401.0 |
| 2022-10-28 09:00:00 | ES | Futures | 4291.55 | 4345.67 | 4288.45 | 4336.65 | 275255.0 |
| 2022-10-28 10:00:00 | ES | Futures | 4336.65 | 4373.86 | 4318.05 | 4372.45 | 323757.0 |
| 2022-10-28 11:00:00 | ES | Futures | 4372.45 | 4378.94 | 4362.87 | 4373.02 | 213877.0 |
| 2022-10-28 12:00:00 | ES | Futures | 4373.02 | 4391.9 | 4364.56 | 4388.8 | 185850.0 |
| 2022-10-28 13:00:00 | ES | Futures | 4389.08 | 4399.8 | 4387.67 | 4393.31 | 125643.0 |
| 2022-10-28 14:00:00 | ES | Futures | 4393.31 | 4410.79 | 4389.37 | 4408.25 | 138270.0 |
| 2022-10-28 15:00:00 | ES | Futures | 4408.53 | 4416.15 | 4402.05 | 4409.66 | 280818.0 |
| 2022-10-28 16:00:00 | ES | Futures | 4409.66 | 4424.88 | 4408.53 | 4423.47 | 94903.0 |
| 2022-10-28 00:00:00 | NQ | Futures | 12825.65 | 12829.96 | 12797.21 | 12810.14 | 3286.0 |
| 2022-10-28 01:00:00 | NQ | Futures | 12810.42 | 12811.29 | 12760.43 | 12771.92 | 8789.0 |
| 2022-10-28 02:00:00 | NQ | Futures | 12772.5 | 12785.43 | 12737.44 | 12747.5 | 9980.0 |
| 2022-10-28 03:00:00 | NQ | Futures | 12748.94 | 12785.43 | 12713.6 | 12731.7 | 16991.0 |
| 2022-10-28 04:00:00 | NQ | Futures | 12730.84 | 12781.12 | 12719.92 | 12768.48 | 9914.0 |
| 2022-10-28 05:00:00 | NQ | Futures | 12768.76 | 12779.11 | 12729.4 | 12775.95 | 10447.0 |
| 2022-10-28 06:00:00 | NQ | Futures | 12777.09 | 12791.17 | 12759.57 | 12779.39 | 7431.0 |
| 2022-10-28 07:00:00 | NQ | Futures | 12779.39 | 12819.04 | 12758.13 | 12791.17 | 12326.0 |
| 2022-10-28 08:00:00 | NQ | Futures | 12792.04 | 12894.9 | 12721.64 | 12815.88 | 47869.0 |
| 2022-10-28 09:00:00 | NQ | Futures | 12815.02 | 13060.97 | 12799.79 | 13010.69 | 112495.0 |
| 2022-10-28 10:00:00 | NQ | Futures | 13010.69 | 13184.52 | 12938.0 | 13172.74 | 121935.0 |
| 2022-10-28 11:00:00 | NQ | Futures | 13172.74 | 13213.83 | 13148.61 | 13171.31 | 68499.0 |
| 2022-10-28 12:00:00 | NQ | Futures | 13170.44 | 13253.19 | 13142.29 | 13238.25 | 63447.0 |
| 2022-10-28 13:00:00 | NQ | Futures | 13238.54 | 13279.63 | 13231.64 | 13249.75 | 39627.0 |
| 2022-10-28 14:00:00 | NQ | Futures | 13249.75 | 13314.68 | 13233.66 | 13304.05 | 46394.0 |
| 2022-10-28 15:00:00 | NQ | Futures | 13304.63 | 13338.24 | 13272.16 | 13314.11 | 73588.0 |
| 2022-10-28 16:00:00 | NQ | Futures | 13314.39 | 13361.8 | 13311.23 | 13361.23 | 20958.0 |
| 2022-10-28 00:00:00 | YM | Futures | 36030.4 | 36040.5 | 35971.0 | 35986.7 | 1236.0 |
| 2022-10-28 01:00:00 | YM | Futures | 35986.7 | 35986.7 | 35891.3 | 35904.7 | 2858.0 |
| 2022-10-28 02:00:00 | YM | Futures | 35905.9 | 35927.2 | 35803.7 | 35838.5 | 4529.0 |
| 2022-10-28 03:00:00 | YM | Futures | 35839.7 | 35894.6 | 35781.3 | 35829.6 | 6170.0 |
| 2022-10-28 04:00:00 | YM | Futures | 35827.3 | 35935.0 | 35801.5 | 35908.1 | 3761.0 |
| 2022-10-28 05:00:00 | YM | Futures | 35907.0 | 35964.2 | 35856.5 | 35956.4 | 4404.0 |
| 2022-10-28 06:00:00 | YM | Futures | 35957.5 | 35969.8 | 35905.9 | 35949.6 | 2767.0 |
| 2022-10-28 07:00:00 | YM | Futures | 35949.6 | 36034.9 | 35908.1 | 35975.4 | 4411.0 |
| 2022-10-28 08:00:00 | YM | Futures | 35974.3 | 36239.2 | 35890.2 | 36040.5 | 14556.0 |
| 2022-10-28 09:00:00 | YM | Futures | 36040.5 | 36490.5 | 36020.3 | 36422.1 | 39150.0 |
| 2022-10-28 10:00:00 | YM | Futures | 36425.5 | 36660.0 | 36286.3 | 36657.8 | 38411.0 |
| 2022-10-28 11:00:00 | YM | Futures | 36658.9 | 36715.0 | 36588.2 | 36678.0 | 21947.0 |
| 2022-10-28 12:00:00 | YM | Futures | 36678.0 | 36800.3 | 36602.8 | 36775.6 | 17172.0 |
| 2022-10-28 13:00:00 | YM | Futures | 36775.6 | 36877.7 | 36768.9 | 36816.0 | 13419.0 |
| 2022-10-28 14:00:00 | YM | Futures | 36817.1 | 36920.4 | 36790.2 | 36895.7 | 13012.0 |
| 2022-10-28 15:00:00 | YM | Futures | 36897.9 | 36950.7 | 36860.9 | 36912.5 | 20280.0 |
> showing 50 of 1,683 rows — these rows as CSV