PREVIEW / futures_1hour / 2022-10-19
file: by_date/futures_1hour/2022/2022-10-19.parquet size: 70 KB rows: 2,070
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-19 00:00:00 | ES | Futures | 4241.65 | 4243.34 | 4237.42 | 4238.83 | 6686.0 |
| 2022-10-19 01:00:00 | ES | Futures | 4238.83 | 4241.37 | 4228.69 | 4231.5 | 11991.0 |
| 2022-10-19 02:00:00 | ES | Futures | 4231.22 | 4232.63 | 4212.62 | 4215.15 | 24200.0 |
| 2022-10-19 03:00:00 | ES | Futures | 4214.87 | 4221.64 | 4202.75 | 4219.95 | 34838.0 |
| 2022-10-19 04:00:00 | ES | Futures | 4220.23 | 4220.23 | 4196.27 | 4206.7 | 24853.0 |
| 2022-10-19 05:00:00 | ES | Futures | 4206.7 | 4231.22 | 4205.01 | 4231.22 | 25462.0 |
| 2022-10-19 06:00:00 | ES | Futures | 4230.94 | 4232.07 | 4203.6 | 4210.64 | 28141.0 |
| 2022-10-19 07:00:00 | ES | Futures | 4210.64 | 4216.28 | 4184.43 | 4195.7 | 50247.0 |
| 2022-10-19 08:00:00 | ES | Futures | 4195.7 | 4196.27 | 4174.0 | 4183.58 | 74404.0 |
| 2022-10-19 09:00:00 | ES | Futures | 4183.58 | 4207.83 | 4172.59 | 4181.05 | 298450.0 |
| 2022-10-19 10:00:00 | ES | Futures | 4180.76 | 4217.97 | 4176.82 | 4193.17 | 344904.0 |
| 2022-10-19 11:00:00 | ES | Futures | 4193.17 | 4205.29 | 4181.61 | 4193.73 | 241913.0 |
| 2022-10-19 12:00:00 | ES | Futures | 4194.01 | 4194.86 | 4161.03 | 4165.54 | 229206.0 |
| 2022-10-19 13:00:00 | ES | Futures | 4165.54 | 4168.08 | 4145.81 | 4161.6 | 220020.0 |
| 2022-10-19 14:00:00 | ES | Futures | 4161.6 | 4179.35 | 4157.65 | 4164.41 | 199939.0 |
| 2022-10-19 15:00:00 | ES | Futures | 4164.7 | 4181.89 | 4161.31 | 4179.92 | 303867.0 |
| 2022-10-19 16:00:00 | ES | Futures | 4180.2 | 4195.99 | 4172.59 | 4183.58 | 89346.0 |
| 2022-10-19 18:00:00 | ES | Futures | 4181.05 | 4183.58 | 4167.8 | 4170.05 | 9596.0 |
| 2022-10-19 19:00:00 | ES | Futures | 4170.05 | 4171.18 | 4163.57 | 4168.36 | 9172.0 |
| 2022-10-19 20:00:00 | ES | Futures | 4168.36 | 4175.97 | 4154.83 | 4161.6 | 19389.0 |
| 2022-10-19 21:00:00 | ES | Futures | 4161.31 | 4161.31 | 4146.09 | 4153.98 | 20762.0 |
| 2022-10-19 22:00:00 | ES | Futures | 4153.98 | 4161.88 | 4151.17 | 4160.19 | 9920.0 |
| 2022-10-19 23:00:00 | ES | Futures | 4160.19 | 4162.44 | 4148.06 | 4153.14 | 9381.0 |
| 2022-10-19 00:00:00 | NQ | Futures | 13023.05 | 13029.08 | 12999.49 | 13004.08 | 4132.0 |
| 2022-10-19 01:00:00 | NQ | Futures | 13005.23 | 13014.71 | 12961.56 | 12974.49 | 6845.0 |
| 2022-10-19 02:00:00 | NQ | Futures | 12974.2 | 12985.41 | 12913.86 | 12923.63 | 12370.0 |
| 2022-10-19 03:00:00 | NQ | Futures | 12924.49 | 12942.31 | 12874.5 | 12933.69 | 18507.0 |
| 2022-10-19 04:00:00 | NQ | Futures | 12933.11 | 12933.97 | 12842.32 | 12886.28 | 15904.0 |
| 2022-10-19 05:00:00 | NQ | Futures | 12885.13 | 12975.92 | 12880.24 | 12975.64 | 14028.0 |
| 2022-10-19 06:00:00 | NQ | Futures | 12975.35 | 12978.22 | 12863.87 | 12890.88 | 15902.0 |
| 2022-10-19 07:00:00 | NQ | Futures | 12891.16 | 12914.72 | 12788.88 | 12837.15 | 24577.0 |
| 2022-10-19 08:00:00 | NQ | Futures | 12836.57 | 12842.32 | 12762.73 | 12792.32 | 33665.0 |
| 2022-10-19 09:00:00 | NQ | Futures | 12792.61 | 12887.43 | 12764.74 | 12799.79 | 96905.0 |
| 2022-10-19 10:00:00 | NQ | Futures | 12799.79 | 12969.32 | 12781.12 | 12858.41 | 113376.0 |
| 2022-10-19 11:00:00 | NQ | Futures | 12858.41 | 12910.99 | 12823.35 | 12875.07 | 67660.0 |
| 2022-10-19 12:00:00 | NQ | Futures | 12875.36 | 12881.68 | 12767.9 | 12780.83 | 56728.0 |
| 2022-10-19 13:00:00 | NQ | Futures | 12781.4 | 12789.74 | 12698.65 | 12755.83 | 65258.0 |
| 2022-10-19 14:00:00 | NQ | Futures | 12755.83 | 12819.04 | 12739.17 | 12760.72 | 47626.0 |
| 2022-10-19 15:00:00 | NQ | Futures | 12761.0 | 12822.78 | 12741.18 | 12819.91 | 63262.0 |
| 2022-10-19 16:00:00 | NQ | Futures | 12820.48 | 12886.85 | 12767.61 | 12815.88 | 38094.0 |
| 2022-10-19 18:00:00 | NQ | Futures | 12796.35 | 12809.85 | 12746.06 | 12755.26 | 5364.0 |
| 2022-10-19 19:00:00 | NQ | Futures | 12756.12 | 12761.29 | 12726.81 | 12744.05 | 5410.0 |
| 2022-10-19 20:00:00 | NQ | Futures | 12743.19 | 12774.22 | 12684.86 | 12709.29 | 9580.0 |
| 2022-10-19 21:00:00 | NQ | Futures | 12708.71 | 12709.0 | 12651.53 | 12677.39 | 9707.0 |
| 2022-10-19 22:00:00 | NQ | Futures | 12678.54 | 12707.27 | 12667.62 | 12702.96 | 5266.0 |
| 2022-10-19 23:00:00 | NQ | Futures | 12702.1 | 12711.01 | 12660.73 | 12676.53 | 5632.0 |
| 2022-10-19 00:00:00 | YM | Futures | 34490.7 | 34502.0 | 34463.8 | 34480.6 | 714.0 |
| 2022-10-19 01:00:00 | YM | Futures | 34480.6 | 34497.5 | 34416.7 | 34432.4 | 1350.0 |
| 2022-10-19 02:00:00 | YM | Futures | 34431.3 | 34436.9 | 34291.0 | 34308.9 | 3015.0 |
| 2022-10-19 03:00:00 | YM | Futures | 34310.0 | 34365.0 | 34224.8 | 34350.5 | 3833.0 |
> showing 50 of 2,070 rows — these rows as CSV