PREVIEW / futures_1hour / 2022-09-29
file: by_date/futures_1hour/2022/2022-09-29.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-09-29 00:00:00 | ES | Futures | 4205.85 | 4212.62 | 4204.44 | 4209.52 | 10901.0 |
| 2022-09-29 01:00:00 | ES | Futures | 4209.8 | 4211.49 | 4190.91 | 4197.96 | 22014.0 |
| 2022-09-29 02:00:00 | ES | Futures | 4197.96 | 4198.24 | 4170.9 | 4183.86 | 34422.0 |
| 2022-09-29 03:00:00 | ES | Futures | 4184.43 | 4187.81 | 4146.37 | 4156.24 | 55605.0 |
| 2022-09-29 04:00:00 | ES | Futures | 4156.24 | 4166.11 | 4150.04 | 4158.21 | 34897.0 |
| 2022-09-29 05:00:00 | ES | Futures | 4157.93 | 4183.02 | 4156.52 | 4175.41 | 33926.0 |
| 2022-09-29 06:00:00 | ES | Futures | 4175.41 | 4176.54 | 4161.03 | 4168.08 | 26963.0 |
| 2022-09-29 07:00:00 | ES | Futures | 4168.36 | 4184.99 | 4168.36 | 4171.18 | 35346.0 |
| 2022-09-29 08:00:00 | ES | Futures | 4171.46 | 4175.69 | 4142.14 | 4153.98 | 100074.0 |
| 2022-09-29 09:00:00 | ES | Futures | 4153.98 | 4172.03 | 4120.16 | 4124.1 | 352073.0 |
| 2022-09-29 10:00:00 | ES | Futures | 4124.39 | 4125.79 | 4094.5 | 4116.77 | 472555.0 |
| 2022-09-29 11:00:00 | ES | Futures | 4116.77 | 4141.02 | 4111.98 | 4133.69 | 329757.0 |
| 2022-09-29 12:00:00 | ES | Futures | 4133.69 | 4138.2 | 4112.26 | 4113.39 | 218503.0 |
| 2022-09-29 13:00:00 | ES | Futures | 4113.67 | 4115.65 | 4092.53 | 4093.38 | 207860.0 |
| 2022-09-29 14:00:00 | ES | Futures | 4093.66 | 4105.78 | 4084.07 | 4086.89 | 251433.0 |
| 2022-09-29 15:00:00 | ES | Futures | 4086.89 | 4125.51 | 4086.33 | 4120.72 | 461237.0 |
| 2022-09-29 16:00:00 | ES | Futures | 4121.0 | 4129.74 | 4119.59 | 4125.51 | 81062.0 |
| 2022-09-29 18:00:00 | ES | Futures | 4122.98 | 4135.66 | 4120.16 | 4130.87 | 14907.0 |
| 2022-09-29 19:00:00 | ES | Futures | 4131.15 | 4139.04 | 4130.02 | 4136.22 | 9804.0 |
| 2022-09-29 20:00:00 | ES | Futures | 4136.51 | 4138.2 | 4116.49 | 4125.23 | 17511.0 |
| 2022-09-29 21:00:00 | ES | Futures | 4125.23 | 4134.53 | 4121.0 | 4129.74 | 14704.0 |
| 2022-09-29 22:00:00 | ES | Futures | 4129.74 | 4132.28 | 4111.42 | 4120.16 | 15668.0 |
| 2022-09-29 23:00:00 | ES | Futures | 4120.16 | 4122.41 | 4107.47 | 4109.73 | 11512.0 |
| 2022-09-29 00:00:00 | NQ | Futures | 13259.23 | 13283.65 | 13253.77 | 13269.86 | 5068.0 |
| 2022-09-29 01:00:00 | NQ | Futures | 13269.86 | 13275.03 | 13197.74 | 13218.71 | 8979.0 |
| 2022-09-29 02:00:00 | NQ | Futures | 13219.0 | 13220.15 | 13128.21 | 13178.49 | 16314.0 |
| 2022-09-29 03:00:00 | NQ | Futures | 13179.06 | 13189.69 | 13056.09 | 13090.85 | 29006.0 |
| 2022-09-29 04:00:00 | NQ | Futures | 13090.85 | 13130.79 | 13074.76 | 13098.33 | 19491.0 |
| 2022-09-29 05:00:00 | NQ | Futures | 13097.18 | 13181.08 | 13090.57 | 13148.89 | 15695.0 |
| 2022-09-29 06:00:00 | NQ | Futures | 13149.76 | 13153.49 | 13088.56 | 13109.24 | 14692.0 |
| 2022-09-29 07:00:00 | NQ | Futures | 13109.53 | 13170.16 | 13108.96 | 13121.89 | 14572.0 |
| 2022-09-29 08:00:00 | NQ | Futures | 13122.46 | 13142.29 | 13024.48 | 13067.58 | 37138.0 |
| 2022-09-29 09:00:00 | NQ | Futures | 13067.58 | 13120.74 | 12921.05 | 12936.56 | 114043.0 |
| 2022-09-29 10:00:00 | NQ | Futures | 12936.85 | 12949.49 | 12825.08 | 12890.59 | 142516.0 |
| 2022-09-29 11:00:00 | NQ | Futures | 12890.59 | 12957.82 | 12860.99 | 12936.85 | 86712.0 |
| 2022-09-29 12:00:00 | NQ | Futures | 12937.14 | 12953.8 | 12844.9 | 12851.51 | 58511.0 |
| 2022-09-29 13:00:00 | NQ | Futures | 12852.09 | 12871.63 | 12778.24 | 12783.13 | 63569.0 |
| 2022-09-29 14:00:00 | NQ | Futures | 12783.7 | 12825.65 | 12747.5 | 12764.17 | 72925.0 |
| 2022-09-29 15:00:00 | NQ | Futures | 12764.74 | 12915.59 | 12763.02 | 12908.69 | 126116.0 |
| 2022-09-29 16:00:00 | NQ | Futures | 12908.4 | 12934.26 | 12894.32 | 12911.28 | 21720.0 |
| 2022-09-29 18:00:00 | NQ | Futures | 12895.19 | 12940.01 | 12893.17 | 12922.48 | 6905.0 |
| 2022-09-29 19:00:00 | NQ | Futures | 12922.48 | 12957.54 | 12921.62 | 12946.9 | 6067.0 |
| 2022-09-29 20:00:00 | NQ | Futures | 12947.77 | 12954.66 | 12880.24 | 12911.56 | 9430.0 |
| 2022-09-29 21:00:00 | NQ | Futures | 12911.28 | 12953.8 | 12898.35 | 12934.26 | 8667.0 |
| 2022-09-29 22:00:00 | NQ | Futures | 12934.26 | 12942.31 | 12866.45 | 12901.22 | 9321.0 |
| 2022-09-29 23:00:00 | NQ | Futures | 12900.93 | 12910.41 | 12858.98 | 12867.03 | 6555.0 |
| 2022-09-29 00:00:00 | YM | Futures | 33370.7 | 33421.2 | 33358.4 | 33402.2 | 1146.0 |
| 2022-09-29 01:00:00 | YM | Futures | 33403.3 | 33412.3 | 33274.2 | 33322.5 | 2388.0 |
| 2022-09-29 02:00:00 | YM | Futures | 33320.2 | 33321.4 | 33121.6 | 33213.6 | 5060.0 |
| 2022-09-29 03:00:00 | YM | Futures | 33217.0 | 33240.6 | 32929.7 | 32992.5 | 7543.0 |
> showing 50 of 2,070 rows — these rows as CSV