PREVIEW / stock_30min / 2025-11-05
file: by_date/stock_30min/2025/2025-11-05.parquet size: 2.3 MB rows: 108,644 symbols: 218
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-11-05 04:00:00 | AAPL | Stock | 268.22 | 270.9 | 268.22 | 269.75 | 23532.0 |
| 2025-11-05 04:30:00 | AAPL | Stock | 269.96 | 270.1 | 269.705 | 269.91 | 4879.0 |
| 2025-11-05 05:00:00 | AAPL | Stock | 269.68 | 269.68 | 269.16 | 269.4 | 4659.0 |
| 2025-11-05 05:30:00 | AAPL | Stock | 269.31 | 269.31 | 268.7 | 268.7 | 5220.0 |
| 2025-11-05 06:00:00 | AAPL | Stock | 268.85 | 269.47 | 268.85 | 269.38 | 8786.0 |
| 2025-11-05 06:30:00 | AAPL | Stock | 269.4 | 269.81 | 269.38 | 269.81 | 4490.0 |
| 2025-11-05 07:00:00 | AAPL | Stock | 269.85 | 270.29 | 269.79 | 269.94 | 4037.0 |
| 2025-11-05 07:30:00 | AAPL | Stock | 269.91 | 269.97 | 269.72 | 269.87 | 5978.0 |
| 2025-11-05 08:00:00 | AAPL | Stock | 269.85 | 270.78 | 268.88 | 270.66 | 99918.0 |
| 2025-11-05 08:30:00 | AAPL | Stock | 270.66 | 270.7781 | 270.04 | 270.15 | 49149.0 |
| 2025-11-05 09:00:00 | AAPL | Stock | 270.19 | 270.19 | 268.39 | 268.61 | 90136.0 |
| 2025-11-05 09:30:00 | AAPL | Stock | 268.61 | 269.57 | 266.93 | 269.235 | 3501486.0 |
| 2025-11-05 10:00:00 | AAPL | Stock | 269.2 | 269.5899 | 268.555 | 269.0101 | 1399499.0 |
| 2025-11-05 10:30:00 | AAPL | Stock | 269.0 | 269.74 | 268.76 | 269.3709 | 972233.0 |
| 2025-11-05 11:00:00 | AAPL | Stock | 269.4 | 270.38 | 268.93 | 270.29 | 1074222.0 |
| 2025-11-05 11:30:00 | AAPL | Stock | 270.28 | 270.47 | 269.975 | 269.9909 | 735628.0 |
| 2025-11-05 12:00:00 | AAPL | Stock | 270.01 | 270.09 | 269.5 | 269.97 | 773911.0 |
| 2025-11-05 12:30:00 | AAPL | Stock | 269.98 | 270.79 | 269.93 | 270.54 | 697190.0 |
| 2025-11-05 13:00:00 | AAPL | Stock | 270.54 | 270.67 | 269.97 | 270.12 | 612330.0 |
| 2025-11-05 13:30:00 | AAPL | Stock | 270.12 | 270.35 | 269.82 | 270.065 | 562693.0 |
| 2025-11-05 14:00:00 | AAPL | Stock | 270.05 | 271.7 | 269.77 | 270.411 | 2001075.0 |
| 2025-11-05 14:30:00 | AAPL | Stock | 270.41 | 271.5 | 269.64 | 269.6664 | 1528521.0 |
| 2025-11-05 15:00:00 | AAPL | Stock | 269.65 | 270.0 | 269.525 | 269.6 | 736647.0 |
| 2025-11-05 15:30:00 | AAPL | Stock | 269.61 | 270.44 | 268.995 | 270.1 | 3819587.0 |
| 2025-11-05 16:00:00 | AAPL | Stock | 270.07 | 270.6729 | 269.03 | 270.23 | 10610415.0 |
| 2025-11-05 16:30:00 | AAPL | Stock | 270.19 | 270.53 | 270.14 | 270.3 | 20282.0 |
| 2025-11-05 17:00:00 | AAPL | Stock | 270.3401 | 270.53 | 270.25 | 270.3 | 6397.0 |
| 2025-11-05 17:30:00 | AAPL | Stock | 270.44 | 270.44 | 270.2 | 270.38 | 10831.0 |
| 2025-11-05 18:00:00 | AAPL | Stock | 270.2345 | 270.2518 | 269.89 | 270.13 | 10852.0 |
| 2025-11-05 18:30:00 | AAPL | Stock | 270.05 | 270.21 | 269.95 | 270.1071 | 4971.0 |
| 2025-11-05 19:00:00 | AAPL | Stock | 270.1071 | 270.27 | 268.8728 | 268.98 | 19281.0 |
| 2025-11-05 19:30:00 | AAPL | Stock | 269.23 | 269.86 | 269.11 | 269.85 | 5607.0 |
| 2025-11-05 04:00:00 | MSFT | Stock | 513.87 | 514.28 | 512.36 | 513.64 | 7880.0 |
| 2025-11-05 04:30:00 | MSFT | Stock | 513.49 | 513.97 | 513.31 | 513.73 | 4127.0 |
| 2025-11-05 05:00:00 | MSFT | Stock | 513.85 | 514.18 | 513.53 | 513.71 | 2201.0 |
| 2025-11-05 05:30:00 | MSFT | Stock | 513.53 | 513.53 | 512.56 | 512.56 | 2237.0 |
| 2025-11-05 06:00:00 | MSFT | Stock | 512.48 | 513.67 | 512.4 | 512.86 | 6607.0 |
| 2025-11-05 06:30:00 | MSFT | Stock | 513.34 | 513.7 | 512.95 | 513.65 | 3373.0 |
| 2025-11-05 07:00:00 | MSFT | Stock | 513.63 | 514.28 | 513.32 | 513.56 | 5420.0 |
| 2025-11-05 07:30:00 | MSFT | Stock | 513.65 | 514.21 | 513.13 | 513.74 | 5732.0 |
| 2025-11-05 08:00:00 | MSFT | Stock | 513.67 | 514.45 | 512.29 | 513.95 | 27107.0 |
| 2025-11-05 08:30:00 | MSFT | Stock | 514.25 | 514.76 | 513.66 | 514.29 | 40893.0 |
| 2025-11-05 09:00:00 | MSFT | Stock | 514.24 | 514.76 | 512.63 | 513.4 | 50309.0 |
| 2025-11-05 09:30:00 | MSFT | Stock | 513.3 | 513.55 | 511.1 | 512.07 | 1658056.0 |
| 2025-11-05 10:00:00 | MSFT | Stock | 511.85 | 514.83 | 511.25 | 514.25 | 1077843.0 |
| 2025-11-05 10:30:00 | MSFT | Stock | 514.28 | 514.315 | 510.47 | 510.515 | 930094.0 |
| 2025-11-05 11:00:00 | MSFT | Stock | 510.5 | 511.09 | 508.75 | 510.09 | 1156456.0 |
| 2025-11-05 11:30:00 | MSFT | Stock | 510.06 | 510.1 | 508.22 | 509.055 | 1117283.0 |
| 2025-11-05 12:00:00 | MSFT | Stock | 509.08 | 509.56 | 508.3 | 508.74 | 722967.0 |
| 2025-11-05 12:30:00 | MSFT | Stock | 508.7599 | 509.5699 | 508.49 | 508.76 | 634489.0 |
> showing 50 of 108,644 rows — these rows as CSV