PREVIEW / stock_30min / 2025-11-06
file: by_date/stock_30min/2025/2025-11-06.parquet size: 2.3 MB rows: 109,004 symbols: 216
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-11-06 04:00:00 | AAPL | Stock | 269.05 | 269.7 | 269.04 | 269.7 | 5775.0 |
| 2025-11-06 04:30:00 | AAPL | Stock | 269.79 | 269.79 | 269.41 | 269.44 | 2574.0 |
| 2025-11-06 05:00:00 | AAPL | Stock | 269.34 | 269.37 | 269.23 | 269.23 | 471.0 |
| 2025-11-06 05:30:00 | AAPL | Stock | 269.46 | 269.76 | 269.25 | 269.27 | 7565.0 |
| 2025-11-06 06:00:00 | AAPL | Stock | 269.24 | 269.55 | 269.22 | 269.22 | 2773.0 |
| 2025-11-06 06:30:00 | AAPL | Stock | 269.2 | 269.7 | 269.2 | 269.33 | 2976.0 |
| 2025-11-06 07:00:00 | AAPL | Stock | 269.25 | 269.52 | 269.11 | 269.11 | 3576.0 |
| 2025-11-06 07:30:00 | AAPL | Stock | 269.17 | 269.44 | 269.16 | 269.44 | 3129.0 |
| 2025-11-06 08:00:00 | AAPL | Stock | 269.26 | 270.45 | 268.5 | 270.3 | 52863.0 |
| 2025-11-06 08:30:00 | AAPL | Stock | 270.0082 | 270.14 | 269.52 | 269.7 | 20949.0 |
| 2025-11-06 09:00:00 | AAPL | Stock | 269.701 | 269.99 | 267.92 | 268.0 | 199124.0 |
| 2025-11-06 09:30:00 | AAPL | Stock | 267.89 | 270.01 | 267.89 | 269.941 | 3243876.0 |
| 2025-11-06 10:00:00 | AAPL | Stock | 269.94 | 272.82 | 269.0914 | 272.82 | 3315010.0 |
| 2025-11-06 10:30:00 | AAPL | Stock | 272.828 | 273.4 | 271.5501 | 272.28 | 3616651.0 |
| 2025-11-06 11:00:00 | AAPL | Stock | 272.285 | 272.6593 | 271.63 | 272.1815 | 2028402.0 |
| 2025-11-06 11:30:00 | AAPL | Stock | 272.18 | 272.22 | 270.54 | 270.58 | 1637656.0 |
| 2025-11-06 12:00:00 | AAPL | Stock | 270.6 | 271.45 | 270.39 | 271.425 | 1246428.0 |
| 2025-11-06 12:30:00 | AAPL | Stock | 271.42 | 272.565 | 271.3304 | 272.275 | 1518096.0 |
| 2025-11-06 13:00:00 | AAPL | Stock | 272.275 | 272.46 | 270.92 | 271.35 | 1394291.0 |
| 2025-11-06 13:30:00 | AAPL | Stock | 271.37 | 271.78 | 271.01 | 271.3954 | 792676.0 |
| 2025-11-06 14:00:00 | AAPL | Stock | 271.41 | 272.16 | 271.34 | 271.9901 | 867034.0 |
| 2025-11-06 14:30:00 | AAPL | Stock | 272.005 | 272.2 | 270.735 | 271.2356 | 1229523.0 |
| 2025-11-06 15:00:00 | AAPL | Stock | 271.25 | 271.67 | 271.05 | 271.21 | 835346.0 |
| 2025-11-06 15:30:00 | AAPL | Stock | 271.21 | 271.5202 | 269.56 | 269.66 | 3742664.0 |
| 2025-11-06 16:00:00 | AAPL | Stock | 269.8 | 270.37 | 269.631 | 270.1177 | 9313524.0 |
| 2025-11-06 16:30:00 | AAPL | Stock | 270.2 | 270.37 | 269.77 | 270.21 | 10160.0 |
| 2025-11-06 17:00:00 | AAPL | Stock | 270.2 | 270.3389 | 269.846 | 270.14 | 13171.0 |
| 2025-11-06 17:30:00 | AAPL | Stock | 270.1 | 270.1577 | 269.8515 | 269.87 | 3759.0 |
| 2025-11-06 18:00:00 | AAPL | Stock | 269.96 | 270.1 | 269.6321 | 269.75 | 13207.0 |
| 2025-11-06 18:30:00 | AAPL | Stock | 269.85 | 270.27 | 269.78 | 270.15 | 3399.0 |
| 2025-11-06 19:00:00 | AAPL | Stock | 270.01 | 270.5 | 269.8 | 270.07 | 7214.0 |
| 2025-11-06 19:30:00 | AAPL | Stock | 270.07 | 270.35 | 270.0 | 270.15 | 12105.0 |
| 2025-11-06 04:00:00 | MSFT | Stock | 505.3 | 506.25 | 505.21 | 506.1 | 6505.0 |
| 2025-11-06 04:30:00 | MSFT | Stock | 506.04 | 506.3 | 505.81 | 505.9 | 2579.0 |
| 2025-11-06 05:00:00 | MSFT | Stock | 506.0 | 506.45 | 506.0 | 506.45 | 1242.0 |
| 2025-11-06 05:30:00 | MSFT | Stock | 506.6 | 506.6 | 505.28 | 505.81 | 2800.0 |
| 2025-11-06 06:00:00 | MSFT | Stock | 505.77 | 506.31 | 505.67 | 506.1 | 4545.0 |
| 2025-11-06 06:30:00 | MSFT | Stock | 506.22 | 506.54 | 505.9 | 506.2 | 3148.0 |
| 2025-11-06 07:00:00 | MSFT | Stock | 506.11 | 506.44 | 506.11 | 506.31 | 6730.0 |
| 2025-11-06 07:30:00 | MSFT | Stock | 506.37 | 506.45 | 506.1 | 506.45 | 1839.0 |
| 2025-11-06 08:00:00 | MSFT | Stock | 506.29 | 507.6 | 505.0 | 506.86 | 52660.0 |
| 2025-11-06 08:30:00 | MSFT | Stock | 506.86 | 507.01 | 506.5 | 506.6 | 22924.0 |
| 2025-11-06 09:00:00 | MSFT | Stock | 506.5 | 506.89 | 505.66 | 505.8 | 35476.0 |
| 2025-11-06 09:30:00 | MSFT | Stock | 505.7 | 505.7 | 498.5 | 499.2005 | 2988959.0 |
| 2025-11-06 10:00:00 | MSFT | Stock | 499.15 | 501.945 | 498.66 | 501.265 | 1526368.0 |
| 2025-11-06 10:30:00 | MSFT | Stock | 501.36 | 501.44 | 495.81 | 496.23 | 1735586.0 |
| 2025-11-06 11:00:00 | MSFT | Stock | 496.295 | 498.35 | 496.05 | 498.1951 | 971148.0 |
| 2025-11-06 11:30:00 | MSFT | Stock | 498.2 | 498.55 | 496.85 | 497.93 | 743854.0 |
| 2025-11-06 12:00:00 | MSFT | Stock | 497.94 | 498.53 | 496.92 | 497.67 | 642507.0 |
| 2025-11-06 12:30:00 | MSFT | Stock | 497.6964 | 498.35 | 497.26 | 498.02 | 577476.0 |
> showing 50 of 109,004 rows — these rows as CSV