PREVIEW / futures_30min / 2022-08-29
file: by_date/futures_30min/2022/2022-08-29.parquet size: 107 KB rows: 3,758
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.69 | 4560.39 | 6176.0 |
| 2022-08-29 00:30:00 | ES | Futures | 4560.1 | 4562.09 | 4558.4 | 4561.8 | 2686.0 |
| 2022-08-29 01:00:00 | ES | Futures | 4561.8 | 4564.35 | 4559.25 | 4560.95 | 4544.0 |
| 2022-08-29 01:30:00 | ES | Futures | 4560.95 | 4562.94 | 4550.19 | 4550.76 | 6309.0 |
| 2022-08-29 02:00:00 | ES | Futures | 4550.47 | 4563.5 | 4550.47 | 4557.84 | 10098.0 |
| 2022-08-29 02:30:00 | ES | Futures | 4557.84 | 4570.3 | 4557.84 | 4569.17 | 7194.0 |
| 2022-08-29 03:00:00 | ES | Futures | 4569.74 | 4578.52 | 4553.31 | 4562.09 | 20506.0 |
| 2022-08-29 03:30:00 | ES | Futures | 4561.8 | 4574.83 | 4561.52 | 4572.0 | 14144.0 |
| 2022-08-29 04:00:00 | ES | Futures | 4572.0 | 4573.98 | 4561.52 | 4562.37 | 9771.0 |
| 2022-08-29 04:30:00 | ES | Futures | 4562.09 | 4564.92 | 4552.74 | 4552.74 | 9640.0 |
| 2022-08-29 05:00:00 | ES | Futures | 4553.02 | 4560.95 | 4551.61 | 4558.12 | 9379.0 |
| 2022-08-29 05:30:00 | ES | Futures | 4558.12 | 4560.39 | 4549.91 | 4558.69 | 10043.0 |
| 2022-08-29 06:00:00 | ES | Futures | 4558.4 | 4560.39 | 4553.02 | 4556.14 | 7023.0 |
| 2022-08-29 06:30:00 | ES | Futures | 4556.14 | 4562.37 | 4555.29 | 4555.29 | 8241.0 |
| 2022-08-29 07:00:00 | ES | Futures | 4555.29 | 4557.27 | 4549.91 | 4552.46 | 10939.0 |
| 2022-08-29 07:30:00 | ES | Futures | 4552.74 | 4559.82 | 4551.32 | 4559.54 | 12909.0 |
| 2022-08-29 08:00:00 | ES | Futures | 4559.25 | 4563.5 | 4553.31 | 4562.94 | 19551.0 |
| 2022-08-29 08:30:00 | ES | Futures | 4563.22 | 4570.87 | 4560.95 | 4561.52 | 23164.0 |
| 2022-08-29 09:00:00 | ES | Futures | 4561.52 | 4568.6 | 4559.25 | 4563.79 | 30650.0 |
| 2022-08-29 09:30:00 | ES | Futures | 4564.07 | 4585.88 | 4555.86 | 4570.59 | 221047.0 |
| 2022-08-29 10:00:00 | ES | Futures | 4570.59 | 4589.56 | 4566.9 | 4577.1 | 173545.0 |
| 2022-08-29 10:30:00 | ES | Futures | 4577.38 | 4583.62 | 4551.61 | 4554.16 | 149236.0 |
| 2022-08-29 11:00:00 | ES | Futures | 4554.16 | 4569.74 | 4553.02 | 4562.94 | 114758.0 |
| 2022-08-29 11:30:00 | ES | Futures | 4563.22 | 4578.52 | 4559.54 | 4577.1 | 118118.0 |
| 2022-08-29 12:00:00 | ES | Futures | 4577.1 | 4589.0 | 4576.25 | 4582.2 | 81868.0 |
| 2022-08-29 12:30:00 | ES | Futures | 4582.2 | 4598.63 | 4573.42 | 4591.26 | 86778.0 |
| 2022-08-29 13:00:00 | ES | Futures | 4590.98 | 4597.5 | 4582.2 | 4589.28 | 72876.0 |
| 2022-08-29 13:30:00 | ES | Futures | 4589.28 | 4604.86 | 4587.58 | 4596.36 | 77108.0 |
| 2022-08-29 14:00:00 | ES | Futures | 4596.08 | 4596.93 | 4580.78 | 4584.75 | 73185.0 |
| 2022-08-29 14:30:00 | ES | Futures | 4584.75 | 4595.51 | 4580.22 | 4590.98 | 72349.0 |
| 2022-08-29 15:00:00 | ES | Futures | 4590.98 | 4602.31 | 4584.75 | 4585.6 | 96649.0 |
| 2022-08-29 15:30:00 | ES | Futures | 4585.6 | 4592.68 | 4565.49 | 4568.6 | 179980.0 |
| 2022-08-29 16:00:00 | ES | Futures | 4568.6 | 4571.72 | 4566.05 | 4566.62 | 44716.0 |
| 2022-08-29 16:30:00 | ES | Futures | 4566.9 | 4572.85 | 4566.34 | 4572.85 | 5403.0 |
| 2022-08-29 18:00:00 | ES | Futures | 4572.85 | 4575.12 | 4571.15 | 4571.15 | 3590.0 |
| 2022-08-29 18:30:00 | ES | Futures | 4571.15 | 4572.29 | 4570.87 | 4571.72 | 1241.0 |
| 2022-08-29 19:00:00 | ES | Futures | 4571.44 | 4574.27 | 4568.6 | 4573.7 | 2028.0 |
| 2022-08-29 19:30:00 | ES | Futures | 4573.98 | 4581.35 | 4572.29 | 4579.37 | 4836.0 |
| 2022-08-29 20:00:00 | ES | Futures | 4579.08 | 4580.5 | 4567.47 | 4569.74 | 8430.0 |
| 2022-08-29 20:30:00 | ES | Futures | 4569.74 | 4572.0 | 4562.65 | 4570.87 | 6870.0 |
| 2022-08-29 21:00:00 | ES | Futures | 4570.87 | 4579.37 | 4570.02 | 4577.1 | 5136.0 |
| 2022-08-29 21:30:00 | ES | Futures | 4577.1 | 4577.1 | 4565.49 | 4567.75 | 6517.0 |
| 2022-08-29 22:00:00 | ES | Futures | 4567.75 | 4570.59 | 4563.22 | 4569.45 | 5897.0 |
| 2022-08-29 22:30:00 | ES | Futures | 4569.45 | 4574.55 | 4567.75 | 4573.42 | 3657.0 |
| 2022-08-29 23:00:00 | ES | Futures | 4573.42 | 4574.83 | 4570.3 | 4574.83 | 2589.0 |
| 2022-08-29 23:30:00 | ES | Futures | 4574.83 | 4579.37 | 4573.42 | 4579.37 | 4183.0 |
| 2022-08-29 00:00:00 | NQ | Futures | 14441.42 | 14452.99 | 14411.91 | 14420.3 | 3386.0 |
| 2022-08-29 00:30:00 | NQ | Futures | 14420.3 | 14428.98 | 14411.34 | 14423.77 | 1344.0 |
| 2022-08-29 01:00:00 | NQ | Futures | 14424.35 | 14437.37 | 14420.3 | 14425.8 | 2236.0 |
| 2022-08-29 01:30:00 | NQ | Futures | 14426.67 | 14433.61 | 14384.44 | 14384.73 | 2954.0 |
> showing 50 of 3,758 rows — these rows as CSV