PREVIEW / stock_30min / 2025-06-16
file: by_date/stock_30min/2025/2025-06-16.parquet size: 2.2 MB rows: 107,984 symbols: 401
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-06-16 04:00:00 | AAPL | Stock | 197.02 | 198.08 | 197.02 | 198.05 | 17684.0 |
| 2025-06-16 04:30:00 | AAPL | Stock | 198.08 | 198.12 | 197.98 | 198.01 | 10617.0 |
| 2025-06-16 05:00:00 | AAPL | Stock | 198.0 | 198.0 | 197.61 | 197.61 | 5337.0 |
| 2025-06-16 05:30:00 | AAPL | Stock | 197.61 | 197.68 | 197.54 | 197.62 | 2320.0 |
| 2025-06-16 06:00:00 | AAPL | Stock | 197.68 | 197.75 | 197.61 | 197.68 | 1810.0 |
| 2025-06-16 06:30:00 | AAPL | Stock | 197.68 | 197.75 | 197.56 | 197.75 | 4417.0 |
| 2025-06-16 07:00:00 | AAPL | Stock | 197.69 | 197.75 | 197.3 | 197.38 | 16081.0 |
| 2025-06-16 07:30:00 | AAPL | Stock | 197.5 | 197.74 | 197.45 | 197.74 | 10742.0 |
| 2025-06-16 08:00:00 | AAPL | Stock | 197.52 | 198.0 | 196.77 | 197.898 | 108480.0 |
| 2025-06-16 08:30:00 | AAPL | Stock | 197.81 | 197.93 | 196.45 | 197.7 | 131395.0 |
| 2025-06-16 09:00:00 | AAPL | Stock | 197.66 | 197.7499 | 197.18 | 197.24 | 77846.0 |
| 2025-06-16 09:30:00 | AAPL | Stock | 197.28 | 198.35 | 196.5636 | 198.34 | 5027691.0 |
| 2025-06-16 10:00:00 | AAPL | Stock | 198.35 | 198.685 | 197.64 | 198.43 | 2622340.0 |
| 2025-06-16 10:30:00 | AAPL | Stock | 198.435 | 198.66 | 198.01 | 198.22 | 1846204.0 |
| 2025-06-16 11:00:00 | AAPL | Stock | 198.225 | 198.225 | 197.165 | 197.315 | 1992970.0 |
| 2025-06-16 11:30:00 | AAPL | Stock | 197.31 | 197.49 | 196.87 | 197.3699 | 1954390.0 |
| 2025-06-16 12:00:00 | AAPL | Stock | 197.37 | 197.63 | 197.02 | 197.08 | 1101706.0 |
| 2025-06-16 12:30:00 | AAPL | Stock | 197.08 | 197.6 | 197.02 | 197.52 | 870055.0 |
| 2025-06-16 13:00:00 | AAPL | Stock | 197.51 | 197.96 | 197.33 | 197.875 | 1061226.0 |
| 2025-06-16 13:30:00 | AAPL | Stock | 197.88 | 198.19 | 197.77 | 197.85 | 1250978.0 |
| 2025-06-16 14:00:00 | AAPL | Stock | 197.86 | 198.1298 | 197.81 | 197.9887 | 882167.0 |
| 2025-06-16 14:30:00 | AAPL | Stock | 197.99 | 198.3985 | 197.77 | 198.3201 | 980483.0 |
| 2025-06-16 15:00:00 | AAPL | Stock | 198.32 | 198.43 | 197.66 | 198.245 | 1641966.0 |
| 2025-06-16 15:30:00 | AAPL | Stock | 198.25 | 198.49 | 197.92 | 198.37 | 3495969.0 |
| 2025-06-16 16:00:00 | AAPL | Stock | 198.42 | 198.42 | 197.65 | 197.95 | 6295210.0 |
| 2025-06-16 16:30:00 | AAPL | Stock | 197.9038 | 198.07 | 197.81 | 198.07 | 68516.0 |
| 2025-06-16 17:00:00 | AAPL | Stock | 198.05 | 198.12 | 197.89 | 198.07 | 13184.0 |
| 2025-06-16 17:30:00 | AAPL | Stock | 198.1 | 198.16 | 198.09 | 198.15 | 10471.0 |
| 2025-06-16 18:00:00 | AAPL | Stock | 198.1102 | 198.12 | 197.9 | 198.05 | 15823.0 |
| 2025-06-16 18:30:00 | AAPL | Stock | 198.04 | 198.04 | 197.31 | 197.6 | 26540.0 |
| 2025-06-16 19:00:00 | AAPL | Stock | 197.65 | 197.8 | 197.55 | 197.66 | 19154.0 |
| 2025-06-16 19:30:00 | AAPL | Stock | 197.71 | 197.72 | 197.08 | 197.08 | 43454.0 |
| 2025-06-16 04:00:00 | MSFT | Stock | 476.12 | 476.12 | 475.43 | 476.0 | 2641.0 |
| 2025-06-16 04:30:00 | MSFT | Stock | 476.38 | 476.6 | 476.17 | 476.32 | 3317.0 |
| 2025-06-16 05:00:00 | MSFT | Stock | 476.0 | 476.48 | 476.0 | 476.48 | 305.0 |
| 2025-06-16 05:30:00 | MSFT | Stock | 476.0 | 476.0 | 475.92 | 475.99 | 2459.0 |
| 2025-06-16 06:00:00 | MSFT | Stock | 475.99 | 475.99 | 475.76 | 475.78 | 1218.0 |
| 2025-06-16 06:30:00 | MSFT | Stock | 475.76 | 476.02 | 475.67 | 476.02 | 2310.0 |
| 2025-06-16 07:00:00 | MSFT | Stock | 475.95 | 475.95 | 475.64 | 475.64 | 2360.0 |
| 2025-06-16 07:30:00 | MSFT | Stock | 475.86 | 476.46 | 475.86 | 476.46 | 1924.0 |
| 2025-06-16 08:00:00 | MSFT | Stock | 475.5 | 477.19 | 473.773 | 477.01 | 13445.0 |
| 2025-06-16 08:30:00 | MSFT | Stock | 476.8 | 477.0 | 476.51 | 476.6 | 5138.0 |
| 2025-06-16 09:00:00 | MSFT | Stock | 476.5 | 476.6 | 474.87 | 475.15 | 13217.0 |
| 2025-06-16 09:30:00 | MSFT | Stock | 475.21 | 479.77 | 475.0 | 479.465 | 1361315.0 |
| 2025-06-16 10:00:00 | MSFT | Stock | 479.48 | 480.6943 | 479.48 | 480.08 | 847686.0 |
| 2025-06-16 10:30:00 | MSFT | Stock | 480.0801 | 480.4 | 479.36 | 479.53 | 468984.0 |
| 2025-06-16 11:00:00 | MSFT | Stock | 479.55 | 480.44 | 479.19 | 480.02 | 514225.0 |
| 2025-06-16 11:30:00 | MSFT | Stock | 479.97 | 480.67 | 479.79 | 480.26 | 379888.0 |
| 2025-06-16 12:00:00 | MSFT | Stock | 480.24 | 480.5704 | 479.63 | 479.83 | 250029.0 |
| 2025-06-16 12:30:00 | MSFT | Stock | 479.825 | 480.2 | 479.555 | 479.75 | 208829.0 |
> showing 50 of 107,984 rows — these rows as CSV