PREVIEW / futures_30min / 2023-06-29
file: by_date/futures_30min/2023/2023-06-29.parquet size: 105 KB rows: 3,841
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-06-29 00:00:00 | ES | Futures | 4853.91 | 4854.73 | 4853.64 | 4854.46 | 1610.0 |
| 2023-06-29 00:30:00 | ES | Futures | 4854.46 | 4855.01 | 4852.54 | 4853.36 | 2726.0 |
| 2023-06-29 01:00:00 | ES | Futures | 4853.36 | 4856.66 | 4851.71 | 4851.99 | 3887.0 |
| 2023-06-29 01:30:00 | ES | Futures | 4851.99 | 4853.36 | 4850.34 | 4853.09 | 4248.0 |
| 2023-06-29 02:00:00 | ES | Futures | 4853.09 | 4853.36 | 4849.52 | 4849.52 | 4585.0 |
| 2023-06-29 02:30:00 | ES | Futures | 4849.79 | 4852.81 | 4849.79 | 4850.34 | 3567.0 |
| 2023-06-29 03:00:00 | ES | Futures | 4850.07 | 4853.09 | 4848.42 | 4848.97 | 10885.0 |
| 2023-06-29 03:30:00 | ES | Futures | 4848.97 | 4851.99 | 4847.32 | 4850.07 | 8814.0 |
| 2023-06-29 04:00:00 | ES | Futures | 4850.34 | 4856.93 | 4849.52 | 4855.56 | 10878.0 |
| 2023-06-29 04:30:00 | ES | Futures | 4855.56 | 4858.03 | 4854.19 | 4857.2 | 6847.0 |
| 2023-06-29 05:00:00 | ES | Futures | 4857.2 | 4858.58 | 4854.73 | 4856.93 | 4856.0 |
| 2023-06-29 05:30:00 | ES | Futures | 4856.66 | 4861.87 | 4855.83 | 4861.32 | 6377.0 |
| 2023-06-29 06:00:00 | ES | Futures | 4861.6 | 4867.64 | 4859.68 | 4864.62 | 11239.0 |
| 2023-06-29 06:30:00 | ES | Futures | 4864.62 | 4866.54 | 4863.79 | 4864.62 | 6170.0 |
| 2023-06-29 07:00:00 | ES | Futures | 4864.34 | 4867.09 | 4863.52 | 4866.81 | 6779.0 |
| 2023-06-29 07:30:00 | ES | Futures | 4866.81 | 4867.36 | 4862.69 | 4864.34 | 8668.0 |
| 2023-06-29 08:00:00 | ES | Futures | 4864.34 | 4867.91 | 4862.15 | 4866.81 | 12531.0 |
| 2023-06-29 08:30:00 | ES | Futures | 4866.54 | 4871.75 | 4853.91 | 4855.56 | 56618.0 |
| 2023-06-29 09:00:00 | ES | Futures | 4855.56 | 4856.11 | 4843.75 | 4846.77 | 55682.0 |
| 2023-06-29 09:30:00 | ES | Futures | 4846.77 | 4857.75 | 4842.11 | 4854.73 | 174056.0 |
| 2023-06-29 10:00:00 | ES | Futures | 4854.46 | 4862.15 | 4847.32 | 4854.19 | 169479.0 |
| 2023-06-29 10:30:00 | ES | Futures | 4854.46 | 4857.48 | 4845.68 | 4851.17 | 120355.0 |
| 2023-06-29 11:00:00 | ES | Futures | 4851.17 | 4865.99 | 4850.34 | 4865.17 | 89737.0 |
| 2023-06-29 11:30:00 | ES | Futures | 4865.17 | 4867.91 | 4860.5 | 4866.26 | 76913.0 |
| 2023-06-29 12:00:00 | ES | Futures | 4866.26 | 4871.48 | 4861.05 | 4870.38 | 64945.0 |
| 2023-06-29 12:30:00 | ES | Futures | 4870.38 | 4872.85 | 4862.69 | 4865.71 | 62726.0 |
| 2023-06-29 13:00:00 | ES | Futures | 4865.71 | 4866.81 | 4857.2 | 4866.26 | 75653.0 |
| 2023-06-29 13:30:00 | ES | Futures | 4866.26 | 4866.81 | 4857.48 | 4859.13 | 62362.0 |
| 2023-06-29 14:00:00 | ES | Futures | 4859.13 | 4861.6 | 4851.17 | 4860.77 | 83469.0 |
| 2023-06-29 14:30:00 | ES | Futures | 4860.77 | 4862.69 | 4856.38 | 4862.69 | 55892.0 |
| 2023-06-29 15:00:00 | ES | Futures | 4862.69 | 4867.09 | 4861.87 | 4865.71 | 58536.0 |
| 2023-06-29 15:30:00 | ES | Futures | 4865.44 | 4871.75 | 4859.68 | 4871.48 | 156584.0 |
| 2023-06-29 16:00:00 | ES | Futures | 4871.2 | 4873.13 | 4869.56 | 4872.58 | 46955.0 |
| 2023-06-29 16:30:00 | ES | Futures | 4872.3 | 4873.13 | 4870.11 | 4870.66 | 14364.0 |
| 2023-06-29 18:00:00 | ES | Futures | 4870.11 | 4871.48 | 4868.73 | 4870.93 | 2451.0 |
| 2023-06-29 18:30:00 | ES | Futures | 4870.93 | 4871.2 | 4869.56 | 4870.66 | 728.0 |
| 2023-06-29 19:00:00 | ES | Futures | 4870.66 | 4872.03 | 4870.38 | 4871.75 | 1038.0 |
| 2023-06-29 19:30:00 | ES | Futures | 4871.48 | 4874.22 | 4871.2 | 4872.3 | 2564.0 |
| 2023-06-29 20:00:00 | ES | Futures | 4872.3 | 4873.13 | 4867.64 | 4869.01 | 5411.0 |
| 2023-06-29 20:30:00 | ES | Futures | 4868.73 | 4870.38 | 4868.19 | 4870.11 | 2224.0 |
| 2023-06-29 21:00:00 | ES | Futures | 4870.11 | 4875.6 | 4870.11 | 4874.77 | 4282.0 |
| 2023-06-29 21:30:00 | ES | Futures | 4874.77 | 4876.15 | 4872.58 | 4874.77 | 3895.0 |
| 2023-06-29 22:00:00 | ES | Futures | 4874.77 | 4877.79 | 4874.5 | 4875.05 | 3742.0 |
| 2023-06-29 22:30:00 | ES | Futures | 4875.05 | 4876.42 | 4874.22 | 4874.22 | 1697.0 |
| 2023-06-29 23:00:00 | ES | Futures | 4874.5 | 4875.6 | 4873.4 | 4874.5 | 1486.0 |
| 2023-06-29 23:30:00 | ES | Futures | 4874.22 | 4874.5 | 4870.93 | 4872.03 | 3817.0 |
| 2023-06-29 00:00:00 | NQ | Futures | 16851.69 | 16860.87 | 16851.13 | 16859.2 | 1060.0 |
| 2023-06-29 00:30:00 | NQ | Futures | 16858.64 | 16860.87 | 16850.02 | 16851.97 | 943.0 |
| 2023-06-29 01:00:00 | NQ | Futures | 16852.52 | 16870.88 | 16849.18 | 16850.58 | 1986.0 |
| 2023-06-29 01:30:00 | NQ | Futures | 16850.3 | 16854.75 | 16842.51 | 16853.63 | 1838.0 |
> showing 50 of 3,841 rows — these rows as CSV