PREVIEW / stock_30min / 2025-07-17
file: by_date/stock_30min/2025/2025-07-17.parquet size: 2.3 MB rows: 108,586 symbols: 371
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-17 04:00:00 | AAPL | Stock | 210.5 | 210.5 | 210.15 | 210.38 | 9715.0 |
| 2025-07-17 04:30:00 | AAPL | Stock | 210.33 | 210.64 | 210.28 | 210.54 | 15020.0 |
| 2025-07-17 05:00:00 | AAPL | Stock | 210.63 | 210.86 | 210.62 | 210.8 | 5335.0 |
| 2025-07-17 05:30:00 | AAPL | Stock | 210.8 | 210.8 | 210.67 | 210.68 | 1374.0 |
| 2025-07-17 06:00:00 | AAPL | Stock | 210.69 | 210.8 | 210.65 | 210.73 | 5201.0 |
| 2025-07-17 06:30:00 | AAPL | Stock | 210.67 | 210.71 | 210.0 | 210.4 | 7679.0 |
| 2025-07-17 07:00:00 | AAPL | Stock | 210.33 | 210.5 | 210.25 | 210.5 | 4893.0 |
| 2025-07-17 07:30:00 | AAPL | Stock | 210.42 | 210.5 | 210.35 | 210.49 | 6578.0 |
| 2025-07-17 08:00:00 | AAPL | Stock | 210.33 | 210.92 | 209.635 | 210.62 | 82957.0 |
| 2025-07-17 08:30:00 | AAPL | Stock | 210.7 | 211.09 | 210.16 | 211.0 | 67177.0 |
| 2025-07-17 09:00:00 | AAPL | Stock | 211.05 | 211.3 | 210.18 | 210.66 | 185147.0 |
| 2025-07-17 09:30:00 | AAPL | Stock | 210.72 | 211.01 | 209.975 | 210.28 | 3817367.0 |
| 2025-07-17 10:00:00 | AAPL | Stock | 210.27 | 210.6 | 209.59 | 209.95 | 2373904.0 |
| 2025-07-17 10:30:00 | AAPL | Stock | 209.94 | 210.2682 | 209.77 | 210.175 | 1551545.0 |
| 2025-07-17 11:00:00 | AAPL | Stock | 210.175 | 210.83 | 210.0817 | 210.44 | 1854554.0 |
| 2025-07-17 11:30:00 | AAPL | Stock | 210.45 | 210.69 | 210.105 | 210.6501 | 1735971.0 |
| 2025-07-17 12:00:00 | AAPL | Stock | 210.66 | 211.45 | 210.535 | 211.39 | 2738965.0 |
| 2025-07-17 12:30:00 | AAPL | Stock | 211.38 | 211.51 | 210.945 | 211.02 | 1694613.0 |
| 2025-07-17 13:00:00 | AAPL | Stock | 211.01 | 211.16 | 210.79 | 210.95 | 1148013.0 |
| 2025-07-17 13:30:00 | AAPL | Stock | 210.945 | 211.5 | 210.9001 | 211.4885 | 1385536.0 |
| 2025-07-17 14:00:00 | AAPL | Stock | 211.485 | 211.8 | 211.09 | 211.28 | 2178724.0 |
| 2025-07-17 14:30:00 | AAPL | Stock | 211.28 | 211.28 | 210.87 | 210.935 | 1391897.0 |
| 2025-07-17 15:00:00 | AAPL | Stock | 210.94 | 211.065 | 210.78 | 210.995 | 1659138.0 |
| 2025-07-17 15:30:00 | AAPL | Stock | 210.9999 | 211.05 | 209.74 | 210.061 | 5371044.0 |
| 2025-07-17 16:00:00 | AAPL | Stock | 210.02 | 210.4519 | 210.02 | 210.45 | 5934091.0 |
| 2025-07-17 16:30:00 | AAPL | Stock | 210.44 | 210.46 | 210.02 | 210.2165 | 22222.0 |
| 2025-07-17 17:00:00 | AAPL | Stock | 210.3 | 210.4 | 210.02 | 210.1354 | 22294.0 |
| 2025-07-17 17:30:00 | AAPL | Stock | 210.17 | 210.25 | 210.1 | 210.2 | 8530.0 |
| 2025-07-17 18:00:00 | AAPL | Stock | 210.13 | 210.25 | 210.1241 | 210.2 | 11253.0 |
| 2025-07-17 18:30:00 | AAPL | Stock | 210.2356 | 210.2356 | 210.12 | 210.12 | 6050.0 |
| 2025-07-17 19:00:00 | AAPL | Stock | 210.1147 | 210.29 | 210.1147 | 210.25 | 13608.0 |
| 2025-07-17 19:30:00 | AAPL | Stock | 210.29 | 210.3 | 210.15 | 210.2395 | 15520.0 |
| 2025-07-17 04:00:00 | MSFT | Stock | 506.18 | 506.39 | 505.62 | 505.64 | 726.0 |
| 2025-07-17 04:30:00 | MSFT | Stock | 505.5 | 505.57 | 505.5 | 505.51 | 791.0 |
| 2025-07-17 05:00:00 | MSFT | Stock | 505.35 | 505.4 | 505.35 | 505.4 | 243.0 |
| 2025-07-17 05:30:00 | MSFT | Stock | 505.51 | 505.51 | 505.45 | 505.45 | 907.0 |
| 2025-07-17 06:30:00 | MSFT | Stock | 505.12 | 505.12 | 504.97 | 504.97 | 400.0 |
| 2025-07-17 07:00:00 | MSFT | Stock | 504.8 | 505.39 | 504.8 | 505.39 | 1022.0 |
| 2025-07-17 07:30:00 | MSFT | Stock | 505.33 | 505.33 | 505.33 | 505.33 | 126.0 |
| 2025-07-17 08:00:00 | MSFT | Stock | 505.39 | 506.9 | 504.3 | 505.2806 | 13841.0 |
| 2025-07-17 08:30:00 | MSFT | Stock | 505.55 | 506.7847 | 505.3653 | 506.33 | 9115.0 |
| 2025-07-17 09:00:00 | MSFT | Stock | 506.8 | 507.0 | 504.9 | 506.0 | 11394.0 |
| 2025-07-17 09:30:00 | MSFT | Stock | 505.68 | 510.27 | 505.62 | 509.76 | 1321192.0 |
| 2025-07-17 10:00:00 | MSFT | Stock | 509.8 | 510.95 | 508.943 | 510.075 | 838016.0 |
| 2025-07-17 10:30:00 | MSFT | Stock | 510.03 | 511.48 | 509.92 | 511.22 | 532247.0 |
| 2025-07-17 11:00:00 | MSFT | Stock | 511.26 | 512.33 | 511.18 | 511.89 | 614905.0 |
| 2025-07-17 11:30:00 | MSFT | Stock | 511.895 | 513.0 | 511.81 | 512.95 | 549415.0 |
| 2025-07-17 12:00:00 | MSFT | Stock | 512.95 | 513.37 | 512.62 | 512.845 | 403879.0 |
| 2025-07-17 12:30:00 | MSFT | Stock | 512.85 | 513.3 | 512.6303 | 512.785 | 262338.0 |
| 2025-07-17 13:00:00 | MSFT | Stock | 512.785 | 512.99 | 512.35 | 512.8175 | 398608.0 |
> showing 50 of 108,586 rows — these rows as CSV