Share price indexed to 100, three covered call ETFs, monthly

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH monthly AS
(
    SELECT
        ticker,
        toStartOfMonth(toTimeZone(window_start, 'America/New_York')) AS month_start,
        argMax(toFloat64(close), window_start)                       AS month_close
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('QYLD', 'XYLD', 'RYLD')
      AND window_start >= toDateTime('2021-09-01 04:00:00')
      AND window_start <  toDateTime('2026-08-01 04: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 ticker, month_start
),
base AS
(
    SELECT
        ticker,
        argMin(month_close, month_start) AS base_close
    FROM monthly
    GROUP BY ticker
)
SELECT
    formatDateTime(m.month_start, '%Y-%m')                                  AS month,
    round(100 * sumIf(m.month_close / b.base_close, m.ticker = 'QYLD'), 1)  AS qyld_price_index,
    round(100 * sumIf(m.month_close / b.base_close, m.ticker = 'XYLD'), 1)  AS xyld_price_index,
    round(100 * sumIf(m.month_close / b.base_close, m.ticker = 'RYLD'), 1)  AS ryld_price_index
FROM monthly AS m
INNER JOIN base AS b ON b.ticker = m.ticker
GROUP BY m.month_start
ORDER BY m.month_start