PREVIEW / futures_30min / 2023-04-05
file: by_date/futures_30min/2023/2023-04-05.parquet size: 111 KB rows: 3,888
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 |
|---|---|---|---|---|---|---|---|
| 2023-04-05 00:00:00 | ES | Futures | 4582.99 | 4582.99 | 4580.49 | 4580.77 | 2581.0 |
| 2023-04-05 00:30:00 | ES | Futures | 4580.77 | 4581.88 | 4580.21 | 4581.32 | 1495.0 |
| 2023-04-05 01:00:00 | ES | Futures | 4581.6 | 4582.16 | 4580.21 | 4581.32 | 1428.0 |
| 2023-04-05 01:30:00 | ES | Futures | 4581.05 | 4581.32 | 4578.83 | 4579.94 | 3490.0 |
| 2023-04-05 02:00:00 | ES | Futures | 4580.21 | 4582.71 | 4575.5 | 4581.88 | 6393.0 |
| 2023-04-05 02:30:00 | ES | Futures | 4582.16 | 4583.54 | 4580.49 | 4582.71 | 3045.0 |
| 2023-04-05 03:00:00 | ES | Futures | 4582.71 | 4584.1 | 4576.61 | 4578.0 | 10145.0 |
| 2023-04-05 03:30:00 | ES | Futures | 4578.0 | 4581.88 | 4571.34 | 4575.22 | 12001.0 |
| 2023-04-05 04:00:00 | ES | Futures | 4575.5 | 4575.5 | 4570.23 | 4571.06 | 8487.0 |
| 2023-04-05 04:30:00 | ES | Futures | 4570.78 | 4573.28 | 4568.29 | 4570.78 | 9968.0 |
| 2023-04-05 05:00:00 | ES | Futures | 4570.51 | 4575.22 | 4569.67 | 4570.78 | 8265.0 |
| 2023-04-05 05:30:00 | ES | Futures | 4570.78 | 4572.45 | 4568.29 | 4569.95 | 7095.0 |
| 2023-04-05 06:00:00 | ES | Futures | 4569.95 | 4572.73 | 4568.57 | 4572.45 | 6148.0 |
| 2023-04-05 06:30:00 | ES | Futures | 4572.45 | 4575.78 | 4570.51 | 4575.5 | 5375.0 |
| 2023-04-05 07:00:00 | ES | Futures | 4575.22 | 4577.44 | 4573.28 | 4577.44 | 6799.0 |
| 2023-04-05 07:30:00 | ES | Futures | 4577.44 | 4579.38 | 4574.39 | 4574.67 | 8376.0 |
| 2023-04-05 08:00:00 | ES | Futures | 4574.67 | 4579.94 | 4571.62 | 4574.39 | 21333.0 |
| 2023-04-05 08:30:00 | ES | Futures | 4574.39 | 4575.22 | 4567.46 | 4571.06 | 22054.0 |
| 2023-04-05 09:00:00 | ES | Futures | 4571.06 | 4573.28 | 4569.12 | 4570.78 | 20135.0 |
| 2023-04-05 09:30:00 | ES | Futures | 4570.78 | 4578.83 | 4569.12 | 4575.5 | 128753.0 |
| 2023-04-05 10:00:00 | ES | Futures | 4575.78 | 4579.38 | 4562.46 | 4563.57 | 173106.0 |
| 2023-04-05 10:30:00 | ES | Futures | 4563.57 | 4569.4 | 4551.37 | 4552.76 | 134822.0 |
| 2023-04-05 11:00:00 | ES | Futures | 4552.76 | 4560.52 | 4550.54 | 4555.53 | 89010.0 |
| 2023-04-05 11:30:00 | ES | Futures | 4555.25 | 4564.96 | 4554.42 | 4561.08 | 87236.0 |
| 2023-04-05 12:00:00 | ES | Futures | 4561.08 | 4561.63 | 4548.04 | 4550.54 | 78260.0 |
| 2023-04-05 12:30:00 | ES | Futures | 4550.81 | 4554.97 | 4547.49 | 4550.54 | 59951.0 |
| 2023-04-05 13:00:00 | ES | Futures | 4550.81 | 4561.08 | 4548.6 | 4558.58 | 77373.0 |
| 2023-04-05 13:30:00 | ES | Futures | 4558.58 | 4562.74 | 4554.97 | 4561.91 | 47417.0 |
| 2023-04-05 14:00:00 | ES | Futures | 4561.91 | 4567.73 | 4560.8 | 4561.35 | 73646.0 |
| 2023-04-05 14:30:00 | ES | Futures | 4561.08 | 4568.84 | 4560.52 | 4566.07 | 67120.0 |
| 2023-04-05 15:00:00 | ES | Futures | 4566.07 | 4566.07 | 4558.58 | 4562.74 | 59106.0 |
| 2023-04-05 15:30:00 | ES | Futures | 4562.74 | 4570.23 | 4562.46 | 4567.73 | 111990.0 |
| 2023-04-05 16:00:00 | ES | Futures | 4567.46 | 4568.57 | 4566.62 | 4567.18 | 34163.0 |
| 2023-04-05 16:30:00 | ES | Futures | 4567.18 | 4567.46 | 4564.68 | 4564.68 | 10092.0 |
| 2023-04-05 18:00:00 | ES | Futures | 4563.85 | 4565.24 | 4560.8 | 4563.3 | 3456.0 |
| 2023-04-05 18:30:00 | ES | Futures | 4563.02 | 4565.79 | 4563.02 | 4564.96 | 1605.0 |
| 2023-04-05 19:00:00 | ES | Futures | 4564.68 | 4565.24 | 4563.57 | 4564.68 | 990.0 |
| 2023-04-05 19:30:00 | ES | Futures | 4564.96 | 4565.24 | 4562.74 | 4563.57 | 1672.0 |
| 2023-04-05 20:00:00 | ES | Futures | 4563.3 | 4564.96 | 4558.58 | 4559.69 | 5325.0 |
| 2023-04-05 20:30:00 | ES | Futures | 4559.69 | 4561.08 | 4559.69 | 4560.52 | 1893.0 |
| 2023-04-05 21:00:00 | ES | Futures | 4560.52 | 4560.8 | 4555.53 | 4558.58 | 5951.0 |
| 2023-04-05 21:30:00 | ES | Futures | 4558.58 | 4559.14 | 4556.08 | 4558.58 | 3599.0 |
| 2023-04-05 22:00:00 | ES | Futures | 4558.58 | 4560.24 | 4557.47 | 4559.97 | 2732.0 |
| 2023-04-05 22:30:00 | ES | Futures | 4559.97 | 4560.24 | 4557.19 | 4557.75 | 1721.0 |
| 2023-04-05 23:00:00 | ES | Futures | 4557.75 | 4558.58 | 4556.92 | 4557.19 | 1637.0 |
| 2023-04-05 23:30:00 | ES | Futures | 4557.19 | 4559.14 | 4555.53 | 4556.08 | 2355.0 |
| 2023-04-05 00:00:00 | NQ | Futures | 14895.28 | 14896.13 | 14883.46 | 14883.74 | 1753.0 |
| 2023-04-05 00:30:00 | NQ | Futures | 14883.46 | 14889.09 | 14880.36 | 14887.12 | 1770.0 |
| 2023-04-05 01:00:00 | NQ | Futures | 14886.83 | 14889.65 | 14881.48 | 14886.55 | 1108.0 |
| 2023-04-05 01:30:00 | NQ | Futures | 14886.83 | 14889.93 | 14879.8 | 14887.4 | 1865.0 |
> showing 50 of 3,888 rows — these rows as CSV