PREVIEW / futures_1hour / 2022-10-10
file: by_date/futures_1hour/2022/2022-10-10.parquet size: 68 KB rows: 2,038
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-10 00:00:00 | ES | Futures | 4100.42 | 4106.91 | 4098.73 | 4105.22 | 6568.0 |
| 2022-10-10 01:00:00 | ES | Futures | 4105.22 | 4108.6 | 4094.79 | 4095.35 | 9563.0 |
| 2022-10-10 02:00:00 | ES | Futures | 4095.35 | 4106.06 | 4089.15 | 4093.94 | 15877.0 |
| 2022-10-10 03:00:00 | ES | Futures | 4094.22 | 4114.52 | 4093.66 | 4101.83 | 27162.0 |
| 2022-10-10 04:00:00 | ES | Futures | 4101.55 | 4103.53 | 4085.77 | 4093.38 | 22202.0 |
| 2022-10-10 05:00:00 | ES | Futures | 4093.66 | 4114.8 | 4093.66 | 4113.67 | 18016.0 |
| 2022-10-10 06:00:00 | ES | Futures | 4113.67 | 4115.93 | 4101.83 | 4104.09 | 27978.0 |
| 2022-10-10 07:00:00 | ES | Futures | 4103.81 | 4115.93 | 4103.53 | 4110.85 | 26839.0 |
| 2022-10-10 08:00:00 | ES | Futures | 4111.14 | 4132.84 | 4107.75 | 4132.28 | 47440.0 |
| 2022-10-10 09:00:00 | ES | Futures | 4132.28 | 4135.38 | 4102.68 | 4104.09 | 221810.0 |
| 2022-10-10 10:00:00 | ES | Futures | 4104.09 | 4119.59 | 4080.97 | 4087.46 | 353268.0 |
| 2022-10-10 11:00:00 | ES | Futures | 4087.46 | 4101.83 | 4077.31 | 4094.22 | 218109.0 |
| 2022-10-10 12:00:00 | ES | Futures | 4094.22 | 4096.76 | 4066.32 | 4066.6 | 153295.0 |
| 2022-10-10 13:00:00 | ES | Futures | 4066.6 | 4112.26 | 4059.27 | 4102.4 | 251514.0 |
| 2022-10-10 14:00:00 | ES | Futures | 4102.4 | 4104.37 | 4084.36 | 4091.4 | 185964.0 |
| 2022-10-10 15:00:00 | ES | Futures | 4091.4 | 4107.75 | 4085.48 | 4085.77 | 260427.0 |
| 2022-10-10 16:00:00 | ES | Futures | 4085.77 | 4091.4 | 4085.48 | 4090.28 | 42052.0 |
| 2022-10-10 18:00:00 | ES | Futures | 4087.18 | 4094.22 | 4086.33 | 4092.53 | 5272.0 |
| 2022-10-10 19:00:00 | ES | Futures | 4092.53 | 4099.86 | 4092.53 | 4095.35 | 7213.0 |
| 2022-10-10 20:00:00 | ES | Futures | 4095.35 | 4096.48 | 4080.41 | 4094.22 | 16885.0 |
| 2022-10-10 21:00:00 | ES | Futures | 4094.22 | 4099.3 | 4073.08 | 4076.75 | 16342.0 |
| 2022-10-10 22:00:00 | ES | Futures | 4076.46 | 4078.72 | 4063.78 | 4066.88 | 18180.0 |
| 2022-10-10 23:00:00 | ES | Futures | 4066.88 | 4074.49 | 4065.19 | 4066.88 | 7697.0 |
| 2022-10-10 00:00:00 | NQ | Futures | 12695.78 | 12713.02 | 12691.18 | 12708.71 | 3658.0 |
| 2022-10-10 01:00:00 | NQ | Futures | 12707.27 | 12723.94 | 12674.23 | 12674.81 | 6077.0 |
| 2022-10-10 02:00:00 | NQ | Futures | 12675.96 | 12716.18 | 12655.84 | 12671.36 | 10036.0 |
| 2022-10-10 03:00:00 | NQ | Futures | 12672.22 | 12747.79 | 12669.64 | 12695.49 | 16438.0 |
| 2022-10-10 04:00:00 | NQ | Futures | 12695.21 | 12702.39 | 12637.45 | 12665.9 | 14059.0 |
| 2022-10-10 05:00:00 | NQ | Futures | 12667.05 | 12735.72 | 12666.19 | 12730.26 | 10243.0 |
| 2022-10-10 06:00:00 | NQ | Futures | 12729.69 | 12739.17 | 12682.28 | 12691.47 | 8874.0 |
| 2022-10-10 07:00:00 | NQ | Futures | 12690.9 | 12740.32 | 12690.61 | 12719.92 | 10355.0 |
| 2022-10-10 08:00:00 | NQ | Futures | 12720.78 | 12790.6 | 12701.82 | 12788.3 | 21626.0 |
| 2022-10-10 09:00:00 | NQ | Futures | 12788.3 | 12799.22 | 12645.5 | 12658.72 | 89181.0 |
| 2022-10-10 10:00:00 | NQ | Futures | 12659.58 | 12720.78 | 12566.49 | 12586.89 | 120820.0 |
| 2022-10-10 11:00:00 | NQ | Futures | 12586.89 | 12664.18 | 12559.3 | 12628.55 | 82198.0 |
| 2022-10-10 12:00:00 | NQ | Futures | 12628.83 | 12629.41 | 12534.88 | 12535.45 | 65469.0 |
| 2022-10-10 13:00:00 | NQ | Futures | 12535.74 | 12720.78 | 12500.69 | 12682.56 | 85456.0 |
| 2022-10-10 14:00:00 | NQ | Futures | 12683.14 | 12692.62 | 12609.58 | 12644.64 | 64377.0 |
| 2022-10-10 15:00:00 | NQ | Futures | 12645.5 | 12699.23 | 12615.91 | 12620.21 | 76774.0 |
| 2022-10-10 16:00:00 | NQ | Futures | 12619.35 | 12647.51 | 12619.07 | 12634.87 | 13326.0 |
| 2022-10-10 18:00:00 | NQ | Futures | 12627.4 | 12655.27 | 12623.95 | 12650.1 | 2924.0 |
| 2022-10-10 19:00:00 | NQ | Futures | 12650.67 | 12678.25 | 12650.67 | 12658.72 | 4125.0 |
| 2022-10-10 20:00:00 | NQ | Futures | 12658.72 | 12667.91 | 12606.42 | 12659.58 | 8120.0 |
| 2022-10-10 21:00:00 | NQ | Futures | 12659.0 | 12675.96 | 12584.87 | 12597.8 | 8698.0 |
| 2022-10-10 22:00:00 | NQ | Futures | 12596.65 | 12606.71 | 12551.26 | 12568.21 | 8502.0 |
| 2022-10-10 23:00:00 | NQ | Futures | 12567.63 | 12590.62 | 12561.6 | 12569.65 | 3632.0 |
| 2022-10-10 00:00:00 | YM | Futures | 32804.0 | 32856.8 | 32798.4 | 32846.7 | 720.0 |
| 2022-10-10 01:00:00 | YM | Futures | 32845.5 | 32860.1 | 32765.9 | 32769.2 | 1087.0 |
| 2022-10-10 02:00:00 | YM | Futures | 32770.3 | 32844.4 | 32735.6 | 32764.7 | 2346.0 |
| 2022-10-10 03:00:00 | YM | Futures | 32765.9 | 32907.3 | 32762.5 | 32823.1 | 3669.0 |
> showing 50 of 2,038 rows — these rows as CSV