PREVIEW / stock_30min / 2025-10-13
file: by_date/stock_30min/2025/2025-10-13.parquet size: 2.3 MB rows: 114,064 symbols: 233
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-10-13 04:00:00 | AAPL | Stock | 248.66 | 250.32 | 247.97 | 249.14 | 34018.0 |
| 2025-10-13 04:30:00 | AAPL | Stock | 249.24 | 249.7 | 249.01 | 249.62 | 15748.0 |
| 2025-10-13 05:00:00 | AAPL | Stock | 249.68 | 249.7 | 249.49 | 249.58 | 32795.0 |
| 2025-10-13 05:30:00 | AAPL | Stock | 249.6 | 249.68 | 249.03 | 249.24 | 5724.0 |
| 2025-10-13 06:00:00 | AAPL | Stock | 249.17 | 249.69 | 249.11 | 249.49 | 20028.0 |
| 2025-10-13 06:30:00 | AAPL | Stock | 249.43 | 249.49 | 248.67 | 249.3 | 7680.0 |
| 2025-10-13 07:00:00 | AAPL | Stock | 249.15 | 249.76 | 248.11 | 248.7 | 68116.0 |
| 2025-10-13 07:30:00 | AAPL | Stock | 248.7 | 249.21 | 248.5 | 249.16 | 21044.0 |
| 2025-10-13 08:00:00 | AAPL | Stock | 249.0 | 250.65 | 248.05 | 249.07 | 134550.0 |
| 2025-10-13 08:30:00 | AAPL | Stock | 249.14 | 249.68 | 248.87 | 248.95 | 73660.0 |
| 2025-10-13 09:00:00 | AAPL | Stock | 248.9 | 249.5 | 248.39 | 249.47 | 96959.0 |
| 2025-10-13 09:30:00 | AAPL | Stock | 249.31 | 249.49 | 245.56 | 246.62 | 4419312.0 |
| 2025-10-13 10:00:00 | AAPL | Stock | 246.635 | 247.63 | 246.1 | 246.376 | 2046160.0 |
| 2025-10-13 10:30:00 | AAPL | Stock | 246.37 | 247.59 | 246.23 | 246.94 | 1339195.0 |
| 2025-10-13 11:00:00 | AAPL | Stock | 246.94 | 248.6599 | 246.66 | 248.5903 | 1540125.0 |
| 2025-10-13 11:30:00 | AAPL | Stock | 248.62 | 248.99 | 248.36 | 248.78 | 1118632.0 |
| 2025-10-13 12:00:00 | AAPL | Stock | 248.79 | 249.63 | 248.7401 | 249.18 | 1064948.0 |
| 2025-10-13 12:30:00 | AAPL | Stock | 249.17 | 249.6 | 248.55 | 249.55 | 976437.0 |
| 2025-10-13 13:00:00 | AAPL | Stock | 249.56 | 249.69 | 248.89 | 249.1042 | 603675.0 |
| 2025-10-13 13:30:00 | AAPL | Stock | 249.09 | 249.179 | 248.688 | 249.05 | 600427.0 |
| 2025-10-13 14:00:00 | AAPL | Stock | 249.04 | 249.32 | 248.81 | 249.1462 | 787559.0 |
| 2025-10-13 14:30:00 | AAPL | Stock | 249.14 | 249.25 | 248.32 | 248.46 | 745559.0 |
| 2025-10-13 15:00:00 | AAPL | Stock | 248.46 | 248.715 | 248.13 | 248.32 | 836475.0 |
| 2025-10-13 15:30:00 | AAPL | Stock | 248.32 | 248.59 | 247.33 | 247.59 | 2676625.0 |
| 2025-10-13 16:00:00 | AAPL | Stock | 247.58 | 247.7017 | 247.21 | 247.5 | 5946069.0 |
| 2025-10-13 16:30:00 | AAPL | Stock | 247.46 | 247.66 | 247.26 | 247.26 | 45104.0 |
| 2025-10-13 17:00:00 | AAPL | Stock | 247.25 | 247.66 | 247.25 | 247.37 | 7834.0 |
| 2025-10-13 17:30:00 | AAPL | Stock | 247.34 | 247.4 | 247.2505 | 247.4 | 9306.0 |
| 2025-10-13 18:00:00 | AAPL | Stock | 247.5 | 247.5 | 247.27 | 247.27 | 10232.0 |
| 2025-10-13 18:30:00 | AAPL | Stock | 247.33 | 247.4 | 247.3 | 247.35 | 4750.0 |
| 2025-10-13 19:00:00 | AAPL | Stock | 247.32 | 247.3873 | 247.21 | 247.2992 | 5461.0 |
| 2025-10-13 19:30:00 | AAPL | Stock | 247.3 | 247.3706 | 247.2 | 247.2609 | 5359.0 |
| 2025-10-13 04:00:00 | MSFT | Stock | 518.4 | 519.01 | 515.22 | 518.4 | 12073.0 |
| 2025-10-13 04:30:00 | MSFT | Stock | 518.48 | 519.0 | 518.16 | 518.57 | 5712.0 |
| 2025-10-13 05:00:00 | MSFT | Stock | 518.71 | 519.06 | 518.69 | 518.75 | 5968.0 |
| 2025-10-13 05:30:00 | MSFT | Stock | 518.71 | 518.71 | 518.4 | 518.4 | 1624.0 |
| 2025-10-13 06:00:00 | MSFT | Stock | 518.4 | 518.76 | 518.4 | 518.61 | 1832.0 |
| 2025-10-13 06:30:00 | MSFT | Stock | 518.9 | 518.95 | 518.4 | 518.4 | 2582.0 |
| 2025-10-13 07:00:00 | MSFT | Stock | 518.4 | 518.41 | 515.98 | 516.75 | 11963.0 |
| 2025-10-13 07:30:00 | MSFT | Stock | 516.85 | 517.72 | 516.78 | 517.6 | 5261.0 |
| 2025-10-13 08:00:00 | MSFT | Stock | 518.4 | 519.3 | 515.75 | 517.6604 | 37602.0 |
| 2025-10-13 08:30:00 | MSFT | Stock | 517.6 | 518.05 | 516.7 | 517.2 | 29620.0 |
| 2025-10-13 09:00:00 | MSFT | Stock | 517.31 | 517.34 | 515.45 | 516.5 | 14578.0 |
| 2025-10-13 09:30:00 | MSFT | Stock | 516.56 | 516.56 | 512.7 | 514.93 | 1200924.0 |
| 2025-10-13 10:00:00 | MSFT | Stock | 514.86 | 515.78 | 514.0 | 515.07 | 689732.0 |
| 2025-10-13 10:30:00 | MSFT | Stock | 515.0 | 515.5 | 512.61 | 513.48 | 602939.0 |
| 2025-10-13 11:00:00 | MSFT | Stock | 513.46 | 513.62 | 511.68 | 512.84 | 552535.0 |
| 2025-10-13 11:30:00 | MSFT | Stock | 513.0 | 514.0 | 512.3 | 513.075 | 321366.0 |
| 2025-10-13 12:00:00 | MSFT | Stock | 513.035 | 514.36 | 512.7 | 513.7901 | 286754.0 |
| 2025-10-13 12:30:00 | MSFT | Stock | 513.87 | 514.484 | 512.9521 | 514.245 | 328248.0 |
> showing 50 of 114,064 rows — these rows as CSV