Which month Altria and PMI announce their dividend raises

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH paid AS
(
    SELECT
        ticker,
        ex_dividend_date      AS ex_date,
        max(declaration_date) AS declared,
        max(cash_amount)      AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('MO', 'PM')
      AND ex_dividend_date >= toDate('2008-04-01')
    GROUP BY ticker, ex_dividend_date
),
steps AS
(
    SELECT
        ticker,
        declared,
        amount,
        lagInFrame(amount) OVER (PARTITION BY ticker ORDER BY ex_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS prior
    FROM paid
),
by_month AS
(
    SELECT
        ticker,
        monthName(declared) AS announced_in,
        count()             AS raises
    FROM steps
    WHERE prior > 0
      AND amount > prior
      AND declared > toDate('2000-01-01')
    GROUP BY ticker, announced_in
)
SELECT
    ticker,
    argMax(announced_in, raises)               AS busiest_month,
    max(raises)                                AS raises_in_busiest_month,
    sum(raises)                                AS raises_since_2008,
    round(100 * max(raises) / sum(raises), 1)  AS share_pct
FROM by_month
GROUP BY ticker
ORDER BY ticker