PREVIEW / futures_1hour / 2022-09-27
file: by_date/futures_1hour/2022/2022-09-27.parquet size: 71 KB rows: 2,094
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-09-27 00:00:00 | ES | Futures | 4166.11 | 4169.21 | 4164.7 | 4166.95 | 5073.0 |
| 2022-09-27 01:00:00 | ES | Futures | 4166.95 | 4172.03 | 4161.31 | 4171.46 | 8121.0 |
| 2022-09-27 02:00:00 | ES | Futures | 4171.74 | 4185.56 | 4168.92 | 4176.54 | 26602.0 |
| 2022-09-27 03:00:00 | ES | Futures | 4176.54 | 4200.21 | 4172.31 | 4194.58 | 49944.0 |
| 2022-09-27 04:00:00 | ES | Futures | 4194.29 | 4197.4 | 4181.89 | 4182.46 | 27869.0 |
| 2022-09-27 05:00:00 | ES | Futures | 4182.17 | 4183.3 | 4166.39 | 4166.67 | 28153.0 |
| 2022-09-27 06:00:00 | ES | Futures | 4166.39 | 4190.91 | 4166.39 | 4185.84 | 33429.0 |
| 2022-09-27 07:00:00 | ES | Futures | 4185.84 | 4199.37 | 4181.33 | 4194.29 | 39960.0 |
| 2022-09-27 08:00:00 | ES | Futures | 4194.01 | 4203.32 | 4184.15 | 4184.71 | 58633.0 |
| 2022-09-27 09:00:00 | ES | Futures | 4184.43 | 4209.24 | 4176.25 | 4185.84 | 323933.0 |
| 2022-09-27 10:00:00 | ES | Futures | 4185.84 | 4192.04 | 4156.52 | 4183.86 | 453192.0 |
| 2022-09-27 11:00:00 | ES | Futures | 4184.15 | 4186.97 | 4135.1 | 4135.94 | 343224.0 |
| 2022-09-27 12:00:00 | ES | Futures | 4135.94 | 4137.07 | 4102.96 | 4120.44 | 411251.0 |
| 2022-09-27 13:00:00 | ES | Futures | 4120.44 | 4120.44 | 4099.01 | 4109.16 | 299353.0 |
| 2022-09-27 14:00:00 | ES | Futures | 4109.44 | 4141.86 | 4104.37 | 4135.1 | 280034.0 |
| 2022-09-27 15:00:00 | ES | Futures | 4135.1 | 4135.66 | 4113.11 | 4128.05 | 370755.0 |
| 2022-09-27 16:00:00 | ES | Futures | 4127.77 | 4133.97 | 4118.18 | 4132.84 | 62470.0 |
| 2022-09-27 18:00:00 | ES | Futures | 4136.51 | 4139.04 | 4128.05 | 4136.22 | 11098.0 |
| 2022-09-27 19:00:00 | ES | Futures | 4135.94 | 4140.17 | 4129.18 | 4130.02 | 9646.0 |
| 2022-09-27 20:00:00 | ES | Futures | 4130.02 | 4143.55 | 4129.74 | 4132.28 | 18456.0 |
| 2022-09-27 21:00:00 | ES | Futures | 4132.56 | 4138.2 | 4104.65 | 4111.42 | 46174.0 |
| 2022-09-27 22:00:00 | ES | Futures | 4111.42 | 4111.7 | 4085.2 | 4093.09 | 36809.0 |
| 2022-09-27 23:00:00 | ES | Futures | 4093.38 | 4106.06 | 4093.38 | 4102.68 | 17487.0 |
| 2022-09-27 00:00:00 | NQ | Futures | 13102.64 | 13110.68 | 13094.3 | 13101.49 | 2293.0 |
| 2022-09-27 01:00:00 | NQ | Futures | 13101.2 | 13125.05 | 13085.97 | 13123.61 | 4525.0 |
| 2022-09-27 02:00:00 | NQ | Futures | 13122.75 | 13178.78 | 13116.43 | 13147.17 | 11373.0 |
| 2022-09-27 03:00:00 | NQ | Futures | 13146.31 | 13229.92 | 13128.49 | 13201.48 | 20282.0 |
| 2022-09-27 04:00:00 | NQ | Futures | 13201.19 | 13218.14 | 13161.25 | 13164.41 | 13426.0 |
| 2022-09-27 05:00:00 | NQ | Futures | 13164.12 | 13169.87 | 13118.73 | 13124.18 | 12285.0 |
| 2022-09-27 06:00:00 | NQ | Futures | 13123.61 | 13200.33 | 13123.32 | 13180.5 | 14272.0 |
| 2022-09-27 07:00:00 | NQ | Futures | 13180.79 | 13234.23 | 13168.15 | 13212.39 | 16236.0 |
| 2022-09-27 08:00:00 | NQ | Futures | 13212.39 | 13245.44 | 13186.82 | 13187.68 | 24980.0 |
| 2022-09-27 09:00:00 | NQ | Futures | 13187.11 | 13295.43 | 13167.86 | 13204.64 | 104953.0 |
| 2022-09-27 10:00:00 | NQ | Futures | 13205.79 | 13221.88 | 13108.09 | 13202.62 | 120687.0 |
| 2022-09-27 11:00:00 | NQ | Futures | 13203.77 | 13215.84 | 13035.11 | 13037.41 | 91892.0 |
| 2022-09-27 12:00:00 | NQ | Futures | 13037.99 | 13040.57 | 12910.7 | 12987.7 | 105281.0 |
| 2022-09-27 13:00:00 | NQ | Futures | 12987.99 | 12988.28 | 12920.47 | 12954.37 | 72847.0 |
| 2022-09-27 14:00:00 | NQ | Futures | 12955.24 | 13060.4 | 12934.55 | 13035.69 | 71570.0 |
| 2022-09-27 15:00:00 | NQ | Futures | 13035.98 | 13050.34 | 12965.58 | 13024.77 | 90361.0 |
| 2022-09-27 16:00:00 | NQ | Futures | 13024.48 | 13052.07 | 12998.34 | 13049.48 | 16400.0 |
| 2022-09-27 18:00:00 | NQ | Futures | 13057.24 | 13076.78 | 13035.4 | 13063.56 | 5301.0 |
| 2022-09-27 19:00:00 | NQ | Futures | 13062.98 | 13075.63 | 13039.71 | 13042.01 | 5181.0 |
| 2022-09-27 20:00:00 | NQ | Futures | 13041.72 | 13093.44 | 13041.72 | 13056.66 | 8993.0 |
| 2022-09-27 21:00:00 | NQ | Futures | 13056.66 | 13075.63 | 12934.26 | 12956.1 | 20558.0 |
| 2022-09-27 22:00:00 | NQ | Futures | 12955.52 | 12957.25 | 12853.81 | 12890.88 | 19702.0 |
| 2022-09-27 23:00:00 | NQ | Futures | 12891.74 | 12928.8 | 12888.86 | 12911.56 | 9716.0 |
| 2022-09-27 00:00:00 | YM | Futures | 33129.5 | 33148.5 | 33118.2 | 33130.6 | 657.0 |
| 2022-09-27 01:00:00 | YM | Futures | 33135.1 | 33164.2 | 33095.8 | 33159.8 | 1131.0 |
| 2022-09-27 02:00:00 | YM | Futures | 33156.4 | 33258.5 | 33142.9 | 33190.1 | 3717.0 |
| 2022-09-27 03:00:00 | YM | Futures | 33187.8 | 33360.6 | 33159.8 | 33314.6 | 6646.0 |
> showing 50 of 2,094 rows — these rows as CSV