Twelve months of dividends a short seller owes, per share

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 divs AS
(
    SELECT
        ticker,
        sum(cash_amount) AS ttm_cash,
        count()          AS payments
    FROM
    (
        SELECT DISTINCT
            ticker,
            ex_dividend_date,
            cash_amount
        FROM global_markets.stocks_dividends
        WHERE ticker IN ('KO', 'T', 'PFE', 'XOM', 'F', 'MSFT', 'AAPL', 'JNJ')
          AND ex_dividend_date >= '2025-10-01'
          AND ex_dividend_date <  '2026-10-01'
          AND cash_amount > 0
    )
    GROUP BY ticker
),
px AS
(
    SELECT
        ticker,
        argMax(toFloat64(close), date) AS last_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('KO', 'T', 'PFE', 'XOM', 'F', 'MSFT', 'AAPL', 'JNJ')
      AND date >= '2026-09-01'
    GROUP BY ticker
)
SELECT
    divs.ticker                                   AS ticker,
    round(divs.ttm_cash, 2)                       AS ttm_dividends_usd,
    round(divs.ttm_cash / px.last_close * 100, 2) AS ttm_dividend_pct_of_price,
    divs.payments                                 AS payment_count
FROM divs
INNER JOIN px ON px.ticker = divs.ticker
ORDER BY ttm_dividend_pct_of_price DESC