PREVIEW / stock_30min / 2025-09-18
file: by_date/stock_30min/2025/2025-09-18.parquet size: 2.3 MB rows: 112,409 symbols: 311
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 |
|---|---|---|---|---|---|---|---|
| 2025-09-18 04:00:00 | AAPL | Stock | 240.7 | 240.83 | 240.0 | 240.59 | 10872.0 |
| 2025-09-18 04:30:00 | AAPL | Stock | 240.61 | 240.98 | 240.51 | 240.9 | 17883.0 |
| 2025-09-18 05:00:00 | AAPL | Stock | 240.9 | 240.93 | 240.38 | 240.59 | 8448.0 |
| 2025-09-18 05:30:00 | AAPL | Stock | 240.57 | 240.8 | 240.11 | 240.33 | 10479.0 |
| 2025-09-18 06:00:00 | AAPL | Stock | 240.33 | 240.33 | 240.03 | 240.08 | 5956.0 |
| 2025-09-18 06:30:00 | AAPL | Stock | 240.02 | 240.24 | 239.81 | 240.2 | 8032.0 |
| 2025-09-18 07:00:00 | AAPL | Stock | 240.11 | 240.28 | 239.86 | 239.87 | 15500.0 |
| 2025-09-18 07:30:00 | AAPL | Stock | 239.87 | 239.87 | 239.07 | 239.4 | 21324.0 |
| 2025-09-18 08:00:00 | AAPL | Stock | 240.05 | 240.97 | 239.0109 | 239.7 | 160668.0 |
| 2025-09-18 08:30:00 | AAPL | Stock | 239.77 | 239.9 | 239.15 | 239.22 | 49212.0 |
| 2025-09-18 09:00:00 | AAPL | Stock | 239.22 | 240.54 | 239.1 | 240.0 | 135362.0 |
| 2025-09-18 09:30:00 | AAPL | Stock | 239.96 | 241.2 | 237.63 | 238.445 | 5002334.0 |
| 2025-09-18 10:00:00 | AAPL | Stock | 238.43 | 238.43 | 236.65 | 237.56 | 3469864.0 |
| 2025-09-18 10:30:00 | AAPL | Stock | 237.565 | 238.39 | 237.315 | 238.235 | 2029545.0 |
| 2025-09-18 11:00:00 | AAPL | Stock | 238.25 | 238.795 | 238.1 | 238.19 | 1456330.0 |
| 2025-09-18 11:30:00 | AAPL | Stock | 238.21 | 238.54 | 237.35 | 237.61 | 1556251.0 |
| 2025-09-18 12:00:00 | AAPL | Stock | 237.59 | 238.18 | 237.445 | 237.94 | 1177447.0 |
| 2025-09-18 12:30:00 | AAPL | Stock | 237.95 | 238.135 | 237.64 | 237.955 | 1069504.0 |
| 2025-09-18 13:00:00 | AAPL | Stock | 237.95 | 238.21 | 237.755 | 237.88 | 1142926.0 |
| 2025-09-18 13:30:00 | AAPL | Stock | 237.87 | 238.1 | 237.2102 | 237.39 | 1088139.0 |
| 2025-09-18 14:00:00 | AAPL | Stock | 237.38 | 238.02 | 237.313 | 237.8018 | 1184558.0 |
| 2025-09-18 14:30:00 | AAPL | Stock | 237.81 | 237.9464 | 237.57 | 237.69 | 1071373.0 |
| 2025-09-18 15:00:00 | AAPL | Stock | 237.69 | 237.8 | 237.2501 | 237.46 | 1564042.0 |
| 2025-09-18 15:30:00 | AAPL | Stock | 237.455 | 238.11 | 237.435 | 237.85 | 3049264.0 |
| 2025-09-18 16:00:00 | AAPL | Stock | 237.88 | 238.15 | 237.86 | 238.02 | 8269369.0 |
| 2025-09-18 16:30:00 | AAPL | Stock | 238.02 | 238.1 | 237.88 | 238.03 | 498983.0 |
| 2025-09-18 17:00:00 | AAPL | Stock | 238.02 | 238.0596 | 237.97 | 238.03 | 5863.0 |
| 2025-09-18 17:30:00 | AAPL | Stock | 238.03 | 238.15 | 237.88 | 238.13 | 20266.0 |
| 2025-09-18 18:00:00 | AAPL | Stock | 238.1 | 238.18 | 238.1 | 238.1795 | 13160.0 |
| 2025-09-18 18:30:00 | AAPL | Stock | 238.1143 | 238.18 | 238.07 | 238.18 | 2477.0 |
| 2025-09-18 19:00:00 | AAPL | Stock | 238.1197 | 238.19 | 238.1 | 238.19 | 10300.0 |
| 2025-09-18 19:30:00 | AAPL | Stock | 238.1076 | 238.2 | 238.1076 | 238.15 | 6019.0 |
| 2025-09-18 04:00:00 | MSFT | Stock | 510.88 | 513.74 | 510.88 | 513.31 | 12799.0 |
| 2025-09-18 04:30:00 | MSFT | Stock | 513.25 | 514.49 | 513.25 | 514.3 | 3082.0 |
| 2025-09-18 05:00:00 | MSFT | Stock | 514.0 | 514.0 | 513.4 | 513.8 | 3558.0 |
| 2025-09-18 05:30:00 | MSFT | Stock | 513.8 | 513.8 | 513.4 | 513.5 | 3518.0 |
| 2025-09-18 06:00:00 | MSFT | Stock | 513.5 | 513.7 | 512.9 | 513.58 | 3038.0 |
| 2025-09-18 06:30:00 | MSFT | Stock | 513.39 | 513.49 | 512.31 | 512.91 | 1830.0 |
| 2025-09-18 07:00:00 | MSFT | Stock | 512.46 | 512.5 | 511.6 | 512.0 | 3404.0 |
| 2025-09-18 07:30:00 | MSFT | Stock | 512.35 | 512.7 | 511.41 | 512.6 | 9954.0 |
| 2025-09-18 08:00:00 | MSFT | Stock | 513.5 | 514.14 | 511.6 | 512.7788 | 26592.0 |
| 2025-09-18 08:30:00 | MSFT | Stock | 512.5501 | 512.7 | 511.5 | 511.5 | 23441.0 |
| 2025-09-18 09:00:00 | MSFT | Stock | 511.26 | 511.52 | 510.14 | 511.03 | 17229.0 |
| 2025-09-18 09:30:00 | MSFT | Stock | 511.49 | 511.49 | 507.66 | 510.07 | 1595371.0 |
| 2025-09-18 10:00:00 | MSFT | Stock | 510.025 | 512.0 | 509.22 | 511.635 | 730625.0 |
| 2025-09-18 10:30:00 | MSFT | Stock | 511.73 | 513.07 | 510.53 | 511.175 | 619586.0 |
| 2025-09-18 11:00:00 | MSFT | Stock | 511.23 | 511.52 | 510.0 | 510.52 | 454447.0 |
| 2025-09-18 11:30:00 | MSFT | Stock | 510.543 | 510.7799 | 508.155 | 508.155 | 379975.0 |
| 2025-09-18 12:00:00 | MSFT | Stock | 508.13 | 509.29 | 507.875 | 508.894 | 533956.0 |
| 2025-09-18 12:30:00 | MSFT | Stock | 508.8901 | 509.66 | 508.74 | 509.505 | 355980.0 |
> showing 50 of 112,409 rows — these rows as CSV