PREVIEW / futures_1hour / 2022-10-06
file: by_date/futures_1hour/2022/2022-10-06.parquet size: 69 KB rows: 2,049
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-10-06 00:00:00 | ES | Futures | 4299.16 | 4301.13 | 4294.93 | 4300.57 | 5387.0 |
| 2022-10-06 01:00:00 | ES | Futures | 4300.85 | 4305.08 | 4298.6 | 4302.54 | 7003.0 |
| 2022-10-06 02:00:00 | ES | Futures | 4302.54 | 4302.54 | 4276.61 | 4277.45 | 19694.0 |
| 2022-10-06 03:00:00 | ES | Futures | 4277.45 | 4289.01 | 4269.84 | 4278.3 | 29451.0 |
| 2022-10-06 04:00:00 | ES | Futures | 4278.02 | 4283.37 | 4259.13 | 4263.08 | 25884.0 |
| 2022-10-06 05:00:00 | ES | Futures | 4263.36 | 4265.05 | 4249.26 | 4250.39 | 17634.0 |
| 2022-10-06 06:00:00 | ES | Futures | 4250.39 | 4252.93 | 4243.91 | 4249.26 | 23438.0 |
| 2022-10-06 07:00:00 | ES | Futures | 4249.26 | 4261.1 | 4248.7 | 4257.16 | 33229.0 |
| 2022-10-06 08:00:00 | ES | Futures | 4257.44 | 4282.25 | 4250.67 | 4270.97 | 65198.0 |
| 2022-10-06 09:00:00 | ES | Futures | 4270.97 | 4297.75 | 4259.13 | 4269.28 | 291933.0 |
| 2022-10-06 10:00:00 | ES | Futures | 4269.56 | 4272.66 | 4237.42 | 4271.82 | 378238.0 |
| 2022-10-06 11:00:00 | ES | Futures | 4271.82 | 4278.02 | 4250.67 | 4252.08 | 264577.0 |
| 2022-10-06 12:00:00 | ES | Futures | 4251.8 | 4270.69 | 4243.34 | 4261.1 | 169995.0 |
| 2022-10-06 13:00:00 | ES | Futures | 4261.1 | 4266.74 | 4252.36 | 4260.54 | 141636.0 |
| 2022-10-06 14:00:00 | ES | Futures | 4260.26 | 4260.82 | 4229.25 | 4237.99 | 184368.0 |
| 2022-10-06 15:00:00 | ES | Futures | 4238.27 | 4251.24 | 4229.53 | 4235.45 | 320941.0 |
| 2022-10-06 16:00:00 | ES | Futures | 4235.45 | 4240.81 | 4228.4 | 4229.53 | 59534.0 |
| 2022-10-06 18:00:00 | ES | Futures | 4223.61 | 4230.66 | 4219.95 | 4223.89 | 9046.0 |
| 2022-10-06 19:00:00 | ES | Futures | 4223.89 | 4232.63 | 4221.07 | 4223.89 | 7621.0 |
| 2022-10-06 20:00:00 | ES | Futures | 4223.61 | 4233.2 | 4223.33 | 4228.97 | 10973.0 |
| 2022-10-06 21:00:00 | ES | Futures | 4229.25 | 4236.02 | 4226.71 | 4234.32 | 10311.0 |
| 2022-10-06 22:00:00 | ES | Futures | 4234.32 | 4241.93 | 4231.5 | 4237.99 | 9146.0 |
| 2022-10-06 23:00:00 | ES | Futures | 4238.27 | 4239.68 | 4228.69 | 4230.94 | 7232.0 |
| 2022-10-06 00:00:00 | NQ | Futures | 13440.24 | 13449.15 | 13423.87 | 13447.43 | 2983.0 |
| 2022-10-06 01:00:00 | NQ | Futures | 13448.0 | 13466.68 | 13439.09 | 13454.9 | 4000.0 |
| 2022-10-06 02:00:00 | NQ | Futures | 13455.76 | 13455.76 | 13366.4 | 13368.41 | 11023.0 |
| 2022-10-06 03:00:00 | NQ | Futures | 13368.99 | 13408.64 | 13338.82 | 13373.58 | 18700.0 |
| 2022-10-06 04:00:00 | NQ | Futures | 13372.43 | 13386.23 | 13293.99 | 13314.68 | 15108.0 |
| 2022-10-06 05:00:00 | NQ | Futures | 13314.68 | 13323.59 | 13265.26 | 13267.85 | 11505.0 |
| 2022-10-06 06:00:00 | NQ | Futures | 13268.42 | 13276.75 | 13244.29 | 13268.42 | 12701.0 |
| 2022-10-06 07:00:00 | NQ | Futures | 13268.71 | 13319.28 | 13267.85 | 13308.36 | 13809.0 |
| 2022-10-06 08:00:00 | NQ | Futures | 13308.94 | 13402.03 | 13276.47 | 13356.92 | 30494.0 |
| 2022-10-06 09:00:00 | NQ | Futures | 13356.63 | 13471.56 | 13302.9 | 13375.02 | 112011.0 |
| 2022-10-06 10:00:00 | NQ | Futures | 13375.59 | 13382.49 | 13247.45 | 13379.33 | 131417.0 |
| 2022-10-06 11:00:00 | NQ | Futures | 13379.62 | 13412.66 | 13309.51 | 13312.96 | 94127.0 |
| 2022-10-06 12:00:00 | NQ | Futures | 13313.25 | 13381.05 | 13287.39 | 13349.16 | 61524.0 |
| 2022-10-06 13:00:00 | NQ | Futures | 13349.45 | 13377.32 | 13317.55 | 13361.8 | 51664.0 |
| 2022-10-06 14:00:00 | NQ | Futures | 13362.38 | 13363.81 | 13249.75 | 13281.64 | 58691.0 |
| 2022-10-06 15:00:00 | NQ | Futures | 13281.93 | 13318.13 | 13248.6 | 13265.55 | 81936.0 |
| 2022-10-06 16:00:00 | NQ | Futures | 13265.84 | 13281.64 | 13223.02 | 13223.6 | 20127.0 |
| 2022-10-06 18:00:00 | NQ | Futures | 13210.67 | 13233.37 | 13189.98 | 13207.8 | 5339.0 |
| 2022-10-06 19:00:00 | NQ | Futures | 13207.8 | 13243.14 | 13205.79 | 13215.55 | 4881.0 |
| 2022-10-06 20:00:00 | NQ | Futures | 13215.27 | 13250.9 | 13212.11 | 13233.37 | 4948.0 |
| 2022-10-06 21:00:00 | NQ | Futures | 13233.94 | 13268.13 | 13227.91 | 13262.68 | 4976.0 |
| 2022-10-06 22:00:00 | NQ | Futures | 13262.39 | 13291.12 | 13248.31 | 13277.33 | 4806.0 |
| 2022-10-06 23:00:00 | NQ | Futures | 13277.9 | 13282.79 | 13241.13 | 13251.76 | 3844.0 |
| 2022-10-06 00:00:00 | YM | Futures | 34157.4 | 34176.5 | 34132.7 | 34175.4 | 621.0 |
| 2022-10-06 01:00:00 | YM | Futures | 34176.5 | 34200.1 | 34156.3 | 34181.0 | 814.0 |
| 2022-10-06 02:00:00 | YM | Futures | 34183.2 | 34183.2 | 33993.6 | 33999.2 | 3584.0 |
| 2022-10-06 03:00:00 | YM | Futures | 34001.4 | 34082.2 | 33942.0 | 33993.6 | 4163.0 |
> showing 50 of 2,049 rows — these rows as CSV