PREVIEW / stock_30min / 2025-07-15
file: by_date/stock_30min/2025/2025-07-15.parquet size: 2.2 MB rows: 103,519 symbols: 372
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-15 04:00:00 | AAPL | Stock | 208.43 | 209.88 | 208.43 | 209.53 | 34240.0 |
| 2025-07-15 04:30:00 | AAPL | Stock | 209.5 | 209.51 | 209.29 | 209.4 | 10286.0 |
| 2025-07-15 05:00:00 | AAPL | Stock | 209.37 | 209.74 | 209.32 | 209.57 | 13149.0 |
| 2025-07-15 05:30:00 | AAPL | Stock | 209.57 | 209.65 | 209.46 | 209.59 | 12390.0 |
| 2025-07-15 06:00:00 | AAPL | Stock | 209.55 | 209.88 | 209.48 | 209.75 | 11486.0 |
| 2025-07-15 06:30:00 | AAPL | Stock | 209.66 | 209.68 | 209.08 | 209.13 | 8658.0 |
| 2025-07-15 07:00:00 | AAPL | Stock | 209.17 | 209.36 | 209.03 | 209.31 | 14348.0 |
| 2025-07-15 07:30:00 | AAPL | Stock | 209.27 | 209.32 | 208.98 | 209.1 | 18791.0 |
| 2025-07-15 08:00:00 | AAPL | Stock | 209.28 | 209.93 | 208.099 | 209.02 | 155384.0 |
| 2025-07-15 08:30:00 | AAPL | Stock | 209.1 | 209.5 | 209.0 | 209.25 | 59564.0 |
| 2025-07-15 09:00:00 | AAPL | Stock | 209.3 | 209.5 | 209.1 | 209.32 | 101128.0 |
| 2025-07-15 09:30:00 | AAPL | Stock | 209.22 | 211.13 | 208.92 | 209.645 | 5208701.0 |
| 2025-07-15 10:00:00 | AAPL | Stock | 209.65 | 210.3 | 209.34 | 210.155 | 2023395.0 |
| 2025-07-15 10:30:00 | AAPL | Stock | 210.14 | 210.18 | 209.1977 | 209.35 | 1676436.0 |
| 2025-07-15 11:00:00 | AAPL | Stock | 209.35 | 211.43 | 209.26 | 211.42 | 2370886.0 |
| 2025-07-15 11:30:00 | AAPL | Stock | 211.43 | 211.89 | 210.73 | 210.79 | 2345014.0 |
| 2025-07-15 12:00:00 | AAPL | Stock | 210.79 | 210.91 | 210.36 | 210.685 | 1217302.0 |
| 2025-07-15 12:30:00 | AAPL | Stock | 210.695 | 210.985 | 210.38 | 210.58 | 819641.0 |
| 2025-07-15 13:00:00 | AAPL | Stock | 210.56 | 211.07 | 210.44 | 210.6727 | 738164.0 |
| 2025-07-15 13:30:00 | AAPL | Stock | 210.685 | 211.35 | 210.66 | 211.28 | 861792.0 |
| 2025-07-15 14:00:00 | AAPL | Stock | 211.2701 | 211.67 | 211.205 | 211.375 | 1052318.0 |
| 2025-07-15 14:30:00 | AAPL | Stock | 211.3889 | 211.48 | 210.43 | 210.51 | 1207517.0 |
| 2025-07-15 15:00:00 | AAPL | Stock | 210.52 | 210.6863 | 209.96 | 210.18 | 1372190.0 |
| 2025-07-15 15:30:00 | AAPL | Stock | 210.19 | 210.29 | 208.98 | 209.01 | 2974870.0 |
| 2025-07-15 16:00:00 | AAPL | Stock | 209.11 | 209.13 | 208.9 | 208.9202 | 4691021.0 |
| 2025-07-15 16:30:00 | AAPL | Stock | 208.94 | 209.11 | 208.86 | 208.89 | 32852.0 |
| 2025-07-15 17:00:00 | AAPL | Stock | 208.91 | 209.11 | 208.86 | 208.8701 | 15843.0 |
| 2025-07-15 17:30:00 | AAPL | Stock | 208.9 | 209.0 | 208.892 | 208.92 | 11823.0 |
| 2025-07-15 18:00:00 | AAPL | Stock | 208.95 | 209.02 | 208.87 | 209.02 | 9137.0 |
| 2025-07-15 18:30:00 | AAPL | Stock | 209.0 | 209.02 | 208.75 | 208.85 | 20999.0 |
| 2025-07-15 19:00:00 | AAPL | Stock | 208.87 | 208.97 | 208.77 | 208.8 | 8890.0 |
| 2025-07-15 19:30:00 | AAPL | Stock | 208.83 | 208.99 | 208.8 | 208.92 | 13434.0 |
| 2025-07-15 04:00:00 | MSFT | Stock | 503.04 | 503.04 | 502.13 | 502.61 | 1086.0 |
| 2025-07-15 04:30:00 | MSFT | Stock | 502.52 | 502.6 | 502.16 | 502.16 | 1157.0 |
| 2025-07-15 05:00:00 | MSFT | Stock | 502.3 | 502.4 | 501.98 | 501.98 | 1179.0 |
| 2025-07-15 05:30:00 | MSFT | Stock | 502.0 | 502.0 | 501.56 | 501.6 | 493.0 |
| 2025-07-15 06:00:00 | MSFT | Stock | 501.6 | 502.04 | 501.6 | 502.04 | 931.0 |
| 2025-07-15 06:30:00 | MSFT | Stock | 501.9 | 502.28 | 501.9 | 502.28 | 1545.0 |
| 2025-07-15 07:00:00 | MSFT | Stock | 502.25 | 502.58 | 502.1 | 502.5 | 2549.0 |
| 2025-07-15 07:30:00 | MSFT | Stock | 502.15 | 502.15 | 501.7 | 501.7 | 922.0 |
| 2025-07-15 08:00:00 | MSFT | Stock | 502.34 | 504.0 | 501.4 | 501.97 | 21748.0 |
| 2025-07-15 08:30:00 | MSFT | Stock | 502.25 | 503.0 | 501.65 | 502.7995 | 14587.0 |
| 2025-07-15 09:00:00 | MSFT | Stock | 502.62 | 503.2 | 502.0327 | 503.02 | 9563.0 |
| 2025-07-15 09:30:00 | MSFT | Stock | 503.02 | 505.65 | 502.78 | 505.275 | 1170524.0 |
| 2025-07-15 10:00:00 | MSFT | Stock | 505.295 | 506.29 | 504.52 | 505.65 | 556176.0 |
| 2025-07-15 10:30:00 | MSFT | Stock | 505.675 | 505.675 | 504.3701 | 504.825 | 404809.0 |
| 2025-07-15 11:00:00 | MSFT | Stock | 504.83 | 507.28 | 504.67 | 507.28 | 587299.0 |
| 2025-07-15 11:30:00 | MSFT | Stock | 507.2504 | 507.39 | 506.5 | 507.075 | 330920.0 |
| 2025-07-15 12:00:00 | MSFT | Stock | 507.09 | 507.3775 | 506.22 | 507.31 | 268968.0 |
| 2025-07-15 12:30:00 | MSFT | Stock | 507.3432 | 507.7399 | 506.295 | 506.445 | 338365.0 |
> showing 50 of 103,519 rows — these rows as CSV