yields

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.ticker                                          AS ticker,
    round(d.gross_dps, 2)                             AS gross_dps_usd,
    round(d.gross_dps * 0.75, 2)                      AS net_dps_usd,
    round(100 * d.gross_dps / p.last_close, 2)        AS gross_yield_pct,
    round(100 * d.gross_dps * 0.75 / p.last_close, 2) AS net_yield_pct
FROM
(
    SELECT
        ticker,
        sum(amount) AS gross_dps
    FROM
    (
        SELECT
            ticker,
            any(toFloat64(cash_amount)) AS amount,
            any(ex_dividend_date)       AS ex_date
        FROM global_markets.stocks_dividends
        WHERE ticker IN ('JNJ', 'KO', 'PG', 'MSFT', 'ABBV', 'CVX')
          AND ex_dividend_date <= today()
          AND ex_dividend_date >  today() - 420
        GROUP BY ticker, id
        ORDER BY ex_date DESC
        LIMIT 4 BY ticker
    )
    GROUP BY ticker
) AS d
INNER JOIN
(
    SELECT
        ticker,
        toFloat64(argMax(close, date)) AS last_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('JNJ', 'KO', 'PG', 'MSFT', 'ABBV', 'CVX')
      AND date > today() - 30
    GROUP BY ticker
) AS p ON p.ticker = d.ticker
ORDER BY gross_yield_pct DESC