PREVIEW / stock_30min / 2025-09-25
file: by_date/stock_30min/2025/2025-09-25.parquet size: 2.3 MB rows: 110,394 symbols: 301
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-25 04:00:00 | AAPL | Stock | 251.69 | 251.81 | 251.5 | 251.61 | 3266.0 |
| 2025-09-25 04:30:00 | AAPL | Stock | 251.85 | 251.85 | 251.46 | 251.6 | 1783.0 |
| 2025-09-25 05:00:00 | AAPL | Stock | 251.6 | 251.66 | 251.6 | 251.66 | 238.0 |
| 2025-09-25 05:30:00 | AAPL | Stock | 251.68 | 251.7 | 251.34 | 251.57 | 8116.0 |
| 2025-09-25 06:00:00 | AAPL | Stock | 251.7 | 252.16 | 251.7 | 251.73 | 3637.0 |
| 2025-09-25 06:30:00 | AAPL | Stock | 251.87 | 253.94 | 251.87 | 252.99 | 54980.0 |
| 2025-09-25 07:00:00 | AAPL | Stock | 252.76 | 253.22 | 252.59 | 252.76 | 26138.0 |
| 2025-09-25 07:30:00 | AAPL | Stock | 252.8 | 252.86 | 252.07 | 252.7 | 24124.0 |
| 2025-09-25 08:00:00 | AAPL | Stock | 253.8 | 253.86 | 251.33 | 252.28 | 104329.0 |
| 2025-09-25 08:30:00 | AAPL | Stock | 251.98 | 252.85 | 251.81 | 252.33 | 83017.0 |
| 2025-09-25 09:00:00 | AAPL | Stock | 252.45 | 253.7 | 252.27 | 253.25 | 203351.0 |
| 2025-09-25 09:30:00 | AAPL | Stock | 253.35 | 254.32 | 251.712 | 252.31 | 6121957.0 |
| 2025-09-25 10:00:00 | AAPL | Stock | 252.33 | 254.12 | 252.12 | 254.0 | 2670132.0 |
| 2025-09-25 10:30:00 | AAPL | Stock | 254.0001 | 254.1388 | 253.03 | 253.68 | 1629443.0 |
| 2025-09-25 11:00:00 | AAPL | Stock | 253.69 | 254.13 | 253.1105 | 253.5001 | 1592984.0 |
| 2025-09-25 11:30:00 | AAPL | Stock | 253.5001 | 253.91 | 252.83 | 252.885 | 1276558.0 |
| 2025-09-25 12:00:00 | AAPL | Stock | 252.8756 | 252.99 | 252.3 | 252.53 | 1337615.0 |
| 2025-09-25 12:30:00 | AAPL | Stock | 252.54 | 253.3699 | 252.5 | 253.23 | 1289337.0 |
| 2025-09-25 13:00:00 | AAPL | Stock | 253.23 | 253.88 | 253.12 | 253.5 | 1608619.0 |
| 2025-09-25 13:30:00 | AAPL | Stock | 253.5 | 253.7 | 253.16 | 253.21 | 1000408.0 |
| 2025-09-25 14:00:00 | AAPL | Stock | 253.21 | 254.59 | 252.85 | 254.56 | 2024052.0 |
| 2025-09-25 14:30:00 | AAPL | Stock | 254.55 | 256.1 | 254.23 | 256.0 | 3987028.0 |
| 2025-09-25 15:00:00 | AAPL | Stock | 255.99 | 257.17 | 255.87 | 256.96 | 4009250.0 |
| 2025-09-25 15:30:00 | AAPL | Stock | 256.95 | 257.11 | 255.42 | 256.94 | 5210299.0 |
| 2025-09-25 16:00:00 | AAPL | Stock | 256.94 | 257.0 | 256.34 | 256.3613 | 6913332.0 |
| 2025-09-25 16:30:00 | AAPL | Stock | 256.36 | 256.52 | 256.1 | 256.26 | 38885.0 |
| 2025-09-25 17:00:00 | AAPL | Stock | 256.24 | 256.45 | 256.24 | 256.39 | 12335.0 |
| 2025-09-25 17:30:00 | AAPL | Stock | 256.39 | 256.39 | 256.1 | 256.25 | 14039.0 |
| 2025-09-25 18:00:00 | AAPL | Stock | 256.2395 | 256.5001 | 256.2313 | 256.3 | 16496.0 |
| 2025-09-25 18:30:00 | AAPL | Stock | 256.27 | 256.43 | 256.23 | 256.23 | 7057.0 |
| 2025-09-25 19:00:00 | AAPL | Stock | 256.2 | 256.2699 | 255.71 | 256.15 | 14237.0 |
| 2025-09-25 19:30:00 | AAPL | Stock | 256.24 | 256.87 | 256.08 | 256.18 | 54811.0 |
| 2025-09-25 04:00:00 | MSFT | Stock | 510.13 | 510.69 | 510.13 | 510.6 | 2188.0 |
| 2025-09-25 04:30:00 | MSFT | Stock | 510.21 | 510.25 | 510.06 | 510.06 | 761.0 |
| 2025-09-25 05:00:00 | MSFT | Stock | 509.76 | 509.79 | 509.76 | 509.79 | 254.0 |
| 2025-09-25 05:30:00 | MSFT | Stock | 509.73 | 509.81 | 509.73 | 509.76 | 1086.0 |
| 2025-09-25 06:00:00 | MSFT | Stock | 509.75 | 510.15 | 509.75 | 509.79 | 2024.0 |
| 2025-09-25 06:30:00 | MSFT | Stock | 509.88 | 510.0 | 509.55 | 509.65 | 1000.0 |
| 2025-09-25 07:00:00 | MSFT | Stock | 509.91 | 509.91 | 507.99 | 508.27 | 7907.0 |
| 2025-09-25 07:30:00 | MSFT | Stock | 508.1 | 508.5 | 508.0 | 508.0 | 3055.0 |
| 2025-09-25 08:00:00 | MSFT | Stock | 508.07 | 511.425 | 507.6 | 508.5 | 23758.0 |
| 2025-09-25 08:30:00 | MSFT | Stock | 508.12 | 508.14 | 507.08 | 507.75 | 17005.0 |
| 2025-09-25 09:00:00 | MSFT | Stock | 507.65 | 510.0 | 507.65 | 508.2997 | 41108.0 |
| 2025-09-25 09:30:00 | MSFT | Stock | 508.3 | 509.27 | 505.5 | 506.265 | 1585319.0 |
| 2025-09-25 10:00:00 | MSFT | Stock | 506.23 | 508.22 | 505.04 | 508.16 | 1014388.0 |
| 2025-09-25 10:30:00 | MSFT | Stock | 508.2 | 510.01 | 507.9801 | 509.69 | 432402.0 |
| 2025-09-25 11:00:00 | MSFT | Stock | 509.7366 | 509.785 | 507.678 | 507.985 | 456128.0 |
| 2025-09-25 11:30:00 | MSFT | Stock | 508.07 | 509.01 | 507.9401 | 508.64 | 313560.0 |
| 2025-09-25 12:00:00 | MSFT | Stock | 508.69 | 509.06 | 508.0 | 508.08 | 223944.0 |
| 2025-09-25 12:30:00 | MSFT | Stock | 508.08 | 508.72 | 507.5501 | 508.0611 | 220348.0 |
> showing 50 of 110,394 rows — these rows as CSV