PREVIEW / futures_1hour / 2022-11-16
file: by_date/futures_1hour/2022/2022-11-16.parquet size: 69 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-11-16 00:00:00 | ES | Futures | 4498.46 | 4517.63 | 4495.64 | 4515.65 | 13368.0 |
| 2022-11-16 01:00:00 | ES | Futures | 4515.65 | 4519.04 | 4509.73 | 4518.19 | 7688.0 |
| 2022-11-16 02:00:00 | ES | Futures | 4518.47 | 4528.06 | 4511.43 | 4524.39 | 15455.0 |
| 2022-11-16 03:00:00 | ES | Futures | 4524.67 | 4527.49 | 4516.22 | 4518.19 | 15565.0 |
| 2022-11-16 04:00:00 | ES | Futures | 4518.47 | 4521.57 | 4512.27 | 4519.04 | 16354.0 |
| 2022-11-16 05:00:00 | ES | Futures | 4519.32 | 4527.49 | 4515.09 | 4516.5 | 14498.0 |
| 2022-11-16 06:00:00 | ES | Futures | 4516.5 | 4518.19 | 4505.22 | 4508.89 | 24177.0 |
| 2022-11-16 07:00:00 | ES | Futures | 4508.61 | 4512.27 | 4502.69 | 4511.43 | 17577.0 |
| 2022-11-16 08:00:00 | ES | Futures | 4511.43 | 4513.4 | 4490.85 | 4493.1 | 53903.0 |
| 2022-11-16 09:00:00 | ES | Futures | 4493.38 | 4502.12 | 4478.73 | 4485.49 | 185597.0 |
| 2022-11-16 10:00:00 | ES | Futures | 4485.49 | 4495.36 | 4472.24 | 4476.19 | 198043.0 |
| 2022-11-16 11:00:00 | ES | Futures | 4476.19 | 4492.54 | 4474.78 | 4487.46 | 134237.0 |
| 2022-11-16 12:00:00 | ES | Futures | 4487.46 | 4500.43 | 4478.16 | 4489.44 | 131488.0 |
| 2022-11-16 13:00:00 | ES | Futures | 4489.44 | 4491.69 | 4471.4 | 4473.09 | 105945.0 |
| 2022-11-16 14:00:00 | ES | Futures | 4473.09 | 4483.8 | 4469.14 | 4483.24 | 138053.0 |
| 2022-11-16 15:00:00 | ES | Futures | 4483.24 | 4484.36 | 4467.45 | 4475.91 | 233073.0 |
| 2022-11-16 16:00:00 | ES | Futures | 4476.19 | 4490.0 | 4474.22 | 4480.98 | 63363.0 |
| 2022-11-16 18:00:00 | ES | Futures | 4484.65 | 4486.62 | 4481.83 | 4484.36 | 5388.0 |
| 2022-11-16 19:00:00 | ES | Futures | 4484.36 | 4486.62 | 4481.26 | 4485.49 | 5970.0 |
| 2022-11-16 20:00:00 | ES | Futures | 4485.49 | 4487.75 | 4477.88 | 4479.85 | 8928.0 |
| 2022-11-16 21:00:00 | ES | Futures | 4479.85 | 4480.98 | 4474.22 | 4478.16 | 7337.0 |
| 2022-11-16 22:00:00 | ES | Futures | 4478.44 | 4479.57 | 4474.78 | 4479.29 | 5459.0 |
| 2022-11-16 23:00:00 | ES | Futures | 4479.57 | 4479.85 | 4476.19 | 4476.47 | 3103.0 |
| 2022-11-16 00:00:00 | NQ | Futures | 13637.06 | 13710.33 | 13628.44 | 13703.15 | 6982.0 |
| 2022-11-16 01:00:00 | NQ | Futures | 13702.57 | 13713.49 | 13679.01 | 13708.32 | 4298.0 |
| 2022-11-16 02:00:00 | NQ | Futures | 13709.18 | 13749.12 | 13681.88 | 13734.75 | 8392.0 |
| 2022-11-16 03:00:00 | NQ | Futures | 13735.33 | 13745.1 | 13699.99 | 13707.74 | 7159.0 |
| 2022-11-16 04:00:00 | NQ | Futures | 13708.32 | 13716.08 | 13682.17 | 13704.01 | 7337.0 |
| 2022-11-16 05:00:00 | NQ | Futures | 13704.3 | 13737.34 | 13685.91 | 13689.07 | 6783.0 |
| 2022-11-16 06:00:00 | NQ | Futures | 13689.35 | 13695.68 | 13650.85 | 13668.95 | 11002.0 |
| 2022-11-16 07:00:00 | NQ | Futures | 13668.67 | 13684.76 | 13642.52 | 13682.46 | 8308.0 |
| 2022-11-16 08:00:00 | NQ | Futures | 13683.61 | 13687.63 | 13591.38 | 13597.98 | 31995.0 |
| 2022-11-16 09:00:00 | NQ | Futures | 13597.41 | 13629.59 | 13503.74 | 13541.67 | 94996.0 |
| 2022-11-16 10:00:00 | NQ | Futures | 13541.67 | 13559.77 | 13454.32 | 13464.38 | 82850.0 |
| 2022-11-16 11:00:00 | NQ | Futures | 13465.24 | 13554.6 | 13460.07 | 13523.85 | 50138.0 |
| 2022-11-16 12:00:00 | NQ | Futures | 13524.72 | 13596.26 | 13499.43 | 13554.31 | 49134.0 |
| 2022-11-16 13:00:00 | NQ | Futures | 13554.6 | 13572.13 | 13489.95 | 13497.71 | 39290.0 |
| 2022-11-16 14:00:00 | NQ | Futures | 13498.28 | 13531.9 | 13482.77 | 13523.57 | 39589.0 |
| 2022-11-16 15:00:00 | NQ | Futures | 13524.14 | 13528.74 | 13460.64 | 13493.4 | 59706.0 |
| 2022-11-16 16:00:00 | NQ | Futures | 13493.69 | 13567.53 | 13489.95 | 13529.03 | 25104.0 |
| 2022-11-16 18:00:00 | NQ | Futures | 13536.21 | 13543.39 | 13520.69 | 13538.8 | 3162.0 |
| 2022-11-16 19:00:00 | NQ | Futures | 13539.08 | 13546.55 | 13530.46 | 13541.96 | 3185.0 |
| 2022-11-16 20:00:00 | NQ | Futures | 13542.53 | 13552.01 | 13508.63 | 13516.38 | 4491.0 |
| 2022-11-16 21:00:00 | NQ | Futures | 13515.81 | 13520.69 | 13495.98 | 13511.21 | 3392.0 |
| 2022-11-16 22:00:00 | NQ | Futures | 13512.07 | 13516.1 | 13498.0 | 13514.37 | 2289.0 |
| 2022-11-16 23:00:00 | NQ | Futures | 13514.95 | 13516.67 | 13502.88 | 13503.74 | 1532.0 |
| 2022-11-16 00:00:00 | YM | Futures | 37646.5 | 37783.4 | 37627.4 | 37771.0 | 2351.0 |
| 2022-11-16 01:00:00 | YM | Futures | 37769.9 | 37796.8 | 37738.5 | 37789.0 | 1419.0 |
| 2022-11-16 02:00:00 | YM | Futures | 37793.5 | 37856.3 | 37746.3 | 37829.4 | 3024.0 |
| 2022-11-16 03:00:00 | YM | Futures | 37832.7 | 37855.2 | 37774.4 | 37795.7 | 2983.0 |
> showing 50 of 2,068 rows — these rows as CSV