PREVIEW / stock_30min / 2025-07-21
file: by_date/stock_30min/2025/2025-07-21.parquet size: 2.3 MB rows: 110,444 symbols: 367
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-21 04:00:00 | AAPL | Stock | 211.22 | 211.88 | 211.22 | 211.72 | 6844.0 |
| 2025-07-21 04:30:00 | AAPL | Stock | 211.71 | 211.77 | 211.67 | 211.77 | 3258.0 |
| 2025-07-21 05:00:00 | AAPL | Stock | 211.78 | 211.9 | 211.78 | 211.85 | 4179.0 |
| 2025-07-21 05:30:00 | AAPL | Stock | 211.88 | 211.95 | 211.85 | 211.9 | 3349.0 |
| 2025-07-21 06:00:00 | AAPL | Stock | 211.94 | 212.0 | 211.93 | 211.96 | 8063.0 |
| 2025-07-21 06:30:00 | AAPL | Stock | 211.96 | 212.7 | 211.91 | 212.4 | 34602.0 |
| 2025-07-21 07:00:00 | AAPL | Stock | 212.28 | 212.65 | 212.07 | 212.65 | 16010.0 |
| 2025-07-21 07:30:00 | AAPL | Stock | 212.65 | 212.65 | 212.5 | 212.55 | 9304.0 |
| 2025-07-21 08:00:00 | AAPL | Stock | 212.31 | 213.0 | 211.61 | 213.0 | 148907.0 |
| 2025-07-21 08:30:00 | AAPL | Stock | 212.9 | 213.0 | 212.38 | 212.44 | 65083.0 |
| 2025-07-21 09:00:00 | AAPL | Stock | 212.4 | 212.82 | 211.58 | 212.1499 | 159560.0 |
| 2025-07-21 09:30:00 | AAPL | Stock | 212.14 | 215.78 | 211.63 | 214.0 | 9950649.0 |
| 2025-07-21 10:00:00 | AAPL | Stock | 214.01 | 215.19 | 214.01 | 214.645 | 3983529.0 |
| 2025-07-21 10:30:00 | AAPL | Stock | 214.64 | 214.71 | 213.2852 | 213.41 | 3450784.0 |
| 2025-07-21 11:00:00 | AAPL | Stock | 213.41 | 213.65 | 212.87 | 213.47 | 2435474.0 |
| 2025-07-21 11:30:00 | AAPL | Stock | 213.46 | 213.71 | 213.16 | 213.3996 | 1346681.0 |
| 2025-07-21 12:00:00 | AAPL | Stock | 213.385 | 213.58 | 213.17 | 213.31 | 932501.0 |
| 2025-07-21 12:30:00 | AAPL | Stock | 213.315 | 213.86 | 213.14 | 213.56 | 1287124.0 |
| 2025-07-21 13:00:00 | AAPL | Stock | 213.55 | 213.73 | 213.41 | 213.67 | 894362.0 |
| 2025-07-21 13:30:00 | AAPL | Stock | 213.66 | 213.71 | 212.885 | 212.9099 | 1313655.0 |
| 2025-07-21 14:00:00 | AAPL | Stock | 212.91 | 213.27 | 212.505 | 213.26 | 1442251.0 |
| 2025-07-21 14:30:00 | AAPL | Stock | 213.2688 | 213.43 | 213.0 | 213.0502 | 964677.0 |
| 2025-07-21 15:00:00 | AAPL | Stock | 213.07 | 213.1099 | 212.51 | 212.58 | 1184260.0 |
| 2025-07-21 15:30:00 | AAPL | Stock | 212.58 | 212.7186 | 212.06 | 212.54 | 2886940.0 |
| 2025-07-21 16:00:00 | AAPL | Stock | 212.529 | 212.75 | 211.9 | 212.0 | 4620361.0 |
| 2025-07-21 16:30:00 | AAPL | Stock | 211.98 | 212.48 | 211.9005 | 212.28 | 32867.0 |
| 2025-07-21 17:00:00 | AAPL | Stock | 212.2501 | 212.44 | 212.2 | 212.23 | 18504.0 |
| 2025-07-21 17:30:00 | AAPL | Stock | 212.2 | 212.48 | 212.15 | 212.2523 | 21285.0 |
| 2025-07-21 18:00:00 | AAPL | Stock | 212.42 | 212.46 | 212.25 | 212.46 | 8697.0 |
| 2025-07-21 18:30:00 | AAPL | Stock | 212.46 | 212.48 | 212.3505 | 212.48 | 6449.0 |
| 2025-07-21 19:00:00 | AAPL | Stock | 212.48 | 212.7375 | 212.4799 | 212.64 | 13619.0 |
| 2025-07-21 19:30:00 | AAPL | Stock | 212.65 | 212.7 | 212.57 | 212.67 | 12912.0 |
| 2025-07-21 04:00:00 | MSFT | Stock | 510.0 | 510.18 | 509.0 | 509.1 | 5355.0 |
| 2025-07-21 04:30:00 | MSFT | Stock | 509.0 | 509.1 | 509.0 | 509.1 | 475.0 |
| 2025-07-21 05:00:00 | MSFT | Stock | 509.51 | 509.64 | 509.5 | 509.5 | 444.0 |
| 2025-07-21 06:00:00 | MSFT | Stock | 509.85 | 509.85 | 509.7 | 509.7 | 318.0 |
| 2025-07-21 06:30:00 | MSFT | Stock | 509.79 | 509.8 | 509.17 | 509.39 | 2311.0 |
| 2025-07-21 07:00:00 | MSFT | Stock | 509.56 | 509.61 | 509.11 | 509.26 | 1465.0 |
| 2025-07-21 07:30:00 | MSFT | Stock | 509.25 | 509.25 | 509.0 | 509.0 | 4394.0 |
| 2025-07-21 08:00:00 | MSFT | Stock | 509.1 | 510.21 | 506.6 | 507.0 | 20671.0 |
| 2025-07-21 08:30:00 | MSFT | Stock | 506.78 | 507.41 | 506.56 | 506.94 | 39992.0 |
| 2025-07-21 09:00:00 | MSFT | Stock | 506.7 | 507.65 | 506.0 | 506.8 | 37258.0 |
| 2025-07-21 09:30:00 | MSFT | Stock | 506.85 | 512.09 | 505.55 | 511.51 | 1477580.0 |
| 2025-07-21 10:00:00 | MSFT | Stock | 511.53 | 512.07 | 510.7 | 511.31 | 528710.0 |
| 2025-07-21 10:30:00 | MSFT | Stock | 511.335 | 512.06 | 510.5601 | 510.635 | 386644.0 |
| 2025-07-21 11:00:00 | MSFT | Stock | 510.66 | 510.85 | 509.99 | 510.435 | 441352.0 |
| 2025-07-21 11:30:00 | MSFT | Stock | 510.435 | 510.815 | 510.26 | 510.75 | 224724.0 |
| 2025-07-21 12:00:00 | MSFT | Stock | 510.75 | 510.77 | 509.8 | 510.3882 | 379616.0 |
| 2025-07-21 12:30:00 | MSFT | Stock | 510.3575 | 511.3699 | 510.16 | 510.97 | 365124.0 |
| 2025-07-21 13:00:00 | MSFT | Stock | 510.99 | 511.035 | 510.43 | 510.9101 | 223194.0 |
> showing 50 of 110,444 rows — these rows as CSV