dividends_by_year

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 divs AS
(
    SELECT
        ticker,
        toYear(ex_dividend_date)    AS year,
        sum(toFloat64(cash_amount)) AS dps
    FROM
    (
        SELECT
            ticker,
            ex_dividend_date,
            any(cash_amount) AS cash_amount
        FROM global_markets.stocks_dividends
        WHERE ticker IN ('QQQ', 'SPY')
          AND ex_dividend_date >= '2021-01-01'
          AND ex_dividend_date <= today()
        GROUP BY ticker, ex_dividend_date
    )
    GROUP BY ticker, year
),
px AS
(
    SELECT
        ticker,
        toYear(date)                   AS year,
        toFloat64(argMax(close, date)) AS last_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('QQQ', 'SPY')
      AND date >= '2021-01-01'
    GROUP BY ticker, year
)
SELECT
    d.year                                                                                 AS year,
    round(sumIf(d.dps, d.ticker = 'QQQ'), 2)                                               AS qqq_dividends_per_share,
    round(sumIf(d.dps, d.ticker = 'QQQ') / maxIf(p.last_close, p.ticker = 'QQQ') * 100, 2) AS qqq_yield_pct,
    round(sumIf(d.dps, d.ticker = 'SPY') / maxIf(p.last_close, p.ticker = 'SPY') * 100, 2) AS spy_yield_pct
FROM divs AS d
INNER JOIN px AS p ON p.ticker = d.ticker AND p.year = d.year
GROUP BY year
ORDER BY year