Increases, cuts and the typical raise this calendar year, by company size (bands use today's market value)

WITH universe AS (
    SELECT ticker, argMax(market_cap, date) AS mcap
    FROM global_markets.stocks_ratios
    WHERE date >= today() - 10 AND market_cap > 0
    GROUP BY ticker
),
regular AS (
    SELECT ticker,
           ex_dividend_date,
           max(declaration_date) AS declared_on,
           argMax(cash_amount, declaration_date) AS amt,
           argMax(frequency, declaration_date) AS freq
    FROM global_markets.stocks_dividends
    WHERE distribution_type = 'recurring'
      AND cash_amount > 0
      AND currency = 'USD'
      AND frequency IN (1, 2, 4, 12)
      AND ex_dividend_date >= today() - 1200
      AND ticker NOT IN ('SPCX')
    GROUP BY ticker, ex_dividend_date
),
seq AS (
    SELECT ticker, ex_dividend_date, declared_on, amt, freq,
           lagInFrame(amt) OVER w AS prev_amt,
           lagInFrame(freq) OVER w AS prev_freq,
           lagInFrame(ex_dividend_date) OVER w AS prev_ex
    FROM regular
    WINDOW w AS (PARTITION BY ticker ORDER BY ex_dividend_date ASC ROWS BETWEEN 1 PRECEDING AND CURRENT ROW)
),
splits AS (
    SELECT ticker, groupArray(execution_date) AS split_dates
    FROM global_markets.stocks_splits
    WHERE execution_date >= today() - 1300
    GROUP BY ticker
),
changes AS (
    SELECT s.ticker AS ticker,
           s.declared_on AS declared_on,
           s.amt / s.prev_amt - 1 AS chg,
           u.mcap AS mcap
    FROM seq s
    INNER JOIN universe u ON u.ticker = s.ticker
    LEFT JOIN splits sp ON sp.ticker = s.ticker
    WHERE s.declared_on >= toStartOfYear(today())
      AND s.declared_on <= today()
      AND s.prev_amt > 0
      AND s.freq = s.prev_freq
      AND arrayCount(x -> x > s.prev_ex, sp.split_dates) = 0
      AND dateDiff('day', s.prev_ex, s.ex_dividend_date) BETWEEN intDiv(240, s.freq) AND intDiv(520, s.freq)
)
SELECT multiIf(mcap >= 1e11, 'Mega cap ($100B and up)',
               mcap >= 1e10, 'Large cap ($10B to $100B)',
               mcap >= 2e9,  'Mid cap ($2B to $10B)',
                             'Small cap (under $2B)') AS size_band,
       count() AS declarations,
       countIf(chg > 0.001) AS increases,
       countIf(chg < -0.005) AS cuts,
       round(100 * countIf(chg < -0.005) / count(), 1) AS cut_share_pct,
       round(100 * quantileDeterministicIf(0.5)(chg, cityHash64(ticker, declared_on), chg > 0.001), 1) AS median_raise_pct
FROM changes
GROUP BY size_band
HAVING countIf(chg > 0.001) > 0
ORDER BY max(mcap) DESC