PREVIEW / stock_30min / 2025-09-17
file: by_date/stock_30min/2025/2025-09-17.parquet size: 2.3 MB rows: 110,339 symbols: 312
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-09-17 04:00:00 | AAPL | Stock | 237.78 | 237.96 | 237.51 | 237.6 | 1202.0 |
| 2025-09-17 04:30:00 | AAPL | Stock | 237.46 | 237.73 | 237.38 | 237.71 | 6537.0 |
| 2025-09-17 05:00:00 | AAPL | Stock | 237.67 | 237.78 | 237.55 | 237.75 | 2959.0 |
| 2025-09-17 05:30:00 | AAPL | Stock | 237.72 | 237.82 | 237.7 | 237.82 | 9469.0 |
| 2025-09-17 06:00:00 | AAPL | Stock | 237.83 | 237.99 | 237.81 | 237.94 | 3387.0 |
| 2025-09-17 06:30:00 | AAPL | Stock | 237.94 | 238.12 | 237.8 | 237.81 | 8489.0 |
| 2025-09-17 07:00:00 | AAPL | Stock | 237.83 | 238.08 | 237.83 | 237.89 | 7616.0 |
| 2025-09-17 07:30:00 | AAPL | Stock | 237.9 | 238.1 | 237.8 | 238.1 | 4836.0 |
| 2025-09-17 08:00:00 | AAPL | Stock | 237.93 | 238.1958 | 237.36 | 238.15 | 54231.0 |
| 2025-09-17 08:30:00 | AAPL | Stock | 238.15 | 238.7183 | 238.14 | 238.7183 | 67397.0 |
| 2025-09-17 09:00:00 | AAPL | Stock | 238.72 | 239.04 | 238.64 | 238.95 | 101902.0 |
| 2025-09-17 09:30:00 | AAPL | Stock | 238.97 | 240.1 | 238.79 | 239.22 | 4982699.0 |
| 2025-09-17 10:00:00 | AAPL | Stock | 239.24 | 240.02 | 239.06 | 239.63 | 2227057.0 |
| 2025-09-17 10:30:00 | AAPL | Stock | 239.64 | 240.01 | 239.38 | 239.535 | 1593212.0 |
| 2025-09-17 11:00:00 | AAPL | Stock | 239.54 | 239.63 | 239.2 | 239.48 | 1232626.0 |
| 2025-09-17 11:30:00 | AAPL | Stock | 239.485 | 239.78 | 239.35 | 239.5527 | 1120342.0 |
| 2025-09-17 12:00:00 | AAPL | Stock | 239.56 | 239.69 | 239.28 | 239.6743 | 1060335.0 |
| 2025-09-17 12:30:00 | AAPL | Stock | 239.68 | 239.77 | 239.35 | 239.585 | 1115692.0 |
| 2025-09-17 13:00:00 | AAPL | Stock | 239.585 | 239.62 | 239.4 | 239.52 | 805605.0 |
| 2025-09-17 13:30:00 | AAPL | Stock | 239.52 | 239.62 | 238.91 | 239.44 | 1398436.0 |
| 2025-09-17 14:00:00 | AAPL | Stock | 239.43 | 239.83 | 238.45 | 239.56 | 2127302.0 |
| 2025-09-17 14:30:00 | AAPL | Stock | 239.55 | 239.63 | 237.7301 | 238.58 | 2397126.0 |
| 2025-09-17 15:00:00 | AAPL | Stock | 238.58 | 239.46 | 238.52 | 239.2629 | 1923413.0 |
| 2025-09-17 15:30:00 | AAPL | Stock | 239.27 | 239.28 | 238.475 | 238.95 | 3209845.0 |
| 2025-09-17 16:00:00 | AAPL | Stock | 239.01 | 240.0 | 238.26 | 239.4243 | 8386999.0 |
| 2025-09-17 16:30:00 | AAPL | Stock | 239.55 | 239.58 | 238.99 | 239.32 | 29778.0 |
| 2025-09-17 17:00:00 | AAPL | Stock | 239.31 | 239.33 | 238.99 | 239.33 | 6816.0 |
| 2025-09-17 17:30:00 | AAPL | Stock | 239.3001 | 239.4379 | 238.99 | 239.42 | 9568.0 |
| 2025-09-17 18:00:00 | AAPL | Stock | 239.4 | 239.44 | 239.28 | 239.32 | 4508.0 |
| 2025-09-17 18:30:00 | AAPL | Stock | 239.33 | 239.64 | 239.3 | 239.56 | 12695.0 |
| 2025-09-17 19:00:00 | AAPL | Stock | 239.5538 | 239.7091 | 239.5 | 239.64 | 16172.0 |
| 2025-09-17 19:30:00 | AAPL | Stock | 239.6 | 239.75 | 239.51 | 239.7001 | 17216.0 |
| 2025-09-17 04:00:00 | MSFT | Stock | 510.43 | 510.9 | 510.09 | 510.09 | 1792.0 |
| 2025-09-17 04:30:00 | MSFT | Stock | 510.0 | 510.18 | 509.9 | 509.9 | 2477.0 |
| 2025-09-17 05:00:00 | MSFT | Stock | 510.97 | 511.3 | 510.97 | 511.3 | 4065.0 |
| 2025-09-17 05:30:00 | MSFT | Stock | 511.37 | 511.37 | 511.0 | 511.0 | 840.0 |
| 2025-09-17 06:00:00 | MSFT | Stock | 510.79 | 510.79 | 510.79 | 510.79 | 100.0 |
| 2025-09-17 06:30:00 | MSFT | Stock | 510.6 | 511.3 | 510.6 | 511.0 | 3900.0 |
| 2025-09-17 07:00:00 | MSFT | Stock | 511.0 | 511.0 | 510.2 | 510.77 | 5456.0 |
| 2025-09-17 07:30:00 | MSFT | Stock | 510.51 | 510.51 | 510.1 | 510.1 | 446.0 |
| 2025-09-17 08:00:00 | MSFT | Stock | 510.74 | 511.17 | 509.6 | 510.23 | 24771.0 |
| 2025-09-17 08:30:00 | MSFT | Stock | 510.56 | 510.84 | 510.0 | 510.8158 | 3549.0 |
| 2025-09-17 09:00:00 | MSFT | Stock | 510.71 | 510.9642 | 510.0 | 510.5 | 8270.0 |
| 2025-09-17 09:30:00 | MSFT | Stock | 510.62 | 510.83 | 505.94 | 506.44 | 1325021.0 |
| 2025-09-17 10:00:00 | MSFT | Stock | 506.49 | 508.36 | 505.93 | 508.2085 | 646470.0 |
| 2025-09-17 10:30:00 | MSFT | Stock | 508.1718 | 508.63 | 507.08 | 507.25 | 335562.0 |
| 2025-09-17 11:00:00 | MSFT | Stock | 507.28 | 507.86 | 506.96 | 507.1 | 232441.0 |
| 2025-09-17 11:30:00 | MSFT | Stock | 507.03 | 508.3287 | 506.83 | 508.2824 | 286269.0 |
| 2025-09-17 12:00:00 | MSFT | Stock | 508.26 | 508.68 | 507.5 | 508.655 | 184905.0 |
| 2025-09-17 12:30:00 | MSFT | Stock | 508.6 | 508.74 | 507.93 | 508.14 | 192885.0 |
> showing 50 of 110,339 rows — these rows as CSV