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

Return of Capital in ETF Distributions
QYLD by calendar year: cash paid, average price, implied ratetable · 2026-08-22 · 5×5 Share price indexed to 100, three covered call ETFs, monthlyseries · 2026-08-22 · 59×4Preview: a 16-point series, ending lower. Trailing year distribution rate, price change, and approximate total returnranking · 2026-08-22 · 7×4Preview: 7 ranked values, largest first. Cash distributions per share, month by monthseries · 2026-08-22 · 59×4Preview: a 16-point series, ending lower.
Payment in Lieu of Dividends, Explained
PFE short interest by settlement date, Aug 2025 through Jul 2026series · 2026-08-22 · 24×3Preview: a 16-point series, ending higher. Ex-dividend events per month across the whole US calendarseries · 2026-08-22 · 12×4Preview: a 12-point series, roughly flat. The most recent regular dividend for eleven household namestable · 2026-08-22 · 11×5 Reported short interest across the same dividend payersranking · 2026-08-22 · 11×3Preview: 11 ranked values, largest first.
QYLD by calendar year: cash paid, average price, implied rate

QYLD by calendar year: cash paid, average price, implied rate

most recentas of table 5×5read in context →
QYLD by calendar year: cash paid, average price, implied rate — 5 rows by 5 columns, computed from US exchange, SIP and OPRA data.
yeardistributions_per_shareavg_closedistribution_rate_pctpayments
20212.85122.5912.612
20222.18818.291212
20232.04217.1711.912
20242.27717.8212.812
20252.04117.1111.912
the exact SQL behind every number 
WITH yearly_px AS
(
    SELECT
        toYear(toTimeZone(window_start, 'America/New_York')) AS yr,
        round(avg(toFloat64(close)), 2)                      AS avg_close
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'QYLD'
      AND window_start >= toDateTime('2021-01-01 05:00:00')
      AND window_start <  toDateTime('2026-01-01 05:00:00')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) >= 570
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) < 960
    GROUP BY yr
),
yearly_div AS
(
    SELECT
        toYear(ex_dividend_date)         AS yr,
        round(sum(cash_amount), 3)       AS distributions_per_share,
        count()                          AS payments
    FROM
    (
        SELECT
            ex_dividend_date,
            toFloat64(max(cash_amount)) AS cash_amount
        FROM global_markets.stocks_dividends
        WHERE ticker = 'QYLD'
          AND ex_dividend_date >= toDate('2021-01-01')
          AND ex_dividend_date <  toDate('2026-01-01')
        GROUP BY ex_dividend_date
    )
    GROUP BY yr
)
SELECT
    toString(p.yr)                                            AS year,
    d.distributions_per_share                                 AS distributions_per_share,
    p.avg_close                                               AS avg_close,
    round(100 * d.distributions_per_share / p.avg_close, 1)   AS distribution_rate_pct,
    d.payments                                                AS payments
FROM yearly_px AS p
INNER JOIN yearly_div AS d ON d.yr = p.yr
ORDER BY p.yr
More from this analysisReturn of Capital in ETF Distributions
Share price indexed to 100, three covered call ETFs, monthly series 59×4 → Cash distributions per share, month by month series 59×4 → Trailing year distribution rate, price change, and approximate total return ranking 7×4 → Short-term Treasury yields by month, the reference for fund borrowing costs series 36×3 → See all 2,170 queries →
$