PREVIEW / stock_30min / 2025-07-22
file: by_date/stock_30min/2025/2025-07-22.parquet size: 2.2 MB rows: 107,875 symbols: 366
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-07-22 04:00:00 | AAPL | Stock | 212.88 | 212.88 | 212.41 | 212.6 | 6106.0 |
| 2025-07-22 04:30:00 | AAPL | Stock | 212.57 | 212.96 | 212.57 | 212.8 | 5724.0 |
| 2025-07-22 05:00:00 | AAPL | Stock | 212.8 | 213.0 | 212.79 | 212.91 | 7678.0 |
| 2025-07-22 05:30:00 | AAPL | Stock | 212.94 | 213.04 | 212.72 | 212.72 | 1013.0 |
| 2025-07-22 06:00:00 | AAPL | Stock | 212.86 | 212.86 | 212.76 | 212.76 | 1137.0 |
| 2025-07-22 06:30:00 | AAPL | Stock | 212.73 | 212.8 | 212.65 | 212.8 | 1186.0 |
| 2025-07-22 07:00:00 | AAPL | Stock | 212.78 | 213.0 | 212.69 | 213.0 | 13922.0 |
| 2025-07-22 07:30:00 | AAPL | Stock | 213.01 | 213.15 | 212.97 | 213.05 | 8375.0 |
| 2025-07-22 08:00:00 | AAPL | Stock | 212.92 | 213.2 | 212.4 | 213.06 | 78863.0 |
| 2025-07-22 08:30:00 | AAPL | Stock | 213.0009 | 213.1341 | 212.9 | 213.1001 | 24421.0 |
| 2025-07-22 09:00:00 | AAPL | Stock | 213.12 | 213.29 | 212.74 | 213.2 | 57738.0 |
| 2025-07-22 09:30:00 | AAPL | Stock | 213.29 | 214.03 | 212.2301 | 213.58 | 5581118.0 |
| 2025-07-22 10:00:00 | AAPL | Stock | 213.58 | 213.77 | 212.68 | 213.28 | 2662493.0 |
| 2025-07-22 10:30:00 | AAPL | Stock | 213.25 | 213.62 | 212.72 | 213.2129 | 2165385.0 |
| 2025-07-22 11:00:00 | AAPL | Stock | 213.21 | 213.69 | 213.0 | 213.47 | 1297048.0 |
| 2025-07-22 11:30:00 | AAPL | Stock | 213.47 | 213.83 | 212.76 | 213.265 | 2790950.0 |
| 2025-07-22 12:00:00 | AAPL | Stock | 213.265 | 213.74 | 212.97 | 213.28 | 1785584.0 |
| 2025-07-22 12:30:00 | AAPL | Stock | 213.25 | 213.54 | 212.84 | 213.41 | 1311587.0 |
| 2025-07-22 13:00:00 | AAPL | Stock | 213.4 | 214.48 | 213.37 | 214.41 | 1722472.0 |
| 2025-07-22 13:30:00 | AAPL | Stock | 214.4 | 214.425 | 213.72 | 213.86 | 1456862.0 |
| 2025-07-22 14:00:00 | AAPL | Stock | 213.8634 | 214.06 | 213.44 | 213.71 | 1231576.0 |
| 2025-07-22 14:30:00 | AAPL | Stock | 213.72 | 214.21 | 213.71 | 214.17 | 1038386.0 |
| 2025-07-22 15:00:00 | AAPL | Stock | 214.15 | 214.4199 | 213.825 | 214.185 | 1730117.0 |
| 2025-07-22 15:30:00 | AAPL | Stock | 214.18 | 214.95 | 213.93 | 214.39 | 3698736.0 |
| 2025-07-22 16:00:00 | AAPL | Stock | 214.4 | 214.56 | 214.28 | 214.45 | 5182724.0 |
| 2025-07-22 16:30:00 | AAPL | Stock | 214.49 | 214.55 | 214.4 | 214.5003 | 19866.0 |
| 2025-07-22 17:00:00 | AAPL | Stock | 214.5006 | 214.7 | 214.4 | 214.7 | 27595.0 |
| 2025-07-22 17:30:00 | AAPL | Stock | 214.7 | 214.74 | 214.67 | 214.73 | 26147.0 |
| 2025-07-22 18:00:00 | AAPL | Stock | 214.73 | 214.82 | 214.61 | 214.65 | 20065.0 |
| 2025-07-22 18:30:00 | AAPL | Stock | 214.65 | 215.0 | 214.64 | 214.7 | 11608.0 |
| 2025-07-22 19:00:00 | AAPL | Stock | 214.7 | 215.0 | 214.65 | 214.8 | 22739.0 |
| 2025-07-22 19:30:00 | AAPL | Stock | 214.79 | 215.0 | 214.55 | 214.85 | 19407.0 |
| 2025-07-22 04:00:00 | MSFT | Stock | 508.71 | 509.2 | 508.7 | 508.99 | 1250.0 |
| 2025-07-22 04:30:00 | MSFT | Stock | 508.98 | 508.98 | 508.98 | 508.98 | 100.0 |
| 2025-07-22 05:00:00 | MSFT | Stock | 508.75 | 509.3 | 508.75 | 509.2 | 1664.0 |
| 2025-07-22 05:30:00 | MSFT | Stock | 509.25 | 509.33 | 509.25 | 509.33 | 282.0 |
| 2025-07-22 06:00:00 | MSFT | Stock | 509.47 | 509.8 | 509.38 | 509.38 | 1242.0 |
| 2025-07-22 06:30:00 | MSFT | Stock | 509.22 | 509.22 | 509.22 | 509.22 | 100.0 |
| 2025-07-22 07:00:00 | MSFT | Stock | 509.34 | 509.89 | 509.34 | 509.69 | 977.0 |
| 2025-07-22 07:30:00 | MSFT | Stock | 509.44 | 510.0 | 509.3 | 509.9 | 1791.0 |
| 2025-07-22 08:00:00 | MSFT | Stock | 509.7522 | 510.93 | 508.6713 | 510.85 | 16353.0 |
| 2025-07-22 08:30:00 | MSFT | Stock | 510.9 | 511.0 | 510.2501 | 510.8 | 7145.0 |
| 2025-07-22 09:00:00 | MSFT | Stock | 510.88 | 511.14 | 509.45 | 511.01 | 12538.0 |
| 2025-07-22 09:30:00 | MSFT | Stock | 511.19 | 511.2 | 507.66 | 508.06 | 1006199.0 |
| 2025-07-22 10:00:00 | MSFT | Stock | 507.99 | 509.43 | 507.43 | 508.9469 | 600717.0 |
| 2025-07-22 10:30:00 | MSFT | Stock | 508.92 | 509.59 | 508.58 | 508.76 | 345920.0 |
| 2025-07-22 11:00:00 | MSFT | Stock | 508.8 | 509.31 | 507.9 | 508.24 | 305486.0 |
| 2025-07-22 11:30:00 | MSFT | Stock | 508.22 | 508.56 | 506.95 | 506.98 | 376927.0 |
| 2025-07-22 12:00:00 | MSFT | Stock | 507.0 | 507.725 | 506.65 | 506.77 | 258315.0 |
| 2025-07-22 12:30:00 | MSFT | Stock | 506.72 | 507.1097 | 506.35 | 506.9683 | 249852.0 |
> showing 50 of 107,875 rows — these rows as CSV