PREVIEW / futures_1hour / 2022-04-22
file: by_date/futures_1hour/2022/2022-04-22.parquet size: 58 KB rows: 1,665
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-04-22 00:00:00 | ES | Futures | 4960.2 | 4965.59 | 4956.24 | 4965.02 | 4910.0 |
| 2022-04-22 01:00:00 | ES | Futures | 4964.74 | 4974.66 | 4963.32 | 4966.72 | 10547.0 |
| 2022-04-22 02:00:00 | ES | Futures | 4966.44 | 4976.64 | 4964.17 | 4974.09 | 9843.0 |
| 2022-04-22 03:00:00 | ES | Futures | 4974.09 | 4980.89 | 4959.64 | 4975.23 | 25939.0 |
| 2022-04-22 04:00:00 | ES | Futures | 4975.51 | 4979.76 | 4966.72 | 4968.42 | 15650.0 |
| 2022-04-22 05:00:00 | ES | Futures | 4968.14 | 4973.53 | 4955.67 | 4959.07 | 18802.0 |
| 2022-04-22 06:00:00 | ES | Futures | 4958.79 | 4964.74 | 4953.97 | 4961.62 | 17671.0 |
| 2022-04-22 07:00:00 | ES | Futures | 4961.62 | 4974.38 | 4961.62 | 4972.67 | 21898.0 |
| 2022-04-22 08:00:00 | ES | Futures | 4972.67 | 4979.19 | 4961.9 | 4964.74 | 30002.0 |
| 2022-04-22 09:00:00 | ES | Futures | 4965.02 | 4967.57 | 4927.32 | 4933.28 | 221894.0 |
| 2022-04-22 10:00:00 | ES | Futures | 4933.28 | 4951.98 | 4908.33 | 4910.6 | 286053.0 |
| 2022-04-22 11:00:00 | ES | Futures | 4910.32 | 4923.92 | 4887.64 | 4888.21 | 196343.0 |
| 2022-04-22 12:00:00 | ES | Futures | 4887.93 | 4905.5 | 4882.26 | 4888.78 | 155136.0 |
| 2022-04-22 13:00:00 | ES | Futures | 4888.49 | 4892.18 | 4869.22 | 4869.5 | 132195.0 |
| 2022-04-22 14:00:00 | ES | Futures | 4869.5 | 4883.67 | 4847.39 | 4854.76 | 181112.0 |
| 2022-04-22 15:00:00 | ES | Futures | 4855.05 | 4888.49 | 4832.37 | 4840.31 | 448983.0 |
| 2022-04-22 16:00:00 | ES | Futures | 4840.59 | 4842.01 | 4815.65 | 4819.9 | 116399.0 |
| 2022-04-22 00:00:00 | NQ | Futures | 15870.04 | 15903.97 | 15852.36 | 15902.23 | 4194.0 |
| 2022-04-22 01:00:00 | NQ | Futures | 15900.78 | 15936.74 | 15888.31 | 15894.4 | 6826.0 |
| 2022-04-22 02:00:00 | NQ | Futures | 15894.4 | 15947.47 | 15885.12 | 15933.55 | 6205.0 |
| 2022-04-22 03:00:00 | NQ | Futures | 15932.68 | 15960.81 | 15848.59 | 15924.27 | 15361.0 |
| 2022-04-22 04:00:00 | NQ | Futures | 15923.4 | 15944.28 | 15893.53 | 15898.75 | 9511.0 |
| 2022-04-22 05:00:00 | NQ | Futures | 15898.17 | 15919.34 | 15835.54 | 15851.2 | 8642.0 |
| 2022-04-22 06:00:00 | NQ | Futures | 15851.2 | 15887.73 | 15834.96 | 15873.23 | 10041.0 |
| 2022-04-22 07:00:00 | NQ | Futures | 15872.65 | 15953.56 | 15868.59 | 15949.21 | 12832.0 |
| 2022-04-22 08:00:00 | NQ | Futures | 15948.63 | 15984.58 | 15902.52 | 15916.44 | 17803.0 |
| 2022-04-22 09:00:00 | NQ | Futures | 15917.31 | 15980.81 | 15793.49 | 15853.81 | 98094.0 |
| 2022-04-22 10:00:00 | NQ | Futures | 15853.23 | 15956.75 | 15754.92 | 15788.56 | 99944.0 |
| 2022-04-22 11:00:00 | NQ | Futures | 15788.27 | 15859.9 | 15673.15 | 15675.47 | 76538.0 |
| 2022-04-22 12:00:00 | NQ | Futures | 15674.6 | 15720.71 | 15641.25 | 15649.37 | 60851.0 |
| 2022-04-22 13:00:00 | NQ | Futures | 15647.92 | 15668.22 | 15577.46 | 15578.04 | 50124.0 |
| 2022-04-22 14:00:00 | NQ | Futures | 15578.04 | 15646.47 | 15514.24 | 15542.37 | 66444.0 |
| 2022-04-22 15:00:00 | NQ | Futures | 15542.37 | 15668.51 | 15473.07 | 15492.5 | 119979.0 |
| 2022-04-22 16:00:00 | NQ | Futures | 15493.95 | 15506.13 | 15423.19 | 15444.65 | 25870.0 |
| 2022-04-22 00:00:00 | YM | Futures | 38995.5 | 39020.3 | 38971.8 | 39009.0 | 1011.0 |
| 2022-04-22 01:00:00 | YM | Futures | 39009.0 | 39087.9 | 39000.0 | 39037.2 | 2205.0 |
| 2022-04-22 02:00:00 | YM | Futures | 39039.5 | 39097.0 | 39022.6 | 39075.5 | 2607.0 |
| 2022-04-22 03:00:00 | YM | Futures | 39075.5 | 39128.5 | 39011.3 | 39101.5 | 5729.0 |
| 2022-04-22 04:00:00 | YM | Futures | 39102.6 | 39139.8 | 39041.7 | 39054.1 | 3958.0 |
| 2022-04-22 05:00:00 | YM | Futures | 39055.2 | 39084.6 | 38973.0 | 38986.5 | 3737.0 |
| 2022-04-22 06:00:00 | YM | Futures | 38985.4 | 39021.4 | 38951.5 | 39003.4 | 3234.0 |
| 2022-04-22 07:00:00 | YM | Futures | 39002.3 | 39063.1 | 38994.4 | 39028.2 | 5879.0 |
| 2022-04-22 08:00:00 | YM | Futures | 39028.2 | 39058.6 | 38976.3 | 38996.6 | 5306.0 |
| 2022-04-22 09:00:00 | YM | Futures | 38998.9 | 39010.2 | 38688.9 | 38714.8 | 34109.0 |
| 2022-04-22 10:00:00 | YM | Futures | 38713.7 | 38815.1 | 38532.2 | 38538.9 | 34512.0 |
| 2022-04-22 11:00:00 | YM | Futures | 38538.9 | 38626.9 | 38436.3 | 38444.2 | 21040.0 |
| 2022-04-22 12:00:00 | YM | Futures | 38443.1 | 38580.6 | 38409.3 | 38470.2 | 17457.0 |
| 2022-04-22 13:00:00 | YM | Futures | 38467.9 | 38483.7 | 38320.2 | 38321.4 | 14070.0 |
| 2022-04-22 14:00:00 | YM | Futures | 38321.4 | 38404.8 | 38127.5 | 38178.2 | 19687.0 |
| 2022-04-22 15:00:00 | YM | Futures | 38177.1 | 38418.3 | 37982.0 | 38046.3 | 37171.0 |
> showing 50 of 1,665 rows — these rows as CSV