PREVIEW / stock_30min / 2025-08-19
file: by_date/stock_30min/2025/2025-08-19.parquet size: 2.2 MB rows: 105,330 symbols: 335
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-08-19 04:00:00 | AAPL | Stock | 230.5 | 230.55 | 230.2 | 230.3 | 4174.0 |
| 2025-08-19 04:30:00 | AAPL | Stock | 230.3 | 230.41 | 230.3 | 230.34 | 1646.0 |
| 2025-08-19 05:00:00 | AAPL | Stock | 230.34 | 230.55 | 230.31 | 230.55 | 1908.0 |
| 2025-08-19 05:30:00 | AAPL | Stock | 230.57 | 230.57 | 230.42 | 230.42 | 1241.0 |
| 2025-08-19 06:00:00 | AAPL | Stock | 230.33 | 230.4 | 230.33 | 230.34 | 768.0 |
| 2025-08-19 06:30:00 | AAPL | Stock | 230.38 | 230.38 | 229.95 | 230.04 | 7127.0 |
| 2025-08-19 07:00:00 | AAPL | Stock | 230.24 | 230.34 | 230.06 | 230.24 | 3860.0 |
| 2025-08-19 07:30:00 | AAPL | Stock | 230.23 | 230.5 | 230.23 | 230.5 | 3863.0 |
| 2025-08-19 08:00:00 | AAPL | Stock | 230.38 | 230.6 | 230.0 | 230.46 | 30308.0 |
| 2025-08-19 08:30:00 | AAPL | Stock | 230.41 | 230.6 | 230.11 | 230.1905 | 10377.0 |
| 2025-08-19 09:00:00 | AAPL | Stock | 230.22 | 231.46 | 230.12 | 231.28 | 67714.0 |
| 2025-08-19 09:30:00 | AAPL | Stock | 231.275 | 232.29 | 230.59 | 232.07 | 3357784.0 |
| 2025-08-19 10:00:00 | AAPL | Stock | 232.04 | 232.87 | 231.59 | 231.82 | 2250518.0 |
| 2025-08-19 10:30:00 | AAPL | Stock | 231.82 | 232.27 | 230.785 | 230.88 | 1839261.0 |
| 2025-08-19 11:00:00 | AAPL | Stock | 230.88 | 231.34 | 230.47 | 231.3226 | 1663746.0 |
| 2025-08-19 11:30:00 | AAPL | Stock | 231.32 | 231.66 | 231.14 | 231.395 | 1189636.0 |
| 2025-08-19 12:00:00 | AAPL | Stock | 231.3912 | 231.54 | 231.055 | 231.3117 | 790170.0 |
| 2025-08-19 12:30:00 | AAPL | Stock | 231.29 | 231.33 | 230.7 | 230.715 | 1126048.0 |
| 2025-08-19 13:00:00 | AAPL | Stock | 230.715 | 230.75 | 230.06 | 230.625 | 1176508.0 |
| 2025-08-19 13:30:00 | AAPL | Stock | 230.62 | 230.9 | 230.5542 | 230.79 | 849504.0 |
| 2025-08-19 14:00:00 | AAPL | Stock | 230.79 | 230.79 | 229.87 | 230.05 | 1189593.0 |
| 2025-08-19 14:30:00 | AAPL | Stock | 230.025 | 230.09 | 229.58 | 229.76 | 1250756.0 |
| 2025-08-19 15:00:00 | AAPL | Stock | 229.76 | 230.19 | 229.35 | 230.185 | 1421308.0 |
| 2025-08-19 15:30:00 | AAPL | Stock | 230.185 | 230.69 | 229.99 | 230.56 | 3078726.0 |
| 2025-08-19 16:00:00 | AAPL | Stock | 230.57 | 230.77 | 230.56 | 230.6901 | 5795019.0 |
| 2025-08-19 16:30:00 | AAPL | Stock | 230.77 | 230.77 | 230.5 | 230.56 | 9527.0 |
| 2025-08-19 17:00:00 | AAPL | Stock | 230.5075 | 230.75 | 230.47 | 230.68 | 20336.0 |
| 2025-08-19 17:30:00 | AAPL | Stock | 230.65 | 230.72 | 230.4318 | 230.47 | 5019.0 |
| 2025-08-19 18:00:00 | AAPL | Stock | 230.56 | 230.98 | 230.43 | 230.47 | 21100.0 |
| 2025-08-19 18:30:00 | AAPL | Stock | 230.49 | 230.89 | 230.48 | 230.57 | 4364.0 |
| 2025-08-19 19:00:00 | AAPL | Stock | 230.58 | 230.6724 | 229.81 | 230.28 | 21276.0 |
| 2025-08-19 19:30:00 | AAPL | Stock | 230.0 | 230.19 | 229.77 | 229.83 | 20847.0 |
| 2025-08-19 04:00:00 | MSFT | Stock | 516.78 | 516.78 | 516.3 | 516.3 | 300.0 |
| 2025-08-19 04:30:00 | MSFT | Stock | 516.3 | 517.0 | 516.3 | 517.0 | 994.0 |
| 2025-08-19 05:00:00 | MSFT | Stock | 517.17 | 517.42 | 517.17 | 517.42 | 258.0 |
| 2025-08-19 05:30:00 | MSFT | Stock | 517.29 | 517.29 | 517.29 | 517.29 | 234.0 |
| 2025-08-19 06:00:00 | MSFT | Stock | 517.16 | 517.2 | 517.16 | 517.2 | 225.0 |
| 2025-08-19 06:30:00 | MSFT | Stock | 516.98 | 516.98 | 516.46 | 516.46 | 1061.0 |
| 2025-08-19 07:00:00 | MSFT | Stock | 516.87 | 517.0 | 516.4 | 516.85 | 1909.0 |
| 2025-08-19 07:30:00 | MSFT | Stock | 516.5 | 516.86 | 516.5 | 516.75 | 1466.0 |
| 2025-08-19 08:00:00 | MSFT | Stock | 516.75 | 516.9874 | 516.0 | 516.36 | 14930.0 |
| 2025-08-19 08:30:00 | MSFT | Stock | 516.78 | 517.0 | 516.36 | 516.3737 | 9608.0 |
| 2025-08-19 09:00:00 | MSFT | Stock | 516.56 | 516.7 | 514.85 | 515.21 | 29311.0 |
| 2025-08-19 09:30:00 | MSFT | Stock | 515.23 | 515.24 | 511.7001 | 513.55 | 1439429.0 |
| 2025-08-19 10:00:00 | MSFT | Stock | 513.505 | 514.1389 | 510.96 | 511.22 | 866728.0 |
| 2025-08-19 10:30:00 | MSFT | Stock | 511.175 | 511.92 | 509.62 | 509.83 | 940974.0 |
| 2025-08-19 11:00:00 | MSFT | Stock | 509.8356 | 509.94 | 508.57 | 509.5401 | 900893.0 |
| 2025-08-19 11:30:00 | MSFT | Stock | 509.55 | 510.0 | 509.2 | 509.795 | 543210.0 |
| 2025-08-19 12:00:00 | MSFT | Stock | 509.8 | 510.9799 | 509.79 | 510.46 | 587324.0 |
| 2025-08-19 12:30:00 | MSFT | Stock | 510.4176 | 510.59 | 509.6801 | 510.4 | 461082.0 |
> showing 50 of 105,330 rows — these rows as CSV