PREVIEW / futures_1hour / 2022-11-14
file: by_date/futures_1hour/2022/2022-11-14.parquet size: 68 KB rows: 2,096
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-14 00:00:00 | ES | Futures | 4497.89 | 4499.87 | 4490.28 | 4490.28 | 7292.0 |
| 2022-11-14 01:00:00 | ES | Futures | 4490.28 | 4498.74 | 4490.0 | 4498.46 | 8498.0 |
| 2022-11-14 02:00:00 | ES | Futures | 4498.46 | 4502.69 | 4495.92 | 4498.46 | 9167.0 |
| 2022-11-14 03:00:00 | ES | Futures | 4498.18 | 4506.35 | 4495.36 | 4501.84 | 24149.0 |
| 2022-11-14 04:00:00 | ES | Futures | 4501.84 | 4502.4 | 4485.49 | 4487.46 | 21839.0 |
| 2022-11-14 05:00:00 | ES | Futures | 4487.18 | 4495.08 | 4484.36 | 4493.1 | 14553.0 |
| 2022-11-14 06:00:00 | ES | Futures | 4493.1 | 4497.61 | 4489.44 | 4493.1 | 14638.0 |
| 2022-11-14 07:00:00 | ES | Futures | 4493.1 | 4500.43 | 4491.13 | 4500.15 | 16800.0 |
| 2022-11-14 08:00:00 | ES | Futures | 4499.87 | 4503.25 | 4492.26 | 4494.51 | 28502.0 |
| 2022-11-14 09:00:00 | ES | Futures | 4494.23 | 4503.25 | 4481.54 | 4495.08 | 204645.0 |
| 2022-11-14 10:00:00 | ES | Futures | 4495.36 | 4516.5 | 4495.08 | 4510.3 | 208914.0 |
| 2022-11-14 11:00:00 | ES | Futures | 4510.3 | 4512.27 | 4486.62 | 4503.53 | 193143.0 |
| 2022-11-14 12:00:00 | ES | Futures | 4503.81 | 4519.32 | 4498.46 | 4512.27 | 137370.0 |
| 2022-11-14 13:00:00 | ES | Futures | 4512.55 | 4530.03 | 4509.45 | 4529.18 | 116590.0 |
| 2022-11-14 14:00:00 | ES | Futures | 4529.18 | 4530.03 | 4511.14 | 4513.68 | 111941.0 |
| 2022-11-14 15:00:00 | ES | Futures | 4513.96 | 4522.14 | 4469.7 | 4473.65 | 275916.0 |
| 2022-11-14 16:00:00 | ES | Futures | 4473.93 | 4483.24 | 4472.81 | 4482.11 | 58755.0 |
| 2022-11-14 18:00:00 | ES | Futures | 4481.83 | 4486.05 | 4480.7 | 4480.98 | 7071.0 |
| 2022-11-14 19:00:00 | ES | Futures | 4480.98 | 4483.8 | 4478.44 | 4479.29 | 6002.0 |
| 2022-11-14 20:00:00 | ES | Futures | 4479.29 | 4488.03 | 4478.44 | 4485.49 | 7732.0 |
| 2022-11-14 21:00:00 | ES | Futures | 4485.77 | 4490.85 | 4484.08 | 4490.85 | 9270.0 |
| 2022-11-14 22:00:00 | ES | Futures | 4491.13 | 4493.95 | 4489.72 | 4492.54 | 5567.0 |
| 2022-11-14 23:00:00 | ES | Futures | 4492.26 | 4492.82 | 4490.0 | 4490.56 | 3375.0 |
| 2022-11-14 00:00:00 | NQ | Futures | 13549.43 | 13556.9 | 13514.66 | 13515.24 | 5260.0 |
| 2022-11-14 01:00:00 | NQ | Futures | 13515.24 | 13547.13 | 13513.8 | 13545.4 | 4126.0 |
| 2022-11-14 02:00:00 | NQ | Futures | 13545.98 | 13569.25 | 13538.51 | 13547.42 | 5417.0 |
| 2022-11-14 03:00:00 | NQ | Futures | 13547.13 | 13575.29 | 13531.61 | 13561.78 | 16925.0 |
| 2022-11-14 04:00:00 | NQ | Futures | 13562.07 | 13564.37 | 13507.19 | 13511.79 | 9573.0 |
| 2022-11-14 05:00:00 | NQ | Futures | 13511.21 | 13536.21 | 13499.43 | 13527.59 | 6293.0 |
| 2022-11-14 06:00:00 | NQ | Futures | 13527.3 | 13539.95 | 13511.5 | 13527.59 | 5684.0 |
| 2022-11-14 07:00:00 | NQ | Futures | 13527.3 | 13564.94 | 13521.56 | 13561.21 | 8127.0 |
| 2022-11-14 08:00:00 | NQ | Futures | 13560.06 | 13567.24 | 13523.85 | 13531.9 | 13523.0 |
| 2022-11-14 09:00:00 | NQ | Futures | 13531.04 | 13549.43 | 13449.15 | 13498.28 | 84388.0 |
| 2022-11-14 10:00:00 | NQ | Futures | 13499.14 | 13581.32 | 13498.28 | 13556.04 | 85694.0 |
| 2022-11-14 11:00:00 | NQ | Futures | 13556.32 | 13592.24 | 13479.61 | 13564.94 | 71128.0 |
| 2022-11-14 12:00:00 | NQ | Futures | 13565.23 | 13623.27 | 13542.53 | 13592.81 | 49791.0 |
| 2022-11-14 13:00:00 | NQ | Futures | 13593.39 | 13670.39 | 13582.18 | 13667.52 | 42819.0 |
| 2022-11-14 14:00:00 | NQ | Futures | 13667.23 | 13674.99 | 13603.73 | 13624.13 | 38773.0 |
| 2022-11-14 15:00:00 | NQ | Futures | 13624.99 | 13657.75 | 13480.18 | 13495.41 | 75135.0 |
| 2022-11-14 16:00:00 | NQ | Futures | 13495.12 | 13530.18 | 13492.82 | 13525.58 | 16081.0 |
| 2022-11-14 18:00:00 | NQ | Futures | 13525.58 | 13543.39 | 13523.57 | 13523.57 | 3604.0 |
| 2022-11-14 19:00:00 | NQ | Futures | 13523.85 | 13536.21 | 13517.82 | 13521.56 | 3163.0 |
| 2022-11-14 20:00:00 | NQ | Futures | 13522.71 | 13555.46 | 13518.4 | 13547.99 | 4582.0 |
| 2022-11-14 21:00:00 | NQ | Futures | 13548.28 | 13568.39 | 13540.23 | 13566.95 | 4101.0 |
| 2022-11-14 22:00:00 | NQ | Futures | 13566.38 | 13576.15 | 13560.06 | 13570.98 | 3373.0 |
| 2022-11-14 23:00:00 | NQ | Futures | 13570.4 | 13575.29 | 13564.08 | 13567.24 | 2571.0 |
| 2022-11-14 00:00:00 | YM | Futures | 37808.1 | 37818.2 | 37772.1 | 37774.4 | 1695.0 |
| 2022-11-14 01:00:00 | YM | Futures | 37774.4 | 37821.5 | 37764.3 | 37820.4 | 1615.0 |
| 2022-11-14 02:00:00 | YM | Futures | 37820.4 | 37839.5 | 37800.2 | 37814.8 | 2392.0 |
| 2022-11-14 03:00:00 | YM | Futures | 37815.9 | 37876.5 | 37799.1 | 37847.3 | 7774.0 |
> showing 50 of 2,096 rows — these rows as CSV