PREVIEW / stock_30min / 2025-07-16
file: by_date/stock_30min/2025/2025-07-16.parquet size: 2.3 MB rows: 107,565 symbols: 377
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-16 04:00:00 | AAPL | Stock | 209.15 | 209.53 | 209.15 | 209.45 | 11239.0 |
| 2025-07-16 04:30:00 | AAPL | Stock | 209.56 | 209.67 | 209.47 | 209.49 | 4814.0 |
| 2025-07-16 05:00:00 | AAPL | Stock | 209.41 | 209.52 | 209.34 | 209.52 | 2934.0 |
| 2025-07-16 05:30:00 | AAPL | Stock | 209.5 | 209.5 | 209.38 | 209.45 | 1903.0 |
| 2025-07-16 06:00:00 | AAPL | Stock | 209.56 | 209.72 | 209.55 | 209.72 | 1417.0 |
| 2025-07-16 06:30:00 | AAPL | Stock | 209.71 | 209.87 | 209.43 | 209.78 | 26518.0 |
| 2025-07-16 07:00:00 | AAPL | Stock | 209.64 | 209.71 | 209.5 | 209.71 | 11097.0 |
| 2025-07-16 07:30:00 | AAPL | Stock | 209.57 | 209.65 | 209.56 | 209.58 | 2760.0 |
| 2025-07-16 08:00:00 | AAPL | Stock | 209.55 | 209.74 | 209.08 | 209.72 | 73232.0 |
| 2025-07-16 08:30:00 | AAPL | Stock | 209.81 | 210.18 | 209.76 | 210.0 | 69756.0 |
| 2025-07-16 09:00:00 | AAPL | Stock | 210.05 | 210.38 | 209.8 | 210.27 | 83815.0 |
| 2025-07-16 09:30:00 | AAPL | Stock | 210.295 | 211.21 | 209.9105 | 211.07 | 4132574.0 |
| 2025-07-16 10:00:00 | AAPL | Stock | 211.05 | 212.4 | 210.6 | 212.085 | 3598351.0 |
| 2025-07-16 10:30:00 | AAPL | Stock | 212.1 | 212.1845 | 210.4893 | 210.7825 | 2611495.0 |
| 2025-07-16 11:00:00 | AAPL | Stock | 210.8 | 210.99 | 209.29 | 210.12 | 2645390.0 |
| 2025-07-16 11:30:00 | AAPL | Stock | 210.1488 | 210.5 | 208.64 | 209.8307 | 2951027.0 |
| 2025-07-16 12:00:00 | AAPL | Stock | 209.85 | 210.0533 | 209.49 | 209.59 | 1171411.0 |
| 2025-07-16 12:30:00 | AAPL | Stock | 209.6 | 210.43 | 209.37 | 210.39 | 1065406.0 |
| 2025-07-16 13:00:00 | AAPL | Stock | 210.395 | 210.948 | 210.34 | 210.35 | 1236866.0 |
| 2025-07-16 13:30:00 | AAPL | Stock | 210.34 | 210.6319 | 210.19 | 210.27 | 841976.0 |
| 2025-07-16 14:00:00 | AAPL | Stock | 210.26 | 210.2812 | 209.87 | 210.03 | 899406.0 |
| 2025-07-16 14:30:00 | AAPL | Stock | 210.03 | 210.47 | 210.03 | 210.4593 | 691081.0 |
| 2025-07-16 15:00:00 | AAPL | Stock | 210.455 | 210.5851 | 210.115 | 210.325 | 843398.0 |
| 2025-07-16 15:30:00 | AAPL | Stock | 210.32 | 210.6366 | 209.97 | 210.15 | 3461788.0 |
| 2025-07-16 16:00:00 | AAPL | Stock | 210.12 | 210.29 | 209.8 | 209.9137 | 7862500.0 |
| 2025-07-16 16:30:00 | AAPL | Stock | 209.98 | 210.14 | 209.9 | 210.0585 | 10105.0 |
| 2025-07-16 17:00:00 | AAPL | Stock | 210.0019 | 210.14 | 210.0 | 210.0515 | 7799.0 |
| 2025-07-16 17:30:00 | AAPL | Stock | 210.0703 | 210.1936 | 210.0703 | 210.16 | 11666.0 |
| 2025-07-16 18:00:00 | AAPL | Stock | 210.16 | 210.198 | 210.06 | 210.06 | 8272.0 |
| 2025-07-16 18:30:00 | AAPL | Stock | 210.051 | 210.1676 | 209.9208 | 210.0 | 19229.0 |
| 2025-07-16 19:00:00 | AAPL | Stock | 209.99 | 210.1 | 209.91 | 210.0 | 7097.0 |
| 2025-07-16 19:30:00 | AAPL | Stock | 209.97 | 210.04 | 209.794 | 210.04 | 15367.0 |
| 2025-07-16 04:00:00 | MSFT | Stock | 504.0 | 504.73 | 504.0 | 504.32 | 2509.0 |
| 2025-07-16 04:30:00 | MSFT | Stock | 504.61 | 504.81 | 504.5 | 504.5 | 849.0 |
| 2025-07-16 05:30:00 | MSFT | Stock | 504.36 | 505.73 | 504.36 | 505.67 | 5365.0 |
| 2025-07-16 06:00:00 | MSFT | Stock | 505.02 | 505.47 | 504.91 | 505.47 | 438.0 |
| 2025-07-16 06:30:00 | MSFT | Stock | 505.5 | 505.56 | 505.31 | 505.31 | 1818.0 |
| 2025-07-16 07:00:00 | MSFT | Stock | 505.27 | 505.27 | 505.0 | 505.1 | 1811.0 |
| 2025-07-16 07:30:00 | MSFT | Stock | 504.87 | 504.87 | 504.49 | 504.5 | 1221.0 |
| 2025-07-16 08:00:00 | MSFT | Stock | 503.15 | 505.5 | 503.01 | 505.13 | 16457.0 |
| 2025-07-16 08:30:00 | MSFT | Stock | 505.17 | 506.0 | 505.17 | 505.9 | 5008.0 |
| 2025-07-16 09:00:00 | MSFT | Stock | 505.9 | 506.35 | 503.45 | 505.05 | 20426.0 |
| 2025-07-16 09:30:00 | MSFT | Stock | 505.2 | 505.5 | 502.32 | 502.825 | 1070277.0 |
| 2025-07-16 10:00:00 | MSFT | Stock | 502.89 | 503.83 | 502.48 | 503.73 | 568844.0 |
| 2025-07-16 10:30:00 | MSFT | Stock | 503.8 | 505.02 | 503.5 | 504.29 | 561486.0 |
| 2025-07-16 11:00:00 | MSFT | Stock | 504.33 | 505.15 | 502.64 | 504.4475 | 563116.0 |
| 2025-07-16 11:30:00 | MSFT | Stock | 504.25 | 505.5 | 501.89 | 504.455 | 723160.0 |
| 2025-07-16 12:00:00 | MSFT | Stock | 504.41 | 504.75 | 503.4 | 503.865 | 290912.0 |
| 2025-07-16 12:30:00 | MSFT | Stock | 503.865 | 505.055 | 503.25 | 505.0171 | 240526.0 |
| 2025-07-16 13:00:00 | MSFT | Stock | 505.025 | 505.73 | 504.96 | 505.45 | 253174.0 |
> showing 50 of 107,565 rows — these rows as CSV