PREVIEW / stock_30min / 2025-07-24
file: by_date/stock_30min/2025/2025-07-24.parquet size: 2.2 MB rows: 107,401 symbols: 364
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-24 04:00:00 | AAPL | Stock | 213.7 | 214.14 | 213.1 | 213.79 | 12401.0 |
| 2025-07-24 04:30:00 | AAPL | Stock | 213.86 | 213.9 | 213.65 | 213.9 | 4815.0 |
| 2025-07-24 05:00:00 | AAPL | Stock | 213.89 | 213.94 | 213.86 | 213.9 | 4941.0 |
| 2025-07-24 05:30:00 | AAPL | Stock | 213.95 | 214.0 | 213.8 | 213.9 | 13371.0 |
| 2025-07-24 06:00:00 | AAPL | Stock | 213.85 | 213.9 | 213.65 | 213.7 | 15208.0 |
| 2025-07-24 06:30:00 | AAPL | Stock | 213.73 | 213.73 | 213.4 | 213.5 | 17508.0 |
| 2025-07-24 07:00:00 | AAPL | Stock | 213.59 | 213.93 | 213.59 | 213.9 | 9155.0 |
| 2025-07-24 07:30:00 | AAPL | Stock | 213.88 | 213.88 | 213.67 | 213.67 | 6796.0 |
| 2025-07-24 08:00:00 | AAPL | Stock | 213.6 | 214.08 | 213.34 | 214.0301 | 124979.0 |
| 2025-07-24 08:30:00 | AAPL | Stock | 214.08 | 214.08 | 213.48 | 213.7799 | 42538.0 |
| 2025-07-24 09:00:00 | AAPL | Stock | 213.74 | 214.0 | 213.4 | 213.9 | 68373.0 |
| 2025-07-24 09:30:00 | AAPL | Stock | 213.9 | 215.69 | 213.53 | 213.83 | 5271027.0 |
| 2025-07-24 10:00:00 | AAPL | Stock | 213.84 | 214.83 | 213.565 | 214.46 | 2535159.0 |
| 2025-07-24 10:30:00 | AAPL | Stock | 214.45 | 214.6434 | 214.0596 | 214.3223 | 2083799.0 |
| 2025-07-24 11:00:00 | AAPL | Stock | 214.32 | 215.35 | 214.31 | 215.26 | 2774950.0 |
| 2025-07-24 11:30:00 | AAPL | Stock | 215.2616 | 215.5 | 214.47 | 214.8953 | 2463552.0 |
| 2025-07-24 12:00:00 | AAPL | Stock | 214.89 | 214.89 | 214.2 | 214.34 | 1394224.0 |
| 2025-07-24 12:30:00 | AAPL | Stock | 214.34 | 214.7999 | 214.28 | 214.675 | 1166606.0 |
| 2025-07-24 13:00:00 | AAPL | Stock | 214.67 | 215.2 | 214.6 | 214.79 | 1160535.0 |
| 2025-07-24 13:30:00 | AAPL | Stock | 214.79 | 214.92 | 214.56 | 214.68 | 748426.0 |
| 2025-07-24 14:00:00 | AAPL | Stock | 214.68 | 215.21 | 214.68 | 214.735 | 1186126.0 |
| 2025-07-24 14:30:00 | AAPL | Stock | 214.7389 | 214.86 | 214.33 | 214.53 | 1122385.0 |
| 2025-07-24 15:00:00 | AAPL | Stock | 214.52 | 215.02 | 214.43 | 214.81 | 1280026.0 |
| 2025-07-24 15:30:00 | AAPL | Stock | 214.811 | 214.94 | 213.72 | 213.76 | 4597969.0 |
| 2025-07-24 16:00:00 | AAPL | Stock | 213.76 | 214.15 | 213.71 | 214.02 | 6152934.0 |
| 2025-07-24 16:30:00 | AAPL | Stock | 214.0 | 214.07 | 213.95 | 213.95 | 20147.0 |
| 2025-07-24 17:00:00 | AAPL | Stock | 214.0 | 214.08 | 213.89 | 214.08 | 22830.0 |
| 2025-07-24 17:30:00 | AAPL | Stock | 213.99 | 214.05 | 213.9 | 214.01 | 12605.0 |
| 2025-07-24 18:00:00 | AAPL | Stock | 214.01 | 214.11 | 213.99 | 214.1 | 12247.0 |
| 2025-07-24 18:30:00 | AAPL | Stock | 214.1 | 214.22 | 214.01 | 214.01 | 9802.0 |
| 2025-07-24 19:00:00 | AAPL | Stock | 214.0152 | 214.2 | 214.01 | 214.0303 | 5107.0 |
| 2025-07-24 19:30:00 | AAPL | Stock | 214.07 | 214.09 | 214.05 | 214.05 | 4259.0 |
| 2025-07-24 04:00:00 | MSFT | Stock | 506.42 | 506.49 | 506.39 | 506.49 | 366.0 |
| 2025-07-24 04:30:00 | MSFT | Stock | 506.49 | 506.5 | 506.4 | 506.4 | 444.0 |
| 2025-07-24 05:00:00 | MSFT | Stock | 506.4 | 506.4 | 506.15 | 506.15 | 780.0 |
| 2025-07-24 05:30:00 | MSFT | Stock | 506.17 | 506.17 | 506.17 | 506.17 | 142.0 |
| 2025-07-24 06:00:00 | MSFT | Stock | 505.82 | 505.82 | 505.79 | 505.79 | 500.0 |
| 2025-07-24 06:30:00 | MSFT | Stock | 505.07 | 505.31 | 505.07 | 505.31 | 400.0 |
| 2025-07-24 07:00:00 | MSFT | Stock | 505.48 | 505.64 | 505.05 | 505.64 | 523.0 |
| 2025-07-24 07:30:00 | MSFT | Stock | 505.95 | 506.05 | 505.74 | 506.05 | 727.0 |
| 2025-07-24 08:00:00 | MSFT | Stock | 506.0 | 506.44 | 505.0 | 505.9399 | 8872.0 |
| 2025-07-24 08:30:00 | MSFT | Stock | 505.502 | 505.77 | 505.0 | 505.77 | 7190.0 |
| 2025-07-24 09:00:00 | MSFT | Stock | 505.69 | 509.5 | 505.3006 | 509.03 | 37629.0 |
| 2025-07-24 09:30:00 | MSFT | Stock | 508.77 | 510.53 | 507.3 | 509.31 | 1378795.0 |
| 2025-07-24 10:00:00 | MSFT | Stock | 509.32 | 509.48 | 507.675 | 508.85 | 531643.0 |
| 2025-07-24 10:30:00 | MSFT | Stock | 508.87 | 510.41 | 508.35 | 510.1463 | 468313.0 |
| 2025-07-24 11:00:00 | MSFT | Stock | 510.15 | 510.83 | 509.833 | 510.55 | 487361.0 |
| 2025-07-24 11:30:00 | MSFT | Stock | 510.61 | 512.41 | 510.5601 | 511.87 | 579769.0 |
| 2025-07-24 12:00:00 | MSFT | Stock | 511.87 | 511.98 | 510.96 | 511.68 | 301883.0 |
| 2025-07-24 12:30:00 | MSFT | Stock | 511.7216 | 512.69 | 511.48 | 512.185 | 414213.0 |
> showing 50 of 107,401 rows — these rows as CSV