PREVIEW / futures_1hour / 2022-02-04
file: by_date/futures_1hour/2022/2022-02-04.parquet size: 59 KB rows: 1,652
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-02-04 00:00:00 | ES | Futures | 5113.91 | 5119.85 | 5113.63 | 5119.28 | 8715.0 |
| 2022-02-04 01:00:00 | ES | Futures | 5119.28 | 5121.26 | 5115.89 | 5119.28 | 5607.0 |
| 2022-02-04 02:00:00 | ES | Futures | 5119.28 | 5122.11 | 5104.3 | 5108.54 | 13450.0 |
| 2022-02-04 03:00:00 | ES | Futures | 5108.54 | 5116.17 | 5092.13 | 5098.92 | 23003.0 |
| 2022-02-04 04:00:00 | ES | Futures | 5098.64 | 5102.6 | 5088.46 | 5091.29 | 21136.0 |
| 2022-02-04 05:00:00 | ES | Futures | 5091.29 | 5091.57 | 5059.9 | 5068.38 | 40087.0 |
| 2022-02-04 06:00:00 | ES | Futures | 5068.1 | 5068.94 | 5038.97 | 5039.25 | 43993.0 |
| 2022-02-04 07:00:00 | ES | Futures | 5039.25 | 5070.64 | 5039.25 | 5066.97 | 37433.0 |
| 2022-02-04 08:00:00 | ES | Futures | 5067.25 | 5068.66 | 5026.24 | 5031.05 | 112992.0 |
| 2022-02-04 09:00:00 | ES | Futures | 5030.77 | 5076.3 | 5020.87 | 5063.29 | 267166.0 |
| 2022-02-04 10:00:00 | ES | Futures | 5063.01 | 5080.82 | 5029.64 | 5035.01 | 278457.0 |
| 2022-02-04 11:00:00 | ES | Futures | 5035.29 | 5070.92 | 5025.39 | 5059.33 | 188749.0 |
| 2022-02-04 12:00:00 | ES | Futures | 5059.33 | 5079.69 | 5055.09 | 5078.84 | 106441.0 |
| 2022-02-04 13:00:00 | ES | Futures | 5078.84 | 5104.86 | 5078.84 | 5102.6 | 146136.0 |
| 2022-02-04 14:00:00 | ES | Futures | 5102.6 | 5108.82 | 5087.89 | 5107.12 | 141194.0 |
| 2022-02-04 15:00:00 | ES | Futures | 5107.12 | 5127.2 | 5078.56 | 5080.54 | 309122.0 |
| 2022-02-04 16:00:00 | ES | Futures | 5080.54 | 5084.5 | 5069.23 | 5074.04 | 79391.0 |
| 2022-02-04 00:00:00 | NQ | Futures | 17131.67 | 17167.61 | 17131.09 | 17161.23 | 4890.0 |
| 2022-02-04 01:00:00 | NQ | Futures | 17161.81 | 17176.88 | 17145.0 | 17165.29 | 4034.0 |
| 2022-02-04 02:00:00 | NQ | Futures | 17165.0 | 17187.03 | 17071.1 | 17091.39 | 9934.0 |
| 2022-02-04 03:00:00 | NQ | Futures | 17092.26 | 17126.17 | 17042.12 | 17077.19 | 12579.0 |
| 2022-02-04 04:00:00 | NQ | Futures | 17074.29 | 17091.1 | 17018.35 | 17025.31 | 10841.0 |
| 2022-02-04 05:00:00 | NQ | Futures | 17024.73 | 17038.64 | 16907.35 | 16952.56 | 20055.0 |
| 2022-02-04 06:00:00 | NQ | Futures | 16951.7 | 16955.17 | 16830.26 | 16833.16 | 17046.0 |
| 2022-02-04 07:00:00 | NQ | Futures | 16834.03 | 16968.5 | 16832.87 | 16957.2 | 18332.0 |
| 2022-02-04 08:00:00 | NQ | Futures | 16958.07 | 16965.61 | 16709.7 | 16714.33 | 57797.0 |
| 2022-02-04 09:00:00 | NQ | Futures | 16713.47 | 16933.15 | 16650.29 | 16896.05 | 119816.0 |
| 2022-02-04 10:00:00 | NQ | Futures | 16896.05 | 17002.7 | 16794.32 | 16812.29 | 105303.0 |
| 2022-02-04 11:00:00 | NQ | Futures | 16813.16 | 16954.3 | 16742.16 | 16904.45 | 71416.0 |
| 2022-02-04 12:00:00 | NQ | Futures | 16904.74 | 16990.82 | 16875.47 | 16985.6 | 53674.0 |
| 2022-02-04 13:00:00 | NQ | Futures | 16985.6 | 17103.27 | 16985.02 | 17092.84 | 55721.0 |
| 2022-02-04 14:00:00 | NQ | Futures | 17093.13 | 17119.5 | 17027.92 | 17106.46 | 49558.0 |
| 2022-02-04 15:00:00 | NQ | Futures | 17106.75 | 17179.78 | 17009.95 | 17018.35 | 84560.0 |
| 2022-02-04 16:00:00 | NQ | Futures | 17018.35 | 17037.19 | 16957.2 | 16977.49 | 21792.0 |
| 2022-02-04 00:00:00 | YM | Futures | 39520.7 | 39561.1 | 39519.6 | 39546.5 | 1466.0 |
| 2022-02-04 01:00:00 | YM | Futures | 39546.5 | 39569.0 | 39528.5 | 39553.3 | 1295.0 |
| 2022-02-04 02:00:00 | YM | Futures | 39551.0 | 39564.5 | 39484.7 | 39510.6 | 3615.0 |
| 2022-02-04 03:00:00 | YM | Futures | 39509.4 | 39563.4 | 39391.4 | 39425.2 | 6968.0 |
| 2022-02-04 04:00:00 | YM | Futures | 39426.3 | 39462.2 | 39391.4 | 39406.1 | 5377.0 |
| 2022-02-04 05:00:00 | YM | Futures | 39406.1 | 39407.2 | 39191.4 | 39248.7 | 11984.0 |
| 2022-02-04 06:00:00 | YM | Futures | 39248.7 | 39253.2 | 39059.9 | 39086.9 | 11173.0 |
| 2022-02-04 07:00:00 | YM | Futures | 39088.0 | 39274.6 | 39085.8 | 39234.1 | 9541.0 |
| 2022-02-04 08:00:00 | YM | Futures | 39235.2 | 39244.2 | 38985.8 | 39108.2 | 20328.0 |
| 2022-02-04 09:00:00 | YM | Futures | 39108.2 | 39395.9 | 39065.5 | 39240.9 | 41866.0 |
| 2022-02-04 10:00:00 | YM | Futures | 39240.9 | 39356.6 | 38971.1 | 39007.1 | 40623.0 |
| 2022-02-04 11:00:00 | YM | Futures | 39009.4 | 39262.2 | 38959.9 | 39189.2 | 25048.0 |
| 2022-02-04 12:00:00 | YM | Futures | 39189.2 | 39297.0 | 39164.4 | 39288.1 | 11794.0 |
| 2022-02-04 13:00:00 | YM | Futures | 39288.1 | 39425.2 | 39288.1 | 39388.1 | 17279.0 |
| 2022-02-04 14:00:00 | YM | Futures | 39389.2 | 39452.1 | 39317.3 | 39439.8 | 14415.0 |
| 2022-02-04 15:00:00 | YM | Futures | 39440.9 | 39571.3 | 39290.3 | 39302.7 | 24549.0 |
> showing 50 of 1,652 rows — these rows as CSV