PREVIEW / stock_30min / 2025-03-18
file: by_date/stock_30min/2025/2025-03-18.parquet size: 2.1 MB rows: 101,435 symbols: 487
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-03-18 04:00:00 | AAPL | Stock | 213.73 | 213.88 | 213.6 | 213.73 | 3409.0 |
| 2025-03-18 04:30:00 | AAPL | Stock | 213.82 | 213.91 | 213.72 | 213.72 | 4142.0 |
| 2025-03-18 05:00:00 | AAPL | Stock | 213.82 | 213.85 | 213.8 | 213.81 | 2724.0 |
| 2025-03-18 05:30:00 | AAPL | Stock | 213.78 | 213.78 | 213.63 | 213.64 | 1869.0 |
| 2025-03-18 06:00:00 | AAPL | Stock | 213.65 | 213.65 | 213.25 | 213.57 | 19878.0 |
| 2025-03-18 06:30:00 | AAPL | Stock | 213.51 | 214.0 | 213.45 | 213.91 | 8716.0 |
| 2025-03-18 07:00:00 | AAPL | Stock | 213.87 | 213.93 | 213.7 | 213.7 | 11279.0 |
| 2025-03-18 07:30:00 | AAPL | Stock | 213.6 | 213.95 | 213.44 | 213.95 | 14340.0 |
| 2025-03-18 08:00:00 | AAPL | Stock | 213.88 | 214.0 | 213.0 | 213.72 | 48675.0 |
| 2025-03-18 08:30:00 | AAPL | Stock | 213.8097 | 213.8999 | 213.26 | 213.42 | 34986.0 |
| 2025-03-18 09:00:00 | AAPL | Stock | 213.42 | 214.2 | 212.85 | 214.15 | 120517.0 |
| 2025-03-18 09:30:00 | AAPL | Stock | 214.15 | 215.05 | 212.95 | 214.43 | 4759680.0 |
| 2025-03-18 10:00:00 | AAPL | Stock | 214.42 | 215.15 | 213.68 | 214.5514 | 3125082.0 |
| 2025-03-18 10:30:00 | AAPL | Stock | 214.55 | 214.89 | 213.4701 | 213.715 | 1654243.0 |
| 2025-03-18 11:00:00 | AAPL | Stock | 213.7047 | 213.82 | 212.65 | 213.33 | 1751959.0 |
| 2025-03-18 11:30:00 | AAPL | Stock | 213.29 | 213.435 | 212.79 | 213.345 | 1211229.0 |
| 2025-03-18 12:00:00 | AAPL | Stock | 213.315 | 214.0 | 213.1301 | 213.72 | 1285235.0 |
| 2025-03-18 12:30:00 | AAPL | Stock | 213.7 | 213.7736 | 211.59 | 212.205 | 1592210.0 |
| 2025-03-18 13:00:00 | AAPL | Stock | 212.195 | 212.575 | 211.49 | 212.28 | 1290637.0 |
| 2025-03-18 13:30:00 | AAPL | Stock | 212.3 | 212.31 | 211.5598 | 211.86 | 1242483.0 |
| 2025-03-18 14:00:00 | AAPL | Stock | 211.85 | 212.32 | 211.68 | 211.995 | 1069927.0 |
| 2025-03-18 14:30:00 | AAPL | Stock | 212.0 | 212.655 | 211.8103 | 212.215 | 1238272.0 |
| 2025-03-18 15:00:00 | AAPL | Stock | 212.215 | 212.62 | 211.89 | 212.345 | 1296998.0 |
| 2025-03-18 15:30:00 | AAPL | Stock | 212.345 | 213.28 | 212.31 | 212.79 | 3186602.0 |
| 2025-03-18 16:00:00 | AAPL | Stock | 212.69 | 214.0 | 212.34 | 212.95 | 6084005.0 |
| 2025-03-18 16:30:00 | AAPL | Stock | 213.05 | 213.11 | 212.69 | 212.86 | 170560.0 |
| 2025-03-18 17:00:00 | AAPL | Stock | 212.92 | 212.93 | 212.75 | 212.75 | 3864.0 |
| 2025-03-18 17:30:00 | AAPL | Stock | 212.76 | 213.0 | 212.75 | 212.7835 | 5190.0 |
| 2025-03-18 18:00:00 | AAPL | Stock | 212.88 | 212.88 | 212.6037 | 212.6037 | 8129.0 |
| 2025-03-18 18:30:00 | AAPL | Stock | 212.6 | 212.99 | 212.37 | 212.83 | 6488.0 |
| 2025-03-18 19:00:00 | AAPL | Stock | 212.75 | 212.9 | 212.6 | 212.8 | 5736.0 |
| 2025-03-18 19:30:00 | AAPL | Stock | 212.6006 | 213.0 | 212.6006 | 213.0 | 11251.0 |
| 2025-03-18 04:00:00 | MSFT | Stock | 388.52 | 388.52 | 388.35 | 388.35 | 458.0 |
| 2025-03-18 04:30:00 | MSFT | Stock | 388.2 | 388.2 | 387.75 | 388.0 | 825.0 |
| 2025-03-18 05:00:00 | MSFT | Stock | 388.14 | 388.15 | 388.14 | 388.15 | 430.0 |
| 2025-03-18 05:30:00 | MSFT | Stock | 387.64 | 387.64 | 387.42 | 387.42 | 300.0 |
| 2025-03-18 06:00:00 | MSFT | Stock | 386.9 | 387.24 | 386.5 | 387.09 | 4525.0 |
| 2025-03-18 06:30:00 | MSFT | Stock | 387.02 | 387.42 | 387.02 | 387.42 | 1637.0 |
| 2025-03-18 07:00:00 | MSFT | Stock | 387.6 | 387.6 | 387.1 | 387.1 | 3741.0 |
| 2025-03-18 07:30:00 | MSFT | Stock | 386.92 | 387.4 | 386.0 | 387.22 | 4209.0 |
| 2025-03-18 08:00:00 | MSFT | Stock | 386.77 | 388.22 | 386.4113 | 387.75 | 10871.0 |
| 2025-03-18 08:30:00 | MSFT | Stock | 387.61 | 387.84 | 386.88 | 386.9999 | 5576.0 |
| 2025-03-18 09:00:00 | MSFT | Stock | 386.62 | 387.38 | 386.02 | 387.38 | 9305.0 |
| 2025-03-18 09:30:00 | MSFT | Stock | 387.24 | 387.37 | 382.5 | 384.01 | 1344428.0 |
| 2025-03-18 10:00:00 | MSFT | Stock | 384.03 | 384.5995 | 383.1976 | 384.0 | 836421.0 |
| 2025-03-18 10:30:00 | MSFT | Stock | 383.91 | 384.14 | 382.81 | 383.125 | 443711.0 |
| 2025-03-18 11:00:00 | MSFT | Stock | 383.125 | 383.43 | 382.21 | 382.5 | 417779.0 |
| 2025-03-18 11:30:00 | MSFT | Stock | 382.54 | 382.95 | 382.02 | 382.695 | 471881.0 |
| 2025-03-18 12:00:00 | MSFT | Stock | 382.65 | 384.065 | 382.55 | 383.595 | 429143.0 |
| 2025-03-18 12:30:00 | MSFT | Stock | 383.53 | 383.59 | 381.14 | 382.23 | 392735.0 |
> showing 50 of 101,435 rows — these rows as CSV