PREVIEW / stock_30min / 2025-12-31
file: by_date/stock_30min/2025/2025-12-31.parquet size: 2.1 MB rows: 100,292 symbols: 172
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-12-31 04:00:00 | AAPL | Stock | 272.41 | 272.41 | 272.18 | 272.25 | 664.0 |
| 2025-12-31 04:30:00 | AAPL | Stock | 272.24 | 272.24 | 272.24 | 272.24 | 100.0 |
| 2025-12-31 05:00:00 | AAPL | Stock | 272.15 | 272.16 | 272.13 | 272.13 | 403.0 |
| 2025-12-31 05:30:00 | AAPL | Stock | 272.26 | 272.26 | 272.26 | 272.26 | 100.0 |
| 2025-12-31 06:00:00 | AAPL | Stock | 272.12 | 272.12 | 272.12 | 272.12 | 100.0 |
| 2025-12-31 07:00:00 | AAPL | Stock | 272.24 | 272.56 | 272.24 | 272.52 | 3593.0 |
| 2025-12-31 07:30:00 | AAPL | Stock | 272.5 | 272.57 | 272.5 | 272.53 | 2705.0 |
| 2025-12-31 08:00:00 | AAPL | Stock | 272.4 | 272.6875 | 272.04 | 272.6 | 17551.0 |
| 2025-12-31 08:30:00 | AAPL | Stock | 272.6 | 273.08 | 272.53 | 272.82 | 21551.0 |
| 2025-12-31 09:00:00 | AAPL | Stock | 272.8 | 273.2 | 272.2 | 273.12 | 55791.0 |
| 2025-12-31 09:30:00 | AAPL | Stock | 273.06 | 273.68 | 272.2318 | 273.06 | 1653823.0 |
| 2025-12-31 10:00:00 | AAPL | Stock | 273.07 | 273.11 | 272.385 | 272.5 | 823379.0 |
| 2025-12-31 10:30:00 | AAPL | Stock | 272.495 | 272.585 | 271.76 | 271.89 | 845483.0 |
| 2025-12-31 11:00:00 | AAPL | Stock | 271.92 | 272.5 | 271.9049 | 272.4701 | 836350.0 |
| 2025-12-31 11:30:00 | AAPL | Stock | 272.49 | 272.77 | 272.27 | 272.7614 | 630715.0 |
| 2025-12-31 12:00:00 | AAPL | Stock | 272.76 | 272.8 | 272.305 | 272.67 | 472726.0 |
| 2025-12-31 12:30:00 | AAPL | Stock | 272.66 | 272.88 | 272.57 | 272.77 | 544098.0 |
| 2025-12-31 13:00:00 | AAPL | Stock | 272.766 | 273.1 | 272.55 | 272.625 | 769048.0 |
| 2025-12-31 13:30:00 | AAPL | Stock | 272.625 | 273.33 | 272.58 | 273.295 | 678229.0 |
| 2025-12-31 14:00:00 | AAPL | Stock | 273.28 | 273.43 | 272.96 | 272.9609 | 638982.0 |
| 2025-12-31 14:30:00 | AAPL | Stock | 272.9702 | 273.0068 | 272.6034 | 272.71 | 530799.0 |
| 2025-12-31 15:00:00 | AAPL | Stock | 272.7 | 272.73 | 271.95 | 272.08 | 687489.0 |
| 2025-12-31 15:30:00 | AAPL | Stock | 272.09 | 272.75 | 271.75 | 271.84 | 2496009.0 |
| 2025-12-31 16:00:00 | AAPL | Stock | 271.86 | 272.41 | 271.76 | 272.09 | 7437314.0 |
| 2025-12-31 16:30:00 | AAPL | Stock | 271.86 | 272.35 | 271.86 | 272.0897 | 30313.0 |
| 2025-12-31 17:00:00 | AAPL | Stock | 272.1 | 272.25 | 272.0401 | 272.2164 | 2931.0 |
| 2025-12-31 17:30:00 | AAPL | Stock | 272.14 | 272.14 | 272.04 | 272.1 | 1459.0 |
| 2025-12-31 18:00:00 | AAPL | Stock | 272.05 | 272.05 | 272.04 | 272.04 | 596.0 |
| 2025-12-31 18:30:00 | AAPL | Stock | 272.05 | 272.1 | 272.04 | 272.1 | 2261.0 |
| 2025-12-31 19:00:00 | AAPL | Stock | 272.14 | 272.2199 | 272.08 | 272.09 | 3612.0 |
| 2025-12-31 19:30:00 | AAPL | Stock | 272.03 | 272.1993 | 272.0 | 272.09 | 3403.0 |
| 2025-12-31 04:00:00 | MSFT | Stock | 486.0 | 487.83 | 486.0 | 486.8 | 2271.0 |
| 2025-12-31 04:30:00 | MSFT | Stock | 486.82 | 486.82 | 486.5 | 486.8 | 225.0 |
| 2025-12-31 05:00:00 | MSFT | Stock | 486.5 | 486.64 | 486.4 | 486.64 | 526.0 |
| 2025-12-31 05:30:00 | MSFT | Stock | 486.95 | 487.28 | 486.95 | 487.15 | 270.0 |
| 2025-12-31 06:00:00 | MSFT | Stock | 487.01 | 487.08 | 486.45 | 487.06 | 1534.0 |
| 2025-12-31 06:30:00 | MSFT | Stock | 487.1 | 487.51 | 487.1 | 487.44 | 740.0 |
| 2025-12-31 07:00:00 | MSFT | Stock | 487.7 | 487.7 | 487.04 | 487.3 | 1704.0 |
| 2025-12-31 07:30:00 | MSFT | Stock | 487.24 | 487.4 | 487.22 | 487.31 | 1268.0 |
| 2025-12-31 08:00:00 | MSFT | Stock | 487.37 | 487.86 | 486.0 | 487.45 | 9537.0 |
| 2025-12-31 08:30:00 | MSFT | Stock | 487.5 | 488.28 | 487.25 | 487.81 | 7493.0 |
| 2025-12-31 09:00:00 | MSFT | Stock | 488.0 | 488.35 | 487.63 | 487.96 | 11737.0 |
| 2025-12-31 09:30:00 | MSFT | Stock | 487.84 | 488.14 | 485.23 | 486.08 | 872424.0 |
| 2025-12-31 10:00:00 | MSFT | Stock | 486.02 | 486.3 | 485.32 | 485.655 | 622558.0 |
| 2025-12-31 10:30:00 | MSFT | Stock | 485.63 | 485.7 | 484.52 | 484.69 | 511238.0 |
| 2025-12-31 11:00:00 | MSFT | Stock | 484.685 | 485.39 | 484.29 | 485.27 | 536949.0 |
| 2025-12-31 11:30:00 | MSFT | Stock | 485.28 | 485.9 | 484.795 | 485.805 | 357757.0 |
| 2025-12-31 12:00:00 | MSFT | Stock | 485.8 | 485.89 | 484.92 | 485.096 | 258320.0 |
| 2025-12-31 12:30:00 | MSFT | Stock | 485.0764 | 485.82 | 484.98 | 485.495 | 236526.0 |
| 2025-12-31 13:00:00 | MSFT | Stock | 485.4828 | 485.89 | 485.4098 | 485.8785 | 207265.0 |
> showing 50 of 100,292 rows — these rows as CSV