PREVIEW / stock_30min / 2025-09-26
file: by_date/stock_30min/2025/2025-09-26.parquet size: 2.2 MB rows: 106,535 symbols: 303
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-09-26 04:00:00 | AAPL | Stock | 256.0 | 256.29 | 255.69 | 255.69 | 6898.0 |
| 2025-09-26 04:30:00 | AAPL | Stock | 255.72 | 255.72 | 255.4 | 255.52 | 3799.0 |
| 2025-09-26 05:00:00 | AAPL | Stock | 255.48 | 256.15 | 255.41 | 255.95 | 7646.0 |
| 2025-09-26 05:30:00 | AAPL | Stock | 255.9 | 256.08 | 255.76 | 255.98 | 9851.0 |
| 2025-09-26 06:00:00 | AAPL | Stock | 256.11 | 256.48 | 255.98 | 256.04 | 31338.0 |
| 2025-09-26 06:30:00 | AAPL | Stock | 256.14 | 256.14 | 255.67 | 255.89 | 4829.0 |
| 2025-09-26 07:00:00 | AAPL | Stock | 256.0 | 256.19 | 254.46 | 254.46 | 56723.0 |
| 2025-09-26 07:30:00 | AAPL | Stock | 254.43 | 255.0 | 253.59 | 254.5 | 80839.0 |
| 2025-09-26 08:00:00 | AAPL | Stock | 256.19 | 256.7 | 253.59 | 254.86 | 153237.0 |
| 2025-09-26 08:30:00 | AAPL | Stock | 254.79 | 255.3809 | 254.25 | 254.42 | 88891.0 |
| 2025-09-26 09:00:00 | AAPL | Stock | 254.37 | 254.83 | 253.78 | 254.03 | 121066.0 |
| 2025-09-26 09:30:00 | AAPL | Stock | 254.18 | 256.34 | 253.78 | 256.2886 | 5502456.0 |
| 2025-09-26 10:00:00 | AAPL | Stock | 256.265 | 256.6 | 254.34 | 255.02 | 2784531.0 |
| 2025-09-26 10:30:00 | AAPL | Stock | 255.02 | 255.68 | 254.57 | 255.025 | 1867409.0 |
| 2025-09-26 11:00:00 | AAPL | Stock | 255.02 | 256.0 | 254.92 | 255.9701 | 1710569.0 |
| 2025-09-26 11:30:00 | AAPL | Stock | 255.97 | 256.04 | 254.86 | 255.06 | 1411232.0 |
| 2025-09-26 12:00:00 | AAPL | Stock | 255.07 | 255.71 | 254.92 | 255.665 | 1121592.0 |
| 2025-09-26 12:30:00 | AAPL | Stock | 255.66 | 256.4 | 255.48 | 256.34 | 986779.0 |
| 2025-09-26 13:00:00 | AAPL | Stock | 256.33 | 256.98 | 256.2 | 256.52 | 1283452.0 |
| 2025-09-26 13:30:00 | AAPL | Stock | 256.52 | 257.6 | 255.86 | 256.1 | 1802475.0 |
| 2025-09-26 14:00:00 | AAPL | Stock | 256.09 | 256.78 | 256.04 | 256.56 | 1172050.0 |
| 2025-09-26 14:30:00 | AAPL | Stock | 256.565 | 256.7299 | 255.9655 | 256.2 | 891465.0 |
| 2025-09-26 15:00:00 | AAPL | Stock | 256.2 | 256.22 | 255.49 | 255.645 | 1173772.0 |
| 2025-09-26 15:30:00 | AAPL | Stock | 255.64 | 255.6498 | 254.9 | 255.46 | 3327813.0 |
| 2025-09-26 16:00:00 | AAPL | Stock | 255.46 | 255.8685 | 255.35 | 255.6599 | 6113460.0 |
| 2025-09-26 16:30:00 | AAPL | Stock | 255.66 | 255.75 | 255.46 | 255.64 | 23952.0 |
| 2025-09-26 17:00:00 | AAPL | Stock | 255.62 | 255.75 | 255.6 | 255.62 | 9257.0 |
| 2025-09-26 17:30:00 | AAPL | Stock | 255.63 | 255.72 | 255.5017 | 255.5085 | 11139.0 |
| 2025-09-26 18:00:00 | AAPL | Stock | 255.55 | 255.5665 | 255.5 | 255.51 | 9174.0 |
| 2025-09-26 18:30:00 | AAPL | Stock | 255.5362 | 255.5632 | 255.5 | 255.5 | 3481.0 |
| 2025-09-26 19:00:00 | AAPL | Stock | 255.5 | 255.54 | 255.45 | 255.49 | 6767.0 |
| 2025-09-26 19:30:00 | AAPL | Stock | 255.4603 | 255.5325 | 255.45 | 255.49 | 5252.0 |
| 2025-09-26 04:00:00 | MSFT | Stock | 508.5 | 509.59 | 508.0 | 509.4 | 9034.0 |
| 2025-09-26 04:30:00 | MSFT | Stock | 509.76 | 510.15 | 509.74 | 509.87 | 3060.0 |
| 2025-09-26 05:00:00 | MSFT | Stock | 509.11 | 510.51 | 509.11 | 510.3 | 2726.0 |
| 2025-09-26 05:30:00 | MSFT | Stock | 510.21 | 510.3 | 509.5 | 509.5 | 3791.0 |
| 2025-09-26 06:00:00 | MSFT | Stock | 509.61 | 509.9 | 509.49 | 509.9 | 1180.0 |
| 2025-09-26 06:30:00 | MSFT | Stock | 509.7 | 510.78 | 509.5 | 509.77 | 4710.0 |
| 2025-09-26 07:00:00 | MSFT | Stock | 509.25 | 509.9 | 509.25 | 509.61 | 1629.0 |
| 2025-09-26 07:30:00 | MSFT | Stock | 509.73 | 510.29 | 509.43 | 510.0 | 3533.0 |
| 2025-09-26 08:00:00 | MSFT | Stock | 509.5 | 510.55 | 506.15 | 509.0501 | 18572.0 |
| 2025-09-26 08:30:00 | MSFT | Stock | 509.59 | 512.0 | 509.59 | 510.85 | 28454.0 |
| 2025-09-26 09:00:00 | MSFT | Stock | 510.67 | 511.15 | 509.7 | 509.75 | 26205.0 |
| 2025-09-26 09:30:00 | MSFT | Stock | 510.06 | 513.94 | 508.0 | 512.67 | 1742930.0 |
| 2025-09-26 10:00:00 | MSFT | Stock | 512.75 | 512.9245 | 507.18 | 508.335 | 710067.0 |
| 2025-09-26 10:30:00 | MSFT | Stock | 508.335 | 508.82 | 506.89 | 507.69 | 461683.0 |
| 2025-09-26 11:00:00 | MSFT | Stock | 507.705 | 508.2 | 506.62 | 508.07 | 304121.0 |
| 2025-09-26 11:30:00 | MSFT | Stock | 508.13 | 508.24 | 506.75 | 506.86 | 254514.0 |
| 2025-09-26 12:00:00 | MSFT | Stock | 506.8 | 508.74 | 506.67 | 508.27 | 244144.0 |
| 2025-09-26 12:30:00 | MSFT | Stock | 508.27 | 509.21 | 508.1401 | 509.025 | 235871.0 |
> showing 50 of 106,535 rows — these rows as CSV