PREVIEW / stock_30min / 2025-07-31
file: by_date/stock_30min/2025/2025-07-31.parquet size: 2.3 MB rows: 109,235 symbols: 358
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-31 04:00:00 | AAPL | Stock | 209.49 | 209.52 | 208.85 | 209.42 | 24063.0 |
| 2025-07-31 04:30:00 | AAPL | Stock | 209.45 | 209.8 | 209.19 | 209.21 | 35568.0 |
| 2025-07-31 05:00:00 | AAPL | Stock | 209.25 | 209.3 | 208.9 | 209.3 | 13364.0 |
| 2025-07-31 05:30:00 | AAPL | Stock | 209.3 | 209.3 | 209.07 | 209.07 | 7307.0 |
| 2025-07-31 06:00:00 | AAPL | Stock | 209.1 | 209.59 | 209.08 | 209.34 | 16295.0 |
| 2025-07-31 06:30:00 | AAPL | Stock | 209.33 | 209.53 | 209.21 | 209.38 | 14159.0 |
| 2025-07-31 07:00:00 | AAPL | Stock | 209.25 | 209.39 | 208.9 | 209.0 | 45139.0 |
| 2025-07-31 07:30:00 | AAPL | Stock | 209.0 | 209.14 | 208.97 | 209.1 | 12029.0 |
| 2025-07-31 08:00:00 | AAPL | Stock | 209.07 | 209.61 | 208.82 | 209.07 | 233074.0 |
| 2025-07-31 08:30:00 | AAPL | Stock | 209.2 | 209.5794 | 209.0202 | 209.5 | 97604.0 |
| 2025-07-31 09:00:00 | AAPL | Stock | 209.51 | 209.89 | 208.12 | 208.43 | 279351.0 |
| 2025-07-31 09:30:00 | AAPL | Stock | 208.49 | 209.45 | 207.82 | 208.47 | 5251994.0 |
| 2025-07-31 10:00:00 | AAPL | Stock | 208.44 | 209.6815 | 208.37 | 208.8424 | 2791298.0 |
| 2025-07-31 10:30:00 | AAPL | Stock | 208.86 | 209.55 | 208.72 | 208.99 | 2962581.0 |
| 2025-07-31 11:00:00 | AAPL | Stock | 208.98 | 209.24 | 208.07 | 208.2828 | 2121779.0 |
| 2025-07-31 11:30:00 | AAPL | Stock | 208.27 | 208.92 | 208.17 | 208.615 | 1992246.0 |
| 2025-07-31 12:00:00 | AAPL | Stock | 208.61 | 209.0 | 208.61 | 208.95 | 1334484.0 |
| 2025-07-31 12:30:00 | AAPL | Stock | 208.95 | 209.3799 | 208.86 | 209.0672 | 1654009.0 |
| 2025-07-31 13:00:00 | AAPL | Stock | 209.0682 | 209.84 | 208.5 | 208.665 | 2381800.0 |
| 2025-07-31 13:30:00 | AAPL | Stock | 208.665 | 208.92 | 208.14 | 208.31 | 1523398.0 |
| 2025-07-31 14:00:00 | AAPL | Stock | 208.3 | 208.77 | 207.58 | 208.61 | 2160861.0 |
| 2025-07-31 14:30:00 | AAPL | Stock | 208.61 | 209.25 | 208.54 | 208.94 | 2020380.0 |
| 2025-07-31 15:00:00 | AAPL | Stock | 208.96 | 209.3843 | 208.49 | 208.5699 | 2630747.0 |
| 2025-07-31 15:30:00 | AAPL | Stock | 208.57 | 208.85 | 207.16 | 207.61 | 6528872.0 |
| 2025-07-31 16:00:00 | AAPL | Stock | 207.61 | 209.83 | 207.57 | 209.3561 | 13249333.0 |
| 2025-07-31 16:30:00 | AAPL | Stock | 209.49 | 214.95 | 207.57 | 210.4 | 5617479.0 |
| 2025-07-31 17:00:00 | AAPL | Stock | 210.32 | 217.0 | 208.5 | 214.5 | 2960857.0 |
| 2025-07-31 17:30:00 | AAPL | Stock | 214.31 | 214.6666 | 210.847 | 212.65 | 1301587.0 |
| 2025-07-31 18:00:00 | AAPL | Stock | 212.6 | 214.2353 | 212.43 | 212.8 | 570036.0 |
| 2025-07-31 18:30:00 | AAPL | Stock | 212.8394 | 212.99 | 211.55 | 212.25 | 227285.0 |
| 2025-07-31 19:00:00 | AAPL | Stock | 212.25 | 212.25 | 211.01 | 211.05 | 147652.0 |
| 2025-07-31 19:30:00 | AAPL | Stock | 211.1 | 212.9 | 211.0225 | 212.59 | 254590.0 |
| 2025-07-31 04:00:00 | MSFT | Stock | 557.44 | 560.0 | 556.56 | 557.03 | 29656.0 |
| 2025-07-31 04:30:00 | MSFT | Stock | 556.6 | 557.0 | 556.12 | 556.4 | 23289.0 |
| 2025-07-31 05:00:00 | MSFT | Stock | 556.5 | 557.2 | 555.86 | 556.2 | 32398.0 |
| 2025-07-31 05:30:00 | MSFT | Stock | 556.31 | 556.5 | 555.49 | 555.52 | 23324.0 |
| 2025-07-31 06:00:00 | MSFT | Stock | 555.52 | 556.61 | 555.52 | 556.06 | 19509.0 |
| 2025-07-31 06:30:00 | MSFT | Stock | 555.98 | 558.85 | 555.98 | 556.91 | 38203.0 |
| 2025-07-31 07:00:00 | MSFT | Stock | 556.65 | 558.7 | 554.51 | 556.25 | 88480.0 |
| 2025-07-31 07:30:00 | MSFT | Stock | 556.28 | 556.63 | 554.37 | 554.5 | 31883.0 |
| 2025-07-31 08:00:00 | MSFT | Stock | 557.37 | 560.51 | 554.26 | 557.45 | 201257.0 |
| 2025-07-31 08:30:00 | MSFT | Stock | 557.4499 | 562.0 | 556.01 | 557.7 | 219384.0 |
| 2025-07-31 09:00:00 | MSFT | Stock | 557.9999 | 561.4 | 551.95 | 555.1 | 408165.0 |
| 2025-07-31 09:30:00 | MSFT | Stock | 555.225 | 555.45 | 536.09 | 536.155 | 9435446.0 |
| 2025-07-31 10:00:00 | MSFT | Stock | 536.275 | 540.14 | 535.66 | 537.7 | 3551074.0 |
| 2025-07-31 10:30:00 | MSFT | Stock | 537.76 | 538.97 | 534.35 | 535.095 | 2604254.0 |
| 2025-07-31 11:00:00 | MSFT | Stock | 535.05 | 537.58 | 535.04 | 537.0 | 1579762.0 |
| 2025-07-31 11:30:00 | MSFT | Stock | 537.04 | 537.71 | 535.26 | 536.73 | 1114243.0 |
| 2025-07-31 12:00:00 | MSFT | Stock | 536.66 | 537.23 | 535.57 | 536.458 | 928702.0 |
| 2025-07-31 12:30:00 | MSFT | Stock | 536.45 | 537.1499 | 535.14 | 536.455 | 893782.0 |
> showing 50 of 109,235 rows — these rows as CSV