PREVIEW / stock_30min / 2025-04-28
file: by_date/stock_30min/2025/2025-04-28.parquet size: 2.1 MB rows: 102,281 symbols: 423
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-04-28 04:00:00 | AAPL | Stock | 208.76 | 208.76 | 207.74 | 208.19 | 10940.0 |
| 2025-04-28 04:30:00 | AAPL | Stock | 208.2 | 208.71 | 208.19 | 208.71 | 4972.0 |
| 2025-04-28 05:00:00 | AAPL | Stock | 208.8 | 209.49 | 208.58 | 209.49 | 14122.0 |
| 2025-04-28 05:30:00 | AAPL | Stock | 209.6 | 210.0 | 209.57 | 209.73 | 15862.0 |
| 2025-04-28 06:00:00 | AAPL | Stock | 209.65 | 209.68 | 209.32 | 209.44 | 11140.0 |
| 2025-04-28 06:30:00 | AAPL | Stock | 209.65 | 209.65 | 209.28 | 209.32 | 3857.0 |
| 2025-04-28 07:00:00 | AAPL | Stock | 209.35 | 209.68 | 209.16 | 209.68 | 12228.0 |
| 2025-04-28 07:30:00 | AAPL | Stock | 209.72 | 210.0 | 209.72 | 209.92 | 22277.0 |
| 2025-04-28 08:00:00 | AAPL | Stock | 209.3 | 210.05 | 207.57 | 209.75 | 103211.0 |
| 2025-04-28 08:30:00 | AAPL | Stock | 209.75 | 210.08 | 209.7396 | 210.05 | 57185.0 |
| 2025-04-28 09:00:00 | AAPL | Stock | 210.05 | 210.3793 | 209.65 | 210.09 | 79034.0 |
| 2025-04-28 09:30:00 | AAPL | Stock | 210.06 | 211.5 | 208.95 | 209.385 | 4113048.0 |
| 2025-04-28 10:00:00 | AAPL | Stock | 209.385 | 209.8186 | 208.74 | 208.84 | 1655984.0 |
| 2025-04-28 10:30:00 | AAPL | Stock | 208.875 | 209.82 | 208.73 | 209.03 | 1542134.0 |
| 2025-04-28 11:00:00 | AAPL | Stock | 209.04 | 209.53 | 207.84 | 207.95 | 1561806.0 |
| 2025-04-28 11:30:00 | AAPL | Stock | 207.9859 | 208.4 | 207.58 | 207.96 | 912870.0 |
| 2025-04-28 12:00:00 | AAPL | Stock | 207.95 | 208.06 | 207.46 | 207.86 | 851055.0 |
| 2025-04-28 12:30:00 | AAPL | Stock | 207.85 | 208.73 | 207.85 | 208.445 | 852575.0 |
| 2025-04-28 13:00:00 | AAPL | Stock | 208.43 | 208.73 | 207.91 | 208.14 | 738187.0 |
| 2025-04-28 13:30:00 | AAPL | Stock | 208.135 | 209.86 | 208.08 | 209.75 | 1098539.0 |
| 2025-04-28 14:00:00 | AAPL | Stock | 209.73 | 210.05 | 209.46 | 209.87 | 1206786.0 |
| 2025-04-28 14:30:00 | AAPL | Stock | 209.85 | 210.1 | 209.7614 | 209.8407 | 680978.0 |
| 2025-04-28 15:00:00 | AAPL | Stock | 209.87 | 210.94 | 209.8 | 210.54 | 1141031.0 |
| 2025-04-28 15:30:00 | AAPL | Stock | 210.52 | 211.5 | 210.04 | 210.09 | 2717732.0 |
| 2025-04-28 16:00:00 | AAPL | Stock | 210.14 | 210.2 | 209.7502 | 210.0 | 6926579.0 |
| 2025-04-28 16:30:00 | AAPL | Stock | 209.99 | 210.14 | 209.8 | 210.0899 | 92736.0 |
| 2025-04-28 17:00:00 | AAPL | Stock | 210.09 | 210.09 | 209.8 | 209.82 | 9219.0 |
| 2025-04-28 17:30:00 | AAPL | Stock | 209.82 | 209.9 | 209.65 | 209.7 | 13782.0 |
| 2025-04-28 18:00:00 | AAPL | Stock | 209.65 | 209.95 | 209.6 | 209.79 | 20401.0 |
| 2025-04-28 18:30:00 | AAPL | Stock | 209.9 | 209.99 | 209.77 | 209.89 | 7087.0 |
| 2025-04-28 19:00:00 | AAPL | Stock | 210.0 | 210.95 | 209.84 | 210.7 | 13299.0 |
| 2025-04-28 19:30:00 | AAPL | Stock | 210.7 | 210.7 | 210.15 | 210.3 | 7916.0 |
| 2025-04-28 04:00:00 | MSFT | Stock | 392.0 | 392.0 | 390.82 | 391.31 | 2864.0 |
| 2025-04-28 04:30:00 | MSFT | Stock | 391.75 | 391.85 | 391.62 | 391.62 | 1449.0 |
| 2025-04-28 05:00:00 | MSFT | Stock | 391.86 | 391.86 | 391.0 | 391.62 | 2747.0 |
| 2025-04-28 05:30:00 | MSFT | Stock | 391.69 | 392.35 | 391.69 | 392.06 | 5009.0 |
| 2025-04-28 06:00:00 | MSFT | Stock | 391.85 | 391.85 | 391.25 | 391.25 | 1273.0 |
| 2025-04-28 06:30:00 | MSFT | Stock | 391.2 | 391.2 | 391.2 | 391.2 | 304.0 |
| 2025-04-28 07:00:00 | MSFT | Stock | 391.33 | 391.4 | 390.94 | 391.3 | 2999.0 |
| 2025-04-28 07:30:00 | MSFT | Stock | 391.3 | 391.53 | 391.25 | 391.25 | 2261.0 |
| 2025-04-28 08:00:00 | MSFT | Stock | 390.89 | 391.9765 | 389.63 | 391.9765 | 13080.0 |
| 2025-04-28 08:30:00 | MSFT | Stock | 391.9765 | 392.3978 | 391.5092 | 392.1197 | 5296.0 |
| 2025-04-28 09:00:00 | MSFT | Stock | 392.05 | 393.0 | 391.85 | 391.85 | 14887.0 |
| 2025-04-28 09:30:00 | MSFT | Stock | 392.08 | 392.08 | 387.65 | 389.85 | 1798329.0 |
| 2025-04-28 10:00:00 | MSFT | Stock | 389.93 | 390.64 | 388.99 | 389.445 | 508262.0 |
| 2025-04-28 10:30:00 | MSFT | Stock | 389.475 | 390.89 | 389.09 | 390.4 | 510371.0 |
| 2025-04-28 11:00:00 | MSFT | Stock | 390.46 | 390.71 | 387.73 | 388.17 | 388499.0 |
| 2025-04-28 11:30:00 | MSFT | Stock | 388.17 | 388.86 | 387.5 | 387.91 | 266766.0 |
| 2025-04-28 12:00:00 | MSFT | Stock | 387.91 | 388.1227 | 386.7085 | 386.99 | 303507.0 |
| 2025-04-28 12:30:00 | MSFT | Stock | 387.04 | 388.28 | 386.95 | 387.49 | 224332.0 |
> showing 50 of 102,281 rows — these rows as CSV