PREVIEW / stock_30min / 2025-09-12
file: by_date/stock_30min/2025/2025-09-12.parquet size: 2.3 MB rows: 108,270 symbols: 315
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-09-12 04:00:00 | AAPL | Stock | 229.79 | 229.82 | 229.38 | 229.38 | 9474.0 |
| 2025-09-12 04:30:00 | AAPL | Stock | 229.49 | 229.51 | 229.4 | 229.45 | 3725.0 |
| 2025-09-12 05:00:00 | AAPL | Stock | 229.5 | 229.55 | 229.44 | 229.44 | 2885.0 |
| 2025-09-12 05:30:00 | AAPL | Stock | 229.45 | 229.53 | 229.3 | 229.53 | 7772.0 |
| 2025-09-12 06:00:00 | AAPL | Stock | 229.43 | 229.49 | 229.38 | 229.49 | 733.0 |
| 2025-09-12 06:30:00 | AAPL | Stock | 229.34 | 229.34 | 229.11 | 229.12 | 3716.0 |
| 2025-09-12 07:00:00 | AAPL | Stock | 229.14 | 229.35 | 229.02 | 229.35 | 16877.0 |
| 2025-09-12 07:30:00 | AAPL | Stock | 229.3 | 229.38 | 229.09 | 229.38 | 9071.0 |
| 2025-09-12 08:00:00 | AAPL | Stock | 229.2 | 230.1 | 229.0004 | 229.5 | 102135.0 |
| 2025-09-12 08:30:00 | AAPL | Stock | 229.45 | 229.59 | 227.5003 | 229.26 | 263994.0 |
| 2025-09-12 09:00:00 | AAPL | Stock | 229.26 | 229.6651 | 228.7 | 229.3194 | 105501.0 |
| 2025-09-12 09:30:00 | AAPL | Stock | 229.3 | 231.23 | 229.02 | 231.214 | 4422127.0 |
| 2025-09-12 10:00:00 | AAPL | Stock | 231.1 | 234.078 | 230.93 | 234.07 | 5578485.0 |
| 2025-09-12 10:30:00 | AAPL | Stock | 234.08 | 234.51 | 233.47 | 233.94 | 3716284.0 |
| 2025-09-12 11:00:00 | AAPL | Stock | 233.95 | 234.29 | 233.36 | 234.095 | 2552663.0 |
| 2025-09-12 11:30:00 | AAPL | Stock | 234.09 | 234.49 | 233.621 | 233.97 | 1689668.0 |
| 2025-09-12 12:00:00 | AAPL | Stock | 233.9855 | 234.265 | 233.765 | 233.9694 | 1578190.0 |
| 2025-09-12 12:30:00 | AAPL | Stock | 233.9637 | 233.965 | 233.125 | 233.1385 | 1480597.0 |
| 2025-09-12 13:00:00 | AAPL | Stock | 233.125 | 233.46 | 233.0 | 233.235 | 1331352.0 |
| 2025-09-12 13:30:00 | AAPL | Stock | 233.22 | 233.87 | 233.2185 | 233.66 | 1243322.0 |
| 2025-09-12 14:00:00 | AAPL | Stock | 233.68 | 233.7116 | 233.22 | 233.54 | 1172889.0 |
| 2025-09-12 14:30:00 | AAPL | Stock | 233.54 | 234.22 | 233.02 | 234.0 | 2453461.0 |
| 2025-09-12 15:00:00 | AAPL | Stock | 234.01 | 234.45 | 233.73 | 233.7755 | 1791014.0 |
| 2025-09-12 15:30:00 | AAPL | Stock | 233.78 | 234.29 | 233.51 | 234.06 | 4035449.0 |
| 2025-09-12 16:00:00 | AAPL | Stock | 234.05 | 234.3 | 233.81 | 234.06 | 5667739.0 |
| 2025-09-12 16:30:00 | AAPL | Stock | 233.95 | 234.07 | 233.92 | 234.0199 | 41326.0 |
| 2025-09-12 17:00:00 | AAPL | Stock | 233.975 | 234.02 | 233.9401 | 233.96 | 17666.0 |
| 2025-09-12 17:30:00 | AAPL | Stock | 233.96 | 234.0 | 233.9 | 234.0 | 11283.0 |
| 2025-09-12 18:00:00 | AAPL | Stock | 233.99 | 234.0 | 233.93 | 233.9303 | 9228.0 |
| 2025-09-12 18:30:00 | AAPL | Stock | 233.9301 | 233.97 | 233.85 | 233.92 | 9656.0 |
| 2025-09-12 19:00:00 | AAPL | Stock | 233.9 | 233.9 | 233.81 | 233.86 | 5040.0 |
| 2025-09-12 19:30:00 | AAPL | Stock | 233.8707 | 234.0 | 233.86 | 233.99 | 12396.0 |
| 2025-09-12 04:00:00 | MSFT | Stock | 510.0 | 510.0 | 507.23 | 508.03 | 6909.0 |
| 2025-09-12 04:30:00 | MSFT | Stock | 508.5 | 508.72 | 508.3 | 508.72 | 3348.0 |
| 2025-09-12 05:00:00 | MSFT | Stock | 508.65 | 508.98 | 508.28 | 508.28 | 4779.0 |
| 2025-09-12 05:30:00 | MSFT | Stock | 508.44 | 508.44 | 508.1 | 508.1 | 1409.0 |
| 2025-09-12 06:00:00 | MSFT | Stock | 508.05 | 508.49 | 507.9 | 508.15 | 6752.0 |
| 2025-09-12 06:30:00 | MSFT | Stock | 507.85 | 507.85 | 507.51 | 507.55 | 1443.0 |
| 2025-09-12 07:00:00 | MSFT | Stock | 507.65 | 507.65 | 505.0 | 506.62 | 21384.0 |
| 2025-09-12 07:30:00 | MSFT | Stock | 506.94 | 507.4 | 506.15 | 506.36 | 10663.0 |
| 2025-09-12 08:00:00 | MSFT | Stock | 505.62 | 510.22 | 505.0 | 507.5 | 95201.0 |
| 2025-09-12 08:30:00 | MSFT | Stock | 507.435 | 507.8864 | 507.0 | 507.0 | 21468.0 |
| 2025-09-12 09:00:00 | MSFT | Stock | 507.02 | 507.99 | 505.0 | 506.35 | 49050.0 |
| 2025-09-12 09:30:00 | MSFT | Stock | 506.51 | 508.11 | 503.85 | 508.05 | 1975392.0 |
| 2025-09-12 10:00:00 | MSFT | Stock | 507.86 | 508.39 | 506.51 | 507.14 | 765416.0 |
| 2025-09-12 10:30:00 | MSFT | Stock | 507.2 | 509.29 | 507.14 | 509.07 | 801295.0 |
| 2025-09-12 11:00:00 | MSFT | Stock | 509.04 | 511.29 | 508.56 | 510.6709 | 914049.0 |
| 2025-09-12 11:30:00 | MSFT | Stock | 510.68 | 511.8 | 510.1301 | 511.235 | 844013.0 |
| 2025-09-12 12:00:00 | MSFT | Stock | 511.22 | 512.23 | 510.7 | 511.8938 | 632985.0 |
| 2025-09-12 12:30:00 | MSFT | Stock | 511.9 | 512.55 | 511.7 | 512.32 | 476799.0 |
> showing 50 of 108,270 rows — these rows as CSV