PREVIEW / futures_1hour / 2022-11-22
file: by_date/futures_1hour/2022/2022-11-22.parquet size: 66 KB rows: 2,024
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-22 00:00:00 | ES | Futures | 4468.01 | 4468.3 | 4461.25 | 4462.38 | 4916.0 |
| 2022-11-22 01:00:00 | ES | Futures | 4462.09 | 4464.63 | 4459.27 | 4460.4 | 5135.0 |
| 2022-11-22 02:00:00 | ES | Futures | 4460.68 | 4464.07 | 4455.05 | 4461.25 | 8380.0 |
| 2022-11-22 03:00:00 | ES | Futures | 4461.25 | 4463.22 | 4448.56 | 4455.05 | 25834.0 |
| 2022-11-22 04:00:00 | ES | Futures | 4455.05 | 4476.19 | 4454.2 | 4474.5 | 33223.0 |
| 2022-11-22 05:00:00 | ES | Futures | 4474.22 | 4475.91 | 4467.73 | 4470.83 | 14768.0 |
| 2022-11-22 06:00:00 | ES | Futures | 4470.83 | 4472.81 | 4461.25 | 4468.01 | 21204.0 |
| 2022-11-22 07:00:00 | ES | Futures | 4468.01 | 4475.91 | 4465.48 | 4474.5 | 17110.0 |
| 2022-11-22 08:00:00 | ES | Futures | 4474.22 | 4486.05 | 4474.22 | 4485.21 | 28627.0 |
| 2022-11-22 09:00:00 | ES | Futures | 4485.49 | 4487.75 | 4468.3 | 4476.75 | 136723.0 |
| 2022-11-22 10:00:00 | ES | Futures | 4477.03 | 4498.46 | 4474.5 | 4496.77 | 192130.0 |
| 2022-11-22 11:00:00 | ES | Futures | 4496.77 | 4497.61 | 4485.77 | 4494.23 | 101870.0 |
| 2022-11-22 12:00:00 | ES | Futures | 4494.51 | 4499.59 | 4492.26 | 4494.79 | 70182.0 |
| 2022-11-22 13:00:00 | ES | Futures | 4494.79 | 4508.89 | 4492.82 | 4506.63 | 84974.0 |
| 2022-11-22 14:00:00 | ES | Futures | 4506.91 | 4512.27 | 4502.4 | 4511.14 | 88313.0 |
| 2022-11-22 15:00:00 | ES | Futures | 4510.86 | 4524.39 | 4510.02 | 4521.57 | 195448.0 |
| 2022-11-22 16:00:00 | ES | Futures | 4521.86 | 4522.42 | 4518.19 | 4520.73 | 49089.0 |
| 2022-11-22 18:00:00 | ES | Futures | 4521.57 | 4523.83 | 4520.16 | 4522.98 | 5504.0 |
| 2022-11-22 19:00:00 | ES | Futures | 4522.7 | 4526.37 | 4520.73 | 4521.57 | 6399.0 |
| 2022-11-22 20:00:00 | ES | Futures | 4521.29 | 4521.57 | 4518.19 | 4519.88 | 8211.0 |
| 2022-11-22 21:00:00 | ES | Futures | 4519.6 | 4521.29 | 4517.06 | 4521.29 | 4311.0 |
| 2022-11-22 22:00:00 | ES | Futures | 4521.01 | 4521.29 | 4518.47 | 4519.32 | 3847.0 |
| 2022-11-22 23:00:00 | ES | Futures | 4519.32 | 4519.88 | 4517.34 | 4519.04 | 3310.0 |
| 2022-11-22 00:00:00 | NQ | Futures | 13337.09 | 13338.53 | 13310.66 | 13312.96 | 3389.0 |
| 2022-11-22 01:00:00 | NQ | Futures | 13312.1 | 13323.59 | 13299.74 | 13306.35 | 3241.0 |
| 2022-11-22 02:00:00 | NQ | Futures | 13306.64 | 13323.88 | 13287.67 | 13315.54 | 4525.0 |
| 2022-11-22 03:00:00 | NQ | Futures | 13314.97 | 13318.42 | 13247.45 | 13278.48 | 12584.0 |
| 2022-11-22 04:00:00 | NQ | Futures | 13277.62 | 13359.5 | 13276.18 | 13349.16 | 13723.0 |
| 2022-11-22 05:00:00 | NQ | Futures | 13348.87 | 13353.76 | 13326.46 | 13341.12 | 5927.0 |
| 2022-11-22 06:00:00 | NQ | Futures | 13340.25 | 13348.01 | 13292.27 | 13314.68 | 9577.0 |
| 2022-11-22 07:00:00 | NQ | Futures | 13315.54 | 13348.01 | 13307.79 | 13341.4 | 7665.0 |
| 2022-11-22 08:00:00 | NQ | Futures | 13340.83 | 13379.62 | 13340.25 | 13374.45 | 14392.0 |
| 2022-11-22 09:00:00 | NQ | Futures | 13374.73 | 13380.19 | 13248.31 | 13269.86 | 68501.0 |
| 2022-11-22 10:00:00 | NQ | Futures | 13270.43 | 13394.56 | 13262.96 | 13390.54 | 92814.0 |
| 2022-11-22 11:00:00 | NQ | Futures | 13390.82 | 13396.57 | 13350.31 | 13381.63 | 56647.0 |
| 2022-11-22 12:00:00 | NQ | Futures | 13382.2 | 13410.65 | 13379.9 | 13393.7 | 42962.0 |
| 2022-11-22 13:00:00 | NQ | Futures | 13393.98 | 13446.85 | 13382.78 | 13444.84 | 56267.0 |
| 2022-11-22 14:00:00 | NQ | Futures | 13445.13 | 13455.18 | 13417.26 | 13446.28 | 47707.0 |
| 2022-11-22 15:00:00 | NQ | Futures | 13445.99 | 13514.95 | 13443.12 | 13506.04 | 55416.0 |
| 2022-11-22 16:00:00 | NQ | Futures | 13506.04 | 13509.49 | 13485.35 | 13491.96 | 12086.0 |
| 2022-11-22 18:00:00 | NQ | Futures | 13494.55 | 13506.33 | 13490.81 | 13498.28 | 2316.0 |
| 2022-11-22 19:00:00 | NQ | Futures | 13498.86 | 13511.21 | 13488.8 | 13491.1 | 2486.0 |
| 2022-11-22 20:00:00 | NQ | Futures | 13490.81 | 13491.39 | 13471.85 | 13481.04 | 3101.0 |
| 2022-11-22 21:00:00 | NQ | Futures | 13480.76 | 13489.09 | 13473.29 | 13489.09 | 1746.0 |
| 2022-11-22 22:00:00 | NQ | Futures | 13489.38 | 13489.38 | 13476.73 | 13479.03 | 1389.0 |
| 2022-11-22 23:00:00 | NQ | Futures | 13479.03 | 13482.19 | 13469.84 | 13478.46 | 1578.0 |
| 2022-11-22 00:00:00 | YM | Futures | 37881.0 | 37883.2 | 37836.1 | 37846.2 | 1138.0 |
| 2022-11-22 01:00:00 | YM | Futures | 37844.0 | 37865.3 | 37830.5 | 37838.4 | 934.0 |
| 2022-11-22 02:00:00 | YM | Futures | 37837.2 | 37857.4 | 37796.8 | 37839.5 | 1648.0 |
| 2022-11-22 03:00:00 | YM | Futures | 37839.5 | 37859.7 | 37772.1 | 37820.4 | 3446.0 |
> showing 50 of 2,024 rows — these rows as CSV