PREVIEW / futures_30min / 2024-10-17
file: by_date/futures_30min/2024/2024-10-17.parquet size: 109 KB rows: 3,980
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 |
|---|---|---|---|---|---|---|---|
| 2024-10-17 00:00:00 | ES | Futures | 6098.02 | 6098.28 | 6095.95 | 6097.24 | 1180.0 |
| 2024-10-17 00:30:00 | ES | Futures | 6097.5 | 6098.28 | 6096.46 | 6097.5 | 813.0 |
| 2024-10-17 01:00:00 | ES | Futures | 6097.24 | 6101.4 | 6096.72 | 6099.06 | 1546.0 |
| 2024-10-17 01:30:00 | ES | Futures | 6099.06 | 6105.81 | 6098.8 | 6104.77 | 4211.0 |
| 2024-10-17 02:00:00 | ES | Futures | 6104.77 | 6112.55 | 6103.73 | 6111.26 | 9569.0 |
| 2024-10-17 02:30:00 | ES | Futures | 6111.26 | 6120.08 | 6111.26 | 6117.23 | 10668.0 |
| 2024-10-17 03:00:00 | ES | Futures | 6117.49 | 6119.56 | 6115.67 | 6118.26 | 8348.0 |
| 2024-10-17 03:30:00 | ES | Futures | 6118.52 | 6124.23 | 6118.52 | 6122.68 | 6420.0 |
| 2024-10-17 04:00:00 | ES | Futures | 6122.94 | 6129.68 | 6122.16 | 6129.68 | 9120.0 |
| 2024-10-17 04:30:00 | ES | Futures | 6129.68 | 6133.58 | 6128.65 | 6133.06 | 6230.0 |
| 2024-10-17 05:00:00 | ES | Futures | 6133.32 | 6135.65 | 6132.28 | 6133.58 | 5393.0 |
| 2024-10-17 05:30:00 | ES | Futures | 6133.58 | 6137.21 | 6130.46 | 6136.17 | 4794.0 |
| 2024-10-17 06:00:00 | ES | Futures | 6135.91 | 6137.99 | 6134.87 | 6136.43 | 4617.0 |
| 2024-10-17 06:30:00 | ES | Futures | 6136.69 | 6139.55 | 6133.84 | 6139.03 | 6175.0 |
| 2024-10-17 07:00:00 | ES | Futures | 6138.77 | 6138.77 | 6135.13 | 6136.95 | 5403.0 |
| 2024-10-17 07:30:00 | ES | Futures | 6136.69 | 6137.99 | 6134.35 | 6135.65 | 6474.0 |
| 2024-10-17 08:00:00 | ES | Futures | 6135.65 | 6142.92 | 6135.13 | 6137.73 | 16927.0 |
| 2024-10-17 08:30:00 | ES | Futures | 6138.25 | 6145.25 | 6135.91 | 6144.22 | 25500.0 |
| 2024-10-17 09:00:00 | ES | Futures | 6144.22 | 6153.04 | 6143.7 | 6148.63 | 32936.0 |
| 2024-10-17 09:30:00 | ES | Futures | 6148.63 | 6150.7 | 6120.08 | 6128.65 | 176151.0 |
| 2024-10-17 10:00:00 | ES | Futures | 6128.65 | 6132.28 | 6115.67 | 6126.57 | 117961.0 |
| 2024-10-17 10:30:00 | ES | Futures | 6126.83 | 6128.39 | 6116.97 | 6118.52 | 70064.0 |
| 2024-10-17 11:00:00 | ES | Futures | 6118.78 | 6128.9 | 6110.74 | 6128.13 | 66186.0 |
| 2024-10-17 11:30:00 | ES | Futures | 6128.39 | 6135.91 | 6126.57 | 6135.39 | 46050.0 |
| 2024-10-17 12:00:00 | ES | Futures | 6135.39 | 6138.77 | 6129.94 | 6131.24 | 43616.0 |
| 2024-10-17 12:30:00 | ES | Futures | 6131.24 | 6134.87 | 6125.27 | 6132.28 | 34953.0 |
| 2024-10-17 13:00:00 | ES | Futures | 6132.28 | 6135.65 | 6128.9 | 6130.2 | 36396.0 |
| 2024-10-17 13:30:00 | ES | Futures | 6130.46 | 6135.13 | 6129.16 | 6132.02 | 29979.0 |
| 2024-10-17 14:00:00 | ES | Futures | 6132.02 | 6132.54 | 6112.04 | 6113.85 | 92209.0 |
| 2024-10-17 14:30:00 | ES | Futures | 6113.85 | 6121.38 | 6111.52 | 6121.12 | 45486.0 |
| 2024-10-17 15:00:00 | ES | Futures | 6121.12 | 6121.64 | 6113.07 | 6113.07 | 44696.0 |
| 2024-10-17 15:30:00 | ES | Futures | 6113.33 | 6114.89 | 6108.92 | 6110.48 | 108733.0 |
| 2024-10-17 16:00:00 | ES | Futures | 6110.74 | 6116.71 | 6108.92 | 6112.55 | 43782.0 |
| 2024-10-17 16:30:00 | ES | Futures | 6112.55 | 6113.59 | 6111.52 | 6111.78 | 14334.0 |
| 2024-10-17 18:00:00 | ES | Futures | 6112.55 | 6116.19 | 6110.48 | 6115.41 | 2446.0 |
| 2024-10-17 18:30:00 | ES | Futures | 6115.41 | 6118.26 | 6115.15 | 6116.45 | 2022.0 |
| 2024-10-17 19:00:00 | ES | Futures | 6116.19 | 6116.71 | 6114.63 | 6115.93 | 1044.0 |
| 2024-10-17 19:30:00 | ES | Futures | 6115.93 | 6116.97 | 6115.41 | 6116.19 | 1054.0 |
| 2024-10-17 20:00:00 | ES | Futures | 6115.93 | 6116.19 | 6101.14 | 6103.47 | 6290.0 |
| 2024-10-17 20:30:00 | ES | Futures | 6103.47 | 6109.7 | 6100.1 | 6108.4 | 4561.0 |
| 2024-10-17 21:00:00 | ES | Futures | 6108.4 | 6109.18 | 6107.36 | 6108.92 | 2102.0 |
| 2024-10-17 21:30:00 | ES | Futures | 6109.18 | 6112.55 | 6106.85 | 6111.52 | 3365.0 |
| 2024-10-17 22:00:00 | ES | Futures | 6111.52 | 6112.81 | 6108.66 | 6110.74 | 3264.0 |
| 2024-10-17 22:30:00 | ES | Futures | 6110.74 | 6113.07 | 6109.7 | 6110.74 | 1793.0 |
| 2024-10-17 23:00:00 | ES | Futures | 6110.48 | 6112.04 | 6109.7 | 6111.26 | 1653.0 |
| 2024-10-17 23:30:00 | ES | Futures | 6111.0 | 6111.26 | 6106.85 | 6108.4 | 1565.0 |
| 2024-10-17 00:00:00 | NQ | Futures | 21182.95 | 21185.56 | 21173.56 | 21181.12 | 638.0 |
| 2024-10-17 00:30:00 | NQ | Futures | 21181.12 | 21186.08 | 21175.64 | 21182.17 | 471.0 |
| 2024-10-17 01:00:00 | NQ | Futures | 21182.17 | 21199.91 | 21179.3 | 21188.95 | 866.0 |
| 2024-10-17 01:30:00 | NQ | Futures | 21188.43 | 21235.91 | 21186.86 | 21229.39 | 3709.0 |
> showing 50 of 3,980 rows — these rows as CSV