对每只股票,求除 ticker 和 date 以外每一列的最大值。
- 最大值忽略 null;某只股票某列全为 null 时,结果为 null。
- 输出的列名与原列名相同。
考点:用一个表达式对“除某几列以外的所有列”批量求聚合,不逐列手写。判题只看结果。
输入
prices(ticker, date, open, high, low, close, volume)
输出
列为 ticker, open, high, low, close, volume,每只股票一行,行顺序不限。
对每只股票,求除 ticker 和 date 以外每一列的最大值。
考点:用一个表达式对“除某几列以外的所有列”批量求聚合,不逐列手写。判题只看结果。
输入
prices(ticker, date, open, high, low, close, volume)输出
列为 ticker, open, high, low, close, volume,每只股票一行,行顺序不限。
prices stocks/prices
| # | tickerstring | datedate | openfloat64 | highfloat64 | lowfloat64 | closefloat64 | volumeint64 |
|---|---|---|---|---|---|---|---|
| 1 | AAPL | 2026-06-01 | 189.58 | 190.97 | 188.93 | 190.66 | 7374313 |
| 2 | AAPL | 2026-06-02 | 191.71 | 195.6 | 191.42 | 194.12 | 1753601 |
| 3 | AAPL | 2026-06-03 | 194.95 | 196.13 | 193.04 | 193.67 | 2817746 |
| 4 | AAPL | 2026-06-04 | 194.03 | 194.88 | 187.39 | 189.08 | 2783341 |
| 5 | AAPL | 2026-06-05 | 189.72 | 193.66 | 189.02 | 193.14 | 8942829 |
| 6 | AAPL | 2026-06-08 | 192.9 | 193.62 | 188.21 | 188.64 | 1357786 |
| 7 | AAPL | 2026-06-09 | 188.63 | 189.8 | 185.9 | 188.98 | 5482117 |
| 8 | AAPL | 2026-06-10 | 189.78 | 191.79 | 188.78 | 191.45 | 1430484 |
| 9 | AAPL | 2026-06-11 | 191.12 | 193.18 | 190.85 | 192.68 | 7642427 |
| 10 | AAPL | 2026-06-12 | 191.04 | 193.87 | 190.02 | 193.37 | 2476587 |
| 11 | AAPL | 2026-06-15 | 193.53 | 195.45 | 193.24 | 193.68 | 1680820 |
| 12 | AAPL | 2026-06-16 | 194.69 | 195.53 | 192.04 | 193.09 | 4196575 |
| 13 | AAPL | 2026-06-17 | 192.64 | 196.25 | 191.03 | 195.73 | 1464728 |
| 14 | AAPL | 2026-06-18 | 195.19 | 196.94 | 192.23 | 192.74 | 2059908 |
| 15 | AAPL | 2026-06-19 | 192.02 | 196.01 | 191.78 | 195.55 | 8247165 |
| 16 | AAPL | 2026-06-22 | 195.28 | 196.64 | 188.45 | null | 2043265 |
| 17 | AAPL | 2026-06-23 | 190.64 | 191.82 | 190.11 | 191.55 | 2220638 |
| 18 | AAPL | 2026-06-24 | 192.95 | 193.43 | 189.2 | 190.21 | 2962146 |
| 19 | AAPL | 2026-06-25 | 190.43 | 190.7 | 188.71 | 189.26 | 1607246 |
| 20 | AAPL | 2026-06-26 | 189.15 | 189.58 | 188.4 | 189.15 | 4162289 |
| # | tickerString | openFloat64 | highFloat64 | lowFloat64 | closeFloat64 | volumeInt64 |
|---|---|---|---|---|---|---|
| 1 | AAPL | 195.56 | 198.51 | 194.25 | 197.47 | 8942829 |
| 2 | MSFT | 478.56 | 486.14 | 476.23 | 480.28 | 8797054 |
| 3 | BABA | 106.35 | 106.9 | 106.11 | 106.36 | 8451685 |
| 4 | NVDA | 139.4 | 140.25 | 136.78 | 138.98 | 8931164 |
| 5 | TSLA | 240.25 | 241.26 | 236.16 | 237.03 | 8844171 |