PREVIEW / stock_30min / 2025-09-16
file: by_date/stock_30min/2025/2025-09-16.parquet size: 2.3 MB rows: 109,446 symbols: 314
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-16 04:00:00 | AAPL | Stock | 236.72 | 236.91 | 236.62 | 236.85 | 12346.0 |
| 2025-09-16 04:30:00 | AAPL | Stock | 236.81 | 236.9 | 236.77 | 236.9 | 3665.0 |
| 2025-09-16 05:00:00 | AAPL | Stock | 236.81 | 236.83 | 236.72 | 236.72 | 550.0 |
| 2025-09-16 05:30:00 | AAPL | Stock | 236.8 | 236.8 | 236.5 | 236.5 | 2722.0 |
| 2025-09-16 06:00:00 | AAPL | Stock | 236.55 | 236.55 | 236.5 | 236.55 | 3389.0 |
| 2025-09-16 06:30:00 | AAPL | Stock | 236.59 | 236.59 | 236.48 | 236.57 | 1152.0 |
| 2025-09-16 07:00:00 | AAPL | Stock | 236.6 | 236.78 | 236.1 | 236.76 | 24821.0 |
| 2025-09-16 07:30:00 | AAPL | Stock | 236.7 | 236.81 | 236.63 | 236.81 | 14038.0 |
| 2025-09-16 08:00:00 | AAPL | Stock | 236.5 | 236.95 | 236.34 | 236.8 | 97675.0 |
| 2025-09-16 08:30:00 | AAPL | Stock | 236.9125 | 236.98 | 236.72 | 236.8 | 33167.0 |
| 2025-09-16 09:00:00 | AAPL | Stock | 236.92 | 237.25 | 236.5 | 237.2 | 112021.0 |
| 2025-09-16 09:30:00 | AAPL | Stock | 237.12 | 240.56 | 236.3235 | 240.36 | 9090674.0 |
| 2025-09-16 10:00:00 | AAPL | Stock | 240.375 | 241.22 | 239.48 | 239.53 | 5865641.0 |
| 2025-09-16 10:30:00 | AAPL | Stock | 239.53 | 239.73 | 238.73 | 238.98 | 3017978.0 |
| 2025-09-16 11:00:00 | AAPL | Stock | 238.99 | 239.85 | 238.245 | 239.5929 | 2703825.0 |
| 2025-09-16 11:30:00 | AAPL | Stock | 239.5801 | 239.5801 | 238.465 | 238.655 | 1666722.0 |
| 2025-09-16 12:00:00 | AAPL | Stock | 238.66 | 239.4142 | 238.63 | 239.195 | 1616325.0 |
| 2025-09-16 12:30:00 | AAPL | Stock | 239.2 | 239.35 | 238.9 | 239.14 | 1194080.0 |
| 2025-09-16 13:00:00 | AAPL | Stock | 239.15 | 239.4 | 238.98 | 239.09 | 1199722.0 |
| 2025-09-16 13:30:00 | AAPL | Stock | 239.1 | 239.11 | 238.13 | 238.32 | 1561396.0 |
| 2025-09-16 14:00:00 | AAPL | Stock | 238.32 | 239.03 | 238.2099 | 238.93 | 1412943.0 |
| 2025-09-16 14:30:00 | AAPL | Stock | 238.93 | 239.11 | 238.81 | 239.06 | 1318721.0 |
| 2025-09-16 15:00:00 | AAPL | Stock | 239.06 | 239.6 | 238.85 | 238.94 | 2218543.0 |
| 2025-09-16 15:30:00 | AAPL | Stock | 238.935 | 239.63 | 238.08 | 238.14 | 4525966.0 |
| 2025-09-16 16:00:00 | AAPL | Stock | 238.12 | 238.3 | 238.01 | 238.12 | 10461262.0 |
| 2025-09-16 16:30:00 | AAPL | Stock | 238.11 | 238.11 | 237.8135 | 237.94 | 75377.0 |
| 2025-09-16 17:00:00 | AAPL | Stock | 237.95 | 238.08 | 237.85 | 237.95 | 10344.0 |
| 2025-09-16 17:30:00 | AAPL | Stock | 237.9119 | 238.0919 | 237.9119 | 237.9501 | 7108.0 |
| 2025-09-16 18:00:00 | AAPL | Stock | 237.95 | 238.15 | 237.9 | 237.91 | 19319.0 |
| 2025-09-16 18:30:00 | AAPL | Stock | 237.9 | 238.0 | 237.89 | 237.9384 | 7563.0 |
| 2025-09-16 19:00:00 | AAPL | Stock | 238.0 | 238.0 | 237.8 | 237.9 | 6445.0 |
| 2025-09-16 19:30:00 | AAPL | Stock | 237.87 | 237.91 | 237.85 | 237.91 | 3529.0 |
| 2025-09-16 04:00:00 | MSFT | Stock | 517.1 | 517.6 | 516.0 | 517.43 | 1559.0 |
| 2025-09-16 04:30:00 | MSFT | Stock | 517.44 | 517.61 | 517.1 | 517.61 | 1235.0 |
| 2025-09-16 05:00:00 | MSFT | Stock | 517.63 | 517.8 | 517.22 | 517.22 | 1477.0 |
| 2025-09-16 05:30:00 | MSFT | Stock | 517.25 | 517.48 | 517.25 | 517.48 | 452.0 |
| 2025-09-16 06:00:00 | MSFT | Stock | 517.48 | 517.48 | 517.25 | 517.28 | 3379.0 |
| 2025-09-16 06:30:00 | MSFT | Stock | 517.28 | 517.28 | 517.28 | 517.28 | 336.0 |
| 2025-09-16 07:00:00 | MSFT | Stock | 517.28 | 517.28 | 516.31 | 516.31 | 13568.0 |
| 2025-09-16 07:30:00 | MSFT | Stock | 516.49 | 517.0 | 516.49 | 517.0 | 1475.0 |
| 2025-09-16 08:00:00 | MSFT | Stock | 517.36 | 517.86 | 516.0 | 516.0 | 34593.0 |
| 2025-09-16 08:30:00 | MSFT | Stock | 515.98 | 516.14 | 515.8 | 515.8 | 7173.0 |
| 2025-09-16 09:00:00 | MSFT | Stock | 515.5 | 517.5 | 514.603 | 517.0 | 40791.0 |
| 2025-09-16 09:30:00 | MSFT | Stock | 516.88 | 517.23 | 511.06 | 511.245 | 1687984.0 |
| 2025-09-16 10:00:00 | MSFT | Stock | 511.32 | 514.0 | 510.59 | 513.47 | 755435.0 |
| 2025-09-16 10:30:00 | MSFT | Stock | 513.31 | 513.95 | 511.89 | 513.3 | 395875.0 |
| 2025-09-16 11:00:00 | MSFT | Stock | 513.34 | 513.65 | 512.4101 | 512.57 | 280981.0 |
| 2025-09-16 11:30:00 | MSFT | Stock | 512.555 | 513.23 | 512.12 | 512.99 | 219670.0 |
| 2025-09-16 12:00:00 | MSFT | Stock | 512.9842 | 513.68 | 512.595 | 513.29 | 172150.0 |
| 2025-09-16 12:30:00 | MSFT | Stock | 513.265 | 513.82 | 512.62 | 513.35 | 218925.0 |
> showing 50 of 109,446 rows — these rows as CSV