PREVIEW / stock_30min / 2026-07-09
file: by_date/stock_30min/2026/2026-07-09.parquet size: 2.1 MB rows: 100,140
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-07-09 04:00:00 | AAPL | Stock | 313.26 | 314.96 | 312.66 | 312.73 | 60045.0 |
| 2026-07-09 04:30:00 | AAPL | Stock | 312.72 | 312.72 | 312.5 | 312.59 | 3322.0 |
| 2026-07-09 05:00:00 | AAPL | Stock | 312.52 | 312.59 | 312.1148 | 312.26 | 3983.0 |
| 2026-07-09 05:30:00 | AAPL | Stock | 312.01 | 312.68 | 312.0 | 312.43 | 6686.0 |
| 2026-07-09 06:00:00 | AAPL | Stock | 312.4898 | 312.4898 | 312.29 | 312.3 | 2576.0 |
| 2026-07-09 06:30:00 | AAPL | Stock | 312.19 | 312.49 | 312.05 | 312.21 | 15188.0 |
| 2026-07-09 07:00:00 | AAPL | Stock | 312.29 | 312.6 | 312.05 | 312.09 | 21155.0 |
| 2026-07-09 07:30:00 | AAPL | Stock | 312.07 | 312.46 | 311.9 | 312.46 | 25689.0 |
| 2026-07-09 08:00:00 | AAPL | Stock | 312.3 | 312.607 | 311.8117 | 312.3387 | 27582.0 |
| 2026-07-09 08:30:00 | AAPL | Stock | 312.36 | 312.77 | 311.26 | 311.55 | 55014.0 |
| 2026-07-09 09:00:00 | AAPL | Stock | 311.7 | 312.19 | 310.0 | 310.31 | 197520.0 |
| 2026-07-09 09:30:00 | AAPL | Stock | 310.34 | 312.07 | 308.16 | 310.975 | 3967941.0 |
| 2026-07-09 10:00:00 | AAPL | Stock | 310.98 | 312.3 | 310.16 | 312.07 | 2087607.0 |
| 2026-07-09 10:30:00 | AAPL | Stock | 312.07 | 312.4 | 310.7012 | 311.555 | 1498761.0 |
| 2026-07-09 11:00:00 | AAPL | Stock | 311.55 | 314.85 | 311.51 | 314.46 | 1912035.0 |
| 2026-07-09 11:30:00 | AAPL | Stock | 314.4699 | 315.02 | 314.3 | 314.77 | 1512378.0 |
| 2026-07-09 12:00:00 | AAPL | Stock | 314.79 | 315.22 | 314.09 | 314.9 | 1805659.0 |
| 2026-07-09 12:30:00 | AAPL | Stock | 314.9001 | 315.5 | 314.42 | 314.71 | 1481441.0 |
| 2026-07-09 13:00:00 | AAPL | Stock | 314.72 | 315.18 | 314.31 | 314.7214 | 1273007.0 |
| 2026-07-09 13:30:00 | AAPL | Stock | 314.73 | 315.08 | 314.43 | 314.98 | 945375.0 |
| 2026-07-09 14:00:00 | AAPL | Stock | 314.99 | 315.3199 | 314.23 | 314.56 | 1372086.0 |
| 2026-07-09 14:30:00 | AAPL | Stock | 314.56 | 314.79 | 314.25 | 314.44 | 1164850.0 |
| 2026-07-09 15:00:00 | AAPL | Stock | 314.44 | 315.69 | 314.405 | 315.41 | 1421724.0 |
| 2026-07-09 15:30:00 | AAPL | Stock | 315.42 | 316.53 | 315.39 | 316.17 | 3527348.0 |
| 2026-07-09 16:00:00 | AAPL | Stock | 316.17 | 316.25 | 315.7003 | 315.89 | 8907242.0 |
| 2026-07-09 16:30:00 | AAPL | Stock | 316.22 | 316.22 | 315.4 | 315.5217 | 41007.0 |
| 2026-07-09 17:00:00 | AAPL | Stock | 315.6 | 315.8948 | 315.56 | 315.78 | 3810.0 |
| 2026-07-09 17:30:00 | AAPL | Stock | 315.8 | 315.85 | 315.692 | 315.73 | 6321.0 |
| 2026-07-09 18:00:00 | AAPL | Stock | 315.72 | 315.81 | 315.37 | 315.81 | 10295.0 |
| 2026-07-09 18:30:00 | AAPL | Stock | 315.55 | 315.55 | 315.373 | 315.44 | 5870.0 |
| 2026-07-09 19:00:00 | AAPL | Stock | 315.4304 | 315.8 | 315.3644 | 315.6601 | 7808.0 |
| 2026-07-09 19:30:00 | AAPL | Stock | 315.68 | 315.68 | 315.18 | 315.2801 | 12201.0 |
| 2026-07-09 04:00:00 | MSFT | Stock | 384.48 | 385.0333 | 381.99 | 382.3 | 79971.0 |
| 2026-07-09 04:30:00 | MSFT | Stock | 382.49 | 382.57 | 380.0 | 381.2 | 43800.0 |
| 2026-07-09 05:00:00 | MSFT | Stock | 381.32 | 381.616 | 380.83 | 381.2 | 11217.0 |
| 2026-07-09 05:30:00 | MSFT | Stock | 381.12 | 381.4 | 380.6 | 381.2 | 7632.0 |
| 2026-07-09 06:00:00 | MSFT | Stock | 381.195 | 381.66 | 379.38 | 380.7248 | 28526.0 |
| 2026-07-09 06:30:00 | MSFT | Stock | 380.6 | 380.89 | 378.62 | 379.95 | 38626.0 |
| 2026-07-09 07:00:00 | MSFT | Stock | 379.95 | 380.0 | 377.37 | 377.52 | 107060.0 |
| 2026-07-09 07:30:00 | MSFT | Stock | 377.62 | 377.88 | 376.0 | 376.84 | 113074.0 |
| 2026-07-09 08:00:00 | MSFT | Stock | 376.87 | 377.0 | 375.03 | 376.08 | 187443.0 |
| 2026-07-09 08:30:00 | MSFT | Stock | 376.13 | 376.6 | 375.32 | 375.32 | 99893.0 |
| 2026-07-09 09:00:00 | MSFT | Stock | 375.485 | 376.5 | 374.0 | 374.5 | 231104.0 |
| 2026-07-09 09:30:00 | MSFT | Stock | 374.46 | 379.32 | 373.35 | 378.59 | 3672966.0 |
| 2026-07-09 10:00:00 | MSFT | Stock | 378.66 | 378.7919 | 375.15 | 376.545 | 2167342.0 |
| 2026-07-09 10:30:00 | MSFT | Stock | 376.545 | 378.94 | 376.1 | 378.94 | 1184938.0 |
| 2026-07-09 11:00:00 | MSFT | Stock | 378.95 | 380.28 | 378.83 | 380.125 | 1200445.0 |
| 2026-07-09 11:30:00 | MSFT | Stock | 380.13 | 380.6 | 379.82 | 380.095 | 837710.0 |
| 2026-07-09 12:00:00 | MSFT | Stock | 380.1 | 380.2 | 378.9501 | 379.665 | 699524.0 |
| 2026-07-09 12:30:00 | MSFT | Stock | 379.62 | 380.15 | 379.17 | 379.42 | 639424.0 |
> showing 50 of 100,140 rows — these rows as CSV