PREVIEW / stock_30min / 2025-09-24
file: by_date/stock_30min/2025/2025-09-24.parquet size: 2.3 MB rows: 109,007 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-24 04:00:00 | AAPL | Stock | 254.21 | 254.37 | 254.14 | 254.17 | 7391.0 |
| 2025-09-24 04:30:00 | AAPL | Stock | 254.15 | 254.52 | 254.15 | 254.52 | 3688.0 |
| 2025-09-24 05:00:00 | AAPL | Stock | 254.61 | 254.94 | 254.58 | 254.8 | 7598.0 |
| 2025-09-24 05:30:00 | AAPL | Stock | 254.72 | 254.72 | 254.5 | 254.55 | 4017.0 |
| 2025-09-24 06:00:00 | AAPL | Stock | 254.6 | 254.68 | 254.43 | 254.43 | 4579.0 |
| 2025-09-24 06:30:00 | AAPL | Stock | 254.43 | 254.57 | 254.26 | 254.41 | 4309.0 |
| 2025-09-24 07:00:00 | AAPL | Stock | 254.42 | 254.94 | 254.42 | 254.7 | 10802.0 |
| 2025-09-24 07:30:00 | AAPL | Stock | 254.71 | 255.0 | 254.68 | 255.0 | 12662.0 |
| 2025-09-24 08:00:00 | AAPL | Stock | 254.51 | 255.21 | 253.794 | 255.21 | 80267.0 |
| 2025-09-24 08:30:00 | AAPL | Stock | 255.21 | 255.45 | 255.0 | 255.11 | 24163.0 |
| 2025-09-24 09:00:00 | AAPL | Stock | 255.1164 | 255.26 | 254.6 | 255.26 | 46940.0 |
| 2025-09-24 09:30:00 | AAPL | Stock | 255.25 | 255.74 | 252.28 | 253.25 | 4424152.0 |
| 2025-09-24 10:00:00 | AAPL | Stock | 253.28 | 253.2995 | 252.08 | 252.622 | 2365707.0 |
| 2025-09-24 10:30:00 | AAPL | Stock | 252.625 | 252.99 | 251.72 | 252.2101 | 2183767.0 |
| 2025-09-24 11:00:00 | AAPL | Stock | 252.22 | 252.31 | 251.54 | 252.12 | 1479199.0 |
| 2025-09-24 11:30:00 | AAPL | Stock | 252.12 | 252.21 | 251.28 | 251.405 | 1567053.0 |
| 2025-09-24 12:00:00 | AAPL | Stock | 251.41 | 252.26 | 251.04 | 252.17 | 1836809.0 |
| 2025-09-24 12:30:00 | AAPL | Stock | 252.1714 | 252.261 | 251.4 | 251.5397 | 949458.0 |
| 2025-09-24 13:00:00 | AAPL | Stock | 251.54 | 251.83 | 251.34 | 251.49 | 691188.0 |
| 2025-09-24 13:30:00 | AAPL | Stock | 251.515 | 252.11 | 251.32 | 251.5 | 661289.0 |
| 2025-09-24 14:00:00 | AAPL | Stock | 251.4938 | 251.84 | 251.28 | 251.7298 | 847737.0 |
| 2025-09-24 14:30:00 | AAPL | Stock | 251.73 | 251.795 | 251.25 | 251.725 | 751495.0 |
| 2025-09-24 15:00:00 | AAPL | Stock | 251.72 | 251.765 | 251.24 | 251.39 | 957354.0 |
| 2025-09-24 15:30:00 | AAPL | Stock | 251.39 | 252.5 | 251.29 | 252.24 | 3075998.0 |
| 2025-09-24 16:00:00 | AAPL | Stock | 252.2 | 252.4 | 252.01 | 252.37 | 9007441.0 |
| 2025-09-24 16:30:00 | AAPL | Stock | 252.37 | 252.47 | 252.31 | 252.32 | 27147.0 |
| 2025-09-24 17:00:00 | AAPL | Stock | 252.31 | 252.41 | 252.26 | 252.4026 | 12128.0 |
| 2025-09-24 17:30:00 | AAPL | Stock | 252.3 | 252.47 | 252.26 | 252.32 | 9276.0 |
| 2025-09-24 18:00:00 | AAPL | Stock | 252.36 | 252.36 | 252.2695 | 252.2988 | 3298.0 |
| 2025-09-24 18:30:00 | AAPL | Stock | 252.27 | 252.3 | 252.2 | 252.25 | 5924.0 |
| 2025-09-24 19:00:00 | AAPL | Stock | 252.2732 | 252.28 | 252.1 | 252.1 | 7734.0 |
| 2025-09-24 19:30:00 | AAPL | Stock | 252.03 | 252.21 | 252.02 | 252.08 | 10800.0 |
| 2025-09-24 04:00:00 | MSFT | Stock | 509.3 | 510.53 | 509.3 | 509.79 | 1123.0 |
| 2025-09-24 04:30:00 | MSFT | Stock | 509.93 | 509.93 | 509.93 | 509.93 | 125.0 |
| 2025-09-24 05:30:00 | MSFT | Stock | 510.31 | 510.49 | 510.31 | 510.49 | 698.0 |
| 2025-09-24 06:00:00 | MSFT | Stock | 510.49 | 510.75 | 510.49 | 510.61 | 1640.0 |
| 2025-09-24 06:30:00 | MSFT | Stock | 510.1 | 510.24 | 510.0 | 510.16 | 835.0 |
| 2025-09-24 07:00:00 | MSFT | Stock | 510.08 | 510.41 | 509.85 | 510.3 | 3808.0 |
| 2025-09-24 07:30:00 | MSFT | Stock | 510.6 | 510.62 | 510.1 | 510.52 | 2005.0 |
| 2025-09-24 08:00:00 | MSFT | Stock | 510.5 | 510.6915 | 508.4 | 510.53 | 13882.0 |
| 2025-09-24 08:30:00 | MSFT | Stock | 510.59 | 510.63 | 510.44 | 510.55 | 3110.0 |
| 2025-09-24 09:00:00 | MSFT | Stock | 510.61 | 510.8 | 510.35 | 510.66 | 4606.0 |
| 2025-09-24 09:30:00 | MSFT | Stock | 510.38 | 512.48 | 507.2 | 508.62 | 1339825.0 |
| 2025-09-24 10:00:00 | MSFT | Stock | 508.74 | 510.11 | 508.03 | 510.05 | 461087.0 |
| 2025-09-24 10:30:00 | MSFT | Stock | 510.03 | 510.8 | 509.04 | 509.37 | 352796.0 |
| 2025-09-24 11:00:00 | MSFT | Stock | 509.39 | 510.89 | 509.39 | 509.585 | 361953.0 |
| 2025-09-24 11:30:00 | MSFT | Stock | 509.63 | 509.76 | 508.2 | 508.27 | 336335.0 |
| 2025-09-24 12:00:00 | MSFT | Stock | 508.275 | 508.86 | 507.62 | 508.0784 | 375748.0 |
| 2025-09-24 12:30:00 | MSFT | Stock | 508.1041 | 508.4999 | 507.4301 | 507.51 | 263552.0 |
| 2025-09-24 13:00:00 | MSFT | Stock | 507.51 | 508.2 | 506.92 | 508.01 | 299143.0 |
> showing 50 of 109,007 rows — these rows as CSV