PREVIEW / stock_30min / 2025-09-29
file: by_date/stock_30min/2025/2025-09-29.parquet size: 2.3 MB rows: 114,175 symbols: 301
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-29 04:00:00 | AAPL | Stock | 255.5 | 255.65 | 254.5 | 254.55 | 37365.0 |
| 2025-09-29 04:30:00 | AAPL | Stock | 254.81 | 254.88 | 254.45 | 254.6 | 11712.0 |
| 2025-09-29 05:00:00 | AAPL | Stock | 254.78 | 254.88 | 254.7 | 254.83 | 6120.0 |
| 2025-09-29 05:30:00 | AAPL | Stock | 254.81 | 255.3 | 254.79 | 255.1 | 11855.0 |
| 2025-09-29 06:00:00 | AAPL | Stock | 255.11 | 255.24 | 254.93 | 255.05 | 8170.0 |
| 2025-09-29 06:30:00 | AAPL | Stock | 255.0 | 255.0 | 254.47 | 254.72 | 16022.0 |
| 2025-09-29 07:00:00 | AAPL | Stock | 254.9 | 255.25 | 254.73 | 254.8 | 19810.0 |
| 2025-09-29 07:30:00 | AAPL | Stock | 254.96 | 254.96 | 254.49 | 254.6 | 16051.0 |
| 2025-09-29 08:00:00 | AAPL | Stock | 254.8 | 256.22 | 254.45 | 255.23 | 127527.0 |
| 2025-09-29 08:30:00 | AAPL | Stock | 255.29 | 255.37 | 254.76 | 255.34 | 31172.0 |
| 2025-09-29 09:00:00 | AAPL | Stock | 255.3414 | 255.77 | 254.25 | 254.6 | 131339.0 |
| 2025-09-29 09:30:00 | AAPL | Stock | 254.56 | 254.87 | 253.01 | 253.705 | 4506914.0 |
| 2025-09-29 10:00:00 | AAPL | Stock | 253.705 | 254.5 | 253.2709 | 254.2199 | 2099403.0 |
| 2025-09-29 10:30:00 | AAPL | Stock | 254.205 | 254.24 | 253.7 | 253.93 | 1698061.0 |
| 2025-09-29 11:00:00 | AAPL | Stock | 253.95 | 254.17 | 253.31 | 253.48 | 1421896.0 |
| 2025-09-29 11:30:00 | AAPL | Stock | 253.46 | 253.65 | 253.12 | 253.535 | 1355278.0 |
| 2025-09-29 12:00:00 | AAPL | Stock | 253.535 | 254.07 | 253.53 | 253.66 | 1090204.0 |
| 2025-09-29 12:30:00 | AAPL | Stock | 253.67 | 253.78 | 253.25 | 253.34 | 1035343.0 |
| 2025-09-29 13:00:00 | AAPL | Stock | 253.35 | 253.465 | 253.21 | 253.4 | 925078.0 |
| 2025-09-29 13:30:00 | AAPL | Stock | 253.39 | 253.5 | 253.13 | 253.355 | 1014073.0 |
| 2025-09-29 14:00:00 | AAPL | Stock | 253.355 | 254.615 | 253.3412 | 254.57 | 1568039.0 |
| 2025-09-29 14:30:00 | AAPL | Stock | 254.57 | 254.6 | 253.895 | 254.06 | 1054139.0 |
| 2025-09-29 15:00:00 | AAPL | Stock | 254.055 | 254.13 | 253.61 | 253.99 | 1189771.0 |
| 2025-09-29 15:30:00 | AAPL | Stock | 253.99 | 255.0 | 253.94 | 254.35 | 2847934.0 |
| 2025-09-29 16:00:00 | AAPL | Stock | 254.43 | 254.5 | 254.26 | 254.3 | 7383606.0 |
| 2025-09-29 16:30:00 | AAPL | Stock | 254.282 | 254.43 | 254.04 | 254.04 | 6117.0 |
| 2025-09-29 17:00:00 | AAPL | Stock | 254.12 | 254.43 | 254.0 | 254.05 | 180540.0 |
| 2025-09-29 17:30:00 | AAPL | Stock | 254.0 | 254.43 | 253.79 | 253.8514 | 14912.0 |
| 2025-09-29 18:00:00 | AAPL | Stock | 253.93 | 254.0 | 253.86 | 253.91 | 3762.0 |
| 2025-09-29 18:30:00 | AAPL | Stock | 253.96 | 254.192 | 253.8515 | 254.1 | 5691.0 |
| 2025-09-29 19:00:00 | AAPL | Stock | 253.85 | 254.2 | 253.85 | 254.13 | 2229.0 |
| 2025-09-29 19:30:00 | AAPL | Stock | 254.29 | 254.29 | 254.0 | 254.0 | 15880.0 |
| 2025-09-29 04:00:00 | MSFT | Stock | 512.11 | 513.1 | 512.11 | 512.84 | 6742.0 |
| 2025-09-29 04:30:00 | MSFT | Stock | 513.07 | 513.07 | 513.07 | 513.07 | 300.0 |
| 2025-09-29 05:00:00 | MSFT | Stock | 512.89 | 513.33 | 512.89 | 513.33 | 2681.0 |
| 2025-09-29 05:30:00 | MSFT | Stock | 513.53 | 514.65 | 512.51 | 513.14 | 9125.0 |
| 2025-09-29 06:00:00 | MSFT | Stock | 513.08 | 513.3 | 513.08 | 513.3 | 716.0 |
| 2025-09-29 06:30:00 | MSFT | Stock | 513.72 | 513.72 | 513.5 | 513.5 | 200.0 |
| 2025-09-29 07:00:00 | MSFT | Stock | 513.2 | 513.33 | 512.99 | 513.28 | 1700.0 |
| 2025-09-29 07:30:00 | MSFT | Stock | 512.85 | 513.28 | 512.69 | 513.28 | 2253.0 |
| 2025-09-29 08:00:00 | MSFT | Stock | 513.5 | 513.7 | 511.96 | 512.94 | 20337.0 |
| 2025-09-29 08:30:00 | MSFT | Stock | 512.93 | 513.5 | 512.87 | 513.44 | 8008.0 |
| 2025-09-29 09:00:00 | MSFT | Stock | 513.49 | 513.7 | 511.28 | 511.5 | 17845.0 |
| 2025-09-29 09:30:00 | MSFT | Stock | 511.5 | 515.84 | 508.88 | 515.395 | 1397050.0 |
| 2025-09-29 10:00:00 | MSFT | Stock | 515.395 | 516.845 | 515.05 | 515.735 | 839589.0 |
| 2025-09-29 10:30:00 | MSFT | Stock | 515.7 | 515.7 | 514.21 | 514.25 | 414636.0 |
| 2025-09-29 11:00:00 | MSFT | Stock | 514.29 | 514.595 | 512.4 | 512.97 | 374059.0 |
| 2025-09-29 11:30:00 | MSFT | Stock | 512.97 | 513.99 | 512.92 | 513.55 | 301778.0 |
| 2025-09-29 12:00:00 | MSFT | Stock | 513.63 | 515.46 | 513.52 | 515.26 | 306411.0 |
| 2025-09-29 12:30:00 | MSFT | Stock | 515.25 | 515.7299 | 514.46 | 514.83 | 267619.0 |
> showing 50 of 114,175 rows — these rows as CSV