div_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 dedup AS
(
    SELECT
        ex_dividend_date,
        toFloat64(any(cash_amount)) AS amount
    FROM global_markets.stocks_dividends
    WHERE ticker = 'QQQ'
      AND ex_dividend_date >= '2016-01-01'
      AND ex_dividend_date <  toStartOfYear(today())
    GROUP BY ex_dividend_date
),
by_year AS
(
    SELECT
        toYear(ex_dividend_date) AS yr,
        sum(amount)              AS gross
    FROM dedup
    GROUP BY yr
),
year_close AS
(
    SELECT
        toYear(date)                   AS yr,
        toFloat64(argMax(close, date)) AS last_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'QQQ'
      AND date >= '2016-01-01'
      AND date <  toStartOfYear(today())
    GROUP BY yr
)
SELECT
    toString(b.yr)                         AS year,
    round(b.gross, 4)                      AS gross_usd,
    round(b.gross * 0.85, 4)               AS after_withholding_usd,
    round(100 * b.gross / c.last_close, 2) AS yield_pct
FROM by_year AS b
INNER JOIN year_close AS c ON b.yr = c.yr
ORDER BY b.yr