PREVIEW / futures_1hour / 2022-02-09
file: by_date/futures_1hour/2022/2022-02-09.parquet size: 67 KB rows: 2,078
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-09 00:00:00 | ES | Futures | 5130.31 | 5132.29 | 5126.64 | 5126.64 | 5558.0 |
| 2022-02-09 01:00:00 | ES | Futures | 5126.92 | 5129.46 | 5124.09 | 5124.09 | 4960.0 |
| 2022-02-09 02:00:00 | ES | Futures | 5124.37 | 5127.48 | 5114.19 | 5119.57 | 9500.0 |
| 2022-02-09 03:00:00 | ES | Futures | 5119.28 | 5140.78 | 5116.17 | 5136.25 | 25755.0 |
| 2022-02-09 04:00:00 | ES | Futures | 5135.97 | 5141.91 | 5134.84 | 5135.69 | 11892.0 |
| 2022-02-09 05:00:00 | ES | Futures | 5135.97 | 5143.89 | 5134.55 | 5141.34 | 10050.0 |
| 2022-02-09 06:00:00 | ES | Futures | 5141.34 | 5145.87 | 5137.1 | 5144.17 | 8722.0 |
| 2022-02-09 07:00:00 | ES | Futures | 5144.17 | 5151.52 | 5142.19 | 5148.98 | 16907.0 |
| 2022-02-09 08:00:00 | ES | Futures | 5148.98 | 5154.92 | 5145.58 | 5151.24 | 25926.0 |
| 2022-02-09 09:00:00 | ES | Futures | 5151.24 | 5168.21 | 5150.67 | 5156.61 | 162808.0 |
| 2022-02-09 10:00:00 | ES | Futures | 5156.9 | 5172.73 | 5153.79 | 5172.45 | 217142.0 |
| 2022-02-09 11:00:00 | ES | Futures | 5172.73 | 5175.56 | 5158.31 | 5162.55 | 134326.0 |
| 2022-02-09 12:00:00 | ES | Futures | 5162.55 | 5171.6 | 5156.33 | 5171.04 | 105169.0 |
| 2022-02-09 13:00:00 | ES | Futures | 5171.04 | 5173.58 | 5164.81 | 5172.17 | 68509.0 |
| 2022-02-09 14:00:00 | ES | Futures | 5172.45 | 5181.78 | 5170.75 | 5171.32 | 109063.0 |
| 2022-02-09 15:00:00 | ES | Futures | 5171.32 | 5183.76 | 5160.86 | 5180.37 | 294560.0 |
| 2022-02-09 16:00:00 | ES | Futures | 5180.37 | 5186.59 | 5175.28 | 5182.35 | 71278.0 |
| 2022-02-09 18:00:00 | ES | Futures | 5183.48 | 5185.18 | 5176.69 | 5180.09 | 7055.0 |
| 2022-02-09 19:00:00 | ES | Futures | 5180.09 | 5181.22 | 5171.32 | 5171.88 | 8239.0 |
| 2022-02-09 20:00:00 | ES | Futures | 5171.88 | 5172.45 | 5162.84 | 5166.23 | 10982.0 |
| 2022-02-09 21:00:00 | ES | Futures | 5166.23 | 5168.21 | 5161.99 | 5164.81 | 8212.0 |
| 2022-02-09 22:00:00 | ES | Futures | 5164.81 | 5168.21 | 5162.84 | 5167.36 | 4567.0 |
| 2022-02-09 23:00:00 | ES | Futures | 5167.08 | 5169.62 | 5165.95 | 5168.49 | 3180.0 |
| 2022-02-09 00:00:00 | NQ | Futures | 17170.51 | 17178.33 | 17157.47 | 17158.04 | 2980.0 |
| 2022-02-09 01:00:00 | NQ | Futures | 17158.33 | 17175.14 | 17147.9 | 17154.86 | 2868.0 |
| 2022-02-09 02:00:00 | NQ | Futures | 17154.57 | 17170.51 | 17108.49 | 17136.89 | 6555.0 |
| 2022-02-09 03:00:00 | NQ | Futures | 17135.44 | 17232.24 | 17123.27 | 17211.08 | 14339.0 |
| 2022-02-09 04:00:00 | NQ | Futures | 17211.08 | 17227.89 | 17202.97 | 17206.73 | 5588.0 |
| 2022-02-09 05:00:00 | NQ | Futures | 17207.89 | 17249.92 | 17201.52 | 17238.32 | 6529.0 |
| 2022-02-09 06:00:00 | NQ | Futures | 17238.32 | 17284.12 | 17220.94 | 17275.71 | 8262.0 |
| 2022-02-09 07:00:00 | NQ | Futures | 17275.71 | 17312.23 | 17267.89 | 17299.19 | 13813.0 |
| 2022-02-09 08:00:00 | NQ | Futures | 17299.48 | 17327.01 | 17291.94 | 17295.13 | 13269.0 |
| 2022-02-09 09:00:00 | NQ | Futures | 17295.13 | 17332.51 | 17231.08 | 17248.18 | 75680.0 |
| 2022-02-09 10:00:00 | NQ | Futures | 17249.63 | 17330.49 | 17218.91 | 17328.46 | 86961.0 |
| 2022-02-09 11:00:00 | NQ | Futures | 17328.17 | 17351.06 | 17287.3 | 17303.82 | 55775.0 |
| 2022-02-09 12:00:00 | NQ | Futures | 17304.69 | 17374.83 | 17283.83 | 17371.35 | 44171.0 |
| 2022-02-09 13:00:00 | NQ | Futures | 17371.93 | 17382.65 | 17341.21 | 17368.16 | 27717.0 |
| 2022-02-09 14:00:00 | NQ | Futures | 17368.74 | 17417.43 | 17367.87 | 17377.15 | 35195.0 |
| 2022-02-09 15:00:00 | NQ | Futures | 17376.86 | 17440.33 | 17327.88 | 17439.17 | 81987.0 |
| 2022-02-09 16:00:00 | NQ | Futures | 17438.59 | 17467.86 | 17418.88 | 17449.31 | 17228.0 |
| 2022-02-09 18:00:00 | NQ | Futures | 17461.19 | 17461.19 | 17425.26 | 17439.17 | 4538.0 |
| 2022-02-09 19:00:00 | NQ | Futures | 17438.88 | 17442.36 | 17398.88 | 17402.07 | 5240.0 |
| 2022-02-09 20:00:00 | NQ | Futures | 17402.36 | 17403.52 | 17372.51 | 17384.68 | 5893.0 |
| 2022-02-09 21:00:00 | NQ | Futures | 17384.39 | 17386.13 | 17358.89 | 17368.16 | 5092.0 |
| 2022-02-09 22:00:00 | NQ | Futures | 17368.16 | 17383.23 | 17351.93 | 17374.83 | 4713.0 |
| 2022-02-09 23:00:00 | NQ | Futures | 17374.83 | 17391.06 | 17372.8 | 17383.52 | 3159.0 |
| 2022-02-09 00:00:00 | YM | Futures | 39876.9 | 39900.5 | 39857.8 | 39857.8 | 1929.0 |
| 2022-02-09 01:00:00 | YM | Futures | 39860.1 | 39872.4 | 39836.5 | 39838.7 | 1377.0 |
| 2022-02-09 02:00:00 | YM | Futures | 39836.5 | 39858.9 | 39783.7 | 39810.6 | 3018.0 |
| 2022-02-09 03:00:00 | YM | Futures | 39809.5 | 39944.4 | 39789.3 | 39920.8 | 8471.0 |
> showing 50 of 2,078 rows — these rows as CSV