PREVIEW / stock_30min / 2025-05-30
file: by_date/stock_30min/2025/2025-05-30.parquet size: 2.1 MB rows: 101,835 symbols: 407
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-30 04:00:00 | AAPL | Stock | 199.93 | 200.29 | 199.89 | 200.15 | 25545.0 |
| 2025-05-30 04:30:00 | AAPL | Stock | 200.2 | 200.25 | 200.06 | 200.17 | 3972.0 |
| 2025-05-30 05:00:00 | AAPL | Stock | 200.02 | 200.26 | 200.02 | 200.11 | 6491.0 |
| 2025-05-30 05:30:00 | AAPL | Stock | 200.26 | 200.35 | 200.19 | 200.19 | 6257.0 |
| 2025-05-30 06:00:00 | AAPL | Stock | 200.19 | 200.28 | 200.0 | 200.06 | 12310.0 |
| 2025-05-30 06:30:00 | AAPL | Stock | 200.09 | 200.2 | 200.09 | 200.18 | 2277.0 |
| 2025-05-30 07:00:00 | AAPL | Stock | 200.2 | 200.4 | 200.0 | 200.1 | 21550.0 |
| 2025-05-30 07:30:00 | AAPL | Stock | 200.15 | 200.33 | 200.1 | 200.2 | 8584.0 |
| 2025-05-30 08:00:00 | AAPL | Stock | 200.2 | 200.35 | 197.1 | 198.25 | 297893.0 |
| 2025-05-30 08:30:00 | AAPL | Stock | 198.25 | 199.24 | 198.24 | 198.62 | 113312.0 |
| 2025-05-30 09:00:00 | AAPL | Stock | 198.62 | 199.49 | 198.5 | 199.42 | 94185.0 |
| 2025-05-30 09:30:00 | AAPL | Stock | 199.39 | 199.58 | 197.97 | 198.2477 | 3578020.0 |
| 2025-05-30 10:00:00 | AAPL | Stock | 198.22 | 199.343 | 198.156 | 199.245 | 2054804.0 |
| 2025-05-30 10:30:00 | AAPL | Stock | 199.23 | 199.485 | 198.9 | 199.035 | 1463957.0 |
| 2025-05-30 11:00:00 | AAPL | Stock | 199.035 | 199.44 | 198.81 | 199.31 | 1052467.0 |
| 2025-05-30 11:30:00 | AAPL | Stock | 199.3 | 199.37 | 198.61 | 198.88 | 1156546.0 |
| 2025-05-30 12:00:00 | AAPL | Stock | 198.88 | 198.99 | 197.53 | 197.715 | 1724437.0 |
| 2025-05-30 12:30:00 | AAPL | Stock | 197.72 | 197.785 | 196.78 | 197.36 | 2425733.0 |
| 2025-05-30 13:00:00 | AAPL | Stock | 197.34 | 198.17 | 197.17 | 198.085 | 1428354.0 |
| 2025-05-30 13:30:00 | AAPL | Stock | 198.08 | 198.47 | 197.95 | 198.215 | 1051201.0 |
| 2025-05-30 14:00:00 | AAPL | Stock | 198.22 | 199.18 | 198.18 | 199.12 | 1320894.0 |
| 2025-05-30 14:30:00 | AAPL | Stock | 199.12 | 199.36 | 198.92 | 199.32 | 1252439.0 |
| 2025-05-30 15:00:00 | AAPL | Stock | 199.32 | 200.23 | 199.2889 | 200.0506 | 2082635.0 |
| 2025-05-30 15:30:00 | AAPL | Stock | 200.07 | 201.96 | 199.7401 | 200.65 | 8064629.0 |
| 2025-05-30 16:00:00 | AAPL | Stock | 200.65 | 201.1 | 200.2 | 200.76 | 17164248.0 |
| 2025-05-30 16:30:00 | AAPL | Stock | 200.6 | 200.85 | 200.4517 | 200.61 | 56406.0 |
| 2025-05-30 17:00:00 | AAPL | Stock | 200.6 | 200.6 | 200.4 | 200.41 | 19196.0 |
| 2025-05-30 17:30:00 | AAPL | Stock | 200.4101 | 200.65 | 200.4 | 200.64 | 14559.0 |
| 2025-05-30 18:00:00 | AAPL | Stock | 200.6 | 200.65 | 200.4 | 200.4 | 9401.0 |
| 2025-05-30 18:30:00 | AAPL | Stock | 200.4488 | 200.5 | 200.4 | 200.4 | 11059.0 |
| 2025-05-30 19:00:00 | AAPL | Stock | 200.4 | 200.4393 | 200.14 | 200.28 | 17753.0 |
| 2025-05-30 19:30:00 | AAPL | Stock | 200.19 | 200.29 | 200.19 | 200.29 | 15229.0 |
| 2025-05-30 04:00:00 | MSFT | Stock | 457.99 | 458.49 | 457.88 | 458.34 | 742.0 |
| 2025-05-30 04:30:00 | MSFT | Stock | 458.53 | 458.53 | 458.21 | 458.21 | 498.0 |
| 2025-05-30 05:00:00 | MSFT | Stock | 458.46 | 458.46 | 458.4 | 458.4 | 361.0 |
| 2025-05-30 05:30:00 | MSFT | Stock | 458.51 | 458.56 | 458.25 | 458.25 | 1039.0 |
| 2025-05-30 06:00:00 | MSFT | Stock | 458.24 | 458.33 | 458.24 | 458.33 | 249.0 |
| 2025-05-30 06:30:00 | MSFT | Stock | 458.7 | 458.7 | 458.34 | 458.34 | 671.0 |
| 2025-05-30 07:00:00 | MSFT | Stock | 458.4 | 459.18 | 458.4 | 458.98 | 1309.0 |
| 2025-05-30 07:30:00 | MSFT | Stock | 458.63 | 458.63 | 458.6 | 458.6 | 200.0 |
| 2025-05-30 08:00:00 | MSFT | Stock | 459.0509 | 459.0509 | 456.79 | 457.54 | 12960.0 |
| 2025-05-30 08:30:00 | MSFT | Stock | 458.16 | 459.45 | 458.16 | 458.57 | 9371.0 |
| 2025-05-30 09:00:00 | MSFT | Stock | 458.62 | 460.15 | 458.45 | 460.15 | 14382.0 |
| 2025-05-30 09:30:00 | MSFT | Stock | 459.715 | 460.18 | 457.6001 | 458.42 | 741477.0 |
| 2025-05-30 10:00:00 | MSFT | Stock | 458.35 | 460.25 | 458.35 | 459.415 | 429137.0 |
| 2025-05-30 10:30:00 | MSFT | Stock | 459.4125 | 459.4125 | 458.44 | 458.58 | 386342.0 |
| 2025-05-30 11:00:00 | MSFT | Stock | 458.63 | 459.4099 | 458.35 | 459.1675 | 335591.0 |
| 2025-05-30 11:30:00 | MSFT | Stock | 459.175 | 459.67 | 458.35 | 459.23 | 234118.0 |
| 2025-05-30 12:00:00 | MSFT | Stock | 459.3 | 459.79 | 456.04 | 456.47 | 397762.0 |
| 2025-05-30 12:30:00 | MSFT | Stock | 456.48 | 457.58 | 455.54 | 456.82 | 508336.0 |
> showing 50 of 101,835 rows — these rows as CSV