yield_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 yearly AS
(
    SELECT
        toYear(date)                   AS year,
        argMin(toFloat64(close), date) AS first_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'SPY'
      AND date >= '2005-01-01'
      AND date <  '2026-01-01'
    GROUP BY year
),
cash AS
(
    SELECT
        toYear(ex_date) AS year,
        sum(cash)       AS cash_paid,
        count()         AS payments
    FROM
    (
        SELECT
            ex_dividend_date            AS ex_date,
            max(toFloat64(cash_amount)) AS cash
        FROM global_markets.stocks_dividends
        WHERE ticker = 'SPY'
          AND ex_dividend_date >= '2005-01-01'
          AND ex_dividend_date <  '2026-01-01'
          AND cash_amount > 0
        GROUP BY ex_dividend_date
    )
    GROUP BY year
    HAVING payments >= 4
)
SELECT
    y.year                                      AS year,
    round(100 * c.cash_paid / y.first_close, 2) AS dividend_yield_pct
FROM yearly AS y
INNER JOIN cash AS c ON c.year = y.year
ORDER BY year