PREVIEW / stock_30min / 2025-08-22
file: by_date/stock_30min/2025/2025-08-22.parquet size: 2.2 MB rows: 105,224 symbols: 330
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-08-22 04:00:00 | AAPL | Stock | 225.16 | 225.64 | 225.16 | 225.49 | 4629.0 |
| 2025-08-22 04:30:00 | AAPL | Stock | 225.5 | 225.68 | 225.5 | 225.68 | 409.0 |
| 2025-08-22 05:00:00 | AAPL | Stock | 225.77 | 225.77 | 225.61 | 225.62 | 1090.0 |
| 2025-08-22 05:30:00 | AAPL | Stock | 225.68 | 225.68 | 225.64 | 225.65 | 1825.0 |
| 2025-08-22 06:00:00 | AAPL | Stock | 225.67 | 225.93 | 225.67 | 225.92 | 4613.0 |
| 2025-08-22 06:30:00 | AAPL | Stock | 225.92 | 226.02 | 225.92 | 226.02 | 3632.0 |
| 2025-08-22 07:00:00 | AAPL | Stock | 226.02 | 226.25 | 225.99 | 226.16 | 4822.0 |
| 2025-08-22 07:30:00 | AAPL | Stock | 226.05 | 226.05 | 225.9 | 226.02 | 1323.0 |
| 2025-08-22 08:00:00 | AAPL | Stock | 226.2 | 226.28 | 223.93 | 226.0832 | 47040.0 |
| 2025-08-22 08:30:00 | AAPL | Stock | 226.08 | 226.2497 | 225.88 | 225.88 | 15367.0 |
| 2025-08-22 09:00:00 | AAPL | Stock | 225.99 | 226.25 | 225.8023 | 226.22 | 50460.0 |
| 2025-08-22 09:30:00 | AAPL | Stock | 226.17 | 226.9855 | 225.41 | 225.98 | 2640965.0 |
| 2025-08-22 10:00:00 | AAPL | Stock | 226.01 | 228.2 | 225.97 | 227.96 | 3098778.0 |
| 2025-08-22 10:30:00 | AAPL | Stock | 227.97 | 228.67 | 227.8 | 228.225 | 2462967.0 |
| 2025-08-22 11:00:00 | AAPL | Stock | 228.22 | 228.72 | 228.0093 | 228.06 | 1496964.0 |
| 2025-08-22 11:30:00 | AAPL | Stock | 228.05 | 228.435 | 227.31 | 227.355 | 1176558.0 |
| 2025-08-22 12:00:00 | AAPL | Stock | 227.35 | 227.4394 | 226.925 | 227.1693 | 1162052.0 |
| 2025-08-22 12:30:00 | AAPL | Stock | 227.17 | 227.48 | 227.07 | 227.24 | 771680.0 |
| 2025-08-22 13:00:00 | AAPL | Stock | 227.23 | 229.09 | 227.165 | 228.6242 | 2906799.0 |
| 2025-08-22 13:30:00 | AAPL | Stock | 228.6274 | 228.6274 | 227.78 | 227.885 | 1151504.0 |
| 2025-08-22 14:00:00 | AAPL | Stock | 227.9 | 228.495 | 227.79 | 227.87 | 1386771.0 |
| 2025-08-22 14:30:00 | AAPL | Stock | 227.89 | 228.52 | 227.825 | 228.2 | 977134.0 |
| 2025-08-22 15:00:00 | AAPL | Stock | 228.2 | 228.375 | 227.78 | 227.85 | 966459.0 |
| 2025-08-22 15:30:00 | AAPL | Stock | 227.84 | 228.31 | 227.44 | 227.75 | 3125104.0 |
| 2025-08-22 16:00:00 | AAPL | Stock | 227.7712 | 227.98 | 227.575 | 227.94 | 4911826.0 |
| 2025-08-22 16:30:00 | AAPL | Stock | 227.97 | 227.97 | 227.76 | 227.83 | 201962.0 |
| 2025-08-22 17:00:00 | AAPL | Stock | 227.89 | 227.9 | 227.76 | 227.8 | 7240.0 |
| 2025-08-22 17:30:00 | AAPL | Stock | 227.78 | 227.83 | 227.76 | 227.83 | 5787.0 |
| 2025-08-22 18:00:00 | AAPL | Stock | 227.9 | 228.0 | 227.85 | 227.85 | 13339.0 |
| 2025-08-22 18:30:00 | AAPL | Stock | 227.8307 | 227.9 | 227.8301 | 227.8999 | 1663.0 |
| 2025-08-22 19:00:00 | AAPL | Stock | 227.88 | 228.07 | 227.83 | 228.05 | 8643.0 |
| 2025-08-22 19:30:00 | AAPL | Stock | 228.05 | 228.1799 | 228.05 | 228.08 | 6938.0 |
| 2025-08-22 04:00:00 | MSFT | Stock | 504.35 | 505.64 | 504.35 | 505.5 | 1741.0 |
| 2025-08-22 04:30:00 | MSFT | Stock | 505.25 | 505.37 | 505.25 | 505.37 | 875.0 |
| 2025-08-22 05:00:00 | MSFT | Stock | 505.61 | 505.61 | 505.61 | 505.61 | 280.0 |
| 2025-08-22 05:30:00 | MSFT | Stock | 506.0 | 506.2 | 505.88 | 505.88 | 950.0 |
| 2025-08-22 06:00:00 | MSFT | Stock | 505.73 | 505.73 | 505.73 | 505.73 | 100.0 |
| 2025-08-22 07:00:00 | MSFT | Stock | 505.74 | 505.85 | 505.74 | 505.85 | 516.0 |
| 2025-08-22 07:30:00 | MSFT | Stock | 505.47 | 505.47 | 504.7 | 504.99 | 4242.0 |
| 2025-08-22 08:00:00 | MSFT | Stock | 505.75 | 505.92 | 501.77 | 505.25 | 15196.0 |
| 2025-08-22 08:30:00 | MSFT | Stock | 505.07 | 505.07 | 504.66 | 504.66 | 5041.0 |
| 2025-08-22 09:00:00 | MSFT | Stock | 504.6623 | 505.25 | 504.23 | 504.25 | 16158.0 |
| 2025-08-22 09:30:00 | MSFT | Stock | 504.25 | 506.47 | 502.41 | 503.86 | 1083145.0 |
| 2025-08-22 10:00:00 | MSFT | Stock | 503.9 | 509.37 | 503.87 | 508.2 | 1652581.0 |
| 2025-08-22 10:30:00 | MSFT | Stock | 508.23 | 510.73 | 508.16 | 509.82 | 1059725.0 |
| 2025-08-22 11:00:00 | MSFT | Stock | 509.8625 | 510.73 | 508.13 | 508.2999 | 858542.0 |
| 2025-08-22 11:30:00 | MSFT | Stock | 508.26 | 509.47 | 507.11 | 507.38 | 956064.0 |
| 2025-08-22 12:00:00 | MSFT | Stock | 507.49 | 507.835 | 506.3701 | 506.945 | 630365.0 |
| 2025-08-22 12:30:00 | MSFT | Stock | 506.9728 | 507.17 | 506.05 | 506.27 | 496287.0 |
| 2025-08-22 13:00:00 | MSFT | Stock | 506.265 | 507.928 | 506.2 | 507.86 | 621551.0 |
> showing 50 of 105,224 rows — these rows as CSV