dividend_history

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 payments AS
(
    SELECT
        ticker,
        ex_dividend_date,
        max(toFloat64(cash_amount)) AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('ABBV', 'PFE')
      AND currency = 'USD'
      AND ex_dividend_date >= '2023-01-01'
      AND ex_dividend_date <  '2026-10-01'
    GROUP BY ticker, ex_dividend_date
)
SELECT
    formatDateTime(toStartOfQuarter(ex_dividend_date), '%Y-%m')                              AS month,
    any(concat('Q', toString(toQuarter(ex_dividend_date)), ' ', toString(toYear(ex_dividend_date)))) AS quarter_label,
    round(sumIf(amount, ticker = 'ABBV'), 4)                                                 AS abbv_usd,
    round(sumIf(amount, ticker = 'PFE'), 4)                                                  AS pfe_usd
FROM payments
GROUP BY month
HAVING abbv_usd > 0 AND pfe_usd > 0
ORDER BY month