PREVIEW / futures_1hour / 2022-05-24
file: by_date/futures_1hour/2022/2022-05-24.parquet size: 67 KB rows: 2,026
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-05-24 00:00:00 | ES | Futures | 4468.15 | 4469.29 | 4459.08 | 4460.22 | 4768.0 |
| 2022-05-24 01:00:00 | ES | Futures | 4460.22 | 4463.05 | 4445.76 | 4447.74 | 14234.0 |
| 2022-05-24 02:00:00 | ES | Futures | 4447.46 | 4453.13 | 4436.69 | 4443.49 | 17161.0 |
| 2022-05-24 03:00:00 | ES | Futures | 4443.49 | 4454.83 | 4432.72 | 4446.33 | 25768.0 |
| 2022-05-24 04:00:00 | ES | Futures | 4446.33 | 4450.29 | 4433.0 | 4435.84 | 17289.0 |
| 2022-05-24 05:00:00 | ES | Futures | 4435.84 | 4452.56 | 4435.27 | 4449.73 | 11136.0 |
| 2022-05-24 06:00:00 | ES | Futures | 4450.01 | 4458.51 | 4445.48 | 4452.85 | 12859.0 |
| 2022-05-24 07:00:00 | ES | Futures | 4453.13 | 4465.32 | 4451.43 | 4453.98 | 22096.0 |
| 2022-05-24 08:00:00 | ES | Futures | 4453.98 | 4463.62 | 4446.61 | 4459.36 | 26269.0 |
| 2022-05-24 09:00:00 | ES | Futures | 4459.36 | 4465.32 | 4431.59 | 4433.29 | 186655.0 |
| 2022-05-24 10:00:00 | ES | Futures | 4433.29 | 4435.27 | 4389.92 | 4402.68 | 346560.0 |
| 2022-05-24 11:00:00 | ES | Futures | 4402.68 | 4436.41 | 4394.17 | 4427.34 | 221316.0 |
| 2022-05-24 12:00:00 | ES | Futures | 4427.05 | 4454.26 | 4414.86 | 4427.05 | 197679.0 |
| 2022-05-24 13:00:00 | ES | Futures | 4426.77 | 4447.46 | 4410.33 | 4441.51 | 153176.0 |
| 2022-05-24 14:00:00 | ES | Futures | 4441.51 | 4461.35 | 4424.5 | 4433.86 | 198596.0 |
| 2022-05-24 15:00:00 | ES | Futures | 4433.86 | 4483.46 | 4432.15 | 4470.7 | 391308.0 |
| 2022-05-24 16:00:00 | ES | Futures | 4470.99 | 4480.62 | 4467.02 | 4478.36 | 63842.0 |
| 2022-05-24 18:00:00 | ES | Futures | 4478.36 | 4492.53 | 4478.07 | 4488.56 | 8779.0 |
| 2022-05-24 19:00:00 | ES | Futures | 4488.84 | 4493.94 | 4486.01 | 4488.28 | 5516.0 |
| 2022-05-24 20:00:00 | ES | Futures | 4487.99 | 4488.28 | 4469.57 | 4477.5 | 12793.0 |
| 2022-05-24 21:00:00 | ES | Futures | 4477.5 | 4485.44 | 4477.22 | 4483.74 | 7507.0 |
| 2022-05-24 22:00:00 | ES | Futures | 4484.02 | 4490.83 | 4481.76 | 4485.72 | 6433.0 |
| 2022-05-24 23:00:00 | ES | Futures | 4485.72 | 4499.9 | 4485.44 | 4498.2 | 5888.0 |
| 2022-05-24 00:00:00 | NQ | Futures | 13770.62 | 13775.26 | 13736.12 | 13740.76 | 2381.0 |
| 2022-05-24 01:00:00 | NQ | Futures | 13739.6 | 13749.75 | 13687.69 | 13702.48 | 6140.0 |
| 2022-05-24 02:00:00 | NQ | Futures | 13700.74 | 13718.72 | 13632.89 | 13665.07 | 9985.0 |
| 2022-05-24 03:00:00 | NQ | Futures | 13664.2 | 13712.63 | 13635.5 | 13689.72 | 14394.0 |
| 2022-05-24 04:00:00 | NQ | Futures | 13690.01 | 13707.99 | 13656.66 | 13669.13 | 10306.0 |
| 2022-05-24 05:00:00 | NQ | Futures | 13669.42 | 13727.42 | 13665.07 | 13716.69 | 6232.0 |
| 2022-05-24 06:00:00 | NQ | Futures | 13717.56 | 13741.92 | 13700.74 | 13720.46 | 7034.0 |
| 2022-05-24 07:00:00 | NQ | Futures | 13720.75 | 13776.13 | 13713.5 | 13726.26 | 13063.0 |
| 2022-05-24 08:00:00 | NQ | Futures | 13725.39 | 13754.68 | 13692.04 | 13732.35 | 13930.0 |
| 2022-05-24 09:00:00 | NQ | Futures | 13732.93 | 13745.98 | 13542.12 | 13546.47 | 84824.0 |
| 2022-05-24 10:00:00 | NQ | Futures | 13545.6 | 13547.63 | 13427.29 | 13485.0 | 120450.0 |
| 2022-05-24 11:00:00 | NQ | Futures | 13485.29 | 13614.62 | 13468.47 | 13579.24 | 76069.0 |
| 2022-05-24 12:00:00 | NQ | Futures | 13578.66 | 13694.65 | 13530.24 | 13572.28 | 72266.0 |
| 2022-05-24 13:00:00 | NQ | Futures | 13569.96 | 13645.65 | 13504.43 | 13616.94 | 56283.0 |
| 2022-05-24 14:00:00 | NQ | Futures | 13616.36 | 13685.66 | 13512.84 | 13546.47 | 64163.0 |
| 2022-05-24 15:00:00 | NQ | Futures | 13546.47 | 13723.65 | 13539.22 | 13665.65 | 96998.0 |
| 2022-05-24 16:00:00 | NQ | Futures | 13666.52 | 13709.73 | 13660.14 | 13699.29 | 17614.0 |
| 2022-05-24 18:00:00 | NQ | Futures | 13696.1 | 13752.65 | 13696.1 | 13742.5 | 5586.0 |
| 2022-05-24 19:00:00 | NQ | Futures | 13742.21 | 13767.44 | 13737.57 | 13749.75 | 3898.0 |
| 2022-05-24 20:00:00 | NQ | Futures | 13749.46 | 13749.46 | 13672.61 | 13705.38 | 7661.0 |
| 2022-05-24 21:00:00 | NQ | Futures | 13703.93 | 13734.38 | 13702.19 | 13727.71 | 4067.0 |
| 2022-05-24 22:00:00 | NQ | Futures | 13728.0 | 13758.74 | 13723.07 | 13739.02 | 4621.0 |
| 2022-05-24 23:00:00 | NQ | Futures | 13739.31 | 13794.11 | 13733.8 | 13786.28 | 4535.0 |
| 2022-05-24 00:00:00 | YM | Futures | 35744.3 | 35752.2 | 35682.3 | 35693.5 | 738.0 |
| 2022-05-24 01:00:00 | YM | Futures | 35691.3 | 35713.8 | 35592.1 | 35610.1 | 2397.0 |
| 2022-05-24 02:00:00 | YM | Futures | 35606.7 | 35647.3 | 35551.5 | 35597.7 | 3323.0 |
| 2022-05-24 03:00:00 | YM | Futures | 35598.9 | 35672.1 | 35514.3 | 35610.1 | 4123.0 |
> showing 50 of 2,026 rows — these rows as CSV