PREVIEW / stock_30min / 2025-07-10
file: by_date/stock_30min/2025/2025-07-10.parquet size: 2.3 MB rows: 107,195 symbols: 375
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-10 04:00:00 | AAPL | Stock | 210.65 | 210.65 | 210.1 | 210.2 | 13536.0 |
| 2025-07-10 04:30:00 | AAPL | Stock | 210.18 | 210.4 | 210.18 | 210.24 | 4044.0 |
| 2025-07-10 05:00:00 | AAPL | Stock | 210.26 | 210.4 | 209.92 | 209.97 | 10303.0 |
| 2025-07-10 05:30:00 | AAPL | Stock | 210.04 | 210.04 | 209.62 | 209.72 | 14470.0 |
| 2025-07-10 06:00:00 | AAPL | Stock | 209.71 | 209.92 | 209.7 | 209.8 | 1963.0 |
| 2025-07-10 06:30:00 | AAPL | Stock | 209.85 | 210.0 | 209.8 | 210.0 | 4282.0 |
| 2025-07-10 07:00:00 | AAPL | Stock | 209.87 | 210.1 | 209.85 | 210.02 | 12040.0 |
| 2025-07-10 07:30:00 | AAPL | Stock | 210.05 | 210.26 | 210.02 | 210.12 | 9716.0 |
| 2025-07-10 08:00:00 | AAPL | Stock | 209.95 | 210.613 | 209.64 | 210.18 | 95741.0 |
| 2025-07-10 08:30:00 | AAPL | Stock | 210.2 | 210.26 | 209.81 | 209.99 | 41364.0 |
| 2025-07-10 09:00:00 | AAPL | Stock | 210.03 | 210.6 | 209.85 | 210.5 | 79058.0 |
| 2025-07-10 09:30:00 | AAPL | Stock | 210.44 | 211.2899 | 210.03 | 211.275 | 3953262.0 |
| 2025-07-10 10:00:00 | AAPL | Stock | 211.27 | 212.2999 | 210.71 | 212.01 | 3250132.0 |
| 2025-07-10 10:30:00 | AAPL | Stock | 212.02 | 213.48 | 211.9 | 212.36 | 4675581.0 |
| 2025-07-10 11:00:00 | AAPL | Stock | 212.3666 | 213.3194 | 212.31 | 212.99 | 2459170.0 |
| 2025-07-10 11:30:00 | AAPL | Stock | 212.99 | 213.18 | 212.23 | 212.39 | 1855796.0 |
| 2025-07-10 12:00:00 | AAPL | Stock | 212.38 | 212.4 | 211.83 | 212.08 | 1775359.0 |
| 2025-07-10 12:30:00 | AAPL | Stock | 212.07 | 212.36 | 211.85 | 212.0174 | 1398732.0 |
| 2025-07-10 13:00:00 | AAPL | Stock | 212.02 | 212.78 | 211.93 | 212.62 | 1274443.0 |
| 2025-07-10 13:30:00 | AAPL | Stock | 212.61 | 213.16 | 212.371 | 212.371 | 1283182.0 |
| 2025-07-10 14:00:00 | AAPL | Stock | 212.39 | 213.0 | 212.31 | 212.6 | 1029453.0 |
| 2025-07-10 14:30:00 | AAPL | Stock | 212.5949 | 213.1425 | 212.57 | 212.935 | 1069166.0 |
| 2025-07-10 15:00:00 | AAPL | Stock | 212.92 | 213.45 | 212.57 | 212.575 | 1438951.0 |
| 2025-07-10 15:30:00 | AAPL | Stock | 212.58 | 213.02 | 212.05 | 212.44 | 2967239.0 |
| 2025-07-10 16:00:00 | AAPL | Stock | 212.41 | 212.438 | 212.11 | 212.3 | 5693512.0 |
| 2025-07-10 16:30:00 | AAPL | Stock | 212.3 | 212.44 | 212.21 | 212.22 | 21483.0 |
| 2025-07-10 17:00:00 | AAPL | Stock | 212.23 | 212.35 | 212.15 | 212.15 | 15213.0 |
| 2025-07-10 17:30:00 | AAPL | Stock | 212.2899 | 212.29 | 212.05 | 212.22 | 17566.0 |
| 2025-07-10 18:00:00 | AAPL | Stock | 212.25 | 212.35 | 212.25 | 212.31 | 6783.0 |
| 2025-07-10 18:30:00 | AAPL | Stock | 212.3001 | 212.349 | 212.3 | 212.31 | 12407.0 |
| 2025-07-10 19:00:00 | AAPL | Stock | 212.32 | 212.3828 | 212.3 | 212.3415 | 3306.0 |
| 2025-07-10 19:30:00 | AAPL | Stock | 212.37 | 212.5 | 212.34 | 212.5 | 12374.0 |
| 2025-07-10 04:00:00 | MSFT | Stock | 502.94 | 503.49 | 502.78 | 503.4 | 1946.0 |
| 2025-07-10 04:30:00 | MSFT | Stock | 503.27 | 503.4 | 503.27 | 503.3 | 438.0 |
| 2025-07-10 05:00:00 | MSFT | Stock | 503.18 | 503.18 | 502.8 | 502.85 | 2197.0 |
| 2025-07-10 05:30:00 | MSFT | Stock | 502.72 | 502.89 | 502.55 | 502.55 | 2521.0 |
| 2025-07-10 06:00:00 | MSFT | Stock | 502.82 | 502.82 | 502.62 | 502.62 | 200.0 |
| 2025-07-10 06:30:00 | MSFT | Stock | 502.61 | 502.75 | 502.61 | 502.75 | 371.0 |
| 2025-07-10 07:00:00 | MSFT | Stock | 502.61 | 502.84 | 502.55 | 502.72 | 1245.0 |
| 2025-07-10 07:30:00 | MSFT | Stock | 502.6 | 503.04 | 502.6 | 502.85 | 1435.0 |
| 2025-07-10 08:00:00 | MSFT | Stock | 502.75 | 503.51 | 501.45 | 502.2 | 11912.0 |
| 2025-07-10 08:30:00 | MSFT | Stock | 502.1 | 502.6376 | 501.7002 | 502.3 | 9859.0 |
| 2025-07-10 09:00:00 | MSFT | Stock | 502.5 | 503.78 | 501.94 | 503.34 | 17449.0 |
| 2025-07-10 09:30:00 | MSFT | Stock | 503.05 | 504.44 | 500.62 | 501.37 | 1227529.0 |
| 2025-07-10 10:00:00 | MSFT | Stock | 501.31 | 501.31 | 498.35 | 498.54 | 796991.0 |
| 2025-07-10 10:30:00 | MSFT | Stock | 498.5 | 500.0599 | 497.75 | 499.49 | 550870.0 |
| 2025-07-10 11:00:00 | MSFT | Stock | 499.505 | 500.48 | 499.0 | 500.065 | 606459.0 |
| 2025-07-10 11:30:00 | MSFT | Stock | 500.1 | 500.64 | 499.87 | 500.355 | 400548.0 |
| 2025-07-10 12:00:00 | MSFT | Stock | 500.32 | 500.3724 | 499.07 | 500.275 | 364351.0 |
| 2025-07-10 12:30:00 | MSFT | Stock | 500.29 | 500.6068 | 499.55 | 500.15 | 275040.0 |
> showing 50 of 107,195 rows — these rows as CSV