PREVIEW / stock_30min / 2025-06-17
file: by_date/stock_30min/2025/2025-06-17.parquet size: 2.2 MB rows: 104,881 symbols: 397
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-06-17 04:00:00 | AAPL | Stock | 197.51 | 197.64 | 197.4 | 197.46 | 3407.0 |
| 2025-06-17 04:30:00 | AAPL | Stock | 197.46 | 197.7 | 197.4 | 197.4 | 8951.0 |
| 2025-06-17 05:00:00 | AAPL | Stock | 197.69 | 197.71 | 197.24 | 197.32 | 6414.0 |
| 2025-06-17 05:30:00 | AAPL | Stock | 197.33 | 197.41 | 197.26 | 197.4 | 2272.0 |
| 2025-06-17 06:00:00 | AAPL | Stock | 197.37 | 197.4 | 197.24 | 197.24 | 6016.0 |
| 2025-06-17 06:30:00 | AAPL | Stock | 197.3 | 197.51 | 197.16 | 197.5 | 14367.0 |
| 2025-06-17 07:00:00 | AAPL | Stock | 197.52 | 197.79 | 197.5 | 197.7 | 11371.0 |
| 2025-06-17 07:30:00 | AAPL | Stock | 197.68 | 197.71 | 197.55 | 197.7 | 4295.0 |
| 2025-06-17 08:00:00 | AAPL | Stock | 197.52 | 197.98 | 197.2 | 197.7185 | 40278.0 |
| 2025-06-17 08:30:00 | AAPL | Stock | 197.7 | 197.77 | 197.36 | 197.49 | 47376.0 |
| 2025-06-17 09:00:00 | AAPL | Stock | 197.45 | 197.6 | 197.0 | 197.09 | 95681.0 |
| 2025-06-17 09:30:00 | AAPL | Stock | 197.2 | 197.93 | 196.255 | 196.82 | 3876490.0 |
| 2025-06-17 10:00:00 | AAPL | Stock | 196.82 | 197.91 | 196.69 | 197.58 | 1776209.0 |
| 2025-06-17 10:30:00 | AAPL | Stock | 197.583 | 197.77 | 197.325 | 197.3801 | 1383691.0 |
| 2025-06-17 11:00:00 | AAPL | Stock | 197.38 | 197.79 | 197.345 | 197.58 | 1082303.0 |
| 2025-06-17 11:30:00 | AAPL | Stock | 197.59 | 198.39 | 197.515 | 197.785 | 1535551.0 |
| 2025-06-17 12:00:00 | AAPL | Stock | 197.785 | 198.15 | 197.46 | 197.61 | 1142170.0 |
| 2025-06-17 12:30:00 | AAPL | Stock | 197.61 | 197.8457 | 196.68 | 196.775 | 1245475.0 |
| 2025-06-17 13:00:00 | AAPL | Stock | 196.77 | 196.86 | 196.465 | 196.52 | 1272025.0 |
| 2025-06-17 13:30:00 | AAPL | Stock | 196.51 | 196.82 | 195.92 | 196.12 | 1530520.0 |
| 2025-06-17 14:00:00 | AAPL | Stock | 196.11 | 196.12 | 195.21 | 195.46 | 1461937.0 |
| 2025-06-17 14:30:00 | AAPL | Stock | 195.48 | 195.87 | 195.4203 | 195.84 | 1084870.0 |
| 2025-06-17 15:00:00 | AAPL | Stock | 195.85 | 195.94 | 195.49 | 195.83 | 1134091.0 |
| 2025-06-17 15:30:00 | AAPL | Stock | 195.84 | 195.885 | 195.441 | 195.64 | 3212730.0 |
| 2025-06-17 16:00:00 | AAPL | Stock | 195.65 | 195.9591 | 195.55 | 195.68 | 5540968.0 |
| 2025-06-17 16:30:00 | AAPL | Stock | 195.7 | 195.85 | 195.64 | 195.75 | 16585.0 |
| 2025-06-17 17:00:00 | AAPL | Stock | 195.7 | 195.72 | 195.65 | 195.7 | 16836.0 |
| 2025-06-17 17:30:00 | AAPL | Stock | 195.65 | 195.71 | 195.5 | 195.56 | 21183.0 |
| 2025-06-17 18:00:00 | AAPL | Stock | 195.56 | 195.6539 | 195.32 | 195.43 | 20354.0 |
| 2025-06-17 18:30:00 | AAPL | Stock | 195.47 | 195.486 | 195.2 | 195.2 | 24841.0 |
| 2025-06-17 19:00:00 | AAPL | Stock | 195.24 | 195.4 | 195.15 | 195.3 | 13942.0 |
| 2025-06-17 19:30:00 | AAPL | Stock | 195.24 | 195.3 | 195.112 | 195.15 | 32128.0 |
| 2025-06-17 04:00:00 | MSFT | Stock | 475.43 | 475.5 | 474.9 | 474.99 | 5875.0 |
| 2025-06-17 04:30:00 | MSFT | Stock | 475.0 | 475.08 | 474.25 | 474.85 | 13006.0 |
| 2025-06-17 05:00:00 | MSFT | Stock | 474.87 | 474.99 | 473.9 | 474.0 | 23548.0 |
| 2025-06-17 06:00:00 | MSFT | Stock | 474.44 | 474.44 | 473.68 | 473.68 | 3794.0 |
| 2025-06-17 06:30:00 | MSFT | Stock | 473.9 | 474.04 | 473.4 | 473.9 | 7944.0 |
| 2025-06-17 07:00:00 | MSFT | Stock | 473.9 | 474.8 | 473.8 | 474.5 | 18528.0 |
| 2025-06-17 07:30:00 | MSFT | Stock | 474.45 | 474.8 | 474.45 | 474.75 | 2775.0 |
| 2025-06-17 08:00:00 | MSFT | Stock | 474.01 | 477.22 | 473.87 | 475.75 | 33729.0 |
| 2025-06-17 08:30:00 | MSFT | Stock | 475.0 | 476.0 | 474.81 | 474.86 | 22434.0 |
| 2025-06-17 09:00:00 | MSFT | Stock | 474.8001 | 475.4999 | 474.609 | 475.49 | 30316.0 |
| 2025-06-17 09:30:00 | MSFT | Stock | 475.49 | 476.61 | 474.08 | 475.43 | 1181290.0 |
| 2025-06-17 10:00:00 | MSFT | Stock | 475.48 | 476.38 | 474.5 | 476.15 | 387953.0 |
| 2025-06-17 10:30:00 | MSFT | Stock | 476.122 | 476.175 | 475.46 | 475.855 | 279901.0 |
| 2025-06-17 11:00:00 | MSFT | Stock | 475.805 | 477.1 | 475.8 | 476.82 | 324852.0 |
| 2025-06-17 11:30:00 | MSFT | Stock | 476.85 | 477.98 | 476.7348 | 477.46 | 356401.0 |
| 2025-06-17 12:00:00 | MSFT | Stock | 477.39 | 478.08 | 477.0 | 477.68 | 323416.0 |
| 2025-06-17 12:30:00 | MSFT | Stock | 477.68 | 478.7399 | 477.0 | 477.245 | 337924.0 |
| 2025-06-17 13:00:00 | MSFT | Stock | 477.23 | 477.8 | 476.6 | 476.615 | 309745.0 |
> showing 50 of 104,881 rows — these rows as CSV