PREVIEW / futures_1hour / 2022-08-29
file: by_date/futures_1hour/2022/2022-08-29.parquet size: 65 KB rows: 1,982
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-08-29 00:00:00 | ES | Futures | 4565.49 | 4567.75 | 4558.4 | 4561.8 | 8862.0 |
| 2022-08-29 01:00:00 | ES | Futures | 4561.8 | 4564.35 | 4550.19 | 4550.76 | 10853.0 |
| 2022-08-29 02:00:00 | ES | Futures | 4550.47 | 4570.3 | 4550.47 | 4569.17 | 17292.0 |
| 2022-08-29 03:00:00 | ES | Futures | 4569.74 | 4578.52 | 4553.31 | 4572.0 | 34650.0 |
| 2022-08-29 04:00:00 | ES | Futures | 4572.0 | 4573.98 | 4552.74 | 4552.74 | 19411.0 |
| 2022-08-29 05:00:00 | ES | Futures | 4553.02 | 4560.95 | 4549.91 | 4558.69 | 19422.0 |
| 2022-08-29 06:00:00 | ES | Futures | 4558.4 | 4562.37 | 4553.02 | 4555.29 | 15264.0 |
| 2022-08-29 07:00:00 | ES | Futures | 4555.29 | 4559.82 | 4549.91 | 4559.54 | 23848.0 |
| 2022-08-29 08:00:00 | ES | Futures | 4559.25 | 4570.87 | 4553.31 | 4561.52 | 42715.0 |
| 2022-08-29 09:00:00 | ES | Futures | 4561.52 | 4585.88 | 4555.86 | 4570.59 | 251697.0 |
| 2022-08-29 10:00:00 | ES | Futures | 4570.59 | 4589.56 | 4551.61 | 4554.16 | 322781.0 |
| 2022-08-29 11:00:00 | ES | Futures | 4554.16 | 4578.52 | 4553.02 | 4577.1 | 232876.0 |
| 2022-08-29 12:00:00 | ES | Futures | 4577.1 | 4598.63 | 4573.42 | 4591.26 | 168646.0 |
| 2022-08-29 13:00:00 | ES | Futures | 4590.98 | 4604.86 | 4582.2 | 4596.36 | 149984.0 |
| 2022-08-29 14:00:00 | ES | Futures | 4596.08 | 4596.93 | 4580.22 | 4590.98 | 145534.0 |
| 2022-08-29 15:00:00 | ES | Futures | 4590.98 | 4602.31 | 4565.49 | 4568.6 | 276629.0 |
| 2022-08-29 16:00:00 | ES | Futures | 4568.6 | 4572.85 | 4566.05 | 4572.85 | 50119.0 |
| 2022-08-29 18:00:00 | ES | Futures | 4572.85 | 4575.12 | 4570.87 | 4571.72 | 4831.0 |
| 2022-08-29 19:00:00 | ES | Futures | 4571.44 | 4581.35 | 4568.6 | 4579.37 | 6864.0 |
| 2022-08-29 20:00:00 | ES | Futures | 4579.08 | 4580.5 | 4562.65 | 4570.87 | 15300.0 |
| 2022-08-29 21:00:00 | ES | Futures | 4570.87 | 4579.37 | 4565.49 | 4567.75 | 11653.0 |
| 2022-08-29 22:00:00 | ES | Futures | 4567.75 | 4574.55 | 4563.22 | 4573.42 | 9554.0 |
| 2022-08-29 23:00:00 | ES | Futures | 4573.42 | 4579.37 | 4570.3 | 4579.37 | 6772.0 |
| 2022-08-29 00:00:00 | NQ | Futures | 14441.42 | 14452.99 | 14411.34 | 14423.77 | 4730.0 |
| 2022-08-29 01:00:00 | NQ | Futures | 14424.35 | 14437.37 | 14384.44 | 14384.73 | 5190.0 |
| 2022-08-29 02:00:00 | NQ | Futures | 14385.59 | 14459.06 | 14384.44 | 14456.75 | 6959.0 |
| 2022-08-29 03:00:00 | NQ | Futures | 14457.32 | 14501.29 | 14393.4 | 14465.71 | 19367.0 |
| 2022-08-29 04:00:00 | NQ | Futures | 14465.71 | 14473.23 | 14405.84 | 14407.58 | 11182.0 |
| 2022-08-29 05:00:00 | NQ | Futures | 14407.29 | 14443.44 | 14401.21 | 14440.55 | 9091.0 |
| 2022-08-29 06:00:00 | NQ | Futures | 14440.26 | 14458.77 | 14422.33 | 14433.9 | 7181.0 |
| 2022-08-29 07:00:00 | NQ | Futures | 14433.03 | 14440.84 | 14407.58 | 14437.95 | 10320.0 |
| 2022-08-29 08:00:00 | NQ | Futures | 14437.37 | 14483.93 | 14415.96 | 14455.88 | 16400.0 |
| 2022-08-29 09:00:00 | NQ | Futures | 14456.17 | 14584.01 | 14437.37 | 14500.71 | 88571.0 |
| 2022-08-29 10:00:00 | NQ | Futures | 14501.29 | 14589.51 | 14413.36 | 14418.86 | 105204.0 |
| 2022-08-29 11:00:00 | NQ | Futures | 14418.86 | 14487.98 | 14402.08 | 14476.41 | 82784.0 |
| 2022-08-29 12:00:00 | NQ | Futures | 14476.7 | 14561.45 | 14461.08 | 14532.82 | 73173.0 |
| 2022-08-29 13:00:00 | NQ | Futures | 14533.11 | 14584.59 | 14504.18 | 14547.86 | 56374.0 |
| 2022-08-29 14:00:00 | NQ | Futures | 14547.86 | 14549.59 | 14487.41 | 14523.85 | 49154.0 |
| 2022-08-29 15:00:00 | NQ | Futures | 14524.14 | 14571.28 | 14446.33 | 14455.88 | 78557.0 |
| 2022-08-29 16:00:00 | NQ | Futures | 14455.88 | 14468.32 | 14439.97 | 14468.03 | 16042.0 |
| 2022-08-29 18:00:00 | NQ | Futures | 14466.0 | 14474.97 | 14453.85 | 14462.82 | 2438.0 |
| 2022-08-29 19:00:00 | NQ | Futures | 14463.11 | 14504.18 | 14448.94 | 14499.55 | 3884.0 |
| 2022-08-29 20:00:00 | NQ | Futures | 14500.42 | 14504.76 | 14442.86 | 14470.92 | 5858.0 |
| 2022-08-29 21:00:00 | NQ | Futures | 14470.63 | 14502.45 | 14453.85 | 14461.95 | 5135.0 |
| 2022-08-29 22:00:00 | NQ | Futures | 14462.82 | 14476.13 | 14443.73 | 14471.79 | 4139.0 |
| 2022-08-29 23:00:00 | NQ | Futures | 14472.65 | 14496.66 | 14459.64 | 14496.66 | 3171.0 |
| 2022-08-29 00:00:00 | YM | Futures | 36184.8 | 36199.5 | 36136.3 | 36157.8 | 1037.0 |
| 2022-08-29 01:00:00 | YM | Futures | 36161.2 | 36177.0 | 36093.5 | 36094.6 | 1823.0 |
| 2022-08-29 02:00:00 | YM | Futures | 36094.6 | 36221.0 | 36094.6 | 36210.8 | 2483.0 |
| 2022-08-29 03:00:00 | YM | Futures | 36213.1 | 36269.5 | 36102.5 | 36225.5 | 5276.0 |
> showing 50 of 1,982 rows — these rows as CSV