PREVIEW / stock_30min / 2025-07-23
file: by_date/stock_30min/2025/2025-07-23.parquet size: 2.3 MB rows: 108,872 symbols: 369
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-23 04:00:00 | AAPL | Stock | 215.29 | 215.5 | 215.07 | 215.5 | 17614.0 |
| 2025-07-23 04:30:00 | AAPL | Stock | 215.4 | 215.5 | 215.4 | 215.45 | 3170.0 |
| 2025-07-23 05:00:00 | AAPL | Stock | 215.5 | 215.51 | 215.27 | 215.27 | 2764.0 |
| 2025-07-23 05:30:00 | AAPL | Stock | 215.29 | 215.34 | 215.27 | 215.27 | 3164.0 |
| 2025-07-23 06:00:00 | AAPL | Stock | 215.27 | 215.27 | 215.1 | 215.11 | 2333.0 |
| 2025-07-23 06:30:00 | AAPL | Stock | 215.11 | 215.12 | 214.95 | 215.05 | 8151.0 |
| 2025-07-23 07:00:00 | AAPL | Stock | 215.05 | 215.05 | 214.69 | 214.8 | 13787.0 |
| 2025-07-23 07:30:00 | AAPL | Stock | 214.78 | 215.0 | 214.78 | 215.0 | 2679.0 |
| 2025-07-23 08:00:00 | AAPL | Stock | 214.88 | 215.4946 | 214.7 | 215.4 | 114548.0 |
| 2025-07-23 08:30:00 | AAPL | Stock | 215.3 | 215.78 | 215.27 | 215.56 | 100392.0 |
| 2025-07-23 09:00:00 | AAPL | Stock | 215.48 | 215.63 | 215.0 | 215.0897 | 79300.0 |
| 2025-07-23 09:30:00 | AAPL | Stock | 215.09 | 215.15 | 212.42 | 212.56 | 6205026.0 |
| 2025-07-23 10:00:00 | AAPL | Stock | 212.56 | 213.16 | 212.41 | 212.9351 | 3172054.0 |
| 2025-07-23 10:30:00 | AAPL | Stock | 212.9499 | 213.0616 | 212.5 | 212.66 | 1832214.0 |
| 2025-07-23 11:00:00 | AAPL | Stock | 212.675 | 213.17 | 212.6519 | 213.145 | 1884651.0 |
| 2025-07-23 11:30:00 | AAPL | Stock | 213.15 | 213.82 | 212.65 | 213.355 | 2062186.0 |
| 2025-07-23 12:00:00 | AAPL | Stock | 213.35 | 213.72 | 213.21 | 213.5 | 1629412.0 |
| 2025-07-23 12:30:00 | AAPL | Stock | 213.5 | 213.63 | 213.36 | 213.5999 | 841426.0 |
| 2025-07-23 13:00:00 | AAPL | Stock | 213.59 | 214.23 | 213.51 | 214.125 | 1211398.0 |
| 2025-07-23 13:30:00 | AAPL | Stock | 214.12 | 214.635 | 214.07 | 214.4601 | 1928582.0 |
| 2025-07-23 14:00:00 | AAPL | Stock | 214.465 | 214.59 | 214.25 | 214.405 | 1312923.0 |
| 2025-07-23 14:30:00 | AAPL | Stock | 214.405 | 214.695 | 214.32 | 214.56 | 1258201.0 |
| 2025-07-23 15:00:00 | AAPL | Stock | 214.57 | 214.63 | 213.94 | 214.14 | 1446515.0 |
| 2025-07-23 15:30:00 | AAPL | Stock | 214.145 | 214.31 | 213.61 | 214.31 | 3275084.0 |
| 2025-07-23 16:00:00 | AAPL | Stock | 214.15 | 214.6 | 213.71 | 213.96 | 6723797.0 |
| 2025-07-23 16:30:00 | AAPL | Stock | 214.09 | 214.3 | 213.91 | 214.2 | 45978.0 |
| 2025-07-23 17:00:00 | AAPL | Stock | 214.1 | 214.1575 | 213.6 | 213.75 | 50595.0 |
| 2025-07-23 17:30:00 | AAPL | Stock | 213.82 | 214.15 | 213.5522 | 213.63 | 43327.0 |
| 2025-07-23 18:00:00 | AAPL | Stock | 213.65 | 213.9462 | 213.6 | 213.7986 | 32017.0 |
| 2025-07-23 18:30:00 | AAPL | Stock | 213.779 | 213.85 | 213.65 | 213.7 | 9274.0 |
| 2025-07-23 19:00:00 | AAPL | Stock | 213.64 | 213.71 | 213.62 | 213.65 | 10165.0 |
| 2025-07-23 19:30:00 | AAPL | Stock | 213.689 | 213.8 | 213.6 | 213.64 | 19832.0 |
| 2025-07-23 04:00:00 | MSFT | Stock | 507.0 | 507.2 | 506.75 | 507.2 | 1214.0 |
| 2025-07-23 04:30:00 | MSFT | Stock | 507.22 | 507.22 | 506.87 | 506.87 | 3015.0 |
| 2025-07-23 05:00:00 | MSFT | Stock | 507.2 | 507.34 | 507.2 | 507.34 | 200.0 |
| 2025-07-23 05:30:00 | MSFT | Stock | 507.11 | 507.27 | 507.05 | 507.27 | 988.0 |
| 2025-07-23 06:00:00 | MSFT | Stock | 507.19 | 507.19 | 507.19 | 507.19 | 189.0 |
| 2025-07-23 06:30:00 | MSFT | Stock | 507.42 | 507.5 | 507.42 | 507.5 | 470.0 |
| 2025-07-23 07:00:00 | MSFT | Stock | 507.06 | 507.06 | 506.34 | 506.34 | 1808.0 |
| 2025-07-23 07:30:00 | MSFT | Stock | 506.46 | 506.71 | 506.46 | 506.57 | 895.0 |
| 2025-07-23 08:00:00 | MSFT | Stock | 507.16 | 507.34 | 506.01 | 506.3897 | 18740.0 |
| 2025-07-23 08:30:00 | MSFT | Stock | 506.05 | 506.3084 | 505.5573 | 505.95 | 9567.0 |
| 2025-07-23 09:00:00 | MSFT | Stock | 505.99 | 507.99 | 505.99 | 506.75 | 10457.0 |
| 2025-07-23 09:30:00 | MSFT | Stock | 506.75 | 506.79 | 502.2 | 503.16 | 1407848.0 |
| 2025-07-23 10:00:00 | MSFT | Stock | 503.13 | 503.13 | 500.7 | 502.63 | 1209463.0 |
| 2025-07-23 10:30:00 | MSFT | Stock | 502.63 | 502.7137 | 501.64 | 502.485 | 615647.0 |
| 2025-07-23 11:00:00 | MSFT | Stock | 502.49 | 502.8593 | 501.4029 | 502.395 | 707634.0 |
| 2025-07-23 11:30:00 | MSFT | Stock | 502.392 | 505.5 | 502.13 | 504.51 | 626303.0 |
| 2025-07-23 12:00:00 | MSFT | Stock | 504.5 | 504.6899 | 502.8 | 503.31 | 369230.0 |
| 2025-07-23 12:30:00 | MSFT | Stock | 503.34 | 504.0372 | 503.2427 | 503.745 | 309660.0 |
> showing 50 of 108,872 rows — these rows as CSV