PREVIEW / stock_30min / 2025-03-21
file: by_date/stock_30min/2025/2025-03-21.parquet size: 2.1 MB rows: 101,597 symbols: 486
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-21 04:00:00 | AAPL | Stock | 213.9 | 213.9 | 213.06 | 213.17 | 3664.0 |
| 2025-03-21 04:30:00 | AAPL | Stock | 213.22 | 213.22 | 213.01 | 213.14 | 3323.0 |
| 2025-03-21 05:00:00 | AAPL | Stock | 213.25 | 213.38 | 213.17 | 213.37 | 2180.0 |
| 2025-03-21 05:30:00 | AAPL | Stock | 213.62 | 213.7 | 213.57 | 213.65 | 2832.0 |
| 2025-03-21 06:00:00 | AAPL | Stock | 213.65 | 213.84 | 213.65 | 213.72 | 3147.0 |
| 2025-03-21 06:30:00 | AAPL | Stock | 213.64 | 213.66 | 211.52 | 212.0 | 64399.0 |
| 2025-03-21 07:00:00 | AAPL | Stock | 212.0 | 212.63 | 212.0 | 212.57 | 15181.0 |
| 2025-03-21 07:30:00 | AAPL | Stock | 212.65 | 213.02 | 212.07 | 212.1 | 42049.0 |
| 2025-03-21 08:00:00 | AAPL | Stock | 212.03 | 214.07 | 211.5 | 211.88 | 74300.0 |
| 2025-03-21 08:30:00 | AAPL | Stock | 211.8 | 211.98 | 210.74 | 210.7447 | 94447.0 |
| 2025-03-21 09:00:00 | AAPL | Stock | 210.7532 | 211.85 | 209.2 | 211.51 | 349587.0 |
| 2025-03-21 09:30:00 | AAPL | Stock | 211.56 | 214.42 | 211.28 | 214.12 | 12463750.0 |
| 2025-03-21 10:00:00 | AAPL | Stock | 214.16 | 214.2263 | 213.17 | 213.74 | 1916052.0 |
| 2025-03-21 10:30:00 | AAPL | Stock | 213.71 | 214.54 | 213.41 | 214.46 | 1496269.0 |
| 2025-03-21 11:00:00 | AAPL | Stock | 214.47 | 214.84 | 213.2607 | 213.4435 | 1379290.0 |
| 2025-03-21 11:30:00 | AAPL | Stock | 213.44 | 213.8599 | 212.68 | 213.2602 | 1263690.0 |
| 2025-03-21 12:00:00 | AAPL | Stock | 213.25 | 215.4 | 212.64 | 214.655 | 1657777.0 |
| 2025-03-21 12:30:00 | AAPL | Stock | 214.67 | 215.48 | 214.62 | 215.43 | 1677830.0 |
| 2025-03-21 13:00:00 | AAPL | Stock | 215.425 | 215.425 | 214.4848 | 214.62 | 970008.0 |
| 2025-03-21 13:30:00 | AAPL | Stock | 214.62 | 215.039 | 214.2601 | 214.29 | 1024507.0 |
| 2025-03-21 14:00:00 | AAPL | Stock | 214.28 | 214.9399 | 214.28 | 214.66 | 1039331.0 |
| 2025-03-21 14:30:00 | AAPL | Stock | 214.67 | 215.37 | 214.64 | 215.17 | 1515509.0 |
| 2025-03-21 15:00:00 | AAPL | Stock | 215.17 | 215.35 | 214.86 | 215.31 | 1622764.0 |
| 2025-03-21 15:30:00 | AAPL | Stock | 215.31 | 218.84 | 215.01 | 218.36 | 8461879.0 |
| 2025-03-21 16:00:00 | AAPL | Stock | 218.35 | 218.44 | 217.2993 | 217.51 | 25726778.0 |
| 2025-03-21 16:30:00 | AAPL | Stock | 217.54 | 218.27 | 217.47 | 217.82 | 76255.0 |
| 2025-03-21 17:00:00 | AAPL | Stock | 217.75 | 218.27 | 217.5 | 217.5693 | 138604.0 |
| 2025-03-21 17:30:00 | AAPL | Stock | 217.53 | 217.6 | 217.403 | 217.6 | 7254.0 |
| 2025-03-21 18:00:00 | AAPL | Stock | 217.6 | 217.72 | 216.0665 | 217.72 | 9988.0 |
| 2025-03-21 18:30:00 | AAPL | Stock | 217.73 | 217.78 | 217.624 | 217.78 | 1966.0 |
| 2025-03-21 19:00:00 | AAPL | Stock | 217.7053 | 217.78 | 217.7 | 217.7001 | 15275.0 |
| 2025-03-21 19:30:00 | AAPL | Stock | 217.7 | 217.8799 | 217.62 | 217.8799 | 17977.0 |
| 2025-03-21 04:00:00 | MSFT | Stock | 386.97 | 386.97 | 385.51 | 385.72 | 1723.0 |
| 2025-03-21 05:00:00 | MSFT | Stock | 385.5 | 385.9 | 385.5 | 385.9 | 1138.0 |
| 2025-03-21 05:30:00 | MSFT | Stock | 386.01 | 386.01 | 385.85 | 385.85 | 565.0 |
| 2025-03-21 06:00:00 | MSFT | Stock | 385.85 | 386.0 | 385.85 | 386.0 | 350.0 |
| 2025-03-21 06:30:00 | MSFT | Stock | 386.22 | 386.35 | 384.58 | 385.0 | 10880.0 |
| 2025-03-21 07:00:00 | MSFT | Stock | 385.45 | 386.06 | 385.45 | 386.06 | 3437.0 |
| 2025-03-21 07:30:00 | MSFT | Stock | 385.96 | 385.96 | 385.49 | 385.63 | 2073.0 |
| 2025-03-21 08:00:00 | MSFT | Stock | 385.6 | 387.12 | 385.1 | 385.1 | 9501.0 |
| 2025-03-21 08:30:00 | MSFT | Stock | 385.2 | 385.2 | 383.6 | 383.84 | 15063.0 |
| 2025-03-21 09:00:00 | MSFT | Stock | 383.82 | 383.84 | 380.46 | 383.51 | 91404.0 |
| 2025-03-21 09:30:00 | MSFT | Stock | 383.11 | 385.72 | 382.99 | 385.105 | 5235798.0 |
| 2025-03-21 10:00:00 | MSFT | Stock | 385.17 | 385.78 | 384.11 | 384.85 | 527614.0 |
| 2025-03-21 10:30:00 | MSFT | Stock | 384.86 | 385.1179 | 383.605 | 384.795 | 531242.0 |
| 2025-03-21 11:00:00 | MSFT | Stock | 384.855 | 385.16 | 383.62 | 383.905 | 416617.0 |
| 2025-03-21 11:30:00 | MSFT | Stock | 383.88 | 384.43 | 382.9 | 383.5 | 476877.0 |
| 2025-03-21 12:00:00 | MSFT | Stock | 383.48 | 385.93 | 382.8 | 385.56 | 495581.0 |
| 2025-03-21 12:30:00 | MSFT | Stock | 385.54 | 386.2 | 385.36 | 386.1 | 377344.0 |
| 2025-03-21 13:00:00 | MSFT | Stock | 386.06 | 386.09 | 384.45 | 384.71 | 318218.0 |
> showing 50 of 101,597 rows — these rows as CSV