PREVIEW / stock_30min / 2025-07-29
file: by_date/stock_30min/2025/2025-07-29.parquet size: 2.2 MB rows: 106,183 symbols: 356
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-29 04:00:00 | AAPL | Stock | 214.06 | 214.15 | 213.91 | 214.13 | 3070.0 |
| 2025-07-29 04:30:00 | AAPL | Stock | 214.19 | 214.19 | 214.05 | 214.05 | 2509.0 |
| 2025-07-29 05:00:00 | AAPL | Stock | 214.03 | 214.14 | 213.99 | 213.99 | 1282.0 |
| 2025-07-29 05:30:00 | AAPL | Stock | 214.08 | 214.1 | 214.01 | 214.1 | 4782.0 |
| 2025-07-29 06:00:00 | AAPL | Stock | 214.1 | 214.1 | 213.98 | 214.0 | 3639.0 |
| 2025-07-29 06:30:00 | AAPL | Stock | 214.02 | 214.04 | 213.8 | 213.81 | 3841.0 |
| 2025-07-29 07:00:00 | AAPL | Stock | 213.82 | 214.0 | 213.8 | 213.89 | 9498.0 |
| 2025-07-29 07:30:00 | AAPL | Stock | 213.89 | 214.04 | 213.75 | 214.0 | 15016.0 |
| 2025-07-29 08:00:00 | AAPL | Stock | 213.84 | 214.1496 | 213.75 | 214.0 | 55041.0 |
| 2025-07-29 08:30:00 | AAPL | Stock | 214.05 | 214.14 | 213.95 | 214.12 | 21577.0 |
| 2025-07-29 09:00:00 | AAPL | Stock | 214.04 | 214.29 | 214.0 | 214.16 | 41439.0 |
| 2025-07-29 09:30:00 | AAPL | Stock | 214.16 | 214.81 | 211.5 | 212.54 | 5409196.0 |
| 2025-07-29 10:00:00 | AAPL | Stock | 212.56 | 213.39 | 212.07 | 213.03 | 2959741.0 |
| 2025-07-29 10:30:00 | AAPL | Stock | 213.04 | 213.2483 | 212.12 | 212.6 | 2272584.0 |
| 2025-07-29 11:00:00 | AAPL | Stock | 212.605 | 212.7695 | 211.89 | 211.9 | 1769992.0 |
| 2025-07-29 11:30:00 | AAPL | Stock | 211.88 | 212.54 | 211.69 | 212.51 | 1990881.0 |
| 2025-07-29 12:00:00 | AAPL | Stock | 212.51 | 212.93 | 212.0 | 212.0 | 1730431.0 |
| 2025-07-29 12:30:00 | AAPL | Stock | 212.0 | 212.2365 | 211.84 | 212.1761 | 1249470.0 |
| 2025-07-29 13:00:00 | AAPL | Stock | 212.16 | 212.39 | 210.82 | 212.205 | 2333996.0 |
| 2025-07-29 13:30:00 | AAPL | Stock | 212.21 | 212.385 | 211.9301 | 212.075 | 1146418.0 |
| 2025-07-29 14:00:00 | AAPL | Stock | 212.065 | 212.39 | 211.81 | 211.96 | 1228791.0 |
| 2025-07-29 14:30:00 | AAPL | Stock | 211.965 | 212.44 | 211.96 | 211.98 | 1007477.0 |
| 2025-07-29 15:00:00 | AAPL | Stock | 211.97 | 212.05 | 211.6 | 211.89 | 1586237.0 |
| 2025-07-29 15:30:00 | AAPL | Stock | 211.89 | 211.91 | 211.0545 | 211.35 | 3803714.0 |
| 2025-07-29 16:00:00 | AAPL | Stock | 211.36 | 211.7 | 211.08 | 211.17 | 7210135.0 |
| 2025-07-29 16:30:00 | AAPL | Stock | 211.13 | 211.3995 | 211.1 | 211.3 | 22713.0 |
| 2025-07-29 17:00:00 | AAPL | Stock | 211.344 | 211.5 | 211.24 | 211.3 | 16554.0 |
| 2025-07-29 17:30:00 | AAPL | Stock | 211.371 | 211.45 | 211.2004 | 211.45 | 14812.0 |
| 2025-07-29 18:00:00 | AAPL | Stock | 211.4482 | 211.49 | 211.35 | 211.37 | 6088.0 |
| 2025-07-29 18:30:00 | AAPL | Stock | 211.42 | 211.44 | 211.38 | 211.402 | 4090.0 |
| 2025-07-29 19:00:00 | AAPL | Stock | 211.42 | 211.46 | 211.38 | 211.4101 | 13530.0 |
| 2025-07-29 19:30:00 | AAPL | Stock | 211.41 | 211.44 | 211.255 | 211.29 | 13390.0 |
| 2025-07-29 04:00:00 | MSFT | Stock | 513.77 | 513.84 | 513.5 | 513.84 | 964.0 |
| 2025-07-29 04:30:00 | MSFT | Stock | 513.99 | 514.02 | 513.45 | 513.45 | 2108.0 |
| 2025-07-29 05:00:00 | MSFT | Stock | 513.89 | 513.89 | 513.89 | 513.89 | 100.0 |
| 2025-07-29 05:30:00 | MSFT | Stock | 513.7 | 513.89 | 513.65 | 513.65 | 418.0 |
| 2025-07-29 06:00:00 | MSFT | Stock | 513.71 | 513.71 | 513.4 | 513.52 | 756.0 |
| 2025-07-29 06:30:00 | MSFT | Stock | 513.6 | 513.7 | 513.52 | 513.52 | 999.0 |
| 2025-07-29 07:00:00 | MSFT | Stock | 513.69 | 514.54 | 513.53 | 514.15 | 12153.0 |
| 2025-07-29 07:30:00 | MSFT | Stock | 514.16 | 514.16 | 513.0 | 513.02 | 2611.0 |
| 2025-07-29 08:00:00 | MSFT | Stock | 514.0 | 514.55 | 511.219 | 513.5 | 12822.0 |
| 2025-07-29 08:30:00 | MSFT | Stock | 513.5 | 513.75 | 513.24 | 513.5 | 3211.0 |
| 2025-07-29 09:00:00 | MSFT | Stock | 513.51 | 516.23 | 513.5 | 515.81 | 30766.0 |
| 2025-07-29 09:30:00 | MSFT | Stock | 515.53 | 517.62 | 514.83 | 515.35 | 1336716.0 |
| 2025-07-29 10:00:00 | MSFT | Stock | 515.395 | 515.5 | 513.73 | 514.31 | 673916.0 |
| 2025-07-29 10:30:00 | MSFT | Stock | 514.345 | 514.39 | 512.7 | 513.07 | 638471.0 |
| 2025-07-29 11:00:00 | MSFT | Stock | 513.05 | 513.6 | 512.88 | 513.36 | 459107.0 |
| 2025-07-29 11:30:00 | MSFT | Stock | 513.335 | 514.73 | 513.2 | 514.0 | 488032.0 |
| 2025-07-29 12:00:00 | MSFT | Stock | 513.99 | 514.1 | 512.39 | 512.8199 | 324793.0 |
| 2025-07-29 12:30:00 | MSFT | Stock | 512.785 | 513.45 | 512.15 | 513.372 | 351824.0 |
> showing 50 of 106,183 rows — these rows as CSV