PREVIEW / futures_1hour / 2022-11-01
file: by_date/futures_1hour/2022/2022-11-01.parquet size: 70 KB rows: 2,099
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-11-01 00:00:00 | ES | Futures | 4394.72 | 4395.85 | 4390.49 | 4393.59 | 4086.0 |
| 2022-11-01 01:00:00 | ES | Futures | 4393.31 | 4405.43 | 4393.03 | 4401.49 | 11682.0 |
| 2022-11-01 02:00:00 | ES | Futures | 4401.49 | 4407.69 | 4401.49 | 4406.84 | 9679.0 |
| 2022-11-01 03:00:00 | ES | Futures | 4406.84 | 4410.51 | 4395.57 | 4403.18 | 21217.0 |
| 2022-11-01 04:00:00 | ES | Futures | 4403.46 | 4418.12 | 4402.61 | 4411.63 | 31489.0 |
| 2022-11-01 05:00:00 | ES | Futures | 4411.63 | 4416.43 | 4405.71 | 4415.58 | 18662.0 |
| 2022-11-01 06:00:00 | ES | Futures | 4415.58 | 4422.35 | 4412.2 | 4418.96 | 17508.0 |
| 2022-11-01 07:00:00 | ES | Futures | 4419.25 | 4422.63 | 4414.17 | 4420.37 | 22931.0 |
| 2022-11-01 08:00:00 | ES | Futures | 4420.37 | 4429.11 | 4417.27 | 4425.17 | 46791.0 |
| 2022-11-01 09:00:00 | ES | Futures | 4424.88 | 4426.01 | 4394.72 | 4398.67 | 223229.0 |
| 2022-11-01 10:00:00 | ES | Futures | 4398.1 | 4402.05 | 4347.36 | 4352.16 | 392928.0 |
| 2022-11-01 11:00:00 | ES | Futures | 4352.16 | 4361.74 | 4343.98 | 4358.36 | 235263.0 |
| 2022-11-01 12:00:00 | ES | Futures | 4358.36 | 4375.27 | 4351.87 | 4360.89 | 216886.0 |
| 2022-11-01 13:00:00 | ES | Futures | 4360.89 | 4368.79 | 4355.26 | 4364.56 | 131408.0 |
| 2022-11-01 14:00:00 | ES | Futures | 4364.56 | 4369.91 | 4355.26 | 4367.66 | 109348.0 |
| 2022-11-01 15:00:00 | ES | Futures | 4367.94 | 4373.02 | 4357.51 | 4358.07 | 223402.0 |
| 2022-11-01 16:00:00 | ES | Futures | 4358.36 | 4362.59 | 4347.64 | 4354.41 | 62273.0 |
| 2022-11-01 18:00:00 | ES | Futures | 4355.82 | 4360.61 | 4354.69 | 4359.77 | 4586.0 |
| 2022-11-01 19:00:00 | ES | Futures | 4360.05 | 4362.87 | 4356.38 | 4358.36 | 5993.0 |
| 2022-11-01 20:00:00 | ES | Futures | 4358.64 | 4368.22 | 4354.13 | 4366.81 | 12131.0 |
| 2022-11-01 21:00:00 | ES | Futures | 4366.53 | 4372.17 | 4364.28 | 4369.35 | 8433.0 |
| 2022-11-01 22:00:00 | ES | Futures | 4369.63 | 4372.45 | 4364.84 | 4370.76 | 7079.0 |
| 2022-11-01 23:00:00 | ES | Futures | 4371.04 | 4373.86 | 4366.81 | 4369.63 | 7281.0 |
| 2022-11-01 00:00:00 | NQ | Futures | 13206.36 | 13209.23 | 13191.99 | 13199.75 | 1966.0 |
| 2022-11-01 01:00:00 | NQ | Futures | 13199.75 | 13245.72 | 13197.45 | 13237.97 | 4840.0 |
| 2022-11-01 02:00:00 | NQ | Futures | 13237.39 | 13264.69 | 13236.82 | 13261.81 | 4132.0 |
| 2022-11-01 03:00:00 | NQ | Futures | 13260.95 | 13273.59 | 13220.73 | 13246.01 | 8170.0 |
| 2022-11-01 04:00:00 | NQ | Futures | 13246.59 | 13302.33 | 13242.85 | 13279.92 | 12655.0 |
| 2022-11-01 05:00:00 | NQ | Futures | 13280.49 | 13300.89 | 13258.08 | 13297.15 | 8881.0 |
| 2022-11-01 06:00:00 | NQ | Futures | 13297.15 | 13324.16 | 13284.23 | 13312.1 | 8504.0 |
| 2022-11-01 07:00:00 | NQ | Futures | 13312.67 | 13325.89 | 13295.72 | 13314.97 | 7547.0 |
| 2022-11-01 08:00:00 | NQ | Futures | 13315.26 | 13348.59 | 13306.06 | 13335.08 | 16394.0 |
| 2022-11-01 09:00:00 | NQ | Futures | 13334.51 | 13353.76 | 13216.7 | 13231.93 | 80058.0 |
| 2022-11-01 10:00:00 | NQ | Futures | 13231.93 | 13248.88 | 13035.69 | 13053.5 | 132808.0 |
| 2022-11-01 11:00:00 | NQ | Futures | 13054.08 | 13098.04 | 13016.72 | 13060.97 | 70533.0 |
| 2022-11-01 12:00:00 | NQ | Futures | 13061.55 | 13114.99 | 13005.23 | 13050.63 | 64560.0 |
| 2022-11-01 13:00:00 | NQ | Futures | 13051.2 | 13073.04 | 13014.14 | 13046.03 | 40918.0 |
| 2022-11-01 14:00:00 | NQ | Futures | 13046.61 | 13074.19 | 13019.6 | 13067.01 | 38118.0 |
| 2022-11-01 15:00:00 | NQ | Futures | 13067.01 | 13079.07 | 13019.89 | 13021.61 | 54973.0 |
| 2022-11-01 16:00:00 | NQ | Futures | 13022.18 | 13033.39 | 12974.2 | 13010.69 | 22137.0 |
| 2022-11-01 18:00:00 | NQ | Futures | 13010.4 | 13037.41 | 13010.4 | 13033.68 | 3936.0 |
| 2022-11-01 19:00:00 | NQ | Futures | 13034.83 | 13043.16 | 13018.45 | 13024.2 | 2568.0 |
| 2022-11-01 20:00:00 | NQ | Futures | 13025.06 | 13067.87 | 13008.68 | 13062.41 | 6456.0 |
| 2022-11-01 21:00:00 | NQ | Futures | 13062.7 | 13077.06 | 13055.23 | 13065.57 | 3328.0 |
| 2022-11-01 22:00:00 | NQ | Futures | 13066.72 | 13078.5 | 13046.89 | 13071.32 | 3324.0 |
| 2022-11-01 23:00:00 | NQ | Futures | 13071.89 | 13083.96 | 13057.24 | 13069.88 | 3646.0 |
| 2022-11-01 00:00:00 | YM | Futures | 36905.8 | 36913.6 | 36875.5 | 36894.6 | 846.0 |
| 2022-11-01 01:00:00 | YM | Futures | 36893.4 | 36970.9 | 36893.4 | 36940.6 | 2345.0 |
| 2022-11-01 02:00:00 | YM | Futures | 36939.4 | 36975.4 | 36930.5 | 36958.5 | 1881.0 |
| 2022-11-01 03:00:00 | YM | Futures | 36957.4 | 36985.5 | 36881.1 | 36927.1 | 3914.0 |
> showing 50 of 2,099 rows — these rows as CSV