PREVIEW / stock_30min / 2025-05-09
file: by_date/stock_30min/2025/2025-05-09.parquet size: 2.1 MB rows: 101,111 symbols: 424
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-09 04:00:00 | AAPL | Stock | 197.71 | 198.34 | 197.71 | 197.97 | 19041.0 |
| 2025-05-09 04:30:00 | AAPL | Stock | 198.03 | 198.1 | 197.88 | 197.94 | 4322.0 |
| 2025-05-09 05:00:00 | AAPL | Stock | 198.03 | 198.13 | 198.03 | 198.05 | 1757.0 |
| 2025-05-09 05:30:00 | AAPL | Stock | 198.04 | 198.33 | 198.04 | 198.33 | 8214.0 |
| 2025-05-09 06:00:00 | AAPL | Stock | 198.36 | 198.53 | 198.32 | 198.5 | 8078.0 |
| 2025-05-09 06:30:00 | AAPL | Stock | 198.4 | 198.72 | 198.38 | 198.61 | 6653.0 |
| 2025-05-09 07:00:00 | AAPL | Stock | 198.48 | 198.87 | 197.0 | 197.85 | 44081.0 |
| 2025-05-09 07:30:00 | AAPL | Stock | 197.75 | 198.32 | 197.36 | 198.05 | 32936.0 |
| 2025-05-09 08:00:00 | AAPL | Stock | 198.68 | 198.7 | 197.13 | 198.23 | 68673.0 |
| 2025-05-09 08:30:00 | AAPL | Stock | 198.21 | 198.6475 | 198.13 | 198.59 | 32628.0 |
| 2025-05-09 09:00:00 | AAPL | Stock | 198.6001 | 199.07 | 198.46 | 199.07 | 88032.0 |
| 2025-05-09 09:30:00 | AAPL | Stock | 199.0 | 200.5399 | 198.395 | 199.75 | 3728313.0 |
| 2025-05-09 10:00:00 | AAPL | Stock | 199.75 | 200.24 | 198.12 | 198.3601 | 2663104.0 |
| 2025-05-09 10:30:00 | AAPL | Stock | 198.385 | 198.58 | 197.535 | 198.38 | 1978753.0 |
| 2025-05-09 11:00:00 | AAPL | Stock | 198.38 | 199.18 | 198.2 | 198.43 | 1554463.0 |
| 2025-05-09 11:30:00 | AAPL | Stock | 198.425 | 199.01 | 198.14 | 198.7585 | 1155773.0 |
| 2025-05-09 12:00:00 | AAPL | Stock | 198.72 | 198.7597 | 197.93 | 198.135 | 1029413.0 |
| 2025-05-09 12:30:00 | AAPL | Stock | 198.13 | 198.39 | 197.75 | 197.97 | 1207899.0 |
| 2025-05-09 13:00:00 | AAPL | Stock | 197.96 | 198.45 | 197.6 | 198.14 | 1244524.0 |
| 2025-05-09 13:30:00 | AAPL | Stock | 198.145 | 198.815 | 197.91 | 198.7057 | 989149.0 |
| 2025-05-09 14:00:00 | AAPL | Stock | 198.71 | 199.0999 | 198.47 | 198.93 | 977247.0 |
| 2025-05-09 14:30:00 | AAPL | Stock | 198.94 | 199.14 | 198.72 | 198.93 | 936230.0 |
| 2025-05-09 15:00:00 | AAPL | Stock | 198.93 | 199.43 | 198.71 | 198.78 | 1400363.0 |
| 2025-05-09 15:30:00 | AAPL | Stock | 198.8 | 198.9299 | 198.3401 | 198.54 | 2790250.0 |
| 2025-05-09 16:00:00 | AAPL | Stock | 198.47 | 198.53 | 198.23 | 198.46 | 4703983.0 |
| 2025-05-09 16:30:00 | AAPL | Stock | 198.48 | 198.65 | 198.3 | 198.64 | 23736.0 |
| 2025-05-09 17:00:00 | AAPL | Stock | 198.6 | 198.7 | 198.376 | 198.56 | 17599.0 |
| 2025-05-09 17:30:00 | AAPL | Stock | 198.4201 | 198.5982 | 198.4201 | 198.53 | 5868.0 |
| 2025-05-09 18:00:00 | AAPL | Stock | 198.5 | 198.59 | 198.5 | 198.54 | 5698.0 |
| 2025-05-09 18:30:00 | AAPL | Stock | 198.5491 | 198.57 | 198.5485 | 198.55 | 2281.0 |
| 2025-05-09 19:00:00 | AAPL | Stock | 198.55 | 198.59 | 198.5163 | 198.5302 | 6513.0 |
| 2025-05-09 19:30:00 | AAPL | Stock | 198.53 | 198.59 | 198.51 | 198.5244 | 15533.0 |
| 2025-05-09 04:00:00 | MSFT | Stock | 438.69 | 439.71 | 438.69 | 438.95 | 10304.0 |
| 2025-05-09 04:30:00 | MSFT | Stock | 439.09 | 439.21 | 438.66 | 438.66 | 2615.0 |
| 2025-05-09 05:00:00 | MSFT | Stock | 438.85 | 438.85 | 438.79 | 438.79 | 400.0 |
| 2025-05-09 05:30:00 | MSFT | Stock | 438.58 | 438.61 | 438.58 | 438.61 | 452.0 |
| 2025-05-09 06:00:00 | MSFT | Stock | 438.82 | 439.34 | 438.82 | 439.27 | 919.0 |
| 2025-05-09 06:30:00 | MSFT | Stock | 439.31 | 439.54 | 439.16 | 439.16 | 1118.0 |
| 2025-05-09 07:00:00 | MSFT | Stock | 439.15 | 440.25 | 438.0 | 438.86 | 12338.0 |
| 2025-05-09 07:30:00 | MSFT | Stock | 438.8 | 439.25 | 437.89 | 438.62 | 13446.0 |
| 2025-05-09 08:00:00 | MSFT | Stock | 439.25 | 439.87 | 438.16 | 439.2705 | 32549.0 |
| 2025-05-09 08:30:00 | MSFT | Stock | 439.12 | 439.88 | 439.11 | 439.4018 | 12800.0 |
| 2025-05-09 09:00:00 | MSFT | Stock | 439.9966 | 440.18 | 439.5087 | 440.05 | 9269.0 |
| 2025-05-09 09:30:00 | MSFT | Stock | 440.18 | 440.74 | 437.7691 | 439.1 | 916544.0 |
| 2025-05-09 10:00:00 | MSFT | Stock | 439.095 | 439.24 | 436.89 | 437.295 | 483027.0 |
| 2025-05-09 10:30:00 | MSFT | Stock | 437.31 | 437.8243 | 436.24 | 437.475 | 470626.0 |
| 2025-05-09 11:00:00 | MSFT | Stock | 437.42 | 437.93 | 436.755 | 437.39 | 304570.0 |
| 2025-05-09 11:30:00 | MSFT | Stock | 437.3 | 437.76 | 436.465 | 437.75 | 406213.0 |
| 2025-05-09 12:00:00 | MSFT | Stock | 437.72 | 437.75 | 435.88 | 436.45 | 293349.0 |
| 2025-05-09 12:30:00 | MSFT | Stock | 436.38 | 437.23 | 436.22 | 436.82 | 219162.0 |
> showing 50 of 101,111 rows — these rows as CSV