PREVIEW / futures_1hour / 2022-05-11
file: by_date/futures_1hour/2022/2022-05-11.parquet size: 70 KB rows: 2,068
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-11 00:00:00 | ES | Futures | 4548.08 | 4550.35 | 4545.53 | 4550.35 | 4681.0 |
| 2022-05-11 01:00:00 | ES | Futures | 4550.35 | 4551.77 | 4545.25 | 4547.8 | 6498.0 |
| 2022-05-11 02:00:00 | ES | Futures | 4547.51 | 4554.32 | 4541.56 | 4545.81 | 11116.0 |
| 2022-05-11 03:00:00 | ES | Futures | 4545.53 | 4550.07 | 4535.89 | 4545.53 | 15799.0 |
| 2022-05-11 04:00:00 | ES | Futures | 4545.25 | 4582.09 | 4544.4 | 4579.54 | 33228.0 |
| 2022-05-11 05:00:00 | ES | Futures | 4579.26 | 4584.65 | 4576.71 | 4580.39 | 16579.0 |
| 2022-05-11 06:00:00 | ES | Futures | 4580.11 | 4584.65 | 4570.76 | 4580.96 | 14347.0 |
| 2022-05-11 07:00:00 | ES | Futures | 4580.96 | 4592.3 | 4579.26 | 4584.36 | 20246.0 |
| 2022-05-11 08:00:00 | ES | Futures | 4584.65 | 4586.06 | 4475.24 | 4484.31 | 168253.0 |
| 2022-05-11 09:00:00 | ES | Futures | 4484.31 | 4576.14 | 4480.91 | 4565.94 | 337457.0 |
| 2022-05-11 10:00:00 | ES | Futures | 4565.65 | 4586.06 | 4535.33 | 4556.87 | 277231.0 |
| 2022-05-11 11:00:00 | ES | Futures | 4556.3 | 4583.23 | 4535.04 | 4555.17 | 188857.0 |
| 2022-05-11 12:00:00 | ES | Futures | 4555.45 | 4559.14 | 4503.58 | 4505.28 | 173666.0 |
| 2022-05-11 13:00:00 | ES | Futures | 4505.0 | 4506.7 | 4462.77 | 4465.88 | 199418.0 |
| 2022-05-11 14:00:00 | ES | Futures | 4465.88 | 4518.6 | 4465.6 | 4486.58 | 211906.0 |
| 2022-05-11 15:00:00 | ES | Futures | 4486.29 | 4491.68 | 4448.59 | 4458.23 | 302857.0 |
| 2022-05-11 16:00:00 | ES | Futures | 4458.23 | 4474.95 | 4452.85 | 4470.42 | 69022.0 |
| 2022-05-11 18:00:00 | ES | Futures | 4466.73 | 4469.0 | 4453.41 | 4467.02 | 11669.0 |
| 2022-05-11 19:00:00 | ES | Futures | 4467.02 | 4474.1 | 4461.07 | 4470.14 | 8049.0 |
| 2022-05-11 20:00:00 | ES | Futures | 4470.14 | 4480.62 | 4444.63 | 4476.37 | 23619.0 |
| 2022-05-11 21:00:00 | ES | Futures | 4476.37 | 4483.17 | 4465.32 | 4478.36 | 14267.0 |
| 2022-05-11 22:00:00 | ES | Futures | 4478.36 | 4480.91 | 4464.18 | 4471.55 | 9222.0 |
| 2022-05-11 23:00:00 | ES | Futures | 4471.55 | 4474.1 | 4464.75 | 4469.0 | 8089.0 |
| 2022-05-11 00:00:00 | NQ | Futures | 14432.93 | 14445.4 | 14423.36 | 14441.63 | 1804.0 |
| 2022-05-11 01:00:00 | NQ | Futures | 14441.34 | 14454.97 | 14419.88 | 14428.29 | 3789.0 |
| 2022-05-11 02:00:00 | NQ | Futures | 14427.71 | 14451.2 | 14401.03 | 14416.98 | 6139.0 |
| 2022-05-11 03:00:00 | NQ | Futures | 14415.82 | 14422.78 | 14365.94 | 14402.19 | 10034.0 |
| 2022-05-11 04:00:00 | NQ | Futures | 14402.19 | 14519.34 | 14398.42 | 14503.39 | 12675.0 |
| 2022-05-11 05:00:00 | NQ | Futures | 14503.68 | 14530.65 | 14491.79 | 14511.22 | 8779.0 |
| 2022-05-11 06:00:00 | NQ | Futures | 14512.09 | 14545.73 | 14470.91 | 14528.91 | 9635.0 |
| 2022-05-11 07:00:00 | NQ | Futures | 14528.91 | 14560.52 | 14510.93 | 14524.85 | 11524.0 |
| 2022-05-11 08:00:00 | NQ | Futures | 14525.14 | 14537.61 | 14036.24 | 14082.35 | 74574.0 |
| 2022-05-11 09:00:00 | NQ | Futures | 14080.9 | 14473.81 | 14069.3 | 14367.39 | 137053.0 |
| 2022-05-11 10:00:00 | NQ | Futures | 14366.52 | 14416.4 | 14221.54 | 14274.02 | 122193.0 |
| 2022-05-11 11:00:00 | NQ | Futures | 14274.6 | 14372.61 | 14171.95 | 14251.4 | 81356.0 |
| 2022-05-11 12:00:00 | NQ | Futures | 14251.4 | 14277.79 | 14064.37 | 14075.97 | 77135.0 |
| 2022-05-11 13:00:00 | NQ | Futures | 14076.55 | 14084.38 | 13921.12 | 13927.79 | 77310.0 |
| 2022-05-11 14:00:00 | NQ | Futures | 13928.37 | 14113.09 | 13926.05 | 13971.87 | 75518.0 |
| 2022-05-11 15:00:00 | NQ | Futures | 13972.45 | 13985.5 | 13847.47 | 13889.51 | 93018.0 |
| 2022-05-11 16:00:00 | NQ | Futures | 13889.51 | 13949.83 | 13873.86 | 13932.14 | 21986.0 |
| 2022-05-11 18:00:00 | NQ | Futures | 13924.02 | 13925.47 | 13861.1 | 13918.51 | 6812.0 |
| 2022-05-11 19:00:00 | NQ | Futures | 13918.8 | 13942.29 | 13890.38 | 13928.95 | 4312.0 |
| 2022-05-11 20:00:00 | NQ | Futures | 13927.79 | 13980.28 | 13827.75 | 13966.36 | 12423.0 |
| 2022-05-11 21:00:00 | NQ | Futures | 13965.2 | 14002.6 | 13928.08 | 13983.47 | 7449.0 |
| 2022-05-11 22:00:00 | NQ | Futures | 13984.34 | 13996.23 | 13928.66 | 13958.24 | 4652.0 |
| 2022-05-11 23:00:00 | NQ | Futures | 13958.24 | 13969.26 | 13921.99 | 13939.1 | 3841.0 |
| 2022-05-11 00:00:00 | YM | Futures | 36252.7 | 36265.1 | 36235.8 | 36261.7 | 587.0 |
| 2022-05-11 01:00:00 | YM | Futures | 36262.8 | 36278.6 | 36233.5 | 36251.6 | 1254.0 |
| 2022-05-11 02:00:00 | YM | Futures | 36248.2 | 36305.7 | 36214.4 | 36243.7 | 2040.0 |
| 2022-05-11 03:00:00 | YM | Futures | 36241.4 | 36293.3 | 36177.2 | 36243.7 | 4139.0 |
> showing 50 of 2,068 rows — these rows as CSV