PREVIEW / stock_30min / 2025-05-28
file: by_date/stock_30min/2025/2025-05-28.parquet size: 2.2 MB rows: 103,741 symbols: 411
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-28 04:00:00 | AAPL | Stock | 200.4 | 200.53 | 200.09 | 200.24 | 9435.0 |
| 2025-05-28 04:30:00 | AAPL | Stock | 200.25 | 200.25 | 199.9 | 200.12 | 11438.0 |
| 2025-05-28 05:00:00 | AAPL | Stock | 200.08 | 200.36 | 200.01 | 200.08 | 3011.0 |
| 2025-05-28 05:30:00 | AAPL | Stock | 200.0 | 200.1 | 199.94 | 200.1 | 6777.0 |
| 2025-05-28 06:00:00 | AAPL | Stock | 200.06 | 200.33 | 200.06 | 200.33 | 1506.0 |
| 2025-05-28 06:30:00 | AAPL | Stock | 200.32 | 200.97 | 200.32 | 200.95 | 5860.0 |
| 2025-05-28 07:00:00 | AAPL | Stock | 200.9 | 200.95 | 200.7 | 200.7 | 10785.0 |
| 2025-05-28 07:30:00 | AAPL | Stock | 200.74 | 200.85 | 200.65 | 200.76 | 5766.0 |
| 2025-05-28 08:00:00 | AAPL | Stock | 200.95 | 201.1 | 200.0 | 200.94 | 60013.0 |
| 2025-05-28 08:30:00 | AAPL | Stock | 200.95 | 201.2271 | 200.88 | 201.13 | 72666.0 |
| 2025-05-28 09:00:00 | AAPL | Stock | 201.13 | 201.4182 | 200.31 | 200.5 | 134692.0 |
| 2025-05-28 09:30:00 | AAPL | Stock | 200.53 | 202.73 | 199.9 | 200.08 | 5710960.0 |
| 2025-05-28 10:00:00 | AAPL | Stock | 200.07 | 200.9 | 200.0 | 200.75 | 2539578.0 |
| 2025-05-28 10:30:00 | AAPL | Stock | 200.74 | 201.05 | 200.21 | 200.7956 | 2115636.0 |
| 2025-05-28 11:00:00 | AAPL | Stock | 200.79 | 201.31 | 200.58 | 201.045 | 1624183.0 |
| 2025-05-28 11:30:00 | AAPL | Stock | 201.04 | 201.29 | 200.8888 | 200.9099 | 1035296.0 |
| 2025-05-28 12:00:00 | AAPL | Stock | 200.91 | 201.29 | 200.862 | 201.1 | 910569.0 |
| 2025-05-28 12:30:00 | AAPL | Stock | 201.09 | 201.35 | 200.825 | 201.08 | 964175.0 |
| 2025-05-28 13:00:00 | AAPL | Stock | 201.09 | 201.52 | 200.93 | 201.11 | 1043431.0 |
| 2025-05-28 13:30:00 | AAPL | Stock | 201.11 | 201.1375 | 200.73 | 200.86 | 1029489.0 |
| 2025-05-28 14:00:00 | AAPL | Stock | 200.8592 | 201.25 | 200.8 | 200.85 | 802203.0 |
| 2025-05-28 14:30:00 | AAPL | Stock | 200.84 | 201.21 | 200.32 | 200.885 | 1183791.0 |
| 2025-05-28 15:00:00 | AAPL | Stock | 200.88 | 201.5211 | 200.81 | 201.1286 | 1474119.0 |
| 2025-05-28 15:30:00 | AAPL | Stock | 201.12 | 201.395 | 200.195 | 200.41 | 3508581.0 |
| 2025-05-28 16:00:00 | AAPL | Stock | 200.43 | 200.66 | 200.0 | 200.48 | 6704390.0 |
| 2025-05-28 16:30:00 | AAPL | Stock | 200.47 | 200.94 | 200.21 | 200.41 | 54110.0 |
| 2025-05-28 17:00:00 | AAPL | Stock | 200.4 | 200.5 | 199.94 | 199.99 | 98013.0 |
| 2025-05-28 17:30:00 | AAPL | Stock | 199.97 | 200.3 | 199.9 | 200.26 | 58556.0 |
| 2025-05-28 18:00:00 | AAPL | Stock | 200.1 | 200.25 | 199.93 | 200.15 | 20463.0 |
| 2025-05-28 18:30:00 | AAPL | Stock | 200.15 | 201.25 | 200.11 | 201.25 | 64067.0 |
| 2025-05-28 19:00:00 | AAPL | Stock | 201.3 | 206.1 | 201.3 | 204.8 | 452591.0 |
| 2025-05-28 19:30:00 | AAPL | Stock | 204.8 | 207.66 | 204.39 | 207.41 | 388729.0 |
| 2025-05-28 04:00:00 | MSFT | Stock | 459.25 | 459.25 | 459.0 | 459.0 | 2820.0 |
| 2025-05-28 04:30:00 | MSFT | Stock | 459.42 | 459.42 | 458.8 | 459.39 | 1460.0 |
| 2025-05-28 05:00:00 | MSFT | Stock | 458.95 | 459.16 | 458.9 | 458.9 | 1019.0 |
| 2025-05-28 05:30:00 | MSFT | Stock | 458.94 | 459.25 | 458.94 | 459.25 | 207.0 |
| 2025-05-28 06:00:00 | MSFT | Stock | 459.16 | 459.36 | 459.15 | 459.36 | 2425.0 |
| 2025-05-28 06:30:00 | MSFT | Stock | 459.46 | 460.43 | 459.46 | 460.43 | 2048.0 |
| 2025-05-28 07:00:00 | MSFT | Stock | 460.55 | 460.7 | 460.0 | 460.32 | 3329.0 |
| 2025-05-28 07:30:00 | MSFT | Stock | 460.35 | 460.5 | 460.3 | 460.5 | 1462.0 |
| 2025-05-28 08:00:00 | MSFT | Stock | 460.6953 | 461.0 | 459.1 | 460.98 | 19277.0 |
| 2025-05-28 08:30:00 | MSFT | Stock | 461.25 | 461.73 | 461.091 | 461.5 | 7009.0 |
| 2025-05-28 09:00:00 | MSFT | Stock | 461.7 | 462.3781 | 460.69 | 461.15 | 111882.0 |
| 2025-05-28 09:30:00 | MSFT | Stock | 461.1 | 462.52 | 460.35 | 460.6 | 1430577.0 |
| 2025-05-28 10:00:00 | MSFT | Stock | 460.6 | 460.89 | 459.36 | 459.605 | 636758.0 |
| 2025-05-28 10:30:00 | MSFT | Stock | 459.6 | 460.13 | 459.16 | 459.34 | 369221.0 |
| 2025-05-28 11:00:00 | MSFT | Stock | 459.345 | 459.91 | 459.11 | 459.52 | 368613.0 |
| 2025-05-28 11:30:00 | MSFT | Stock | 459.51 | 459.7048 | 458.2977 | 458.555 | 531906.0 |
| 2025-05-28 12:00:00 | MSFT | Stock | 458.565 | 459.03 | 458.3 | 458.8591 | 287833.0 |
| 2025-05-28 12:30:00 | MSFT | Stock | 458.86 | 458.98 | 457.8493 | 458.09 | 460066.0 |
> showing 50 of 103,741 rows — these rows as CSV