STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Poor Man's Covered Call: How the Trade Works
Dividend cash paid on 100 shares over the trailing yearranking · 2026-09-26 · 6×3Preview: 6 ranked values, largest first.
Dividend cash paid on 100 shares over the trailing year

Dividend cash paid on 100 shares over the trailing year

most recentas of ranking 6×3read in context →
Dividend cash paid on 100 shares over the trailing year — 6 rows by 3 columns, computed from US exchange, SIP and OPRA data.
symbolannual_cash_on_100_sharespayment_count
SPY758.274
JNJ5284
XOM4124
MSFT3644
KO2104
AAPL1064
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
Related queries
Parity-implied financing rate by expiry, deep ITM AAPL strikes ranking 10×4 → AAPL LEAPS calls and puts at matching strikes, one recent session table 5×9 → Implied financing rate at each AAPL LEAPS strike, versus the 1-year Treasury table 5×5 → AAPL dividends in the twelve months before the pricing session series 4×3 → See all 3,256 queries →
$