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

3,293 answered market questions

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

Full options quote history: clean NBBO bid/ask snapshots for any US option contract at the interval you choose, by SQL API, $79 a month. See the options quotes plan
Weekly Dividend ETFs: How the Payouts Work
Symbols paying on a weekly cadence, by complete calendar yearranking · 2026-11-07 · 5×2Preview: 5 ranked values, smallest first. Symbols with the most ex-dividend dates in the trailing yearranking · 2026-11-07 · 12×3Preview: 12 ranked values, largest first. Every distribution from the most frequent payer, with its annualized rateseries · 2026-11-07 · 108×4Preview: a 16-point series, ending lower. Average distribution against the average ex-date price moveranking · 2026-11-07 · 10×4Preview: 10 ranked values, largest first. Trailing-year cash paid and price change, as a percentage of the starting priceranking · 2026-11-07 · 10×4Preview: 10 ranked values, largest first.
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
$