dividends_since_peak

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.ex_date                                                   AS ex_date,
    formatDateTime(d.ex_date, '%d/%m/%Y')                       AS ex_date_label,
    round(d.dividend_per_share, 3)                              AS dividend_per_share,
    round(a.close_on_ex_date, 2)                                AS close_on_ex_date,
    round(d.dividend_per_share / a.close_on_ex_date * 100, 3)   AS quarterly_yield_pct
FROM
(
    SELECT
        toDate(ex_dividend_date)        AS ex_date,
        max(toFloat64(cash_amount))     AS dividend_per_share
    FROM global_markets.stocks_dividends
    WHERE ticker = 'NKE'
      AND ex_dividend_date <= today()
      AND ex_dividend_date >
      (
          SELECT argMax(date, toFloat64(close))
          FROM global_markets.stocks_daily_aggs
          WHERE ticker = 'NKE'
            AND date >= '2016-01-01'
      )
    GROUP BY ex_date
) AS d
INNER JOIN
(
    SELECT
        toDate(date)           AS session_date,
        toFloat64(any(close))  AS close_on_ex_date
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'NKE'
      AND date >= '2021-01-01'
    GROUP BY session_date
) AS a ON a.session_date = d.ex_date
ORDER BY d.ex_date