PREVIEW / futures_1hour / 2022-10-03
file: by_date/futures_1hour/2022/2022-10-03.parquet size: 72 KB rows: 2,100
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-03 00:00:00 | ES | Futures | 4058.7 | 4061.24 | 4050.53 | 4054.48 | 7902.0 |
| 2022-10-03 01:00:00 | ES | Futures | 4054.19 | 4072.8 | 4047.15 | 4065.19 | 16406.0 |
| 2022-10-03 02:00:00 | ES | Futures | 4065.19 | 4081.54 | 4055.6 | 4065.47 | 25811.0 |
| 2022-10-03 03:00:00 | ES | Futures | 4065.47 | 4073.93 | 4050.81 | 4060.68 | 42148.0 |
| 2022-10-03 04:00:00 | ES | Futures | 4060.4 | 4060.68 | 4049.12 | 4057.86 | 25560.0 |
| 2022-10-03 05:00:00 | ES | Futures | 4057.86 | 4068.01 | 4045.17 | 4064.91 | 29977.0 |
| 2022-10-03 06:00:00 | ES | Futures | 4065.19 | 4077.87 | 4063.5 | 4077.59 | 25726.0 |
| 2022-10-03 07:00:00 | ES | Futures | 4077.59 | 4087.74 | 4072.52 | 4087.18 | 34871.0 |
| 2022-10-03 08:00:00 | ES | Futures | 4087.18 | 4106.34 | 4080.97 | 4099.86 | 74913.0 |
| 2022-10-03 09:00:00 | ES | Futures | 4100.14 | 4110.57 | 4078.44 | 4095.35 | 269097.0 |
| 2022-10-03 10:00:00 | ES | Futures | 4095.35 | 4143.84 | 4095.07 | 4136.79 | 421919.0 |
| 2022-10-03 11:00:00 | ES | Futures | 4136.79 | 4149.47 | 4126.64 | 4130.3 | 233769.0 |
| 2022-10-03 12:00:00 | ES | Futures | 4130.59 | 4144.4 | 4126.36 | 4136.22 | 159824.0 |
| 2022-10-03 13:00:00 | ES | Futures | 4136.51 | 4158.21 | 4135.1 | 4152.01 | 153524.0 |
| 2022-10-03 14:00:00 | ES | Futures | 4152.29 | 4185.27 | 4152.29 | 4180.2 | 178498.0 |
| 2022-10-03 15:00:00 | ES | Futures | 4180.2 | 4182.74 | 4156.24 | 4162.16 | 337562.0 |
| 2022-10-03 16:00:00 | ES | Futures | 4162.44 | 4169.77 | 4161.31 | 4165.82 | 65907.0 |
| 2022-10-03 18:00:00 | ES | Futures | 4168.08 | 4172.59 | 4156.52 | 4161.6 | 13023.0 |
| 2022-10-03 19:00:00 | ES | Futures | 4161.03 | 4176.25 | 4160.75 | 4174.84 | 12245.0 |
| 2022-10-03 20:00:00 | ES | Futures | 4174.84 | 4192.04 | 4172.31 | 4187.25 | 21678.0 |
| 2022-10-03 21:00:00 | ES | Futures | 4187.25 | 4187.53 | 4178.51 | 4179.35 | 9643.0 |
| 2022-10-03 22:00:00 | ES | Futures | 4179.35 | 4184.15 | 4173.15 | 4184.15 | 10700.0 |
| 2022-10-03 23:00:00 | ES | Futures | 4184.15 | 4197.68 | 4181.61 | 4196.27 | 18584.0 |
| 2022-10-03 00:00:00 | NQ | Futures | 12631.42 | 12642.34 | 12600.1 | 12613.61 | 5206.0 |
| 2022-10-03 01:00:00 | NQ | Futures | 12613.89 | 12682.56 | 12586.31 | 12653.83 | 10521.0 |
| 2022-10-03 02:00:00 | NQ | Futures | 12654.98 | 12712.45 | 12615.33 | 12649.23 | 15711.0 |
| 2022-10-03 03:00:00 | NQ | Futures | 12650.1 | 12681.7 | 12600.96 | 12632.28 | 25226.0 |
| 2022-10-03 04:00:00 | NQ | Futures | 12633.14 | 12634.01 | 12589.18 | 12620.5 | 16440.0 |
| 2022-10-03 05:00:00 | NQ | Futures | 12619.93 | 12650.38 | 12577.98 | 12647.22 | 14445.0 |
| 2022-10-03 06:00:00 | NQ | Futures | 12646.94 | 12689.46 | 12640.04 | 12686.3 | 12442.0 |
| 2022-10-03 07:00:00 | NQ | Futures | 12686.87 | 12729.4 | 12674.23 | 12726.53 | 16407.0 |
| 2022-10-03 08:00:00 | NQ | Futures | 12726.24 | 12787.73 | 12702.68 | 12763.59 | 27389.0 |
| 2022-10-03 09:00:00 | NQ | Futures | 12763.59 | 12798.07 | 12688.02 | 12746.06 | 84874.0 |
| 2022-10-03 10:00:00 | NQ | Futures | 12746.35 | 12907.25 | 12745.78 | 12870.19 | 110428.0 |
| 2022-10-03 11:00:00 | NQ | Futures | 12870.48 | 12914.15 | 12824.22 | 12845.19 | 62826.0 |
| 2022-10-03 12:00:00 | NQ | Futures | 12844.9 | 12898.35 | 12842.32 | 12879.38 | 46703.0 |
| 2022-10-03 13:00:00 | NQ | Futures | 12879.96 | 12966.16 | 12876.22 | 12945.47 | 53905.0 |
| 2022-10-03 14:00:00 | NQ | Futures | 12946.04 | 13054.08 | 12945.18 | 13035.98 | 59327.0 |
| 2022-10-03 15:00:00 | NQ | Futures | 13036.55 | 13052.35 | 12960.41 | 12976.5 | 87058.0 |
| 2022-10-03 16:00:00 | NQ | Futures | 12976.79 | 13017.87 | 12972.48 | 12997.19 | 18724.0 |
| 2022-10-03 18:00:00 | NQ | Futures | 13003.8 | 13019.89 | 12965.87 | 12986.56 | 5404.0 |
| 2022-10-03 19:00:00 | NQ | Futures | 12986.27 | 13040.29 | 12985.12 | 13038.27 | 7039.0 |
| 2022-10-03 20:00:00 | NQ | Futures | 13038.27 | 13105.51 | 13027.36 | 13085.11 | 10990.0 |
| 2022-10-03 21:00:00 | NQ | Futures | 13085.4 | 13085.4 | 13051.2 | 13051.49 | 5238.0 |
| 2022-10-03 22:00:00 | NQ | Futures | 13052.35 | 13065.86 | 13027.64 | 13064.71 | 6260.0 |
| 2022-10-03 23:00:00 | NQ | Futures | 13065.28 | 13103.78 | 13059.25 | 13100.34 | 8060.0 |
| 2022-10-03 00:00:00 | YM | Futures | 32363.0 | 32378.7 | 32318.1 | 32342.8 | 1196.0 |
| 2022-10-03 01:00:00 | YM | Futures | 32342.8 | 32460.6 | 32288.9 | 32420.2 | 2474.0 |
| 2022-10-03 02:00:00 | YM | Futures | 32421.3 | 32515.6 | 32354.0 | 32423.6 | 4097.0 |
| 2022-10-03 03:00:00 | YM | Futures | 32423.6 | 32470.7 | 32313.6 | 32385.4 | 4902.0 |
> showing 50 of 2,100 rows — these rows as CSV