PREVIEW / stock_30min / 2025-06-12
file: by_date/stock_30min/2025/2025-06-12.parquet size: 2.2 MB rows: 105,032 symbols: 397
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-06-12 04:00:00 | AAPL | Stock | 199.2 | 199.2 | 198.45 | 198.85 | 27278.0 |
| 2025-06-12 04:30:00 | AAPL | Stock | 198.87 | 199.44 | 198.82 | 199.3 | 8122.0 |
| 2025-06-12 05:00:00 | AAPL | Stock | 199.25 | 199.6 | 199.25 | 199.34 | 10788.0 |
| 2025-06-12 05:30:00 | AAPL | Stock | 199.35 | 199.6 | 199.12 | 199.14 | 7234.0 |
| 2025-06-12 06:00:00 | AAPL | Stock | 199.26 | 199.26 | 199.0 | 199.0 | 2590.0 |
| 2025-06-12 06:30:00 | AAPL | Stock | 199.11 | 199.54 | 198.98 | 199.3 | 9571.0 |
| 2025-06-12 07:00:00 | AAPL | Stock | 199.29 | 199.29 | 198.83 | 198.83 | 10977.0 |
| 2025-06-12 07:30:00 | AAPL | Stock | 198.81 | 198.96 | 198.66 | 198.74 | 9145.0 |
| 2025-06-12 08:00:00 | AAPL | Stock | 199.1 | 199.45 | 198.65 | 199.0 | 98370.0 |
| 2025-06-12 08:30:00 | AAPL | Stock | 198.97 | 199.52 | 198.9 | 199.4684 | 91096.0 |
| 2025-06-12 09:00:00 | AAPL | Stock | 199.45 | 199.6073 | 198.88 | 199.08 | 71957.0 |
| 2025-06-12 09:30:00 | AAPL | Stock | 199.08 | 199.39 | 197.7396 | 197.94 | 4954557.0 |
| 2025-06-12 10:00:00 | AAPL | Stock | 197.94 | 198.54 | 197.3601 | 198.0667 | 2958429.0 |
| 2025-06-12 10:30:00 | AAPL | Stock | 198.08 | 198.58 | 198.0 | 198.2788 | 1822712.0 |
| 2025-06-12 11:00:00 | AAPL | Stock | 198.26 | 198.925 | 197.8627 | 198.14 | 2275669.0 |
| 2025-06-12 11:30:00 | AAPL | Stock | 198.1337 | 198.3278 | 197.755 | 198.3098 | 1532188.0 |
| 2025-06-12 12:00:00 | AAPL | Stock | 198.295 | 198.64 | 198.08 | 198.59 | 1392518.0 |
| 2025-06-12 12:30:00 | AAPL | Stock | 198.58 | 198.97 | 198.2 | 198.5625 | 1529736.0 |
| 2025-06-12 13:00:00 | AAPL | Stock | 198.561 | 199.44 | 198.46 | 199.26 | 1750898.0 |
| 2025-06-12 13:30:00 | AAPL | Stock | 199.26 | 199.68 | 198.9404 | 198.9404 | 1216089.0 |
| 2025-06-12 14:00:00 | AAPL | Stock | 198.96 | 199.19 | 198.665 | 198.75 | 1243365.0 |
| 2025-06-12 14:30:00 | AAPL | Stock | 198.76 | 199.03 | 198.545 | 198.985 | 1221748.0 |
| 2025-06-12 15:00:00 | AAPL | Stock | 198.98 | 199.0604 | 198.8299 | 198.885 | 1001622.0 |
| 2025-06-12 15:30:00 | AAPL | Stock | 198.88 | 199.2 | 198.4 | 199.2 | 2977500.0 |
| 2025-06-12 16:00:00 | AAPL | Stock | 199.19 | 199.2 | 198.66 | 198.66 | 6149868.0 |
| 2025-06-12 16:30:00 | AAPL | Stock | 198.83 | 199.45 | 198.7 | 199.0101 | 90816.0 |
| 2025-06-12 17:00:00 | AAPL | Stock | 199.13 | 199.19 | 198.92 | 199.01 | 4619.0 |
| 2025-06-12 17:30:00 | AAPL | Stock | 198.95 | 199.2 | 198.9 | 198.9 | 26669.0 |
| 2025-06-12 18:00:00 | AAPL | Stock | 198.95 | 198.9772 | 198.68 | 198.68 | 13534.0 |
| 2025-06-12 18:30:00 | AAPL | Stock | 198.68 | 198.83 | 198.5 | 198.75 | 10799.0 |
| 2025-06-12 19:00:00 | AAPL | Stock | 198.71 | 198.74 | 198.687 | 198.687 | 1238.0 |
| 2025-06-12 19:30:00 | AAPL | Stock | 198.68 | 198.75 | 198.01 | 198.5795 | 18798.0 |
| 2025-06-12 04:00:00 | MSFT | Stock | 471.01 | 471.01 | 470.17 | 470.61 | 1805.0 |
| 2025-06-12 04:30:00 | MSFT | Stock | 471.65 | 472.12 | 471.65 | 472.11 | 406.0 |
| 2025-06-12 05:00:00 | MSFT | Stock | 472.49 | 472.98 | 472.49 | 472.72 | 1153.0 |
| 2025-06-12 05:30:00 | MSFT | Stock | 473.07 | 473.56 | 473.0 | 473.07 | 1012.0 |
| 2025-06-12 06:00:00 | MSFT | Stock | 473.12 | 473.12 | 473.12 | 473.12 | 106.0 |
| 2025-06-12 06:30:00 | MSFT | Stock | 473.41 | 475.1 | 473.41 | 474.56 | 7752.0 |
| 2025-06-12 07:00:00 | MSFT | Stock | 474.33 | 474.77 | 474.01 | 474.14 | 5255.0 |
| 2025-06-12 07:30:00 | MSFT | Stock | 474.01 | 474.37 | 473.67 | 473.8 | 4481.0 |
| 2025-06-12 08:00:00 | MSFT | Stock | 474.5 | 475.37 | 472.5 | 474.88 | 39357.0 |
| 2025-06-12 08:30:00 | MSFT | Stock | 474.91 | 476.2 | 474.34 | 476.13 | 17886.0 |
| 2025-06-12 09:00:00 | MSFT | Stock | 476.0 | 476.63 | 474.39 | 474.73 | 18400.0 |
| 2025-06-12 09:30:00 | MSFT | Stock | 475.02 | 476.0854 | 473.52 | 475.1 | 1490720.0 |
| 2025-06-12 10:00:00 | MSFT | Stock | 475.04 | 477.02 | 474.77 | 476.52 | 876753.0 |
| 2025-06-12 10:30:00 | MSFT | Stock | 476.53 | 476.86 | 475.75 | 476.67 | 520207.0 |
| 2025-06-12 11:00:00 | MSFT | Stock | 476.67 | 478.0836 | 476.34 | 476.99 | 660624.0 |
| 2025-06-12 11:30:00 | MSFT | Stock | 476.98 | 477.8816 | 476.58 | 477.74 | 335183.0 |
| 2025-06-12 12:00:00 | MSFT | Stock | 477.73 | 478.815 | 477.44 | 478.7 | 589141.0 |
| 2025-06-12 12:30:00 | MSFT | Stock | 478.64 | 479.33 | 477.8 | 478.69 | 586159.0 |
> showing 50 of 105,032 rows — these rows as CSV