jnj_dividend_years

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.

SELECT
    d.year                                                    AS year,
    d.payment_count                                           AS payment_count,
    round(d.gross, 2)                                         AS gross_dividend_usd,
    round(d.gross * 0.25, 2)                                  AS us_withholding_usd,
    round(d.gross - round(d.gross * 0.25, 2), 2)              AS net_credited_usd,
    round(d.gross / toFloat64(p.year_end_close) * 100, 2)     AS yield_on_year_end_close_pct
FROM
(
    SELECT
        toYear(ex_dividend_date)  AS year,
        count()                   AS payment_count,
        sum(dividend_usd)         AS gross
    FROM
    (
        SELECT
            ex_dividend_date,
            max(toFloat64(cash_amount)) AS dividend_usd
        FROM global_markets.stocks_dividends
        WHERE ticker = 'JNJ'
          AND ex_dividend_date >= toDate('2019-01-01')
          AND toYear(ex_dividend_date) < toYear(today())
        GROUP BY ex_dividend_date
    )
    GROUP BY year
) AS d
INNER JOIN
(
    SELECT
        toYear(date)          AS year,
        argMax(close, date)   AS year_end_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'JNJ'
      AND date >= toDate('2019-01-01')
      AND toYear(date) < toYear(today())
    GROUP BY year
) AS p ON p.year = d.year
ORDER BY d.year