PREVIEW / stock_30min / 2025-09-23
file: by_date/stock_30min/2025/2025-09-23.parquet size: 2.3 MB rows: 110,509 symbols: 307
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-23 04:00:00 | AAPL | Stock | 256.68 | 256.68 | 256.1 | 256.32 | 14452.0 |
| 2025-09-23 04:30:00 | AAPL | Stock | 256.3 | 256.3 | 255.09 | 255.1 | 17274.0 |
| 2025-09-23 05:00:00 | AAPL | Stock | 255.05 | 255.6 | 254.94 | 255.2 | 9011.0 |
| 2025-09-23 05:30:00 | AAPL | Stock | 255.1 | 255.8 | 255.1 | 255.65 | 6727.0 |
| 2025-09-23 06:00:00 | AAPL | Stock | 255.65 | 255.65 | 255.17 | 255.38 | 2043.0 |
| 2025-09-23 06:30:00 | AAPL | Stock | 255.49 | 255.55 | 255.09 | 255.3 | 8178.0 |
| 2025-09-23 07:00:00 | AAPL | Stock | 255.28 | 255.47 | 254.69 | 255.1 | 25153.0 |
| 2025-09-23 07:30:00 | AAPL | Stock | 255.06 | 255.17 | 254.62 | 255.08 | 29290.0 |
| 2025-09-23 08:00:00 | AAPL | Stock | 256.41 | 256.75 | 254.6 | 254.85 | 171750.0 |
| 2025-09-23 08:30:00 | AAPL | Stock | 254.85 | 255.05 | 254.76 | 255.03 | 60342.0 |
| 2025-09-23 09:00:00 | AAPL | Stock | 255.03 | 255.95 | 254.75 | 255.93 | 204914.0 |
| 2025-09-23 09:30:00 | AAPL | Stock | 255.83 | 257.34 | 255.28 | 256.2 | 7261228.0 |
| 2025-09-23 10:00:00 | AAPL | Stock | 256.21 | 257.0 | 255.52 | 256.6173 | 3634117.0 |
| 2025-09-23 10:30:00 | AAPL | Stock | 256.61 | 256.72 | 255.0 | 255.29 | 3349833.0 |
| 2025-09-23 11:00:00 | AAPL | Stock | 255.31 | 256.38 | 255.22 | 256.1 | 2219438.0 |
| 2025-09-23 11:30:00 | AAPL | Stock | 256.11 | 256.15 | 255.345 | 255.9656 | 1828838.0 |
| 2025-09-23 12:00:00 | AAPL | Stock | 255.965 | 256.21 | 255.56 | 255.7269 | 1404175.0 |
| 2025-09-23 12:30:00 | AAPL | Stock | 255.7201 | 255.85 | 254.68 | 255.093 | 1325766.0 |
| 2025-09-23 13:00:00 | AAPL | Stock | 255.08 | 255.23 | 254.4 | 254.67 | 1636598.0 |
| 2025-09-23 13:30:00 | AAPL | Stock | 254.65 | 254.885 | 253.93 | 254.3276 | 2199526.0 |
| 2025-09-23 14:00:00 | AAPL | Stock | 254.335 | 254.961 | 253.97 | 254.64 | 1602494.0 |
| 2025-09-23 14:30:00 | AAPL | Stock | 254.64 | 254.84 | 254.09 | 254.125 | 1664725.0 |
| 2025-09-23 15:00:00 | AAPL | Stock | 254.12 | 254.24 | 253.58 | 254.1699 | 1739111.0 |
| 2025-09-23 15:30:00 | AAPL | Stock | 254.16 | 254.53 | 253.67 | 254.53 | 3841226.0 |
| 2025-09-23 16:00:00 | AAPL | Stock | 254.43 | 254.65 | 254.2 | 254.43 | 8301760.0 |
| 2025-09-23 16:30:00 | AAPL | Stock | 254.39 | 254.43 | 254.2 | 254.33 | 34475.0 |
| 2025-09-23 17:00:00 | AAPL | Stock | 254.4 | 254.4 | 254.34 | 254.3999 | 3408.0 |
| 2025-09-23 17:30:00 | AAPL | Stock | 254.3359 | 254.41 | 254.21 | 254.26 | 5161.0 |
| 2025-09-23 18:00:00 | AAPL | Stock | 254.28 | 254.49 | 254.2615 | 254.35 | 10829.0 |
| 2025-09-23 18:30:00 | AAPL | Stock | 254.31 | 254.38 | 254.1542 | 254.35 | 7361.0 |
| 2025-09-23 19:00:00 | AAPL | Stock | 254.28 | 254.35 | 253.95 | 254.11 | 7187.0 |
| 2025-09-23 19:30:00 | AAPL | Stock | 254.01 | 254.18 | 254.0 | 254.18 | 10705.0 |
| 2025-09-23 04:00:00 | MSFT | Stock | 515.75 | 516.5 | 515.66 | 516.5 | 2276.0 |
| 2025-09-23 04:30:00 | MSFT | Stock | 516.18 | 516.18 | 515.7 | 515.78 | 550.0 |
| 2025-09-23 05:00:00 | MSFT | Stock | 515.35 | 515.65 | 515.3 | 515.65 | 4451.0 |
| 2025-09-23 05:30:00 | MSFT | Stock | 515.51 | 515.55 | 515.5 | 515.5 | 1292.0 |
| 2025-09-23 06:00:00 | MSFT | Stock | 515.01 | 515.01 | 514.8 | 514.8 | 295.0 |
| 2025-09-23 06:30:00 | MSFT | Stock | 514.58 | 514.73 | 514.46 | 514.7 | 1205.0 |
| 2025-09-23 07:00:00 | MSFT | Stock | 514.7 | 514.95 | 514.6 | 514.95 | 3984.0 |
| 2025-09-23 07:30:00 | MSFT | Stock | 514.85 | 514.85 | 514.5 | 514.83 | 3313.0 |
| 2025-09-23 08:00:00 | MSFT | Stock | 514.9 | 516.3 | 514.45 | 515.0 | 18792.0 |
| 2025-09-23 08:30:00 | MSFT | Stock | 514.75 | 515.61 | 514.75 | 515.49 | 7906.0 |
| 2025-09-23 09:00:00 | MSFT | Stock | 515.5 | 515.74 | 512.94 | 513.7 | 30281.0 |
| 2025-09-23 09:30:00 | MSFT | Stock | 513.81 | 514.5899 | 510.375 | 511.75 | 1312721.0 |
| 2025-09-23 10:00:00 | MSFT | Stock | 511.68 | 513.0632 | 511.41 | 511.555 | 745484.0 |
| 2025-09-23 10:30:00 | MSFT | Stock | 511.6 | 511.75 | 510.85 | 511.07 | 406161.0 |
| 2025-09-23 11:00:00 | MSFT | Stock | 511.12 | 511.425 | 510.84 | 510.91 | 408134.0 |
| 2025-09-23 11:30:00 | MSFT | Stock | 510.925 | 511.19 | 509.84 | 510.37 | 552676.0 |
| 2025-09-23 12:00:00 | MSFT | Stock | 510.37 | 510.86 | 510.0654 | 510.3792 | 321120.0 |
| 2025-09-23 12:30:00 | MSFT | Stock | 510.31 | 511.37 | 510.1 | 510.43 | 268068.0 |
> showing 50 of 110,509 rows — these rows as CSV