PREVIEW / futures_30min / 2023-08-16
file: by_date/futures_30min/2023/2023-08-16.parquet size: 110 KB rows: 3,845
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-08-16 00:00:00 | ES | Futures | 4892.89 | 4893.17 | 4889.05 | 4889.32 | 2738.0 |
| 2023-08-16 00:30:00 | ES | Futures | 4889.32 | 4891.24 | 4888.77 | 4890.42 | 1147.0 |
| 2023-08-16 01:00:00 | ES | Futures | 4890.7 | 4892.07 | 4888.5 | 4891.24 | 2359.0 |
| 2023-08-16 01:30:00 | ES | Futures | 4891.24 | 4892.34 | 4888.5 | 4889.6 | 2677.0 |
| 2023-08-16 02:00:00 | ES | Futures | 4889.6 | 4891.79 | 4884.38 | 4891.52 | 7115.0 |
| 2023-08-16 02:30:00 | ES | Futures | 4891.52 | 4892.07 | 4889.32 | 4891.24 | 3351.0 |
| 2023-08-16 03:00:00 | ES | Futures | 4891.52 | 4895.64 | 4890.42 | 4895.36 | 9212.0 |
| 2023-08-16 03:30:00 | ES | Futures | 4895.09 | 4901.4 | 4894.26 | 4897.83 | 9732.0 |
| 2023-08-16 04:00:00 | ES | Futures | 4898.11 | 4904.7 | 4897.83 | 4903.32 | 8892.0 |
| 2023-08-16 04:30:00 | ES | Futures | 4903.6 | 4905.24 | 4899.75 | 4901.4 | 7386.0 |
| 2023-08-16 05:00:00 | ES | Futures | 4901.4 | 4901.95 | 4891.79 | 4894.81 | 8919.0 |
| 2023-08-16 05:30:00 | ES | Futures | 4894.54 | 4896.46 | 4888.77 | 4892.07 | 7457.0 |
| 2023-08-16 06:00:00 | ES | Futures | 4891.79 | 4893.44 | 4888.22 | 4892.34 | 5390.0 |
| 2023-08-16 06:30:00 | ES | Futures | 4892.34 | 4893.71 | 4888.77 | 4890.15 | 6247.0 |
| 2023-08-16 07:00:00 | ES | Futures | 4890.42 | 4891.24 | 4883.83 | 4889.32 | 7947.0 |
| 2023-08-16 07:30:00 | ES | Futures | 4889.32 | 4892.89 | 4887.95 | 4892.62 | 8122.0 |
| 2023-08-16 08:00:00 | ES | Futures | 4892.34 | 4894.54 | 4884.66 | 4886.03 | 13709.0 |
| 2023-08-16 08:30:00 | ES | Futures | 4886.03 | 4890.15 | 4880.26 | 4881.36 | 15972.0 |
| 2023-08-16 09:00:00 | ES | Futures | 4881.36 | 4885.75 | 4879.99 | 4884.11 | 23255.0 |
| 2023-08-16 09:30:00 | ES | Futures | 4884.38 | 4903.32 | 4883.28 | 4895.64 | 137246.0 |
| 2023-08-16 10:00:00 | ES | Futures | 4895.91 | 4903.05 | 4889.6 | 4894.54 | 90433.0 |
| 2023-08-16 10:30:00 | ES | Futures | 4894.81 | 4901.4 | 4890.7 | 4900.58 | 80406.0 |
| 2023-08-16 11:00:00 | ES | Futures | 4900.85 | 4903.05 | 4893.71 | 4895.91 | 56927.0 |
| 2023-08-16 11:30:00 | ES | Futures | 4895.91 | 4897.01 | 4882.19 | 4884.93 | 66167.0 |
| 2023-08-16 12:00:00 | ES | Futures | 4884.66 | 4888.5 | 4875.87 | 4877.24 | 72786.0 |
| 2023-08-16 12:30:00 | ES | Futures | 4877.24 | 4883.83 | 4875.87 | 4876.42 | 42864.0 |
| 2023-08-16 13:00:00 | ES | Futures | 4876.42 | 4879.44 | 4867.91 | 4871.48 | 61414.0 |
| 2023-08-16 13:30:00 | ES | Futures | 4871.48 | 4886.03 | 4869.01 | 4881.91 | 53590.0 |
| 2023-08-16 14:00:00 | ES | Futures | 4882.46 | 4888.77 | 4866.54 | 4886.03 | 117982.0 |
| 2023-08-16 14:30:00 | ES | Futures | 4886.03 | 4891.24 | 4872.58 | 4877.24 | 81361.0 |
| 2023-08-16 15:00:00 | ES | Futures | 4876.97 | 4876.97 | 4854.46 | 4858.3 | 125939.0 |
| 2023-08-16 15:30:00 | ES | Futures | 4858.58 | 4864.34 | 4851.71 | 4852.81 | 193931.0 |
| 2023-08-16 16:00:00 | ES | Futures | 4853.09 | 4856.66 | 4850.07 | 4851.44 | 60840.0 |
| 2023-08-16 16:30:00 | ES | Futures | 4851.44 | 4853.64 | 4851.17 | 4852.81 | 8764.0 |
| 2023-08-16 18:00:00 | ES | Futures | 4853.91 | 4857.2 | 4853.36 | 4857.2 | 3297.0 |
| 2023-08-16 18:30:00 | ES | Futures | 4857.2 | 4857.48 | 4853.91 | 4853.91 | 1585.0 |
| 2023-08-16 19:00:00 | ES | Futures | 4854.19 | 4855.01 | 4852.54 | 4854.19 | 1656.0 |
| 2023-08-16 19:30:00 | ES | Futures | 4854.46 | 4855.01 | 4851.17 | 4852.26 | 3547.0 |
| 2023-08-16 20:00:00 | ES | Futures | 4851.99 | 4852.26 | 4845.4 | 4847.32 | 8770.0 |
| 2023-08-16 20:30:00 | ES | Futures | 4847.6 | 4848.42 | 4845.13 | 4847.32 | 4680.0 |
| 2023-08-16 21:00:00 | ES | Futures | 4847.6 | 4848.42 | 4841.83 | 4844.85 | 6744.0 |
| 2023-08-16 21:30:00 | ES | Futures | 4844.85 | 4849.79 | 4843.48 | 4849.79 | 6742.0 |
| 2023-08-16 22:00:00 | ES | Futures | 4849.79 | 4851.44 | 4847.87 | 4850.89 | 4326.0 |
| 2023-08-16 22:30:00 | ES | Futures | 4850.89 | 4853.91 | 4849.79 | 4852.26 | 6075.0 |
| 2023-08-16 23:00:00 | ES | Futures | 4851.99 | 4855.01 | 4851.17 | 4854.46 | 4555.0 |
| 2023-08-16 23:30:00 | ES | Futures | 4854.46 | 4856.93 | 4854.19 | 4856.66 | 3781.0 |
| 2023-08-16 00:00:00 | NQ | Futures | 16823.32 | 16827.21 | 16802.46 | 16802.46 | 2046.0 |
| 2023-08-16 00:30:00 | NQ | Futures | 16802.46 | 16813.03 | 16797.73 | 16810.25 | 1315.0 |
| 2023-08-16 01:00:00 | NQ | Futures | 16810.25 | 16819.7 | 16802.18 | 16816.92 | 1850.0 |
| 2023-08-16 01:30:00 | NQ | Futures | 16817.2 | 16823.32 | 16805.52 | 16810.25 | 1800.0 |
> showing 50 of 3,845 rows — these rows as CSV