PREVIEW / futures_1hour / 2022-09-01
file: by_date/futures_1hour/2022/2022-09-01.parquet size: 67 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-09-01 00:00:00 | ES | Futures | 4450.2 | 4458.98 | 4449.91 | 4458.41 | 6404.0 |
| 2022-09-01 01:00:00 | ES | Futures | 4458.13 | 4460.39 | 4452.46 | 4455.01 | 10208.0 |
| 2022-09-01 02:00:00 | ES | Futures | 4455.29 | 4460.68 | 4443.96 | 4456.99 | 26707.0 |
| 2022-09-01 03:00:00 | ES | Futures | 4456.71 | 4464.36 | 4446.23 | 4453.59 | 27704.0 |
| 2022-09-01 04:00:00 | ES | Futures | 4453.31 | 4457.28 | 4442.83 | 4447.36 | 23082.0 |
| 2022-09-01 05:00:00 | ES | Futures | 4447.08 | 4456.14 | 4442.83 | 4452.74 | 19435.0 |
| 2022-09-01 06:00:00 | ES | Futures | 4453.03 | 4454.44 | 4448.21 | 4452.46 | 15155.0 |
| 2022-09-01 07:00:00 | ES | Futures | 4452.18 | 4473.71 | 4452.18 | 4466.34 | 28322.0 |
| 2022-09-01 08:00:00 | ES | Futures | 4466.62 | 4470.59 | 4450.48 | 4452.18 | 52467.0 |
| 2022-09-01 09:00:00 | ES | Futures | 4452.18 | 4462.09 | 4444.81 | 4454.73 | 246517.0 |
| 2022-09-01 10:00:00 | ES | Futures | 4454.73 | 4459.83 | 4423.85 | 4426.4 | 381332.0 |
| 2022-09-01 11:00:00 | ES | Futures | 4426.12 | 4452.46 | 4423.0 | 4436.03 | 265038.0 |
| 2022-09-01 12:00:00 | ES | Futures | 4435.75 | 4449.06 | 4425.83 | 4431.22 | 151249.0 |
| 2022-09-01 13:00:00 | ES | Futures | 4431.22 | 4458.69 | 4428.38 | 4446.8 | 174938.0 |
| 2022-09-01 14:00:00 | ES | Futures | 4447.08 | 4479.66 | 4443.4 | 4470.87 | 239504.0 |
| 2022-09-01 15:00:00 | ES | Futures | 4470.87 | 4499.77 | 4463.51 | 4495.52 | 322301.0 |
| 2022-09-01 16:00:00 | ES | Futures | 4495.52 | 4498.35 | 4486.74 | 4496.09 | 64462.0 |
| 2022-09-01 18:00:00 | ES | Futures | 4495.52 | 4503.17 | 4492.4 | 4495.52 | 9127.0 |
| 2022-09-01 19:00:00 | ES | Futures | 4495.8 | 4498.35 | 4491.84 | 4497.78 | 5091.0 |
| 2022-09-01 20:00:00 | ES | Futures | 4497.5 | 4498.63 | 4490.42 | 4493.82 | 8601.0 |
| 2022-09-01 21:00:00 | ES | Futures | 4493.54 | 4496.09 | 4489.29 | 4492.69 | 7038.0 |
| 2022-09-01 22:00:00 | ES | Futures | 4492.69 | 4492.69 | 4484.75 | 4489.57 | 6240.0 |
| 2022-09-01 23:00:00 | ES | Futures | 4489.57 | 4494.1 | 4489.0 | 4492.4 | 4074.0 |
| 2022-09-01 00:00:00 | NQ | Futures | 14041.11 | 14075.24 | 14038.51 | 14070.32 | 4792.0 |
| 2022-09-01 01:00:00 | NQ | Futures | 14070.03 | 14077.84 | 14048.92 | 14058.17 | 5310.0 |
| 2022-09-01 02:00:00 | NQ | Futures | 14059.33 | 14079.58 | 14014.79 | 14063.96 | 11540.0 |
| 2022-09-01 03:00:00 | NQ | Futures | 14063.67 | 14099.83 | 14034.46 | 14067.43 | 16978.0 |
| 2022-09-01 04:00:00 | NQ | Futures | 14068.59 | 14081.31 | 14027.52 | 14046.03 | 12392.0 |
| 2022-09-01 05:00:00 | NQ | Futures | 14045.74 | 14071.19 | 14017.97 | 14059.62 | 11477.0 |
| 2022-09-01 06:00:00 | NQ | Futures | 14059.91 | 14084.5 | 14052.1 | 14078.42 | 8833.0 |
| 2022-09-01 07:00:00 | NQ | Futures | 14078.13 | 14158.25 | 14076.98 | 14123.25 | 18748.0 |
| 2022-09-01 08:00:00 | NQ | Futures | 14123.83 | 14138.29 | 14068.88 | 14089.99 | 26692.0 |
| 2022-09-01 09:00:00 | NQ | Futures | 14089.7 | 14142.63 | 14046.03 | 14099.83 | 87835.0 |
| 2022-09-01 10:00:00 | NQ | Futures | 14094.91 | 14118.34 | 13944.5 | 13944.79 | 134423.0 |
| 2022-09-01 11:00:00 | NQ | Futures | 13945.08 | 13998.88 | 13912.98 | 13933.51 | 100313.0 |
| 2022-09-01 12:00:00 | NQ | Futures | 13933.22 | 13980.66 | 13904.01 | 13928.02 | 63355.0 |
| 2022-09-01 13:00:00 | NQ | Futures | 13928.88 | 14030.41 | 13919.92 | 13980.37 | 64408.0 |
| 2022-09-01 14:00:00 | NQ | Futures | 13981.24 | 14139.16 | 13966.78 | 14105.03 | 82659.0 |
| 2022-09-01 15:00:00 | NQ | Futures | 14104.16 | 14229.98 | 14093.46 | 14213.5 | 90811.0 |
| 2022-09-01 16:00:00 | NQ | Futures | 14213.79 | 14229.69 | 14181.68 | 14221.59 | 19155.0 |
| 2022-09-01 18:00:00 | NQ | Futures | 14227.96 | 14254.28 | 14207.71 | 14220.73 | 5986.0 |
| 2022-09-01 19:00:00 | NQ | Futures | 14220.73 | 14229.98 | 14201.35 | 14229.11 | 3750.0 |
| 2022-09-01 20:00:00 | NQ | Futures | 14229.4 | 14239.24 | 14206.27 | 14221.31 | 5398.0 |
| 2022-09-01 21:00:00 | NQ | Futures | 14220.44 | 14229.69 | 14209.45 | 14218.99 | 3935.0 |
| 2022-09-01 22:00:00 | NQ | Futures | 14219.57 | 14219.57 | 14179.08 | 14195.56 | 4484.0 |
| 2022-09-01 23:00:00 | NQ | Futures | 14195.56 | 14215.52 | 14193.83 | 14204.53 | 2745.0 |
| 2022-09-01 00:00:00 | YM | Futures | 35414.2 | 35477.4 | 35413.1 | 35470.6 | 837.0 |
| 2022-09-01 01:00:00 | YM | Futures | 35472.9 | 35488.7 | 35436.8 | 35455.9 | 1168.0 |
| 2022-09-01 02:00:00 | YM | Futures | 35453.7 | 35485.3 | 35378.1 | 35462.7 | 3352.0 |
| 2022-09-01 03:00:00 | YM | Futures | 35462.7 | 35499.9 | 35374.7 | 35419.8 | 4729.0 |
> showing 50 of 2,049 rows — these rows as CSV