PREVIEW / stock_30min / 2025-04-01
file: by_date/stock_30min/2025/2025-04-01.parquet size: 2.1 MB rows: 103,100 symbols: 459
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-04-01 04:00:00 | AAPL | Stock | 221.42 | 221.46 | 220.45 | 221.33 | 20326.0 |
| 2025-04-01 04:30:00 | AAPL | Stock | 221.2 | 221.76 | 221.15 | 221.22 | 9492.0 |
| 2025-04-01 05:00:00 | AAPL | Stock | 221.22 | 221.44 | 220.87 | 220.87 | 4296.0 |
| 2025-04-01 05:30:00 | AAPL | Stock | 220.86 | 221.23 | 220.86 | 221.0 | 2690.0 |
| 2025-04-01 06:00:00 | AAPL | Stock | 220.63 | 220.76 | 219.82 | 219.82 | 10404.0 |
| 2025-04-01 06:30:00 | AAPL | Stock | 219.84 | 220.39 | 219.25 | 220.39 | 27267.0 |
| 2025-04-01 07:00:00 | AAPL | Stock | 220.18 | 220.21 | 219.59 | 219.7 | 23511.0 |
| 2025-04-01 07:30:00 | AAPL | Stock | 219.72 | 220.07 | 219.52 | 220.0 | 20399.0 |
| 2025-04-01 08:00:00 | AAPL | Stock | 220.0 | 222.13 | 219.35 | 219.71 | 67406.0 |
| 2025-04-01 08:30:00 | AAPL | Stock | 219.84 | 222.13 | 219.7137 | 220.24 | 36012.0 |
| 2025-04-01 09:00:00 | AAPL | Stock | 220.3 | 220.8 | 219.43 | 219.8 | 114565.0 |
| 2025-04-01 09:30:00 | AAPL | Stock | 219.87 | 223.36 | 218.9 | 223.14 | 4189339.0 |
| 2025-04-01 10:00:00 | AAPL | Stock | 223.12 | 223.39 | 220.8201 | 221.5199 | 2571733.0 |
| 2025-04-01 10:30:00 | AAPL | Stock | 221.49 | 222.68 | 221.36 | 222.5688 | 1581993.0 |
| 2025-04-01 11:00:00 | AAPL | Stock | 222.555 | 223.43 | 222.33 | 222.8799 | 1316387.0 |
| 2025-04-01 11:30:00 | AAPL | Stock | 222.865 | 223.04 | 222.14 | 222.5802 | 1183558.0 |
| 2025-04-01 12:00:00 | AAPL | Stock | 222.6 | 223.14 | 222.39 | 222.55 | 918705.0 |
| 2025-04-01 12:30:00 | AAPL | Stock | 222.555 | 223.08 | 222.3 | 222.77 | 755487.0 |
| 2025-04-01 13:00:00 | AAPL | Stock | 222.765 | 222.97 | 222.19 | 222.3385 | 768149.0 |
| 2025-04-01 13:30:00 | AAPL | Stock | 222.3 | 222.78 | 222.1 | 222.2 | 860444.0 |
| 2025-04-01 14:00:00 | AAPL | Stock | 222.2 | 222.24 | 221.45 | 221.5 | 794870.0 |
| 2025-04-01 14:30:00 | AAPL | Stock | 221.49 | 221.8363 | 221.14 | 221.8102 | 895621.0 |
| 2025-04-01 15:00:00 | AAPL | Stock | 221.81 | 222.12 | 221.48 | 221.73 | 958508.0 |
| 2025-04-01 15:30:00 | AAPL | Stock | 221.72 | 223.68 | 221.57 | 223.14 | 3210114.0 |
| 2025-04-01 16:00:00 | AAPL | Stock | 223.14 | 223.72 | 222.74 | 223.1294 | 6225509.0 |
| 2025-04-01 16:30:00 | AAPL | Stock | 223.1878 | 223.43 | 222.94 | 223.02 | 39025.0 |
| 2025-04-01 17:00:00 | AAPL | Stock | 223.05 | 223.21 | 223.032 | 223.1488 | 5876.0 |
| 2025-04-01 17:30:00 | AAPL | Stock | 223.13 | 223.19 | 223.1 | 223.19 | 1150.0 |
| 2025-04-01 18:00:00 | AAPL | Stock | 223.25 | 224.0 | 223.19 | 223.9748 | 14696.0 |
| 2025-04-01 18:30:00 | AAPL | Stock | 223.78 | 223.78 | 223.5013 | 223.53 | 3603.0 |
| 2025-04-01 19:00:00 | AAPL | Stock | 223.6563 | 223.6563 | 223.5 | 223.59 | 8536.0 |
| 2025-04-01 19:30:00 | AAPL | Stock | 223.53 | 223.66 | 223.45 | 223.45 | 3529.0 |
| 2025-04-01 04:00:00 | MSFT | Stock | 373.99 | 374.83 | 373.89 | 374.83 | 2310.0 |
| 2025-04-01 04:30:00 | MSFT | Stock | 374.91 | 375.61 | 374.83 | 375.24 | 3653.0 |
| 2025-04-01 05:00:00 | MSFT | Stock | 375.32 | 375.74 | 374.3 | 375.36 | 18630.0 |
| 2025-04-01 05:30:00 | MSFT | Stock | 375.67 | 376.14 | 375.67 | 375.92 | 574.0 |
| 2025-04-01 06:00:00 | MSFT | Stock | 375.55 | 375.55 | 374.62 | 374.79 | 2237.0 |
| 2025-04-01 06:30:00 | MSFT | Stock | 374.55 | 374.55 | 374.16 | 374.22 | 796.0 |
| 2025-04-01 07:00:00 | MSFT | Stock | 374.51 | 374.62 | 374.1 | 374.16 | 5140.0 |
| 2025-04-01 07:30:00 | MSFT | Stock | 374.22 | 374.24 | 373.33 | 373.55 | 6434.0 |
| 2025-04-01 08:00:00 | MSFT | Stock | 373.41 | 375.39 | 373.2213 | 373.71 | 15997.0 |
| 2025-04-01 08:30:00 | MSFT | Stock | 373.7101 | 375.39 | 373.7 | 374.2 | 7220.0 |
| 2025-04-01 09:00:00 | MSFT | Stock | 374.48 | 374.99 | 374.11 | 374.7 | 7636.0 |
| 2025-04-01 09:30:00 | MSFT | Stock | 374.65 | 378.68 | 373.23 | 378.17 | 1893534.0 |
| 2025-04-01 10:00:00 | MSFT | Stock | 378.11 | 378.53 | 375.68 | 377.52 | 1208237.0 |
| 2025-04-01 10:30:00 | MSFT | Stock | 377.475 | 380.55 | 377.3238 | 380.365 | 913583.0 |
| 2025-04-01 11:00:00 | MSFT | Stock | 380.34 | 381.89 | 380.1 | 381.11 | 679303.0 |
| 2025-04-01 11:30:00 | MSFT | Stock | 381.155 | 381.48 | 380.01 | 381.135 | 485843.0 |
| 2025-04-01 12:00:00 | MSFT | Stock | 381.165 | 382.325 | 380.68 | 380.81 | 540940.0 |
| 2025-04-01 12:30:00 | MSFT | Stock | 380.78 | 381.7 | 379.65 | 381.05 | 403424.0 |
> showing 50 of 103,100 rows — these rows as CSV