PREVIEW / futures_30min / 2023-04-26
file: by_date/futures_30min/2023/2023-04-26.parquet size: 111 KB rows: 3,947
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-26 00:00:00 | ES | Futures | 4559.14 | 4559.69 | 4558.03 | 4559.14 | 3262.0 |
| 2023-04-26 00:30:00 | ES | Futures | 4559.14 | 4561.08 | 4558.86 | 4560.52 | 3021.0 |
| 2023-04-26 01:00:00 | ES | Futures | 4560.52 | 4562.19 | 4559.97 | 4562.19 | 2575.0 |
| 2023-04-26 01:30:00 | ES | Futures | 4562.46 | 4565.79 | 4561.35 | 4564.68 | 4416.0 |
| 2023-04-26 02:00:00 | ES | Futures | 4564.96 | 4565.24 | 4559.97 | 4561.63 | 4928.0 |
| 2023-04-26 02:30:00 | ES | Futures | 4561.63 | 4563.85 | 4560.8 | 4562.74 | 3993.0 |
| 2023-04-26 03:00:00 | ES | Futures | 4562.74 | 4563.57 | 4556.08 | 4559.41 | 12410.0 |
| 2023-04-26 03:30:00 | ES | Futures | 4559.69 | 4559.97 | 4549.43 | 4555.53 | 14235.0 |
| 2023-04-26 04:00:00 | ES | Futures | 4555.53 | 4559.14 | 4547.76 | 4559.14 | 14131.0 |
| 2023-04-26 04:30:00 | ES | Futures | 4558.86 | 4561.63 | 4557.47 | 4560.24 | 8086.0 |
| 2023-04-26 05:00:00 | ES | Futures | 4560.24 | 4562.19 | 4556.36 | 4557.47 | 6147.0 |
| 2023-04-26 05:30:00 | ES | Futures | 4557.75 | 4561.63 | 4550.81 | 4554.42 | 9503.0 |
| 2023-04-26 06:00:00 | ES | Futures | 4554.7 | 4558.86 | 4551.92 | 4554.42 | 6777.0 |
| 2023-04-26 06:30:00 | ES | Futures | 4554.7 | 4554.97 | 4544.71 | 4547.49 | 16103.0 |
| 2023-04-26 07:00:00 | ES | Futures | 4547.49 | 4549.98 | 4536.67 | 4541.11 | 25719.0 |
| 2023-04-26 07:30:00 | ES | Futures | 4540.83 | 4553.87 | 4540.55 | 4544.99 | 30831.0 |
| 2023-04-26 08:00:00 | ES | Futures | 4544.71 | 4552.76 | 4543.05 | 4551.09 | 13693.0 |
| 2023-04-26 08:30:00 | ES | Futures | 4550.81 | 4555.53 | 4546.1 | 4554.14 | 16227.0 |
| 2023-04-26 09:00:00 | ES | Futures | 4554.42 | 4556.64 | 4544.71 | 4547.49 | 46529.0 |
| 2023-04-26 09:30:00 | ES | Futures | 4547.21 | 4553.31 | 4542.49 | 4548.87 | 157445.0 |
| 2023-04-26 10:00:00 | ES | Futures | 4549.15 | 4549.98 | 4527.79 | 4531.68 | 165535.0 |
| 2023-04-26 10:30:00 | ES | Futures | 4531.68 | 4542.49 | 4531.4 | 4541.38 | 117516.0 |
| 2023-04-26 11:00:00 | ES | Futures | 4541.66 | 4556.36 | 4541.38 | 4551.92 | 114470.0 |
| 2023-04-26 11:30:00 | ES | Futures | 4551.92 | 4556.08 | 4547.76 | 4553.87 | 75681.0 |
| 2023-04-26 12:00:00 | ES | Futures | 4553.87 | 4559.41 | 4550.81 | 4551.65 | 77603.0 |
| 2023-04-26 12:30:00 | ES | Futures | 4551.65 | 4551.92 | 4544.44 | 4546.65 | 59667.0 |
| 2023-04-26 13:00:00 | ES | Futures | 4546.65 | 4549.98 | 4539.72 | 4541.66 | 64879.0 |
| 2023-04-26 13:30:00 | ES | Futures | 4541.66 | 4543.6 | 4527.52 | 4530.84 | 85300.0 |
| 2023-04-26 14:00:00 | ES | Futures | 4530.84 | 4531.4 | 4522.8 | 4530.84 | 93829.0 |
| 2023-04-26 14:30:00 | ES | Futures | 4530.84 | 4531.4 | 4517.53 | 4520.58 | 109541.0 |
| 2023-04-26 15:00:00 | ES | Futures | 4520.31 | 4524.74 | 4515.87 | 4519.75 | 84587.0 |
| 2023-04-26 15:30:00 | ES | Futures | 4519.75 | 4527.24 | 4513.93 | 4520.58 | 172219.0 |
| 2023-04-26 16:00:00 | ES | Futures | 4520.58 | 4532.79 | 4519.47 | 4532.51 | 61508.0 |
| 2023-04-26 16:30:00 | ES | Futures | 4532.51 | 4533.9 | 4531.12 | 4532.51 | 11248.0 |
| 2023-04-26 18:00:00 | ES | Futures | 4532.51 | 4533.62 | 4528.9 | 4530.57 | 3617.0 |
| 2023-04-26 18:30:00 | ES | Futures | 4530.29 | 4531.95 | 4529.74 | 4531.68 | 1009.0 |
| 2023-04-26 19:00:00 | ES | Futures | 4531.68 | 4531.95 | 4530.29 | 4531.4 | 1623.0 |
| 2023-04-26 19:30:00 | ES | Futures | 4531.4 | 4532.79 | 4529.46 | 4532.23 | 1756.0 |
| 2023-04-26 20:00:00 | ES | Futures | 4532.51 | 4532.51 | 4528.35 | 4531.4 | 3299.0 |
| 2023-04-26 20:30:00 | ES | Futures | 4531.68 | 4531.68 | 4528.9 | 4530.57 | 2061.0 |
| 2023-04-26 21:00:00 | ES | Futures | 4530.29 | 4530.84 | 4527.24 | 4528.07 | 2345.0 |
| 2023-04-26 21:30:00 | ES | Futures | 4528.35 | 4532.23 | 4527.79 | 4530.84 | 2518.0 |
| 2023-04-26 22:00:00 | ES | Futures | 4530.84 | 4534.17 | 4529.74 | 4533.62 | 2836.0 |
| 2023-04-26 22:30:00 | ES | Futures | 4533.62 | 4534.17 | 4531.95 | 4532.79 | 1643.0 |
| 2023-04-26 23:00:00 | ES | Futures | 4532.79 | 4533.62 | 4531.68 | 4531.95 | 1420.0 |
| 2023-04-26 23:30:00 | ES | Futures | 4532.23 | 4532.79 | 4531.12 | 4531.68 | 1282.0 |
| 2023-04-26 00:00:00 | NQ | Futures | 14607.53 | 14611.48 | 14601.62 | 14607.82 | 2435.0 |
| 2023-04-26 00:30:00 | NQ | Futures | 14607.82 | 14611.48 | 14604.15 | 14609.22 | 1470.0 |
| 2023-04-26 01:00:00 | NQ | Futures | 14609.22 | 14623.3 | 14608.38 | 14622.46 | 1693.0 |
| 2023-04-26 01:30:00 | NQ | Futures | 14622.46 | 14632.31 | 14617.39 | 14632.03 | 2054.0 |
> showing 50 of 3,947 rows — these rows as CSV