PREVIEW / futures_1hour / 2024-01-10
file: by_date/futures_1hour/2024/2024-01-10.parquet size: 66 KB rows: 2,068
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 |
|---|---|---|---|---|---|---|---|
| 2024-01-10 00:00:00 | ES | Futures | 5145.12 | 5146.73 | 5143.51 | 5145.66 | 4497.0 |
| 2024-01-10 01:00:00 | ES | Futures | 5145.66 | 5147.54 | 5141.9 | 5143.78 | 4551.0 |
| 2024-01-10 02:00:00 | ES | Futures | 5143.78 | 5149.42 | 5142.97 | 5148.88 | 7846.0 |
| 2024-01-10 03:00:00 | ES | Futures | 5148.88 | 5150.76 | 5146.2 | 5149.42 | 15275.0 |
| 2024-01-10 04:00:00 | ES | Futures | 5149.42 | 5161.24 | 5148.88 | 5157.75 | 19017.0 |
| 2024-01-10 05:00:00 | ES | Futures | 5158.01 | 5158.55 | 5151.3 | 5153.18 | 13096.0 |
| 2024-01-10 06:00:00 | ES | Futures | 5153.45 | 5155.06 | 5145.12 | 5147.81 | 13959.0 |
| 2024-01-10 07:00:00 | ES | Futures | 5147.81 | 5153.45 | 5147.54 | 5149.42 | 16516.0 |
| 2024-01-10 08:00:00 | ES | Futures | 5149.42 | 5151.84 | 5145.39 | 5145.66 | 23058.0 |
| 2024-01-10 09:00:00 | ES | Futures | 5145.39 | 5164.73 | 5143.78 | 5158.01 | 175768.0 |
| 2024-01-10 10:00:00 | ES | Futures | 5157.75 | 5163.65 | 5148.61 | 5163.39 | 165006.0 |
| 2024-01-10 11:00:00 | ES | Futures | 5163.12 | 5163.92 | 5154.52 | 5160.16 | 109926.0 |
| 2024-01-10 12:00:00 | ES | Futures | 5160.16 | 5166.07 | 5156.4 | 5165.0 | 81651.0 |
| 2024-01-10 13:00:00 | ES | Futures | 5165.27 | 5171.17 | 5158.82 | 5169.29 | 124461.0 |
| 2024-01-10 14:00:00 | ES | Futures | 5169.29 | 5185.95 | 5168.22 | 5185.68 | 139312.0 |
| 2024-01-10 15:00:00 | ES | Futures | 5185.68 | 5187.56 | 5163.12 | 5177.62 | 307240.0 |
| 2024-01-10 16:00:00 | ES | Futures | 5177.62 | 5180.04 | 5176.55 | 5178.7 | 50795.0 |
| 2024-01-10 18:00:00 | ES | Futures | 5178.96 | 5181.38 | 5176.28 | 5179.77 | 5336.0 |
| 2024-01-10 19:00:00 | ES | Futures | 5179.77 | 5185.41 | 5178.7 | 5183.26 | 7512.0 |
| 2024-01-10 20:00:00 | ES | Futures | 5183.26 | 5186.48 | 5183.26 | 5185.14 | 6708.0 |
| 2024-01-10 21:00:00 | ES | Futures | 5185.41 | 5187.56 | 5184.6 | 5185.68 | 6020.0 |
| 2024-01-10 22:00:00 | ES | Futures | 5185.95 | 5189.44 | 5185.68 | 5188.9 | 4492.0 |
| 2024-01-10 23:00:00 | ES | Futures | 5188.63 | 5189.17 | 5186.75 | 5187.56 | 2724.0 |
| 2024-01-10 00:00:00 | NQ | Futures | 18255.12 | 18258.92 | 18246.71 | 18253.49 | 2147.0 |
| 2024-01-10 01:00:00 | NQ | Futures | 18252.68 | 18261.09 | 18231.8 | 18238.85 | 3083.0 |
| 2024-01-10 02:00:00 | NQ | Futures | 18239.39 | 18277.36 | 18236.14 | 18273.83 | 4842.0 |
| 2024-01-10 03:00:00 | NQ | Futures | 18274.38 | 18295.26 | 18269.22 | 18289.02 | 8513.0 |
| 2024-01-10 04:00:00 | NQ | Futures | 18288.75 | 18340.28 | 18281.43 | 18331.06 | 10781.0 |
| 2024-01-10 05:00:00 | NQ | Futures | 18330.79 | 18335.4 | 18297.43 | 18305.02 | 6371.0 |
| 2024-01-10 06:00:00 | NQ | Futures | 18306.38 | 18316.41 | 18262.44 | 18276.55 | 8498.0 |
| 2024-01-10 07:00:00 | NQ | Futures | 18276.28 | 18296.62 | 18268.41 | 18269.77 | 10126.0 |
| 2024-01-10 08:00:00 | NQ | Futures | 18270.04 | 18277.9 | 18241.02 | 18242.92 | 14084.0 |
| 2024-01-10 09:00:00 | NQ | Futures | 18242.37 | 18305.29 | 18235.05 | 18265.43 | 80030.0 |
| 2024-01-10 10:00:00 | NQ | Futures | 18265.43 | 18326.72 | 18226.64 | 18325.63 | 81475.0 |
| 2024-01-10 11:00:00 | NQ | Futures | 18325.63 | 18330.79 | 18284.41 | 18311.26 | 50147.0 |
| 2024-01-10 12:00:00 | NQ | Futures | 18311.53 | 18348.96 | 18300.14 | 18345.16 | 38060.0 |
| 2024-01-10 13:00:00 | NQ | Futures | 18345.43 | 18368.76 | 18318.31 | 18360.08 | 54001.0 |
| 2024-01-10 14:00:00 | NQ | Futures | 18360.08 | 18422.18 | 18356.55 | 18420.83 | 53631.0 |
| 2024-01-10 15:00:00 | NQ | Futures | 18420.83 | 18423.54 | 18325.63 | 18378.52 | 89269.0 |
| 2024-01-10 16:00:00 | NQ | Futures | 18378.79 | 18397.5 | 18376.62 | 18395.33 | 10621.0 |
| 2024-01-10 18:00:00 | NQ | Futures | 18393.16 | 18406.73 | 18382.05 | 18399.4 | 3360.0 |
| 2024-01-10 19:00:00 | NQ | Futures | 18399.13 | 18427.61 | 18397.78 | 18413.51 | 3998.0 |
| 2024-01-10 20:00:00 | NQ | Futures | 18413.51 | 18432.22 | 18413.23 | 18425.71 | 4297.0 |
| 2024-01-10 21:00:00 | NQ | Futures | 18425.71 | 18438.46 | 18423.27 | 18435.74 | 4356.0 |
| 2024-01-10 22:00:00 | NQ | Futures | 18435.74 | 18450.66 | 18433.85 | 18448.76 | 3407.0 |
| 2024-01-10 23:00:00 | NQ | Futures | 18448.49 | 18452.29 | 18434.93 | 18439.54 | 2875.0 |
| 2024-01-10 00:00:00 | YM | Futures | 40509.9 | 40519.6 | 40498.1 | 40514.2 | 598.0 |
| 2024-01-10 01:00:00 | YM | Futures | 40513.1 | 40524.9 | 40490.6 | 40502.4 | 698.0 |
| 2024-01-10 02:00:00 | YM | Futures | 40503.5 | 40540.0 | 40500.2 | 40528.2 | 1693.0 |
| 2024-01-10 03:00:00 | YM | Futures | 40529.2 | 40540.0 | 40500.2 | 40526.0 | 2714.0 |
> showing 50 of 2,068 rows — these rows as CSV