PREVIEW / stock_30min / 2025-07-25
file: by_date/stock_30min/2025/2025-07-25.parquet size: 2.2 MB rows: 104,526 symbols: 362
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-07-25 04:00:00 | AAPL | Stock | 213.72 | 214.18 | 213.72 | 214.02 | 8214.0 |
| 2025-07-25 04:30:00 | AAPL | Stock | 214.02 | 214.19 | 214.01 | 214.16 | 1771.0 |
| 2025-07-25 05:00:00 | AAPL | Stock | 214.13 | 214.32 | 214.11 | 214.32 | 2888.0 |
| 2025-07-25 05:30:00 | AAPL | Stock | 214.25 | 214.42 | 214.22 | 214.42 | 2445.0 |
| 2025-07-25 06:00:00 | AAPL | Stock | 214.46 | 214.57 | 214.33 | 214.36 | 4217.0 |
| 2025-07-25 06:30:00 | AAPL | Stock | 214.31 | 214.5 | 214.3 | 214.5 | 2637.0 |
| 2025-07-25 07:00:00 | AAPL | Stock | 214.38 | 214.38 | 214.22 | 214.24 | 6158.0 |
| 2025-07-25 07:30:00 | AAPL | Stock | 214.25 | 214.4 | 214.14 | 214.15 | 6258.0 |
| 2025-07-25 08:00:00 | AAPL | Stock | 214.34 | 214.57 | 213.8 | 214.25 | 52076.0 |
| 2025-07-25 08:30:00 | AAPL | Stock | 214.17 | 214.5 | 214.17 | 214.47 | 32092.0 |
| 2025-07-25 09:00:00 | AAPL | Stock | 214.41 | 214.73 | 214.3 | 214.65 | 42687.0 |
| 2025-07-25 09:30:00 | AAPL | Stock | 214.64 | 214.86 | 213.8 | 214.0918 | 3630961.0 |
| 2025-07-25 10:00:00 | AAPL | Stock | 214.09 | 214.65 | 213.73 | 214.5853 | 2670663.0 |
| 2025-07-25 10:30:00 | AAPL | Stock | 214.59 | 215.24 | 214.4139 | 214.7302 | 2421887.0 |
| 2025-07-25 11:00:00 | AAPL | Stock | 214.73 | 214.78 | 214.21 | 214.51 | 1537318.0 |
| 2025-07-25 11:30:00 | AAPL | Stock | 214.5 | 214.64 | 214.09 | 214.2365 | 1183823.0 |
| 2025-07-25 12:00:00 | AAPL | Stock | 214.23 | 214.615 | 214.05 | 214.3896 | 1064812.0 |
| 2025-07-25 12:30:00 | AAPL | Stock | 214.39 | 214.59 | 214.325 | 214.405 | 952543.0 |
| 2025-07-25 13:00:00 | AAPL | Stock | 214.4049 | 214.405 | 214.04 | 214.17 | 1062017.0 |
| 2025-07-25 13:30:00 | AAPL | Stock | 214.1704 | 214.51 | 213.92 | 213.9901 | 1452037.0 |
| 2025-07-25 14:00:00 | AAPL | Stock | 213.995 | 214.1699 | 213.82 | 213.89 | 871001.0 |
| 2025-07-25 14:30:00 | AAPL | Stock | 213.8932 | 214.01 | 213.7 | 213.7935 | 1034501.0 |
| 2025-07-25 15:00:00 | AAPL | Stock | 213.79 | 213.9 | 213.4 | 213.5 | 1246715.0 |
| 2025-07-25 15:30:00 | AAPL | Stock | 213.505 | 214.0 | 213.49 | 213.96 | 3361855.0 |
| 2025-07-25 16:00:00 | AAPL | Stock | 213.96 | 213.96 | 213.7 | 213.8155 | 3738096.0 |
| 2025-07-25 16:30:00 | AAPL | Stock | 213.8991 | 214.01 | 213.81 | 214.0 | 20942.0 |
| 2025-07-25 17:00:00 | AAPL | Stock | 214.02 | 214.03 | 213.95 | 213.9796 | 25088.0 |
| 2025-07-25 17:30:00 | AAPL | Stock | 213.9501 | 213.99 | 213.81 | 213.9 | 15265.0 |
| 2025-07-25 18:00:00 | AAPL | Stock | 213.881 | 214.0 | 213.85 | 213.92 | 23159.0 |
| 2025-07-25 18:30:00 | AAPL | Stock | 213.9695 | 213.9695 | 213.91 | 213.92 | 4518.0 |
| 2025-07-25 19:00:00 | AAPL | Stock | 213.95 | 213.95 | 213.91 | 213.91 | 5395.0 |
| 2025-07-25 19:30:00 | AAPL | Stock | 213.9101 | 214.05 | 213.91 | 214.0 | 12773.0 |
| 2025-07-25 04:00:00 | MSFT | Stock | 511.7 | 511.7 | 511.5 | 511.5 | 358.0 |
| 2025-07-25 04:30:00 | MSFT | Stock | 512.01 | 512.01 | 512.01 | 512.01 | 385.0 |
| 2025-07-25 05:00:00 | MSFT | Stock | 511.9 | 511.95 | 511.62 | 511.62 | 1068.0 |
| 2025-07-25 05:30:00 | MSFT | Stock | 511.79 | 511.87 | 511.79 | 511.87 | 1104.0 |
| 2025-07-25 06:00:00 | MSFT | Stock | 511.9 | 511.99 | 511.74 | 511.99 | 951.0 |
| 2025-07-25 06:30:00 | MSFT | Stock | 512.19 | 512.39 | 512.1 | 512.39 | 447.0 |
| 2025-07-25 07:00:00 | MSFT | Stock | 512.5 | 512.5 | 512.4 | 512.4 | 3456.0 |
| 2025-07-25 07:30:00 | MSFT | Stock | 512.68 | 512.77 | 512.68 | 512.72 | 3055.0 |
| 2025-07-25 08:00:00 | MSFT | Stock | 512.4 | 513.3 | 511.0 | 513.1 | 7889.0 |
| 2025-07-25 08:30:00 | MSFT | Stock | 513.024 | 513.38 | 513.0 | 513.15 | 5786.0 |
| 2025-07-25 09:00:00 | MSFT | Stock | 513.01 | 513.01 | 512.3 | 512.33 | 6871.0 |
| 2025-07-25 09:30:00 | MSFT | Stock | 512.27 | 512.8 | 510.3592 | 512.08 | 845833.0 |
| 2025-07-25 10:00:00 | MSFT | Stock | 512.2035 | 512.85 | 511.45 | 512.565 | 584160.0 |
| 2025-07-25 10:30:00 | MSFT | Stock | 512.57 | 513.14 | 512.17 | 512.6236 | 411644.0 |
| 2025-07-25 11:00:00 | MSFT | Stock | 512.6 | 514.13 | 512.1101 | 514.02 | 594115.0 |
| 2025-07-25 11:30:00 | MSFT | Stock | 514.005 | 514.15 | 513.2801 | 513.5832 | 446703.0 |
| 2025-07-25 12:00:00 | MSFT | Stock | 513.61 | 514.5 | 513.06 | 514.405 | 522662.0 |
| 2025-07-25 12:30:00 | MSFT | Stock | 514.42 | 514.59 | 513.75 | 513.93 | 373115.0 |
> showing 50 of 104,526 rows — these rows as CSV