PREVIEW / stock_30min / 2025-09-08
file: by_date/stock_30min/2025/2025-09-08.parquet size: 2.3 MB rows: 109,502 symbols: 315
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-08 04:00:00 | AAPL | Stock | 239.98 | 240.49 | 239.98 | 240.15 | 5989.0 |
| 2025-09-08 04:30:00 | AAPL | Stock | 240.06 | 240.06 | 239.51 | 239.51 | 6103.0 |
| 2025-09-08 05:00:00 | AAPL | Stock | 239.55 | 239.58 | 239.5 | 239.58 | 1949.0 |
| 2025-09-08 05:30:00 | AAPL | Stock | 239.63 | 239.74 | 239.63 | 239.72 | 1038.0 |
| 2025-09-08 06:00:00 | AAPL | Stock | 239.67 | 239.89 | 239.64 | 239.85 | 2309.0 |
| 2025-09-08 06:30:00 | AAPL | Stock | 239.76 | 239.89 | 239.6 | 239.6 | 5273.0 |
| 2025-09-08 07:00:00 | AAPL | Stock | 239.67 | 240.04 | 239.6 | 239.85 | 7319.0 |
| 2025-09-08 07:30:00 | AAPL | Stock | 239.85 | 239.88 | 239.75 | 239.75 | 5797.0 |
| 2025-09-08 08:00:00 | AAPL | Stock | 239.7 | 240.75 | 239.5 | 239.82 | 70108.0 |
| 2025-09-08 08:30:00 | AAPL | Stock | 239.85 | 240.0 | 239.7445 | 239.95 | 12160.0 |
| 2025-09-08 09:00:00 | AAPL | Stock | 239.96 | 240.41 | 239.29 | 239.42 | 87994.0 |
| 2025-09-08 09:30:00 | AAPL | Stock | 239.3 | 240.15 | 238.74 | 239.35 | 5153796.0 |
| 2025-09-08 10:00:00 | AAPL | Stock | 239.32 | 239.84 | 239.0 | 239.23 | 2493459.0 |
| 2025-09-08 10:30:00 | AAPL | Stock | 239.22 | 239.49 | 238.835 | 239.15 | 1811199.0 |
| 2025-09-08 11:00:00 | AAPL | Stock | 239.14 | 239.57 | 238.615 | 238.695 | 2012565.0 |
| 2025-09-08 11:30:00 | AAPL | Stock | 238.695 | 238.7899 | 237.98 | 238.28 | 1823440.0 |
| 2025-09-08 12:00:00 | AAPL | Stock | 238.27 | 238.375 | 237.6 | 237.73 | 1454437.0 |
| 2025-09-08 12:30:00 | AAPL | Stock | 237.72 | 237.7897 | 236.86 | 236.98 | 1630585.0 |
| 2025-09-08 13:00:00 | AAPL | Stock | 236.98 | 237.8799 | 236.34 | 237.8058 | 2141576.0 |
| 2025-09-08 13:30:00 | AAPL | Stock | 237.805 | 237.955 | 237.4992 | 237.75 | 1608675.0 |
| 2025-09-08 14:00:00 | AAPL | Stock | 237.75 | 237.85 | 237.105 | 237.165 | 1615994.0 |
| 2025-09-08 14:30:00 | AAPL | Stock | 237.16 | 237.195 | 236.61 | 236.875 | 1426378.0 |
| 2025-09-08 15:00:00 | AAPL | Stock | 236.87 | 237.2499 | 236.75 | 237.11 | 1292384.0 |
| 2025-09-08 15:30:00 | AAPL | Stock | 237.115 | 238.01 | 236.9042 | 237.92 | 3954159.0 |
| 2025-09-08 16:00:00 | AAPL | Stock | 237.92 | 238.2977 | 237.8 | 238.04 | 4913754.0 |
| 2025-09-08 16:30:00 | AAPL | Stock | 238.03 | 238.2 | 237.6 | 238.2 | 42689.0 |
| 2025-09-08 17:00:00 | AAPL | Stock | 238.05 | 238.3 | 238.0101 | 238.06 | 11944.0 |
| 2025-09-08 17:30:00 | AAPL | Stock | 238.0513 | 238.1377 | 237.85 | 237.98 | 16741.0 |
| 2025-09-08 18:00:00 | AAPL | Stock | 238.0 | 238.08 | 237.8801 | 237.9474 | 5446.0 |
| 2025-09-08 18:30:00 | AAPL | Stock | 237.9138 | 238.0791 | 237.88 | 238.0791 | 3751.0 |
| 2025-09-08 19:00:00 | AAPL | Stock | 238.06 | 238.0707 | 237.98 | 238.0 | 6680.0 |
| 2025-09-08 19:30:00 | AAPL | Stock | 237.98 | 238.0 | 237.7 | 237.86 | 13505.0 |
| 2025-09-08 04:00:00 | MSFT | Stock | 497.09 | 499.5 | 497.09 | 499.5 | 7903.0 |
| 2025-09-08 04:30:00 | MSFT | Stock | 499.65 | 500.08 | 499.5 | 500.08 | 4120.0 |
| 2025-09-08 05:00:00 | MSFT | Stock | 500.0 | 500.24 | 500.0 | 500.15 | 7342.0 |
| 2025-09-08 05:30:00 | MSFT | Stock | 500.15 | 500.41 | 499.85 | 500.41 | 4074.0 |
| 2025-09-08 06:00:00 | MSFT | Stock | 500.32 | 500.4 | 500.31 | 500.32 | 1686.0 |
| 2025-09-08 06:30:00 | MSFT | Stock | 500.15 | 500.15 | 500.15 | 500.15 | 809.0 |
| 2025-09-08 07:00:00 | MSFT | Stock | 500.0 | 500.0 | 498.5 | 499.5 | 15071.0 |
| 2025-09-08 07:30:00 | MSFT | Stock | 499.4 | 499.4 | 498.56 | 498.75 | 2336.0 |
| 2025-09-08 08:00:00 | MSFT | Stock | 499.0 | 500.5 | 496.3 | 497.8 | 50588.0 |
| 2025-09-08 08:30:00 | MSFT | Stock | 498.0 | 498.2 | 497.5 | 497.9499 | 6712.0 |
| 2025-09-08 09:00:00 | MSFT | Stock | 497.95 | 499.7 | 497.95 | 498.2 | 19670.0 |
| 2025-09-08 09:30:00 | MSFT | Stock | 498.105 | 500.21 | 495.03 | 498.78 | 1991170.0 |
| 2025-09-08 10:00:00 | MSFT | Stock | 498.78 | 500.65 | 498.3003 | 500.6 | 698656.0 |
| 2025-09-08 10:30:00 | MSFT | Stock | 500.6 | 500.86 | 499.83 | 500.18 | 560400.0 |
| 2025-09-08 11:00:00 | MSFT | Stock | 500.165 | 500.8 | 499.39 | 500.65 | 534059.0 |
| 2025-09-08 11:30:00 | MSFT | Stock | 500.635 | 501.195 | 500.11 | 500.41 | 417413.0 |
| 2025-09-08 12:00:00 | MSFT | Stock | 500.4193 | 500.4193 | 498.5 | 498.8 | 326769.0 |
| 2025-09-08 12:30:00 | MSFT | Stock | 498.8 | 498.9187 | 497.78 | 498.68 | 268972.0 |
> showing 50 of 109,502 rows — these rows as CSV