PREVIEW / stock_30min / 2025-07-30
file: by_date/stock_30min/2025/2025-07-30.parquet size: 2.2 MB rows: 106,842 symbols: 358
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-30 04:00:00 | AAPL | Stock | 211.63 | 211.64 | 211.27 | 211.39 | 6362.0 |
| 2025-07-30 04:30:00 | AAPL | Stock | 211.36 | 211.61 | 211.33 | 211.58 | 1454.0 |
| 2025-07-30 05:00:00 | AAPL | Stock | 211.53 | 211.72 | 211.53 | 211.7 | 4806.0 |
| 2025-07-30 05:30:00 | AAPL | Stock | 211.69 | 211.69 | 211.55 | 211.6 | 627.0 |
| 2025-07-30 06:00:00 | AAPL | Stock | 211.62 | 211.98 | 211.62 | 211.79 | 6215.0 |
| 2025-07-30 06:30:00 | AAPL | Stock | 211.9 | 212.09 | 211.9 | 212.08 | 4834.0 |
| 2025-07-30 07:00:00 | AAPL | Stock | 212.09 | 212.09 | 211.91 | 212.02 | 6896.0 |
| 2025-07-30 07:30:00 | AAPL | Stock | 211.95 | 211.95 | 211.81 | 211.83 | 3235.0 |
| 2025-07-30 08:00:00 | AAPL | Stock | 212.01 | 212.15 | 209.8 | 210.6 | 276480.0 |
| 2025-07-30 08:30:00 | AAPL | Stock | 210.45 | 211.19 | 210.21 | 210.8 | 58980.0 |
| 2025-07-30 09:00:00 | AAPL | Stock | 210.82 | 211.99 | 210.407 | 211.99 | 129067.0 |
| 2025-07-30 09:30:00 | AAPL | Stock | 211.895 | 212.39 | 210.02 | 210.42 | 3446213.0 |
| 2025-07-30 10:00:00 | AAPL | Stock | 210.4325 | 210.88 | 210.1 | 210.61 | 1811571.0 |
| 2025-07-30 10:30:00 | AAPL | Stock | 210.62 | 210.72 | 210.34 | 210.43 | 1183056.0 |
| 2025-07-30 11:00:00 | AAPL | Stock | 210.44 | 210.58 | 209.62 | 209.725 | 1649096.0 |
| 2025-07-30 11:30:00 | AAPL | Stock | 209.72 | 210.19 | 209.57 | 210.1604 | 1190954.0 |
| 2025-07-30 12:00:00 | AAPL | Stock | 210.15 | 210.42 | 210.07 | 210.125 | 900173.0 |
| 2025-07-30 12:30:00 | AAPL | Stock | 210.11 | 210.17 | 209.51 | 209.58 | 1000761.0 |
| 2025-07-30 13:00:00 | AAPL | Stock | 209.585 | 209.82 | 209.32 | 209.755 | 1153907.0 |
| 2025-07-30 13:30:00 | AAPL | Stock | 209.755 | 210.1499 | 209.72 | 209.92 | 930276.0 |
| 2025-07-30 14:00:00 | AAPL | Stock | 209.92 | 210.035 | 209.48 | 209.855 | 1053100.0 |
| 2025-07-30 14:30:00 | AAPL | Stock | 209.855 | 210.14 | 208.3 | 208.35 | 2197832.0 |
| 2025-07-30 15:00:00 | AAPL | Stock | 208.325 | 208.71 | 207.72 | 208.52 | 2281102.0 |
| 2025-07-30 15:30:00 | AAPL | Stock | 208.51 | 209.11 | 208.1213 | 209.02 | 3185657.0 |
| 2025-07-30 16:00:00 | AAPL | Stock | 209.05 | 210.0 | 207.91 | 207.91 | 7444056.0 |
| 2025-07-30 16:30:00 | AAPL | Stock | 207.91 | 208.26 | 207.39 | 208.24 | 297073.0 |
| 2025-07-30 17:00:00 | AAPL | Stock | 208.1 | 208.4 | 208.01 | 208.26 | 63703.0 |
| 2025-07-30 17:30:00 | AAPL | Stock | 208.2498 | 208.3963 | 207.77 | 207.941 | 66501.0 |
| 2025-07-30 18:00:00 | AAPL | Stock | 207.81 | 208.235 | 207.66 | 208.08 | 65484.0 |
| 2025-07-30 18:30:00 | AAPL | Stock | 208.09 | 208.5 | 208.0499 | 208.45 | 60607.0 |
| 2025-07-30 19:00:00 | AAPL | Stock | 208.3464 | 208.76 | 208.3 | 208.69 | 54428.0 |
| 2025-07-30 19:30:00 | AAPL | Stock | 208.722 | 208.9801 | 208.4139 | 208.6573 | 63569.0 |
| 2025-07-30 04:00:00 | MSFT | Stock | 514.06 | 514.18 | 513.51 | 513.6 | 2067.0 |
| 2025-07-30 04:30:00 | MSFT | Stock | 513.21 | 513.21 | 513.21 | 513.21 | 200.0 |
| 2025-07-30 05:00:00 | MSFT | Stock | 513.98 | 514.29 | 513.98 | 514.02 | 2272.0 |
| 2025-07-30 05:30:00 | MSFT | Stock | 513.99 | 513.99 | 513.99 | 513.99 | 100.0 |
| 2025-07-30 06:00:00 | MSFT | Stock | 514.14 | 514.14 | 514.14 | 514.14 | 100.0 |
| 2025-07-30 06:30:00 | MSFT | Stock | 514.08 | 514.2 | 514.08 | 514.2 | 1378.0 |
| 2025-07-30 07:00:00 | MSFT | Stock | 514.29 | 514.36 | 513.93 | 514.03 | 2916.0 |
| 2025-07-30 07:30:00 | MSFT | Stock | 514.11 | 514.35 | 514.1 | 514.1 | 3308.0 |
| 2025-07-30 08:00:00 | MSFT | Stock | 514.2954 | 514.3737 | 513.62 | 514.1 | 13320.0 |
| 2025-07-30 08:30:00 | MSFT | Stock | 514.06 | 514.1794 | 513.55 | 513.55 | 9245.0 |
| 2025-07-30 09:00:00 | MSFT | Stock | 513.53 | 516.12 | 513.0 | 515.6 | 35050.0 |
| 2025-07-30 09:30:00 | MSFT | Stock | 515.41 | 515.95 | 510.67 | 512.475 | 1315379.0 |
| 2025-07-30 10:00:00 | MSFT | Stock | 512.45 | 513.58 | 511.81 | 513.32 | 592168.0 |
| 2025-07-30 10:30:00 | MSFT | Stock | 513.39 | 514.3199 | 513.29 | 513.3494 | 641762.0 |
| 2025-07-30 11:00:00 | MSFT | Stock | 513.32 | 513.55 | 512.43 | 513.05 | 491441.0 |
| 2025-07-30 11:30:00 | MSFT | Stock | 513.07 | 513.1 | 512.495 | 512.96 | 715046.0 |
| 2025-07-30 12:00:00 | MSFT | Stock | 512.96 | 513.59 | 512.61 | 513.24 | 551453.0 |
| 2025-07-30 12:30:00 | MSFT | Stock | 513.24 | 513.43 | 512.67 | 512.86 | 391454.0 |
> showing 50 of 106,842 rows — these rows as CSV