Dividend cash paid on 100 shares over the trailing year

Name: Dividend cash paid on 100 shares over the trailing year
Creator: Strasmore
Published: 2026-08-22
License: https://www.strasmore.com/terms/

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-22, from Poor Man's Covered Call: How the Trade Works.

as of 2026-08-22 ranking 6×3read in context →

Dividend cash paid on 100 shares over the trailing year — 6 rows by 3 columns, computed 2026-08-22 from US exchange, SIP and OPRA data.
symbol	annual_cash_on_100_shares	payment_count
SPY	752.5	4
JNJ	524	4
XOM	412	4
MSFT	364	4
KO	208	4
AAPL	106	4

Rows × columns: 6 × 3
Computed: 2026-08-22
Completeness: No missing values
Source: US exchange, SIP and OPRA market data
Licence: Strasmore terms · free, no signup
Formats: JSON · CSV · the SQL below

What each column holds

Column definitions for Dividend cash paid on 100 shares over the trailing year, derived from the stored result.
Column	Type	Range	Notes
`symbol`	text	6 distinct values (AAPL, JNJ, KO…)
`annual_cash_on_100_shares`	number	106 to 752.5	count
`payment_count`	number	every row is 4	count

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on 2026-08-22, and the query below is what returned them.

the exact SQL behind every number

SELECT
    ticker                                   AS symbol,
    round(sum(toFloat64(cash_amount)) * 100, 2) AS annual_cash_on_100_shares,
    count()                                  AS payment_count
FROM
(
    SELECT
        ticker,
        id,
        any(cash_amount) AS cash_amount
    FROM global_markets.stocks_dividends
    WHERE ticker IN ('AAPL', 'MSFT', 'KO', 'JNJ', 'XOM', 'SPY')
      AND ex_dividend_date >= today() - 365
      AND ex_dividend_date <= today()
    GROUP BY ticker, id
)
GROUP BY ticker
ORDER BY annual_cash_on_100_shares DESC

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.