STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 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-08-22 · 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
SPY752.54
JNJ5244
XOM4124
MSFT3644
KO2084
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
Third Friday expirations over the next fourteen months, by underlyings listing them ranking 14×3 → Monthly expirations beyond 300 days out, by underlyings listing them ranking 14×2 → Start-to-end change in Treasury yields by calendar year, in basis points ranking 13×3 → 2026 cash dividends per share at eight widely held payers ranking 8×4 → See all 2,170 queries →
$