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

Weekly Dividend ETFs: How the Payouts Work
Symbols paying on a weekly cadence, by complete calendar yearranking · 2026-10-04 · 5×2Preview: 5 ranked values, smallest first. Symbols with the most ex-dividend dates in the trailing yearranking · 2026-10-04 · 12×3Preview: 12 ranked values, largest first. Every distribution from the most frequent payer, with its annualized rateseries · 2026-10-04 · 104×4Preview: a 16-point series, ending higher. Average distribution against the average ex-date price moveranking · 2026-10-04 · 10×4Preview: 10 ranked values, largest first. Trailing-year cash paid and price change, as a percentage of the starting priceranking · 2026-10-04 · 10×4Preview: 10 ranked values, largest first.
Return of Capital in ETF Distributions
QYLD by calendar year: cash paid, average price, implied ratetable · 2026-10-04 · 5×5 Share price indexed to 100, three covered call ETFs, monthlyseries · 2026-10-04 · 59×4Preview: a 16-point series, ending lower. Trailing year distribution rate, price change, and approximate total returnranking · 2026-10-04 · 7×4Preview: 7 ranked values, largest first. Cash distributions per share, month by monthseries · 2026-10-04 · 59×4Preview: a 16-point series, ending lower.
Monthly Dividend ETFs: Who Actually Pays
Trailing 12 month distribution rate, by fund familyranking · 2026-10-04 · 12×3Preview: 12 ranked values, largest first. Distributions per year: monthly funds beside quarterly benchmarksranking · 2026-10-04 · 12×3Preview: 12 ranked values, largest first. Days from ex dividend date to cash, monthly paying fundsranking · 2026-10-04 · 9×2Preview: 9 ranked values, largest first. Monthly cash per share: an option income fund and a bond fundseries · 2026-10-04 · 24×3Preview: a 16-point series, roughly flat.
Gold Miner Covered Call ETFs: Yield vs Upside
2026 price return, distributions and total return: miners, wrapper and bulliontable · 2026-10-04 · 4×5 Monthly price move, 2026: GDX vs the covered call wrapper GDXYseries · 2026-10-04 · 10×3Preview: a 10-point series, roughly flat. Monthly at-the-money IV: GDX, GDXJ and SPY over the past yearseries · 2026-10-04 · 13×5Preview: a 13-point series, roughly flat. At-the-money implied volatility: gold miners vs bullion vs the S&P 500table · 2026-10-04 · 4×6
Covered Call Closed-End Funds vs ETFs
Short-term Treasury yields by month, the reference for fund borrowing costsseries · 2026-10-04 · 36×3Preview: a 16-point series, ending lower. Cash distributions over the trailing year, by declared scheduleranking · 2026-10-04 · 5×2Preview: 5 ranked values, largest first. Monthly cost of a near-the-money call, as a percent of share priceseries · 2026-10-04 · 18×3Preview: a 16-point series, ending lower.
Mutual Funds vs ETFs: What Actually Differs
Quoted bid-ask spread by fund: venue quotes, 11:00 to 13:59 ET, July 22, 2026ranking · 2026-08-02 · 7×4Preview: 7 ranked values, smallest first. The first active ETF share class: DFMC weekly closes since its March 2026 listingseries · 2026-08-02 · 20×4Preview: a 16-point series, ending lower. How far the price travels inside a day: seven ETFs, July 2026 sessionsranking · 2026-08-02 · 7×4Preview: 7 ranked values, largest first. One session, many prices: VOO in half-hour marks, Wednesday July 22, 2026series · 2026-08-02 · 32×3Preview: a 16-point series, roughly flat.
Symbols paying on a weekly cadence, by complete calendar year

Symbols paying on a weekly cadence, by complete calendar year

most recentas of ranking 5×2read in context →
Symbols paying on a weekly cadence, by complete calendar year — 5 rows by 2 columns, computed from US exchange, SIP and OPRA data.
yearfunds_paying_weekly
20211
20222
20232
20242
202520
the exact SQL behind every number 
SELECT
    year,
    count() AS funds_paying_weekly
FROM
(
    SELECT
        toString(toYear(ex_dividend_date))  AS year,
        ticker,
        countDistinct(ex_dividend_date)     AS ex_dates
    FROM global_markets.stocks_dividends
    WHERE ex_dividend_date >= '2018-01-01'
      AND ex_dividend_date <  toStartOfYear(today())
      AND ticker NOT IN ('SPCX')
    GROUP BY year, ticker
    HAVING ex_dates >= 40
)
GROUP BY year
ORDER BY year
More from this analysisWeekly Dividend ETFs: How the Payouts Work
Symbols with the most ex-dividend dates in the trailing year ranking 12×3 → Average distribution against the average ex-date price move ranking 10×4 → Trailing-year cash paid and price change, as a percentage of the starting price ranking 10×4 → Every distribution from the most frequent payer, with its annualized rate series 104×4 → See all 3,256 queries →
$