PREVIEW / stock_30min / 2025-07-07
file: by_date/stock_30min/2025/2025-07-07.parquet size: 2.3 MB rows: 108,651 symbols: 380
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-07 04:00:00 | AAPL | Stock | 213.57 | 213.57 | 211.81 | 212.02 | 25601.0 |
| 2025-07-07 04:30:00 | AAPL | Stock | 211.86 | 211.87 | 211.59 | 211.7 | 10035.0 |
| 2025-07-07 05:00:00 | AAPL | Stock | 211.75 | 211.83 | 211.55 | 211.61 | 5283.0 |
| 2025-07-07 05:30:00 | AAPL | Stock | 211.6 | 212.12 | 211.42 | 212.1 | 10265.0 |
| 2025-07-07 06:00:00 | AAPL | Stock | 212.02 | 212.45 | 212.02 | 212.33 | 10778.0 |
| 2025-07-07 06:30:00 | AAPL | Stock | 212.36 | 212.59 | 212.34 | 212.36 | 18197.0 |
| 2025-07-07 07:00:00 | AAPL | Stock | 212.42 | 212.53 | 212.4 | 212.4 | 9812.0 |
| 2025-07-07 07:30:00 | AAPL | Stock | 212.44 | 212.64 | 212.29 | 212.6 | 8718.0 |
| 2025-07-07 08:00:00 | AAPL | Stock | 212.45 | 213.17 | 211.5172 | 212.71 | 119122.0 |
| 2025-07-07 08:30:00 | AAPL | Stock | 212.78 | 212.78 | 212.3519 | 212.36 | 23585.0 |
| 2025-07-07 09:00:00 | AAPL | Stock | 212.3636 | 212.72 | 211.91 | 212.7 | 77549.0 |
| 2025-07-07 09:30:00 | AAPL | Stock | 212.72 | 216.23 | 212.47 | 212.94 | 7060765.0 |
| 2025-07-07 10:00:00 | AAPL | Stock | 212.93 | 213.12 | 211.81 | 212.365 | 2858157.0 |
| 2025-07-07 10:30:00 | AAPL | Stock | 212.37 | 212.38 | 211.6 | 212.11 | 1890249.0 |
| 2025-07-07 11:00:00 | AAPL | Stock | 212.115 | 212.6 | 211.865 | 212.04 | 1530660.0 |
| 2025-07-07 11:30:00 | AAPL | Stock | 212.035 | 212.16 | 211.53 | 211.75 | 1401959.0 |
| 2025-07-07 12:00:00 | AAPL | Stock | 211.74 | 212.22 | 210.38 | 210.84 | 2217848.0 |
| 2025-07-07 12:30:00 | AAPL | Stock | 210.8373 | 211.1699 | 209.9 | 210.635 | 2178240.0 |
| 2025-07-07 13:00:00 | AAPL | Stock | 210.635 | 210.795 | 209.52 | 209.6704 | 1685453.0 |
| 2025-07-07 13:30:00 | AAPL | Stock | 209.67 | 210.5 | 209.55 | 210.05 | 1471046.0 |
| 2025-07-07 14:00:00 | AAPL | Stock | 210.06 | 210.21 | 208.91 | 208.9404 | 1740779.0 |
| 2025-07-07 14:30:00 | AAPL | Stock | 208.94 | 209.78 | 208.8 | 209.7623 | 1747195.0 |
| 2025-07-07 15:00:00 | AAPL | Stock | 209.765 | 210.07 | 209.34 | 209.45 | 1602726.0 |
| 2025-07-07 15:30:00 | AAPL | Stock | 209.46 | 210.25 | 209.19 | 209.94 | 3552635.0 |
| 2025-07-07 16:00:00 | AAPL | Stock | 209.93 | 210.26 | 209.7091 | 210.15 | 6908148.0 |
| 2025-07-07 16:30:00 | AAPL | Stock | 210.18 | 210.23 | 209.2538 | 209.46 | 59850.0 |
| 2025-07-07 17:00:00 | AAPL | Stock | 209.5 | 209.95 | 209.01 | 209.1147 | 88467.0 |
| 2025-07-07 17:30:00 | AAPL | Stock | 209.26 | 209.38 | 208.95 | 209.14 | 46198.0 |
| 2025-07-07 18:00:00 | AAPL | Stock | 209.2 | 209.34 | 209.0 | 209.03 | 19760.0 |
| 2025-07-07 18:30:00 | AAPL | Stock | 209.0496 | 209.2821 | 209.0 | 209.2 | 10855.0 |
| 2025-07-07 19:00:00 | AAPL | Stock | 209.25 | 209.36 | 208.92 | 209.0 | 43503.0 |
| 2025-07-07 19:30:00 | AAPL | Stock | 208.99 | 209.09 | 208.8617 | 208.9822 | 31716.0 |
| 2025-07-07 04:00:00 | MSFT | Stock | 497.0 | 498.6 | 496.76 | 498.6 | 8565.0 |
| 2025-07-07 04:30:00 | MSFT | Stock | 498.5 | 498.73 | 498.28 | 498.49 | 2586.0 |
| 2025-07-07 05:00:00 | MSFT | Stock | 498.6 | 499.32 | 498.54 | 499.09 | 2651.0 |
| 2025-07-07 06:00:00 | MSFT | Stock | 499.69 | 499.79 | 499.4 | 499.79 | 1280.0 |
| 2025-07-07 06:30:00 | MSFT | Stock | 499.86 | 499.94 | 499.7 | 499.7 | 1000.0 |
| 2025-07-07 07:00:00 | MSFT | Stock | 499.7 | 499.7 | 499.23 | 499.24 | 1226.0 |
| 2025-07-07 07:30:00 | MSFT | Stock | 499.56 | 499.74 | 499.39 | 499.45 | 4409.0 |
| 2025-07-07 08:00:00 | MSFT | Stock | 499.73 | 500.0 | 496.29 | 499.54 | 22687.0 |
| 2025-07-07 08:30:00 | MSFT | Stock | 499.68 | 499.68 | 498.6197 | 498.68 | 4083.0 |
| 2025-07-07 09:00:00 | MSFT | Stock | 498.75 | 498.75 | 496.5 | 497.19 | 23472.0 |
| 2025-07-07 09:30:00 | MSFT | Stock | 497.54 | 498.39 | 496.12 | 497.85 | 1054926.0 |
| 2025-07-07 10:00:00 | MSFT | Stock | 497.82 | 498.065 | 495.96 | 497.59 | 466865.0 |
| 2025-07-07 10:30:00 | MSFT | Stock | 497.62 | 498.125 | 496.97 | 497.35 | 439763.0 |
| 2025-07-07 11:00:00 | MSFT | Stock | 497.34 | 498.09 | 497.34 | 497.84 | 292692.0 |
| 2025-07-07 11:30:00 | MSFT | Stock | 497.83 | 498.59 | 497.42 | 498.095 | 277145.0 |
| 2025-07-07 12:00:00 | MSFT | Stock | 498.13 | 498.75 | 496.4512 | 497.6 | 471120.0 |
| 2025-07-07 12:30:00 | MSFT | Stock | 497.57 | 498.01 | 496.575 | 497.02 | 235576.0 |
| 2025-07-07 13:00:00 | MSFT | Stock | 496.965 | 497.625 | 496.275 | 496.45 | 233031.0 |
> showing 50 of 108,651 rows — these rows as CSV