PREVIEW / futures_1hour / 2022-11-15
file: by_date/futures_1hour/2022/2022-11-15.parquet size: 70 KB rows: 2,086
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-15 00:00:00 | ES | Futures | 4490.56 | 4496.2 | 4489.72 | 4492.82 | 5822.0 |
| 2022-11-15 01:00:00 | ES | Futures | 4492.54 | 4497.33 | 4492.26 | 4496.77 | 4771.0 |
| 2022-11-15 02:00:00 | ES | Futures | 4496.77 | 4506.63 | 4495.92 | 4499.87 | 14262.0 |
| 2022-11-15 03:00:00 | ES | Futures | 4499.87 | 4503.25 | 4494.51 | 4501.0 | 20375.0 |
| 2022-11-15 04:00:00 | ES | Futures | 4501.0 | 4504.1 | 4497.05 | 4501.28 | 15255.0 |
| 2022-11-15 05:00:00 | ES | Futures | 4501.28 | 4509.73 | 4501.0 | 4503.53 | 14253.0 |
| 2022-11-15 06:00:00 | ES | Futures | 4503.53 | 4508.89 | 4499.02 | 4505.51 | 15809.0 |
| 2022-11-15 07:00:00 | ES | Futures | 4505.79 | 4518.19 | 4500.71 | 4516.5 | 31190.0 |
| 2022-11-15 08:00:00 | ES | Futures | 4516.5 | 4567.52 | 4515.37 | 4555.12 | 112984.0 |
| 2022-11-15 09:00:00 | ES | Futures | 4555.12 | 4556.25 | 4527.21 | 4546.1 | 258944.0 |
| 2022-11-15 10:00:00 | ES | Futures | 4546.1 | 4552.58 | 4525.52 | 4530.59 | 261444.0 |
| 2022-11-15 11:00:00 | ES | Futures | 4530.59 | 4545.53 | 4520.45 | 4541.31 | 206766.0 |
| 2022-11-15 12:00:00 | ES | Futures | 4541.31 | 4542.72 | 4521.01 | 4527.49 | 138976.0 |
| 2022-11-15 13:00:00 | ES | Futures | 4527.49 | 4531.16 | 4465.19 | 4487.18 | 362500.0 |
| 2022-11-15 14:00:00 | ES | Futures | 4487.18 | 4517.91 | 4469.7 | 4512.55 | 316249.0 |
| 2022-11-15 15:00:00 | ES | Futures | 4512.83 | 4522.42 | 4498.18 | 4511.43 | 280963.0 |
| 2022-11-15 16:00:00 | ES | Futures | 4511.14 | 4517.06 | 4500.71 | 4504.38 | 57043.0 |
| 2022-11-15 18:00:00 | ES | Futures | 4501.28 | 4506.07 | 4491.97 | 4505.79 | 11307.0 |
| 2022-11-15 19:00:00 | ES | Futures | 4505.51 | 4506.63 | 4488.87 | 4489.16 | 14406.0 |
| 2022-11-15 20:00:00 | ES | Futures | 4489.16 | 4499.02 | 4488.31 | 4498.18 | 14223.0 |
| 2022-11-15 21:00:00 | ES | Futures | 4498.18 | 4509.17 | 4496.48 | 4505.51 | 17648.0 |
| 2022-11-15 22:00:00 | ES | Futures | 4505.51 | 4509.45 | 4501.28 | 4505.22 | 9861.0 |
| 2022-11-15 23:00:00 | ES | Futures | 4505.22 | 4505.22 | 4497.05 | 4498.18 | 5739.0 |
| 2022-11-15 00:00:00 | NQ | Futures | 13567.24 | 13593.39 | 13565.52 | 13581.61 | 3822.0 |
| 2022-11-15 01:00:00 | NQ | Futures | 13581.32 | 13599.13 | 13579.6 | 13598.85 | 3210.0 |
| 2022-11-15 02:00:00 | NQ | Futures | 13598.56 | 13633.04 | 13595.4 | 13610.63 | 7891.0 |
| 2022-11-15 03:00:00 | NQ | Futures | 13611.49 | 13626.72 | 13589.37 | 13617.52 | 10193.0 |
| 2022-11-15 04:00:00 | NQ | Futures | 13618.1 | 13632.18 | 13605.74 | 13626.14 | 8299.0 |
| 2022-11-15 05:00:00 | NQ | Futures | 13625.28 | 13653.44 | 13622.98 | 13645.68 | 7667.0 |
| 2022-11-15 06:00:00 | NQ | Futures | 13644.53 | 13657.75 | 13628.15 | 13652.0 | 7437.0 |
| 2022-11-15 07:00:00 | NQ | Futures | 13652.29 | 13700.27 | 13628.44 | 13694.24 | 14635.0 |
| 2022-11-15 08:00:00 | NQ | Futures | 13693.38 | 13928.12 | 13690.22 | 13876.98 | 70955.0 |
| 2022-11-15 09:00:00 | NQ | Futures | 13877.27 | 13882.15 | 13749.12 | 13827.56 | 99963.0 |
| 2022-11-15 10:00:00 | NQ | Futures | 13827.27 | 13854.57 | 13747.11 | 13770.67 | 87378.0 |
| 2022-11-15 11:00:00 | NQ | Futures | 13772.1 | 13842.21 | 13726.71 | 13834.17 | 70844.0 |
| 2022-11-15 12:00:00 | NQ | Futures | 13834.45 | 13837.04 | 13758.03 | 13779.29 | 46068.0 |
| 2022-11-15 13:00:00 | NQ | Futures | 13779.57 | 13792.79 | 13520.98 | 13612.64 | 119303.0 |
| 2022-11-15 14:00:00 | NQ | Futures | 13612.64 | 13716.36 | 13537.93 | 13699.7 | 95547.0 |
| 2022-11-15 15:00:00 | NQ | Futures | 13700.27 | 13736.48 | 13645.39 | 13683.03 | 71171.0 |
| 2022-11-15 16:00:00 | NQ | Futures | 13683.32 | 13719.24 | 13654.01 | 13669.82 | 19704.0 |
| 2022-11-15 18:00:00 | NQ | Futures | 13656.02 | 13676.42 | 13627.29 | 13675.28 | 5620.0 |
| 2022-11-15 19:00:00 | NQ | Futures | 13674.99 | 13680.73 | 13608.62 | 13610.63 | 7353.0 |
| 2022-11-15 20:00:00 | NQ | Futures | 13610.63 | 13651.71 | 13606.03 | 13647.69 | 7625.0 |
| 2022-11-15 21:00:00 | NQ | Futures | 13647.98 | 13683.32 | 13642.81 | 13666.66 | 6574.0 |
| 2022-11-15 22:00:00 | NQ | Futures | 13667.52 | 13686.77 | 13649.99 | 13666.66 | 4720.0 |
| 2022-11-15 23:00:00 | NQ | Futures | 13666.08 | 13666.94 | 13631.31 | 13636.77 | 3996.0 |
| 2022-11-15 00:00:00 | YM | Futures | 37786.7 | 37822.6 | 37780.0 | 37795.7 | 1244.0 |
| 2022-11-15 01:00:00 | YM | Futures | 37794.6 | 37821.5 | 37791.2 | 37818.2 | 1062.0 |
| 2022-11-15 02:00:00 | YM | Futures | 37817.0 | 37886.6 | 37812.5 | 37835.0 | 3053.0 |
| 2022-11-15 03:00:00 | YM | Futures | 37837.2 | 37858.6 | 37805.8 | 37844.0 | 3394.0 |
> showing 50 of 2,086 rows — these rows as CSV