PREVIEW / futures_1hour / 2021-01-08
file: by_date/futures_1hour/2021/2021-01-08.parquet size: 53 KB rows: 1,566
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 |
|---|---|---|---|---|---|---|---|
| 2021-01-08 00:00:00 | ES | Futures | 4278.2 | 4283.81 | 4277.92 | 4280.16 | 7762.0 |
| 2021-01-08 01:00:00 | ES | Futures | 4280.44 | 4284.37 | 4278.76 | 4279.6 | 8644.0 |
| 2021-01-08 02:00:00 | ES | Futures | 4279.88 | 4286.06 | 4279.04 | 4281.85 | 10293.0 |
| 2021-01-08 03:00:00 | ES | Futures | 4281.57 | 4284.37 | 4271.74 | 4273.71 | 22813.0 |
| 2021-01-08 04:00:00 | ES | Futures | 4273.71 | 4274.55 | 4264.45 | 4273.99 | 19759.0 |
| 2021-01-08 05:00:00 | ES | Futures | 4274.27 | 4276.23 | 4270.34 | 4272.58 | 11572.0 |
| 2021-01-08 06:00:00 | ES | Futures | 4272.58 | 4278.2 | 4269.78 | 4273.15 | 11412.0 |
| 2021-01-08 07:00:00 | ES | Futures | 4272.87 | 4277.92 | 4271.74 | 4273.71 | 9621.0 |
| 2021-01-08 08:00:00 | ES | Futures | 4273.71 | 4279.88 | 4267.53 | 4272.02 | 41619.0 |
| 2021-01-08 09:00:00 | ES | Futures | 4272.02 | 4284.65 | 4271.46 | 4276.79 | 170719.0 |
| 2021-01-08 10:00:00 | ES | Futures | 4277.08 | 4282.69 | 4258.27 | 4277.36 | 220224.0 |
| 2021-01-08 11:00:00 | ES | Futures | 4277.36 | 4280.72 | 4266.41 | 4273.99 | 156415.0 |
| 2021-01-08 12:00:00 | ES | Futures | 4273.99 | 4278.76 | 4266.41 | 4268.66 | 95670.0 |
| 2021-01-08 13:00:00 | ES | Futures | 4268.66 | 4270.34 | 4238.06 | 4251.25 | 230484.0 |
| 2021-01-08 14:00:00 | ES | Futures | 4251.25 | 4271.74 | 4250.13 | 4270.9 | 180629.0 |
| 2021-01-08 15:00:00 | ES | Futures | 4270.9 | 4287.74 | 4270.34 | 4285.21 | 237421.0 |
| 2021-01-08 16:00:00 | ES | Futures | 4285.5 | 4293.63 | 4284.93 | 4290.83 | 52599.0 |
| 2021-01-08 00:00:00 | NQ | Futures | 15001.93 | 15017.85 | 14999.61 | 15013.22 | 2287.0 |
| 2021-01-08 01:00:00 | NQ | Futures | 15013.22 | 15021.61 | 15007.72 | 15017.56 | 2741.0 |
| 2021-01-08 02:00:00 | NQ | Futures | 15016.98 | 15036.37 | 15008.88 | 15028.85 | 7353.0 |
| 2021-01-08 03:00:00 | NQ | Futures | 15027.98 | 15042.45 | 15011.19 | 15019.3 | 8140.0 |
| 2021-01-08 04:00:00 | NQ | Futures | 15018.43 | 15027.4 | 14990.35 | 15026.53 | 7788.0 |
| 2021-01-08 05:00:00 | NQ | Futures | 15026.24 | 15034.64 | 15015.24 | 15023.06 | 3393.0 |
| 2021-01-08 06:00:00 | NQ | Futures | 15022.77 | 15040.42 | 15014.38 | 15024.51 | 4647.0 |
| 2021-01-08 07:00:00 | NQ | Futures | 15023.64 | 15056.34 | 15022.77 | 15041.29 | 7837.0 |
| 2021-01-08 08:00:00 | NQ | Futures | 15041.87 | 15069.08 | 15028.27 | 15046.79 | 13370.0 |
| 2021-01-08 09:00:00 | NQ | Futures | 15046.5 | 15110.76 | 15034.06 | 15071.97 | 70693.0 |
| 2021-01-08 10:00:00 | NQ | Futures | 15072.26 | 15113.65 | 14995.56 | 15086.44 | 82613.0 |
| 2021-01-08 11:00:00 | NQ | Futures | 15087.02 | 15117.99 | 15049.4 | 15088.76 | 49995.0 |
| 2021-01-08 12:00:00 | NQ | Futures | 15088.47 | 15126.68 | 15060.97 | 15089.34 | 38357.0 |
| 2021-01-08 13:00:00 | NQ | Futures | 15088.76 | 15098.89 | 14966.33 | 15036.37 | 64579.0 |
| 2021-01-08 14:00:00 | NQ | Futures | 15036.37 | 15106.13 | 15033.48 | 15100.34 | 48637.0 |
| 2021-01-08 15:00:00 | NQ | Futures | 15100.05 | 15171.54 | 15092.81 | 15157.07 | 55217.0 |
| 2021-01-08 16:00:00 | NQ | Futures | 15156.2 | 15195.27 | 15151.86 | 15193.25 | 12160.0 |
| 2021-01-08 00:00:00 | YM | Futures | 34476.0 | 34521.5 | 34474.9 | 34496.0 | 1910.0 |
| 2021-01-08 01:00:00 | YM | Futures | 34497.1 | 34549.2 | 34492.6 | 34500.4 | 2659.0 |
| 2021-01-08 02:00:00 | YM | Futures | 34501.5 | 34545.9 | 34481.5 | 34500.4 | 2981.0 |
| 2021-01-08 03:00:00 | YM | Futures | 34498.2 | 34524.8 | 34415.0 | 34432.7 | 5655.0 |
| 2021-01-08 04:00:00 | YM | Futures | 34435.0 | 34438.3 | 34354.0 | 34427.2 | 5686.0 |
| 2021-01-08 05:00:00 | YM | Futures | 34428.3 | 34446.1 | 34397.3 | 34407.2 | 2481.0 |
| 2021-01-08 06:00:00 | YM | Futures | 34407.2 | 34451.6 | 34389.5 | 34403.9 | 2378.0 |
| 2021-01-08 07:00:00 | YM | Futures | 34402.8 | 34436.1 | 34391.7 | 34407.2 | 2166.0 |
| 2021-01-08 08:00:00 | YM | Futures | 34409.5 | 34451.6 | 34349.6 | 34374.0 | 6153.0 |
| 2021-01-08 09:00:00 | YM | Futures | 34374.0 | 34432.7 | 34287.4 | 34331.8 | 21318.0 |
| 2021-01-08 10:00:00 | YM | Futures | 34330.7 | 34357.3 | 34185.4 | 34320.7 | 25736.0 |
| 2021-01-08 11:00:00 | YM | Futures | 34320.7 | 34337.4 | 34203.1 | 34271.9 | 16954.0 |
| 2021-01-08 12:00:00 | YM | Futures | 34271.9 | 34299.6 | 34218.7 | 34227.5 | 10686.0 |
| 2021-01-08 13:00:00 | YM | Futures | 34226.4 | 34229.8 | 34037.9 | 34111.1 | 25961.0 |
| 2021-01-08 14:00:00 | YM | Futures | 34112.2 | 34284.1 | 34103.3 | 34281.9 | 17853.0 |
| 2021-01-08 15:00:00 | YM | Futures | 34281.9 | 34409.5 | 34278.6 | 34375.1 | 21470.0 |
> showing 50 of 1,566 rows — these rows as CSV