PREVIEW / stock_30min / 2025-04-30
file: by_date/stock_30min/2025/2025-04-30.parquet size: 2.1 MB rows: 103,789 symbols: 422
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-30 04:00:00 | AAPL | Stock | 210.58 | 211.34 | 210.58 | 210.81 | 10231.0 |
| 2025-04-30 04:30:00 | AAPL | Stock | 210.9 | 210.9 | 210.61 | 210.72 | 2718.0 |
| 2025-04-30 05:00:00 | AAPL | Stock | 210.72 | 210.72 | 210.72 | 210.72 | 109.0 |
| 2025-04-30 05:30:00 | AAPL | Stock | 210.91 | 210.91 | 210.65 | 210.65 | 999.0 |
| 2025-04-30 06:00:00 | AAPL | Stock | 210.65 | 210.66 | 210.33 | 210.33 | 2956.0 |
| 2025-04-30 06:30:00 | AAPL | Stock | 210.19 | 210.46 | 210.12 | 210.32 | 3120.0 |
| 2025-04-30 07:00:00 | AAPL | Stock | 210.36 | 210.75 | 210.25 | 210.29 | 9102.0 |
| 2025-04-30 07:30:00 | AAPL | Stock | 210.35 | 210.35 | 209.77 | 209.99 | 5847.0 |
| 2025-04-30 08:00:00 | AAPL | Stock | 210.4 | 210.95 | 209.3303 | 209.5 | 67335.0 |
| 2025-04-30 08:30:00 | AAPL | Stock | 209.5 | 209.9377 | 207.02 | 207.49 | 132424.0 |
| 2025-04-30 09:00:00 | AAPL | Stock | 207.55 | 209.68 | 207.01 | 209.29 | 206050.0 |
| 2025-04-30 09:30:00 | AAPL | Stock | 209.26 | 209.72 | 206.6705 | 207.14 | 3125849.0 |
| 2025-04-30 10:00:00 | AAPL | Stock | 207.185 | 209.3499 | 207.14 | 209.3212 | 1468362.0 |
| 2025-04-30 10:30:00 | AAPL | Stock | 209.3495 | 209.75 | 208.7101 | 209.6355 | 1403241.0 |
| 2025-04-30 11:00:00 | AAPL | Stock | 209.59 | 210.86 | 209.56 | 210.545 | 1343981.0 |
| 2025-04-30 11:30:00 | AAPL | Stock | 210.56 | 211.13 | 209.95 | 211.05 | 1026751.0 |
| 2025-04-30 12:00:00 | AAPL | Stock | 211.04 | 211.28 | 210.39 | 210.59 | 873514.0 |
| 2025-04-30 12:30:00 | AAPL | Stock | 210.59 | 211.36 | 210.22 | 210.92 | 889106.0 |
| 2025-04-30 13:00:00 | AAPL | Stock | 210.915 | 211.21 | 209.8 | 211.08 | 897898.0 |
| 2025-04-30 13:30:00 | AAPL | Stock | 211.07 | 211.85 | 210.92 | 211.1031 | 919361.0 |
| 2025-04-30 14:00:00 | AAPL | Stock | 211.13 | 212.97 | 210.315 | 210.715 | 1560495.0 |
| 2025-04-30 14:30:00 | AAPL | Stock | 210.7 | 211.31 | 210.37 | 210.652 | 1147692.0 |
| 2025-04-30 15:00:00 | AAPL | Stock | 210.66 | 211.07 | 210.25 | 210.3446 | 914344.0 |
| 2025-04-30 15:30:00 | AAPL | Stock | 210.375 | 213.58 | 210.05 | 212.48 | 5354413.0 |
| 2025-04-30 16:00:00 | AAPL | Stock | 212.46 | 212.8 | 210.96 | 212.59 | 14330540.0 |
| 2025-04-30 16:30:00 | AAPL | Stock | 212.66 | 212.93 | 212.28 | 212.5 | 109315.0 |
| 2025-04-30 17:00:00 | AAPL | Stock | 212.5 | 212.6548 | 211.56 | 212.0 | 39042.0 |
| 2025-04-30 17:30:00 | AAPL | Stock | 212.0 | 212.4 | 212.0 | 212.1 | 13025.0 |
| 2025-04-30 18:00:00 | AAPL | Stock | 212.09 | 212.15 | 210.5 | 210.57 | 119033.0 |
| 2025-04-30 18:30:00 | AAPL | Stock | 210.69 | 210.78 | 210.1 | 210.24 | 119154.0 |
| 2025-04-30 19:00:00 | AAPL | Stock | 210.1452 | 210.506 | 209.64 | 209.79 | 101276.0 |
| 2025-04-30 19:30:00 | AAPL | Stock | 209.7997 | 209.9992 | 208.65 | 209.0 | 154749.0 |
| 2025-04-30 04:00:00 | MSFT | Stock | 394.13 | 394.48 | 393.42 | 394.0 | 4153.0 |
| 2025-04-30 04:30:00 | MSFT | Stock | 394.14 | 394.9 | 394.14 | 394.68 | 2809.0 |
| 2025-04-30 05:00:00 | MSFT | Stock | 394.68 | 394.93 | 394.4 | 394.93 | 668.0 |
| 2025-04-30 05:30:00 | MSFT | Stock | 394.86 | 394.95 | 394.23 | 394.23 | 1685.0 |
| 2025-04-30 06:00:00 | MSFT | Stock | 394.34 | 394.34 | 394.34 | 394.34 | 135.0 |
| 2025-04-30 06:30:00 | MSFT | Stock | 394.3 | 394.56 | 393.65 | 394.56 | 2665.0 |
| 2025-04-30 07:00:00 | MSFT | Stock | 394.45 | 395.21 | 394.45 | 394.7 | 5593.0 |
| 2025-04-30 07:30:00 | MSFT | Stock | 394.45 | 394.6 | 393.7 | 393.7 | 6124.0 |
| 2025-04-30 08:00:00 | MSFT | Stock | 394.9965 | 395.4913 | 391.71 | 392.0 | 29334.0 |
| 2025-04-30 08:30:00 | MSFT | Stock | 392.0 | 392.0 | 389.25 | 390.23 | 44674.0 |
| 2025-04-30 09:00:00 | MSFT | Stock | 390.0 | 391.72 | 388.59 | 390.21 | 67753.0 |
| 2025-04-30 09:30:00 | MSFT | Stock | 390.21 | 390.305 | 384.96 | 385.07 | 1771136.0 |
| 2025-04-30 10:00:00 | MSFT | Stock | 385.1 | 388.5606 | 384.44 | 388.505 | 1027500.0 |
| 2025-04-30 10:30:00 | MSFT | Stock | 388.505 | 389.16 | 387.55 | 388.595 | 524574.0 |
| 2025-04-30 11:00:00 | MSFT | Stock | 388.53 | 390.77 | 388.47 | 390.44 | 599423.0 |
| 2025-04-30 11:30:00 | MSFT | Stock | 390.44 | 391.04 | 389.9 | 390.35 | 456826.0 |
| 2025-04-30 12:00:00 | MSFT | Stock | 390.365 | 390.86 | 389.22 | 389.4 | 574620.0 |
| 2025-04-30 12:30:00 | MSFT | Stock | 389.39 | 390.53 | 388.76 | 390.085 | 364208.0 |
> showing 50 of 103,789 rows — these rows as CSV