PREVIEW / stock_30min / 2025-05-14
file: by_date/stock_30min/2025/2025-05-14.parquet size: 2.2 MB rows: 105,797 symbols: 421
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-05-14 04:00:00 | AAPL | Stock | 212.8 | 212.8 | 211.8 | 211.85 | 19836.0 |
| 2025-05-14 04:30:00 | AAPL | Stock | 211.9 | 212.0 | 211.8 | 211.96 | 8964.0 |
| 2025-05-14 05:00:00 | AAPL | Stock | 211.9 | 212.0 | 211.55 | 211.92 | 7398.0 |
| 2025-05-14 05:30:00 | AAPL | Stock | 211.98 | 211.99 | 211.75 | 211.75 | 9959.0 |
| 2025-05-14 06:00:00 | AAPL | Stock | 211.76 | 211.94 | 211.68 | 211.75 | 9843.0 |
| 2025-05-14 06:30:00 | AAPL | Stock | 211.95 | 212.11 | 211.85 | 211.91 | 4402.0 |
| 2025-05-14 07:00:00 | AAPL | Stock | 212.1 | 212.49 | 211.99 | 212.4 | 50147.0 |
| 2025-05-14 07:30:00 | AAPL | Stock | 212.43 | 212.54 | 212.15 | 212.29 | 30962.0 |
| 2025-05-14 08:00:00 | AAPL | Stock | 212.39 | 212.8 | 211.7736 | 212.41 | 135712.0 |
| 2025-05-14 08:30:00 | AAPL | Stock | 212.5344 | 212.5344 | 212.06 | 212.26 | 43219.0 |
| 2025-05-14 09:00:00 | AAPL | Stock | 212.25 | 212.7 | 212.02 | 212.42 | 97732.0 |
| 2025-05-14 09:30:00 | AAPL | Stock | 212.43 | 213.61 | 211.85 | 213.11 | 4860267.0 |
| 2025-05-14 10:00:00 | AAPL | Stock | 213.11 | 213.94 | 212.5524 | 213.29 | 2858833.0 |
| 2025-05-14 10:30:00 | AAPL | Stock | 213.29 | 213.7164 | 212.37 | 212.98 | 1883706.0 |
| 2025-05-14 11:00:00 | AAPL | Stock | 212.98 | 213.0999 | 211.8898 | 212.62 | 1861583.0 |
| 2025-05-14 11:30:00 | AAPL | Stock | 212.618 | 212.88 | 212.3525 | 212.39 | 1203792.0 |
| 2025-05-14 12:00:00 | AAPL | Stock | 212.3811 | 212.64 | 211.99 | 212.29 | 1082671.0 |
| 2025-05-14 12:30:00 | AAPL | Stock | 212.295 | 212.6 | 211.97 | 212.01 | 1083497.0 |
| 2025-05-14 13:00:00 | AAPL | Stock | 212.0 | 212.03 | 210.5801 | 210.96 | 2104131.0 |
| 2025-05-14 13:30:00 | AAPL | Stock | 210.97 | 211.7499 | 210.96 | 211.695 | 1132150.0 |
| 2025-05-14 14:00:00 | AAPL | Stock | 211.7 | 211.9452 | 211.36 | 211.38 | 1045020.0 |
| 2025-05-14 14:30:00 | AAPL | Stock | 211.38 | 212.05 | 211.19 | 211.4 | 1445668.0 |
| 2025-05-14 15:00:00 | AAPL | Stock | 211.4 | 211.635 | 210.99 | 211.3595 | 1321494.0 |
| 2025-05-14 15:30:00 | AAPL | Stock | 211.34 | 212.68 | 211.24 | 212.41 | 4822394.0 |
| 2025-05-14 16:00:00 | AAPL | Stock | 212.41 | 212.41 | 211.9 | 212.0 | 7683391.0 |
| 2025-05-14 16:30:00 | AAPL | Stock | 211.91 | 212.33 | 211.89 | 211.92 | 17252.0 |
| 2025-05-14 17:00:00 | AAPL | Stock | 211.92 | 211.9996 | 211.9 | 211.99 | 6883.0 |
| 2025-05-14 17:30:00 | AAPL | Stock | 211.97 | 211.98 | 211.8012 | 211.96 | 5617.0 |
| 2025-05-14 18:00:00 | AAPL | Stock | 211.97 | 211.97 | 211.8024 | 211.84 | 12704.0 |
| 2025-05-14 18:30:00 | AAPL | Stock | 211.84 | 211.9699 | 211.75 | 211.96 | 14498.0 |
| 2025-05-14 19:00:00 | AAPL | Stock | 211.93 | 211.94 | 211.63 | 211.7 | 18068.0 |
| 2025-05-14 19:30:00 | AAPL | Stock | 211.62 | 211.9661 | 211.58 | 211.9661 | 16483.0 |
| 2025-05-14 04:00:00 | MSFT | Stock | 447.25 | 447.36 | 446.93 | 446.93 | 3087.0 |
| 2025-05-14 04:30:00 | MSFT | Stock | 446.12 | 446.12 | 445.52 | 445.94 | 2967.0 |
| 2025-05-14 05:00:00 | MSFT | Stock | 445.51 | 446.3 | 445.5 | 446.3 | 1026.0 |
| 2025-05-14 05:30:00 | MSFT | Stock | 446.07 | 446.07 | 445.48 | 445.5 | 4836.0 |
| 2025-05-14 06:00:00 | MSFT | Stock | 445.63 | 446.21 | 445.62 | 446.21 | 1030.0 |
| 2025-05-14 06:30:00 | MSFT | Stock | 446.35 | 446.97 | 446.35 | 446.97 | 1382.0 |
| 2025-05-14 07:00:00 | MSFT | Stock | 447.0 | 447.78 | 446.9 | 447.7 | 9988.0 |
| 2025-05-14 07:30:00 | MSFT | Stock | 447.74 | 447.74 | 447.0 | 447.01 | 6015.0 |
| 2025-05-14 08:00:00 | MSFT | Stock | 447.89 | 449.0 | 445.56 | 447.32 | 22502.0 |
| 2025-05-14 08:30:00 | MSFT | Stock | 447.34 | 447.7996 | 447.0 | 447.26 | 14846.0 |
| 2025-05-14 09:00:00 | MSFT | Stock | 447.1 | 448.19 | 446.3 | 448.0 | 21189.0 |
| 2025-05-14 09:30:00 | MSFT | Stock | 448.14 | 453.33 | 448.14 | 453.27 | 2053851.0 |
| 2025-05-14 10:00:00 | MSFT | Stock | 453.27 | 453.75 | 451.2659 | 452.82 | 959920.0 |
| 2025-05-14 10:30:00 | MSFT | Stock | 452.82 | 453.9 | 452.48 | 452.815 | 936760.0 |
| 2025-05-14 11:00:00 | MSFT | Stock | 452.86 | 453.2 | 451.62 | 452.695 | 401967.0 |
| 2025-05-14 11:30:00 | MSFT | Stock | 452.71 | 453.56 | 452.4208 | 452.8125 | 374317.0 |
| 2025-05-14 12:00:00 | MSFT | Stock | 452.77 | 452.92 | 451.785 | 452.355 | 359220.0 |
| 2025-05-14 12:30:00 | MSFT | Stock | 452.3253 | 452.54 | 451.2 | 451.4446 | 307686.0 |
> showing 50 of 105,797 rows — these rows as CSV