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

2,173 answered market questions

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

Mini Index Options Explained: XSP, XND, MRUT
SPY ex-dividend dates and cash amounts, trailing three yearsseries · 2026-08-22 · 12×3Preview: a 12-point series, ending higher. Open to close moves on monthly expiration Fridays, SPY since 2015ranking · 2026-08-22 · 5×3Preview: 5 ranked values, largest first. Dollar exposure in one 100-multiplier contract, by monthseries · 2026-08-22 · 37×5Preview: a 16-point series, ending higher.
SPY ex-dividend dates and cash amounts, trailing three years

SPY ex-dividend dates and cash amounts, trailing three years

most recentas of series 12×3read in context →
SPY ex-dividend dates and cash amounts, trailing three years — 12 rows by 3 columns, computed from US exchange, SIP and OPRA data.
ex_dateex_date_labelcash_amount_usd
2023-09-15Sep 15, 20231.5832
2023-12-15Dec 15, 20231.9061
2024-03-15Mar 15, 20241.5949
2024-06-21Jun 21, 20241.759
2024-09-20Sep 20, 20241.7455
2024-12-20Dec 20, 20241.9655
2025-03-21Mar 21, 20251.6955
2025-06-20Jun 20, 20251.7611
2025-09-19Sep 19, 20251.8311
2025-12-19Dec 19, 20251.9934
2026-03-20Mar 20, 20261.797
2026-06-18Jun 18, 20261.9035
the exact SQL behind every number 
SELECT
    toString(ex_dividend_date)                      AS ex_date,
    formatDateTime(ex_dividend_date, '%b %e, %Y')   AS ex_date_label,
    round(toFloat64(max(cash_amount)), 4)           AS cash_amount_usd
FROM global_markets.stocks_dividends
WHERE ticker = 'SPY'
  AND ex_dividend_date >= today() - 1150
  AND ex_dividend_date <= today()
GROUP BY ex_dividend_date
ORDER BY ex_dividend_date
More from this analysisMini Index Options Explained: XSP, XND, MRUT
Dollar exposure in one 100-multiplier contract, by month series 37×5 → Open to close moves on monthly expiration Fridays, SPY since 2015 ranking 5×3 → Share of contract volume by days to expiry, SPX and SPY ranking 5×3 → Average daily options volume: Section 1256 names against equity options ranking 4×3 → See all 2,173 queries →
$