PREVIEW / futures_1hour / 2022-10-20
file: by_date/futures_1hour/2022/2022-10-20.parquet size: 68 KB rows: 2,053
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-20 00:00:00 | ES | Futures | 4153.14 | 4177.66 | 4149.76 | 4169.77 | 20422.0 |
| 2022-10-20 01:00:00 | ES | Futures | 4169.77 | 4193.45 | 4163.29 | 4174.28 | 22350.0 |
| 2022-10-20 02:00:00 | ES | Futures | 4174.28 | 4177.66 | 4159.9 | 4170.9 | 16472.0 |
| 2022-10-20 03:00:00 | ES | Futures | 4171.18 | 4175.13 | 4149.76 | 4154.55 | 33710.0 |
| 2022-10-20 04:00:00 | ES | Futures | 4154.55 | 4164.13 | 4151.45 | 4157.37 | 17988.0 |
| 2022-10-20 05:00:00 | ES | Futures | 4157.65 | 4172.87 | 4156.8 | 4167.51 | 16682.0 |
| 2022-10-20 06:00:00 | ES | Futures | 4167.51 | 4195.99 | 4163.57 | 4189.78 | 28304.0 |
| 2022-10-20 07:00:00 | ES | Futures | 4189.78 | 4199.93 | 4180.76 | 4189.22 | 36549.0 |
| 2022-10-20 08:00:00 | ES | Futures | 4188.94 | 4205.85 | 4165.54 | 4165.54 | 109902.0 |
| 2022-10-20 09:00:00 | ES | Futures | 4165.82 | 4193.45 | 4161.03 | 4185.27 | 292431.0 |
| 2022-10-20 10:00:00 | ES | Futures | 4184.99 | 4226.15 | 4183.58 | 4217.97 | 353634.0 |
| 2022-10-20 11:00:00 | ES | Futures | 4217.69 | 4219.95 | 4194.01 | 4198.24 | 233975.0 |
| 2022-10-20 12:00:00 | ES | Futures | 4198.24 | 4199.93 | 4163.57 | 4171.74 | 260491.0 |
| 2022-10-20 13:00:00 | ES | Futures | 4171.74 | 4173.43 | 4142.43 | 4150.88 | 229059.0 |
| 2022-10-20 14:00:00 | ES | Futures | 4151.17 | 4152.86 | 4134.82 | 4145.53 | 207980.0 |
| 2022-10-20 15:00:00 | ES | Futures | 4145.53 | 4156.8 | 4133.97 | 4143.27 | 303261.0 |
| 2022-10-20 16:00:00 | ES | Futures | 4143.55 | 4153.14 | 4141.3 | 4145.81 | 80801.0 |
| 2022-10-20 18:00:00 | ES | Futures | 4146.94 | 4147.22 | 4127.49 | 4129.46 | 12409.0 |
| 2022-10-20 19:00:00 | ES | Futures | 4129.74 | 4131.15 | 4122.98 | 4129.18 | 11528.0 |
| 2022-10-20 20:00:00 | ES | Futures | 4129.46 | 4136.51 | 4121.85 | 4133.69 | 15391.0 |
| 2022-10-20 21:00:00 | ES | Futures | 4133.69 | 4137.35 | 4127.77 | 4131.43 | 12206.0 |
| 2022-10-20 22:00:00 | ES | Futures | 4131.43 | 4142.43 | 4130.3 | 4141.02 | 9402.0 |
| 2022-10-20 23:00:00 | ES | Futures | 4140.74 | 4144.96 | 4130.3 | 4133.12 | 10191.0 |
| 2022-10-20 00:00:00 | NQ | Futures | 12676.53 | 12760.43 | 12662.45 | 12735.72 | 10374.0 |
| 2022-10-20 01:00:00 | NQ | Futures | 12735.15 | 12820.77 | 12713.02 | 12757.27 | 12804.0 |
| 2022-10-20 02:00:00 | NQ | Futures | 12756.69 | 12766.75 | 12705.55 | 12744.34 | 8533.0 |
| 2022-10-20 03:00:00 | NQ | Futures | 12745.2 | 12757.27 | 12675.67 | 12689.75 | 18378.0 |
| 2022-10-20 04:00:00 | NQ | Futures | 12690.04 | 12728.25 | 12677.11 | 12705.26 | 11089.0 |
| 2022-10-20 05:00:00 | NQ | Futures | 12704.69 | 12762.73 | 12700.09 | 12740.32 | 9721.0 |
| 2022-10-20 06:00:00 | NQ | Futures | 12740.03 | 12847.78 | 12724.51 | 12825.08 | 14195.0 |
| 2022-10-20 07:00:00 | NQ | Futures | 12825.65 | 12858.7 | 12784.85 | 12825.37 | 18206.0 |
| 2022-10-20 08:00:00 | NQ | Futures | 12825.08 | 12894.04 | 12737.44 | 12738.59 | 44621.0 |
| 2022-10-20 09:00:00 | NQ | Futures | 12738.88 | 12906.39 | 12737.44 | 12875.07 | 89366.0 |
| 2022-10-20 10:00:00 | NQ | Futures | 12874.79 | 13020.17 | 12864.44 | 13007.82 | 100054.0 |
| 2022-10-20 11:00:00 | NQ | Futures | 13008.39 | 13016.72 | 12925.36 | 12953.51 | 60839.0 |
| 2022-10-20 12:00:00 | NQ | Futures | 12954.37 | 12958.68 | 12808.7 | 12844.04 | 68991.0 |
| 2022-10-20 13:00:00 | NQ | Futures | 12844.04 | 12852.66 | 12727.39 | 12752.38 | 68368.0 |
| 2022-10-20 14:00:00 | NQ | Futures | 12752.67 | 12760.72 | 12689.75 | 12738.59 | 58842.0 |
| 2022-10-20 15:00:00 | NQ | Futures | 12739.17 | 12780.54 | 12707.27 | 12743.19 | 66174.0 |
| 2022-10-20 16:00:00 | NQ | Futures | 12742.62 | 12788.01 | 12699.8 | 12711.01 | 31023.0 |
| 2022-10-20 18:00:00 | NQ | Futures | 12712.73 | 12715.32 | 12654.98 | 12663.03 | 6345.0 |
| 2022-10-20 19:00:00 | NQ | Futures | 12662.74 | 12669.35 | 12637.45 | 12665.33 | 6058.0 |
| 2022-10-20 20:00:00 | NQ | Futures | 12666.47 | 12686.01 | 12622.23 | 12673.94 | 7338.0 |
| 2022-10-20 21:00:00 | NQ | Futures | 12674.23 | 12686.01 | 12654.98 | 12664.46 | 5047.0 |
| 2022-10-20 22:00:00 | NQ | Futures | 12663.6 | 12704.11 | 12660.15 | 12698.08 | 5336.0 |
| 2022-10-20 23:00:00 | NQ | Futures | 12696.93 | 12713.88 | 12663.89 | 12671.36 | 5506.0 |
| 2022-10-20 00:00:00 | YM | Futures | 34084.5 | 34265.2 | 34062.0 | 34213.5 | 3592.0 |
| 2022-10-20 01:00:00 | YM | Futures | 34212.4 | 34366.2 | 34166.4 | 34242.7 | 3753.0 |
| 2022-10-20 02:00:00 | YM | Futures | 34239.3 | 34270.8 | 34139.5 | 34219.1 | 2576.0 |
| 2022-10-20 03:00:00 | YM | Futures | 34222.5 | 34248.3 | 34067.6 | 34103.6 | 5379.0 |
> showing 50 of 2,053 rows — these rows as CSV