PREVIEW / futures_1hour / 2022-11-10
file: by_date/futures_1hour/2022/2022-11-10.parquet size: 72 KB rows: 2,112
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-11-10 00:00:00 | ES | Futures | 4244.75 | 4248.42 | 4243.06 | 4244.47 | 4963.0 |
| 2022-11-10 01:00:00 | ES | Futures | 4244.75 | 4246.45 | 4240.24 | 4243.63 | 5774.0 |
| 2022-11-10 02:00:00 | ES | Futures | 4243.91 | 4247.85 | 4234.32 | 4238.27 | 11601.0 |
| 2022-11-10 03:00:00 | ES | Futures | 4238.83 | 4250.67 | 4236.3 | 4243.06 | 15571.0 |
| 2022-11-10 04:00:00 | ES | Futures | 4243.06 | 4248.42 | 4239.96 | 4245.88 | 11584.0 |
| 2022-11-10 05:00:00 | ES | Futures | 4245.88 | 4249.55 | 4237.14 | 4249.26 | 13549.0 |
| 2022-11-10 06:00:00 | ES | Futures | 4249.26 | 4252.65 | 4239.12 | 4246.45 | 22762.0 |
| 2022-11-10 07:00:00 | ES | Futures | 4246.45 | 4249.26 | 4240.53 | 4246.16 | 20702.0 |
| 2022-11-10 08:00:00 | ES | Futures | 4245.88 | 4378.09 | 4230.1 | 4372.73 | 230425.0 |
| 2022-11-10 09:00:00 | ES | Futures | 4372.73 | 4412.48 | 4363.71 | 4411.92 | 414027.0 |
| 2022-11-10 10:00:00 | ES | Futures | 4411.92 | 4422.35 | 4391.06 | 4419.81 | 353606.0 |
| 2022-11-10 11:00:00 | ES | Futures | 4419.53 | 4437.85 | 4407.97 | 4435.88 | 209517.0 |
| 2022-11-10 12:00:00 | ES | Futures | 4435.88 | 4435.88 | 4402.61 | 4404.02 | 157083.0 |
| 2022-11-10 13:00:00 | ES | Futures | 4404.02 | 4431.93 | 4404.02 | 4428.83 | 153175.0 |
| 2022-11-10 14:00:00 | ES | Futures | 4428.83 | 4441.23 | 4425.17 | 4440.11 | 118092.0 |
| 2022-11-10 15:00:00 | ES | Futures | 4439.82 | 4471.4 | 4437.01 | 4466.32 | 392198.0 |
| 2022-11-10 16:00:00 | ES | Futures | 4466.6 | 4480.42 | 4463.79 | 4479.85 | 112860.0 |
| 2022-11-10 18:00:00 | ES | Futures | 4479.85 | 4481.54 | 4471.11 | 4478.73 | 12010.0 |
| 2022-11-10 19:00:00 | ES | Futures | 4478.73 | 4480.7 | 4467.73 | 4474.22 | 13983.0 |
| 2022-11-10 20:00:00 | ES | Futures | 4473.93 | 4478.73 | 4463.5 | 4464.35 | 18243.0 |
| 2022-11-10 21:00:00 | ES | Futures | 4464.35 | 4474.78 | 4464.07 | 4469.14 | 9918.0 |
| 2022-11-10 22:00:00 | ES | Futures | 4468.86 | 4469.42 | 4462.09 | 4466.89 | 7999.0 |
| 2022-11-10 23:00:00 | ES | Futures | 4466.89 | 4475.62 | 4464.35 | 4475.62 | 7108.0 |
| 2022-11-10 00:00:00 | NQ | Futures | 12502.12 | 12517.35 | 12496.66 | 12502.41 | 3242.0 |
| 2022-11-10 01:00:00 | NQ | Futures | 12503.56 | 12509.02 | 12482.3 | 12499.54 | 3027.0 |
| 2022-11-10 02:00:00 | NQ | Futures | 12498.96 | 12512.18 | 12458.16 | 12477.41 | 5670.0 |
| 2022-11-10 03:00:00 | NQ | Futures | 12478.85 | 12513.04 | 12470.81 | 12484.31 | 8630.0 |
| 2022-11-10 04:00:00 | NQ | Futures | 12484.31 | 12500.97 | 12469.08 | 12486.61 | 6331.0 |
| 2022-11-10 05:00:00 | NQ | Futures | 12485.75 | 12511.03 | 12461.9 | 12510.74 | 7403.0 |
| 2022-11-10 06:00:00 | NQ | Futures | 12510.74 | 12532.87 | 12474.83 | 12509.59 | 12184.0 |
| 2022-11-10 07:00:00 | NQ | Futures | 12509.59 | 12516.78 | 12485.46 | 12502.7 | 8511.0 |
| 2022-11-10 08:00:00 | NQ | Futures | 12502.7 | 13005.81 | 12421.67 | 12992.59 | 103727.0 |
| 2022-11-10 09:00:00 | NQ | Futures | 12992.88 | 13164.98 | 12951.79 | 13160.39 | 167668.0 |
| 2022-11-10 10:00:00 | NQ | Futures | 13160.67 | 13181.36 | 13054.08 | 13157.23 | 117774.0 |
| 2022-11-10 11:00:00 | NQ | Futures | 13157.51 | 13215.55 | 13111.25 | 13210.1 | 70598.0 |
| 2022-11-10 12:00:00 | NQ | Futures | 13210.38 | 13212.11 | 13127.63 | 13131.94 | 55627.0 |
| 2022-11-10 13:00:00 | NQ | Futures | 13131.94 | 13226.47 | 13130.51 | 13218.43 | 60094.0 |
| 2022-11-10 14:00:00 | NQ | Futures | 13217.85 | 13250.9 | 13201.19 | 13245.72 | 42207.0 |
| 2022-11-10 15:00:00 | NQ | Futures | 13246.01 | 13383.35 | 13231.93 | 13364.96 | 113361.0 |
| 2022-11-10 16:00:00 | NQ | Futures | 13364.39 | 13420.42 | 13351.75 | 13418.41 | 29952.0 |
| 2022-11-10 18:00:00 | NQ | Futures | 13412.09 | 13429.61 | 13384.79 | 13418.69 | 6296.0 |
| 2022-11-10 19:00:00 | NQ | Futures | 13418.41 | 13426.74 | 13380.77 | 13405.76 | 6069.0 |
| 2022-11-10 20:00:00 | NQ | Futures | 13405.48 | 13420.13 | 13360.94 | 13366.4 | 8482.0 |
| 2022-11-10 21:00:00 | NQ | Futures | 13366.11 | 13402.6 | 13365.83 | 13381.63 | 4396.0 |
| 2022-11-10 22:00:00 | NQ | Futures | 13381.34 | 13381.92 | 13355.19 | 13372.72 | 4422.0 |
| 2022-11-10 23:00:00 | NQ | Futures | 13371.86 | 13397.72 | 13362.67 | 13395.42 | 3237.0 |
| 2022-11-10 00:00:00 | YM | Futures | 36566.9 | 36592.7 | 36555.6 | 36562.4 | 811.0 |
| 2022-11-10 01:00:00 | YM | Futures | 36564.6 | 36579.2 | 36536.6 | 36565.7 | 1133.0 |
| 2022-11-10 02:00:00 | YM | Futures | 36563.5 | 36589.3 | 36496.2 | 36529.8 | 2414.0 |
| 2022-11-10 03:00:00 | YM | Futures | 36528.7 | 36619.6 | 36513.0 | 36564.6 | 3260.0 |
> showing 50 of 2,112 rows — these rows as CSV