PREVIEW / stock_30min / 2025-11-17
file: by_date/stock_30min/2025/2025-11-17.parquet size: 2.2 MB rows: 104,581 symbols: 211
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-17 04:00:00 | AAPL | Stock | 272.89 | 272.89 | 271.79 | 271.8 | 21950.0 |
| 2025-11-17 04:30:00 | AAPL | Stock | 271.78 | 271.88 | 271.6 | 271.65 | 2589.0 |
| 2025-11-17 05:00:00 | AAPL | Stock | 271.55 | 271.7 | 271.48 | 271.51 | 5071.0 |
| 2025-11-17 05:30:00 | AAPL | Stock | 271.42 | 271.7 | 271.03 | 271.23 | 6797.0 |
| 2025-11-17 06:00:00 | AAPL | Stock | 271.2 | 271.73 | 271.2 | 271.51 | 4401.0 |
| 2025-11-17 06:30:00 | AAPL | Stock | 271.46 | 271.48 | 270.2 | 270.5 | 19138.0 |
| 2025-11-17 07:00:00 | AAPL | Stock | 270.5 | 270.5 | 269.62 | 269.7 | 25033.0 |
| 2025-11-17 07:30:00 | AAPL | Stock | 269.66 | 269.95 | 269.3 | 269.95 | 15107.0 |
| 2025-11-17 08:00:00 | AAPL | Stock | 270.1 | 273.0 | 269.0 | 269.26 | 131356.0 |
| 2025-11-17 08:30:00 | AAPL | Stock | 269.34 | 269.7449 | 268.88 | 269.69 | 61209.0 |
| 2025-11-17 09:00:00 | AAPL | Stock | 269.7 | 269.79 | 268.38 | 268.85 | 128471.0 |
| 2025-11-17 09:30:00 | AAPL | Stock | 268.83 | 270.49 | 267.0 | 270.04 | 5077886.0 |
| 2025-11-17 10:00:00 | AAPL | Stock | 270.01 | 270.32 | 268.8372 | 269.28 | 1651215.0 |
| 2025-11-17 10:30:00 | AAPL | Stock | 269.23 | 269.39 | 267.76 | 268.0 | 1608414.0 |
| 2025-11-17 11:00:00 | AAPL | Stock | 268.0 | 268.19 | 266.65 | 267.8799 | 1615270.0 |
| 2025-11-17 11:30:00 | AAPL | Stock | 267.86 | 269.55 | 267.82 | 269.52 | 1166049.0 |
| 2025-11-17 12:00:00 | AAPL | Stock | 269.51 | 269.52 | 268.67 | 268.92 | 713428.0 |
| 2025-11-17 12:30:00 | AAPL | Stock | 268.93 | 269.35 | 267.87 | 267.885 | 962266.0 |
| 2025-11-17 13:00:00 | AAPL | Stock | 267.93 | 268.12 | 267.44 | 267.78 | 781474.0 |
| 2025-11-17 13:30:00 | AAPL | Stock | 267.77 | 268.35 | 267.17 | 267.28 | 830537.0 |
| 2025-11-17 14:00:00 | AAPL | Stock | 267.27 | 267.505 | 266.86 | 267.29 | 1045708.0 |
| 2025-11-17 14:30:00 | AAPL | Stock | 267.295 | 267.38 | 265.844 | 265.86 | 987549.0 |
| 2025-11-17 15:00:00 | AAPL | Stock | 265.84 | 266.59 | 265.73 | 266.44 | 1488655.0 |
| 2025-11-17 15:30:00 | AAPL | Stock | 266.44 | 267.59 | 266.19 | 267.46 | 3471584.0 |
| 2025-11-17 16:00:00 | AAPL | Stock | 267.501 | 268.33 | 267.45 | 267.7 | 8592499.0 |
| 2025-11-17 16:30:00 | AAPL | Stock | 267.78 | 268.0 | 267.46 | 267.49 | 65599.0 |
| 2025-11-17 17:00:00 | AAPL | Stock | 267.9799 | 267.9799 | 267.6 | 267.74 | 4789.0 |
| 2025-11-17 17:30:00 | AAPL | Stock | 267.7378 | 267.7378 | 267.1936 | 267.2072 | 8146.0 |
| 2025-11-17 18:00:00 | AAPL | Stock | 267.46 | 268.0 | 267.2535 | 267.71 | 10838.0 |
| 2025-11-17 18:30:00 | AAPL | Stock | 267.8 | 267.9 | 267.55 | 267.67 | 8191.0 |
| 2025-11-17 19:00:00 | AAPL | Stock | 267.68 | 267.9 | 267.35 | 267.45 | 7056.0 |
| 2025-11-17 19:30:00 | AAPL | Stock | 267.36 | 267.69 | 267.06 | 267.69 | 27958.0 |
| 2025-11-17 04:00:00 | MSFT | Stock | 511.96 | 512.61 | 511.64 | 511.82 | 4382.0 |
| 2025-11-17 04:30:00 | MSFT | Stock | 511.84 | 511.84 | 510.61 | 510.61 | 3165.0 |
| 2025-11-17 05:00:00 | MSFT | Stock | 510.6 | 510.71 | 509.45 | 509.8 | 5383.0 |
| 2025-11-17 05:30:00 | MSFT | Stock | 509.73 | 509.74 | 508.57 | 508.57 | 1806.0 |
| 2025-11-17 06:00:00 | MSFT | Stock | 508.56 | 509.4 | 508.56 | 509.4 | 927.0 |
| 2025-11-17 06:30:00 | MSFT | Stock | 509.49 | 510.18 | 509.49 | 509.69 | 1100.0 |
| 2025-11-17 07:00:00 | MSFT | Stock | 509.66 | 509.81 | 508.9 | 509.68 | 3251.0 |
| 2025-11-17 07:30:00 | MSFT | Stock | 509.22 | 509.5 | 508.8 | 508.85 | 6867.0 |
| 2025-11-17 08:00:00 | MSFT | Stock | 509.6 | 513.0 | 508.0 | 508.54 | 42297.0 |
| 2025-11-17 08:30:00 | MSFT | Stock | 508.51 | 508.73 | 507.5 | 508.16 | 10526.0 |
| 2025-11-17 09:00:00 | MSFT | Stock | 508.43 | 509.0 | 507.5 | 508.0 | 19639.0 |
| 2025-11-17 09:30:00 | MSFT | Stock | 508.45 | 512.12 | 506.05 | 508.96 | 1883435.0 |
| 2025-11-17 10:00:00 | MSFT | Stock | 508.92 | 509.39 | 506.66 | 507.48 | 761767.0 |
| 2025-11-17 10:30:00 | MSFT | Stock | 507.4994 | 508.37 | 506.5845 | 507.625 | 500857.0 |
| 2025-11-17 11:00:00 | MSFT | Stock | 507.57 | 507.96 | 505.6 | 507.33 | 469667.0 |
| 2025-11-17 11:30:00 | MSFT | Stock | 507.32 | 510.25 | 507.23 | 510.185 | 427644.0 |
| 2025-11-17 12:00:00 | MSFT | Stock | 510.24 | 510.82 | 509.79 | 510.315 | 454424.0 |
| 2025-11-17 12:30:00 | MSFT | Stock | 510.33 | 510.53 | 508.17 | 508.235 | 319701.0 |
> showing 50 of 104,581 rows — these rows as CSV