PREVIEW / stock_30min / 2026-06-18
file: by_date/stock_30min/2026/2026-06-18.parquet size: 2.2 MB rows: 105,507 symbols: 12
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 |
|---|---|---|---|---|---|---|---|
| 2026-06-18 04:00:00 | AAPL | Stock | 297.0 | 298.6058 | 297.0 | 297.6116 | 54671.0 |
| 2026-06-18 04:30:00 | AAPL | Stock | 297.6 | 297.78 | 297.34 | 297.71 | 6011.0 |
| 2026-06-18 05:00:00 | AAPL | Stock | 297.3469 | 297.69 | 297.3469 | 297.61 | 5074.0 |
| 2026-06-18 05:30:00 | AAPL | Stock | 297.6 | 297.69 | 297.4498 | 297.6 | 6536.0 |
| 2026-06-18 06:00:00 | AAPL | Stock | 297.65 | 297.677 | 297.56 | 297.64 | 2918.0 |
| 2026-06-18 06:30:00 | AAPL | Stock | 297.641 | 297.641 | 297.03 | 297.53 | 13262.0 |
| 2026-06-18 07:00:00 | AAPL | Stock | 297.45 | 297.53 | 296.88 | 296.88 | 35261.0 |
| 2026-06-18 07:30:00 | AAPL | Stock | 296.85 | 297.0 | 295.87 | 296.76 | 59690.0 |
| 2026-06-18 08:00:00 | AAPL | Stock | 296.7585 | 296.98 | 296.2 | 296.8997 | 31634.0 |
| 2026-06-18 08:30:00 | AAPL | Stock | 296.91 | 296.95 | 296.35 | 296.68 | 38980.0 |
| 2026-06-18 09:00:00 | AAPL | Stock | 296.6 | 298.82 | 296.526 | 297.96 | 250595.0 |
| 2026-06-18 09:30:00 | AAPL | Stock | 297.96 | 300.4599 | 295.62 | 298.275 | 13676160.0 |
| 2026-06-18 10:00:00 | AAPL | Stock | 298.31 | 299.63 | 298.02 | 299.61 | 2521681.0 |
| 2026-06-18 10:30:00 | AAPL | Stock | 299.615 | 300.57 | 298.5 | 299.18 | 2243643.0 |
| 2026-06-18 11:00:00 | AAPL | Stock | 299.22 | 299.23 | 296.96 | 297.1 | 1756196.0 |
| 2026-06-18 11:30:00 | AAPL | Stock | 297.1 | 297.62 | 295.95 | 297.38 | 1685557.0 |
| 2026-06-18 12:00:00 | AAPL | Stock | 297.4 | 297.73 | 296.69 | 297.49 | 1123852.0 |
| 2026-06-18 12:30:00 | AAPL | Stock | 297.485 | 297.69 | 296.84 | 297.14 | 840142.0 |
| 2026-06-18 13:00:00 | AAPL | Stock | 297.13 | 298.36 | 297.03 | 297.82 | 956657.0 |
| 2026-06-18 13:30:00 | AAPL | Stock | 297.825 | 297.985 | 297.35 | 297.56 | 891662.0 |
| 2026-06-18 14:00:00 | AAPL | Stock | 297.575 | 297.68 | 297.01 | 297.125 | 867323.0 |
| 2026-06-18 14:30:00 | AAPL | Stock | 297.14 | 298.0785 | 297.0601 | 297.7 | 938767.0 |
| 2026-06-18 15:00:00 | AAPL | Stock | 297.705 | 297.76 | 297.04 | 297.385 | 993081.0 |
| 2026-06-18 15:30:00 | AAPL | Stock | 297.38 | 299.24 | 297.06 | 297.89 | 4257381.0 |
| 2026-06-18 16:00:00 | AAPL | Stock | 297.865 | 298.9026 | 297.85 | 298.0 | 25487651.0 |
| 2026-06-18 16:30:00 | AAPL | Stock | 298.01 | 298.01 | 297.62 | 297.65 | 30548.0 |
| 2026-06-18 17:00:00 | AAPL | Stock | 297.78 | 298.23 | 297.78 | 298.23 | 11916.0 |
| 2026-06-18 17:30:00 | AAPL | Stock | 298.1 | 298.22 | 298.02 | 298.02 | 5844.0 |
| 2026-06-18 18:00:00 | AAPL | Stock | 298.03 | 298.04 | 297.05 | 297.09 | 14737.0 |
| 2026-06-18 18:30:00 | AAPL | Stock | 297.1 | 297.29 | 297.0 | 297.1 | 12132.0 |
| 2026-06-18 19:00:00 | AAPL | Stock | 297.1562 | 297.39 | 297.01 | 297.17 | 3248.0 |
| 2026-06-18 19:30:00 | AAPL | Stock | 297.3 | 297.34 | 297.1 | 297.23 | 7094.0 |
| 2026-06-18 04:00:00 | MSFT | Stock | 382.26 | 382.88 | 380.72 | 382.36 | 80864.0 |
| 2026-06-18 04:30:00 | MSFT | Stock | 382.35 | 382.35 | 380.89 | 381.0 | 19958.0 |
| 2026-06-18 05:00:00 | MSFT | Stock | 380.93 | 381.3178 | 380.88 | 381.09 | 13712.0 |
| 2026-06-18 05:30:00 | MSFT | Stock | 381.09 | 381.3 | 381.02 | 381.08 | 12237.0 |
| 2026-06-18 06:00:00 | MSFT | Stock | 381.14 | 382.82 | 381.02 | 382.82 | 34730.0 |
| 2026-06-18 06:30:00 | MSFT | Stock | 382.68 | 382.785 | 379.66 | 380.01 | 63061.0 |
| 2026-06-18 07:00:00 | MSFT | Stock | 380.25 | 380.7 | 377.52 | 378.1002 | 144277.0 |
| 2026-06-18 07:30:00 | MSFT | Stock | 378.01 | 378.38 | 377.26 | 377.5278 | 90075.0 |
| 2026-06-18 08:00:00 | MSFT | Stock | 377.51 | 378.4 | 376.8 | 378.04 | 94724.0 |
| 2026-06-18 08:30:00 | MSFT | Stock | 378.24 | 379.6 | 377.79 | 378.87 | 90188.0 |
| 2026-06-18 09:00:00 | MSFT | Stock | 378.9 | 381.0 | 377.82 | 377.82 | 147918.0 |
| 2026-06-18 09:30:00 | MSFT | Stock | 377.82 | 379.521 | 373.28 | 376.23 | 9613565.0 |
| 2026-06-18 10:00:00 | MSFT | Stock | 376.215 | 379.62 | 375.29 | 377.22 | 2625118.0 |
| 2026-06-18 10:30:00 | MSFT | Stock | 377.17 | 378.45 | 376.5986 | 376.5986 | 1719907.0 |
| 2026-06-18 11:00:00 | MSFT | Stock | 376.61 | 376.92 | 374.82 | 375.165 | 1902627.0 |
| 2026-06-18 11:30:00 | MSFT | Stock | 375.2 | 378.04 | 375.05 | 377.926 | 1500875.0 |
| 2026-06-18 12:00:00 | MSFT | Stock | 377.9 | 378.7815 | 376.56 | 378.595 | 1417284.0 |
| 2026-06-18 12:30:00 | MSFT | Stock | 378.595 | 379.61 | 378.5482 | 379.51 | 923574.0 |
> showing 50 of 105,507 rows — these rows as CSV