PREVIEW / stock_30min / 2025-10-17
file: by_date/stock_30min/2025/2025-10-17.parquet size: 2.3 MB rows: 112,802 symbols: 231
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-10-17 04:00:00 | AAPL | Stock | 246.2 | 246.3 | 244.07 | 245.57 | 20163.0 |
| 2025-10-17 04:30:00 | AAPL | Stock | 245.96 | 245.99 | 245.06 | 245.35 | 5714.0 |
| 2025-10-17 05:00:00 | AAPL | Stock | 245.3 | 245.69 | 244.98 | 245.39 | 6158.0 |
| 2025-10-17 05:30:00 | AAPL | Stock | 245.46 | 245.59 | 245.21 | 245.25 | 2857.0 |
| 2025-10-17 06:00:00 | AAPL | Stock | 245.4 | 245.44 | 244.4 | 244.98 | 9509.0 |
| 2025-10-17 06:30:00 | AAPL | Stock | 245.21 | 245.78 | 244.92 | 245.71 | 24250.0 |
| 2025-10-17 07:00:00 | AAPL | Stock | 245.97 | 247.5 | 245.77 | 247.02 | 34126.0 |
| 2025-10-17 07:30:00 | AAPL | Stock | 246.949 | 247.32 | 246.75 | 247.22 | 14105.0 |
| 2025-10-17 08:00:00 | AAPL | Stock | 245.9 | 247.98 | 244.01 | 247.28 | 91049.0 |
| 2025-10-17 08:30:00 | AAPL | Stock | 247.44 | 247.74 | 246.9787 | 247.11 | 27767.0 |
| 2025-10-17 09:00:00 | AAPL | Stock | 247.18 | 248.48 | 246.75 | 248.08 | 139920.0 |
| 2025-10-17 09:30:00 | AAPL | Stock | 248.08 | 249.19 | 247.27 | 248.41 | 5484268.0 |
| 2025-10-17 10:00:00 | AAPL | Stock | 248.41 | 250.32 | 248.26 | 249.5601 | 2160181.0 |
| 2025-10-17 10:30:00 | AAPL | Stock | 249.644 | 249.86 | 248.6652 | 248.874 | 1215346.0 |
| 2025-10-17 11:00:00 | AAPL | Stock | 248.91 | 249.582 | 248.23 | 248.48 | 1082998.0 |
| 2025-10-17 11:30:00 | AAPL | Stock | 248.5 | 249.78 | 248.0972 | 249.5775 | 1325210.0 |
| 2025-10-17 12:00:00 | AAPL | Stock | 249.54 | 250.35 | 249.4502 | 250.2965 | 1486956.0 |
| 2025-10-17 12:30:00 | AAPL | Stock | 250.29 | 251.36 | 250.2752 | 251.13 | 2145491.0 |
| 2025-10-17 13:00:00 | AAPL | Stock | 251.13 | 251.33 | 250.36 | 250.815 | 1224220.0 |
| 2025-10-17 13:30:00 | AAPL | Stock | 250.8 | 251.37 | 250.245 | 251.3 | 1098411.0 |
| 2025-10-17 14:00:00 | AAPL | Stock | 251.319 | 252.535 | 251.319 | 252.3 | 1712887.0 |
| 2025-10-17 14:30:00 | AAPL | Stock | 252.2824 | 252.46 | 251.7 | 252.2735 | 1148498.0 |
| 2025-10-17 15:00:00 | AAPL | Stock | 252.28 | 252.82 | 252.1001 | 252.76 | 1840112.0 |
| 2025-10-17 15:30:00 | AAPL | Stock | 252.75 | 253.38 | 252.11 | 252.3 | 4165799.0 |
| 2025-10-17 16:00:00 | AAPL | Stock | 252.3 | 253.41 | 252.17 | 252.81 | 5971182.0 |
| 2025-10-17 16:30:00 | AAPL | Stock | 252.72 | 253.3 | 252.29 | 252.61 | 72719.0 |
| 2025-10-17 17:00:00 | AAPL | Stock | 252.58 | 252.58 | 252.4 | 252.49 | 17488.0 |
| 2025-10-17 17:30:00 | AAPL | Stock | 252.5 | 252.7 | 252.49 | 252.55 | 4872.0 |
| 2025-10-17 18:00:00 | AAPL | Stock | 252.65 | 252.7 | 252.5 | 252.5206 | 6353.0 |
| 2025-10-17 18:30:00 | AAPL | Stock | 252.54 | 252.55 | 252.26 | 252.26 | 10716.0 |
| 2025-10-17 19:00:00 | AAPL | Stock | 252.2 | 252.26 | 252.1 | 252.1 | 8078.0 |
| 2025-10-17 19:30:00 | AAPL | Stock | 252.02 | 252.4932 | 251.8331 | 252.4001 | 8146.0 |
| 2025-10-17 04:00:00 | MSFT | Stock | 506.7 | 509.66 | 506.7 | 509.66 | 9601.0 |
| 2025-10-17 04:30:00 | MSFT | Stock | 510.0 | 510.51 | 509.42 | 509.42 | 2584.0 |
| 2025-10-17 05:00:00 | MSFT | Stock | 509.6 | 509.62 | 508.57 | 508.57 | 1845.0 |
| 2025-10-17 05:30:00 | MSFT | Stock | 508.25 | 508.65 | 507.11 | 507.74 | 2982.0 |
| 2025-10-17 06:00:00 | MSFT | Stock | 507.84 | 507.84 | 506.94 | 507.5 | 3147.0 |
| 2025-10-17 06:30:00 | MSFT | Stock | 507.92 | 508.9 | 507.92 | 508.07 | 5820.0 |
| 2025-10-17 07:00:00 | MSFT | Stock | 508.29 | 509.85 | 508.2 | 509.3 | 6866.0 |
| 2025-10-17 07:30:00 | MSFT | Stock | 509.48 | 509.96 | 509.15 | 509.79 | 2981.0 |
| 2025-10-17 08:00:00 | MSFT | Stock | 508.5 | 511.0 | 506.11 | 510.46 | 35941.0 |
| 2025-10-17 08:30:00 | MSFT | Stock | 510.02 | 510.6869 | 509.3 | 510.1 | 5894.0 |
| 2025-10-17 09:00:00 | MSFT | Stock | 510.0 | 510.5 | 507.77 | 508.3 | 24445.0 |
| 2025-10-17 09:30:00 | MSFT | Stock | 509.01 | 511.89 | 507.31 | 510.0 | 2141756.0 |
| 2025-10-17 10:00:00 | MSFT | Stock | 509.94 | 512.655 | 509.49 | 511.25 | 474085.0 |
| 2025-10-17 10:30:00 | MSFT | Stock | 511.41 | 511.537 | 509.025 | 509.5 | 345094.0 |
| 2025-10-17 11:00:00 | MSFT | Stock | 509.55 | 511.2 | 509.525 | 509.755 | 353041.0 |
| 2025-10-17 11:30:00 | MSFT | Stock | 509.84 | 511.59 | 508.68 | 511.06 | 382825.0 |
| 2025-10-17 12:00:00 | MSFT | Stock | 511.12 | 513.8 | 511.109 | 513.53 | 330814.0 |
| 2025-10-17 12:30:00 | MSFT | Stock | 513.49 | 514.3655 | 512.58 | 513.16 | 224638.0 |
> showing 50 of 112,802 rows — these rows as CSV