PREVIEW / futures_30min / 2023-01-31
file: by_date/futures_30min/2023/2023-01-31.parquet size: 114 KB rows: 3,991
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-01-31 00:00:00 | ES | Futures | 4507.82 | 4510.33 | 4505.86 | 4510.05 | 3142.0 |
| 2023-01-31 00:30:00 | ES | Futures | 4509.77 | 4510.05 | 4504.18 | 4504.46 | 3612.0 |
| 2023-01-31 01:00:00 | ES | Futures | 4504.74 | 4509.77 | 4504.74 | 4508.38 | 3405.0 |
| 2023-01-31 01:30:00 | ES | Futures | 4508.1 | 4509.77 | 4505.3 | 4508.94 | 3150.0 |
| 2023-01-31 02:00:00 | ES | Futures | 4508.66 | 4512.01 | 4506.14 | 4507.82 | 6295.0 |
| 2023-01-31 02:30:00 | ES | Futures | 4507.82 | 4520.12 | 4507.82 | 4518.72 | 10331.0 |
| 2023-01-31 03:00:00 | ES | Futures | 4518.72 | 4520.12 | 4508.1 | 4508.94 | 12954.0 |
| 2023-01-31 03:30:00 | ES | Futures | 4509.21 | 4509.21 | 4496.63 | 4499.99 | 13598.0 |
| 2023-01-31 04:00:00 | ES | Futures | 4499.99 | 4501.39 | 4493.56 | 4496.63 | 11203.0 |
| 2023-01-31 04:30:00 | ES | Futures | 4496.35 | 4499.71 | 4495.23 | 4496.63 | 6022.0 |
| 2023-01-31 05:00:00 | ES | Futures | 4496.63 | 4496.91 | 4491.88 | 4494.12 | 6775.0 |
| 2023-01-31 05:30:00 | ES | Futures | 4494.4 | 4495.23 | 4487.69 | 4487.96 | 10499.0 |
| 2023-01-31 06:00:00 | ES | Futures | 4487.96 | 4491.04 | 4485.45 | 4486.01 | 9566.0 |
| 2023-01-31 06:30:00 | ES | Futures | 4485.73 | 4495.51 | 4482.09 | 4494.4 | 16674.0 |
| 2023-01-31 07:00:00 | ES | Futures | 4494.12 | 4499.43 | 4493.84 | 4499.43 | 14027.0 |
| 2023-01-31 07:30:00 | ES | Futures | 4499.15 | 4504.18 | 4497.75 | 4501.39 | 12422.0 |
| 2023-01-31 08:00:00 | ES | Futures | 4501.67 | 4505.86 | 4501.11 | 4503.34 | 15462.0 |
| 2023-01-31 08:30:00 | ES | Futures | 4503.34 | 4527.95 | 4503.34 | 4522.08 | 79733.0 |
| 2023-01-31 09:00:00 | ES | Futures | 4522.36 | 4525.43 | 4513.41 | 4514.81 | 32580.0 |
| 2023-01-31 09:30:00 | ES | Futures | 4514.81 | 4529.07 | 4512.57 | 4516.21 | 161405.0 |
| 2023-01-31 10:00:00 | ES | Futures | 4516.21 | 4533.82 | 4510.89 | 4532.98 | 179898.0 |
| 2023-01-31 10:30:00 | ES | Futures | 4533.26 | 4540.25 | 4529.91 | 4535.78 | 104613.0 |
| 2023-01-31 11:00:00 | ES | Futures | 4535.78 | 4541.93 | 4533.26 | 4538.01 | 78364.0 |
| 2023-01-31 11:30:00 | ES | Futures | 4538.29 | 4542.49 | 4533.54 | 4537.18 | 58936.0 |
| 2023-01-31 12:00:00 | ES | Futures | 4537.18 | 4543.89 | 4530.74 | 4541.37 | 73239.0 |
| 2023-01-31 12:30:00 | ES | Futures | 4541.37 | 4546.4 | 4539.13 | 4544.17 | 47727.0 |
| 2023-01-31 13:00:00 | ES | Futures | 4544.45 | 4546.4 | 4539.69 | 4544.45 | 34602.0 |
| 2023-01-31 13:30:00 | ES | Futures | 4544.17 | 4551.16 | 4541.65 | 4550.32 | 52301.0 |
| 2023-01-31 14:00:00 | ES | Futures | 4550.32 | 4553.95 | 4548.92 | 4551.44 | 50576.0 |
| 2023-01-31 14:30:00 | ES | Futures | 4551.72 | 4556.19 | 4549.48 | 4553.39 | 52510.0 |
| 2023-01-31 15:00:00 | ES | Futures | 4553.67 | 4557.31 | 4543.61 | 4545.0 | 81803.0 |
| 2023-01-31 15:30:00 | ES | Futures | 4544.72 | 4575.76 | 4544.45 | 4574.64 | 302984.0 |
| 2023-01-31 16:00:00 | ES | Futures | 4574.92 | 4575.2 | 4567.09 | 4569.33 | 98134.0 |
| 2023-01-31 16:30:00 | ES | Futures | 4569.61 | 4570.17 | 4566.53 | 4569.61 | 8243.0 |
| 2023-01-31 18:00:00 | ES | Futures | 4569.61 | 4569.89 | 4564.02 | 4564.02 | 4757.0 |
| 2023-01-31 18:30:00 | ES | Futures | 4564.3 | 4567.09 | 4561.78 | 4564.3 | 3952.0 |
| 2023-01-31 19:00:00 | ES | Futures | 4564.3 | 4569.61 | 4559.26 | 4560.1 | 7124.0 |
| 2023-01-31 19:30:00 | ES | Futures | 4560.1 | 4561.22 | 4558.15 | 4558.71 | 3964.0 |
| 2023-01-31 20:00:00 | ES | Futures | 4558.98 | 4561.5 | 4557.87 | 4560.66 | 3714.0 |
| 2023-01-31 20:30:00 | ES | Futures | 4560.94 | 4562.9 | 4558.43 | 4560.94 | 4445.0 |
| 2023-01-31 21:00:00 | ES | Futures | 4560.94 | 4561.22 | 4558.71 | 4559.82 | 2228.0 |
| 2023-01-31 21:30:00 | ES | Futures | 4559.54 | 4560.66 | 4558.43 | 4558.71 | 2060.0 |
| 2023-01-31 22:00:00 | ES | Futures | 4558.71 | 4564.3 | 4558.71 | 4562.06 | 3163.0 |
| 2023-01-31 22:30:00 | ES | Futures | 4562.06 | 4563.74 | 4561.5 | 4562.34 | 2000.0 |
| 2023-01-31 23:00:00 | ES | Futures | 4562.34 | 4565.7 | 4561.78 | 4565.14 | 2745.0 |
| 2023-01-31 23:30:00 | ES | Futures | 4565.14 | 4565.98 | 4562.34 | 4562.9 | 2227.0 |
| 2023-01-31 00:00:00 | NQ | Futures | 13585.16 | 13599.39 | 13574.63 | 13596.82 | 2016.0 |
| 2023-01-31 00:30:00 | NQ | Futures | 13595.97 | 13597.11 | 13572.36 | 13574.63 | 1731.0 |
| 2023-01-31 01:00:00 | NQ | Futures | 13575.49 | 13595.4 | 13571.5 | 13589.71 | 1836.0 |
| 2023-01-31 01:30:00 | NQ | Futures | 13589.43 | 13593.41 | 13579.19 | 13589.43 | 1380.0 |
> showing 50 of 3,991 rows — these rows as CSV