PREVIEW / stock_30min / 2025-07-28
file: by_date/stock_30min/2025/2025-07-28.parquet size: 2.3 MB rows: 108,920 symbols: 364
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-28 04:00:00 | AAPL | Stock | 214.72 | 214.75 | 214.3 | 214.43 | 13515.0 |
| 2025-07-28 04:30:00 | AAPL | Stock | 214.47 | 214.51 | 214.45 | 214.5 | 5238.0 |
| 2025-07-28 05:00:00 | AAPL | Stock | 214.5 | 214.54 | 214.33 | 214.4 | 4891.0 |
| 2025-07-28 05:30:00 | AAPL | Stock | 214.42 | 214.49 | 214.41 | 214.48 | 1599.0 |
| 2025-07-28 06:00:00 | AAPL | Stock | 214.51 | 214.58 | 214.41 | 214.45 | 5222.0 |
| 2025-07-28 06:30:00 | AAPL | Stock | 214.45 | 214.7 | 214.3 | 214.3 | 5831.0 |
| 2025-07-28 07:00:00 | AAPL | Stock | 214.39 | 214.5 | 214.28 | 214.4 | 15408.0 |
| 2025-07-28 07:30:00 | AAPL | Stock | 214.35 | 214.45 | 214.27 | 214.32 | 16248.0 |
| 2025-07-28 08:00:00 | AAPL | Stock | 214.44 | 214.93 | 213.346 | 214.34 | 82671.0 |
| 2025-07-28 08:30:00 | AAPL | Stock | 214.32 | 214.39 | 214.27 | 214.3588 | 23433.0 |
| 2025-07-28 09:00:00 | AAPL | Stock | 214.34 | 214.36 | 213.88 | 214.0 | 80011.0 |
| 2025-07-28 09:30:00 | AAPL | Stock | 214.0 | 214.67 | 213.58 | 213.9 | 3546870.0 |
| 2025-07-28 10:00:00 | AAPL | Stock | 213.93 | 214.74 | 213.86 | 214.52 | 2350656.0 |
| 2025-07-28 10:30:00 | AAPL | Stock | 214.535 | 214.845 | 214.395 | 214.42 | 1592287.0 |
| 2025-07-28 11:00:00 | AAPL | Stock | 214.435 | 214.55 | 214.12 | 214.435 | 1338822.0 |
| 2025-07-28 11:30:00 | AAPL | Stock | 214.44 | 214.6 | 214.35 | 214.43 | 1043600.0 |
| 2025-07-28 12:00:00 | AAPL | Stock | 214.435 | 214.75 | 214.29 | 214.54 | 976395.0 |
| 2025-07-28 12:30:00 | AAPL | Stock | 214.535 | 214.5799 | 214.225 | 214.33 | 814351.0 |
| 2025-07-28 13:00:00 | AAPL | Stock | 214.34 | 214.45 | 213.415 | 213.645 | 1462067.0 |
| 2025-07-28 13:30:00 | AAPL | Stock | 213.635 | 214.02 | 213.62 | 213.735 | 797630.0 |
| 2025-07-28 14:00:00 | AAPL | Stock | 213.735 | 213.983 | 213.6703 | 213.8 | 850187.0 |
| 2025-07-28 14:30:00 | AAPL | Stock | 213.82 | 213.83 | 213.06 | 213.12 | 1452269.0 |
| 2025-07-28 15:00:00 | AAPL | Stock | 213.14 | 213.4364 | 213.06 | 213.43 | 1579755.0 |
| 2025-07-28 15:30:00 | AAPL | Stock | 213.42 | 214.1 | 213.32 | 214.04 | 3186945.0 |
| 2025-07-28 16:00:00 | AAPL | Stock | 214.03 | 214.1 | 213.85 | 213.85 | 4490777.0 |
| 2025-07-28 16:30:00 | AAPL | Stock | 213.86 | 214.0 | 213.85 | 213.9 | 16178.0 |
| 2025-07-28 17:00:00 | AAPL | Stock | 214.0 | 214.05 | 213.9 | 213.98 | 14950.0 |
| 2025-07-28 17:30:00 | AAPL | Stock | 213.96 | 213.98 | 213.9 | 213.9 | 5984.0 |
| 2025-07-28 18:00:00 | AAPL | Stock | 213.92 | 214.08 | 213.92 | 214.05 | 9463.0 |
| 2025-07-28 18:30:00 | AAPL | Stock | 214.05 | 214.28 | 214.0 | 214.27 | 12000.0 |
| 2025-07-28 19:00:00 | AAPL | Stock | 214.1301 | 214.2 | 214.12 | 214.12 | 12732.0 |
| 2025-07-28 19:30:00 | AAPL | Stock | 214.12 | 214.15 | 214.11 | 214.1106 | 10738.0 |
| 2025-07-28 04:00:00 | MSFT | Stock | 516.51 | 516.51 | 515.11 | 515.4 | 5048.0 |
| 2025-07-28 04:30:00 | MSFT | Stock | 515.89 | 515.89 | 515.49 | 515.49 | 1182.0 |
| 2025-07-28 05:00:00 | MSFT | Stock | 515.75 | 515.8 | 515.48 | 515.48 | 1462.0 |
| 2025-07-28 06:00:00 | MSFT | Stock | 515.2 | 515.2 | 514.7 | 514.76 | 10919.0 |
| 2025-07-28 06:30:00 | MSFT | Stock | 514.71 | 514.72 | 514.4 | 514.4 | 977.0 |
| 2025-07-28 07:00:00 | MSFT | Stock | 514.34 | 515.0 | 514.17 | 514.5 | 8276.0 |
| 2025-07-28 07:30:00 | MSFT | Stock | 514.5 | 515.0 | 514.3 | 515.0 | 5806.0 |
| 2025-07-28 08:00:00 | MSFT | Stock | 514.34 | 516.55 | 512.426 | 514.74 | 34981.0 |
| 2025-07-28 08:30:00 | MSFT | Stock | 514.7 | 515.98 | 514.5001 | 515.56 | 15986.0 |
| 2025-07-28 09:00:00 | MSFT | Stock | 515.5 | 515.6 | 514.01 | 514.14 | 11313.0 |
| 2025-07-28 09:30:00 | MSFT | Stock | 514.22 | 514.77 | 512.36 | 514.69 | 1201654.0 |
| 2025-07-28 10:00:00 | MSFT | Stock | 514.695 | 515.0 | 513.31 | 514.08 | 604219.0 |
| 2025-07-28 10:30:00 | MSFT | Stock | 514.12 | 514.24 | 512.21 | 512.775 | 433088.0 |
| 2025-07-28 11:00:00 | MSFT | Stock | 512.73 | 512.7499 | 511.555 | 512.658 | 425650.0 |
| 2025-07-28 11:30:00 | MSFT | Stock | 512.655 | 512.84 | 512.0 | 512.36 | 274361.0 |
| 2025-07-28 12:00:00 | MSFT | Stock | 512.365 | 512.4893 | 511.72 | 512.12 | 273584.0 |
| 2025-07-28 12:30:00 | MSFT | Stock | 512.14 | 512.44 | 511.88 | 512.16 | 209426.0 |
| 2025-07-28 13:00:00 | MSFT | Stock | 512.16 | 512.41 | 511.11 | 511.165 | 271239.0 |
> showing 50 of 108,920 rows — these rows as CSV