Total return by calendar year: a Nasdaq index fund vs a Nasdaq covered call fund

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 ranges AS (
    SELECT arrayJoin([('2022 decline', toDate('2022-01-03'), toDate('2022-12-30')),
                      ('2023 rebound', toDate('2023-01-03'), toDate('2023-12-29')),
                      ('2024 advance', toDate('2024-01-02'), toDate('2024-12-31')),
                      ('2025 advance', toDate('2025-01-02'), toDate('2025-12-31'))]) AS r
),
px AS (
    SELECT r.1 AS regime,
           m.ticker AS ticker,
           argMin(m.close, m.window_start) AS p0,
           argMax(m.close, m.window_start) AS p1
    FROM ranges, global_markets.delayed_stocks_minute_aggs AS m
    WHERE m.ticker IN ('QYLD', 'QQQ')
      AND toDate(toTimeZone(m.window_start, 'America/New_York')) BETWEEN r.2 AND r.3
      AND (toHour(toTimeZone(m.window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(m.window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY regime, ticker
),
dv AS (
    SELECT r.1 AS regime,
           d.ticker AS ticker,
           sum(d.cash_amount) AS dist
    FROM ranges, global_markets.stocks_dividends AS d
    WHERE d.ticker IN ('QYLD', 'QQQ')
      AND d.cash_amount > 0
      AND d.ex_dividend_date BETWEEN r.2 AND r.3
    GROUP BY regime, ticker
)
SELECT px.regime AS regime,
       round(maxIf((px.p1 - px.p0 + dv.dist) / px.p0 * 100, px.ticker = 'QQQ'), 1) AS index_fund_total_pct,
       round(maxIf((px.p1 - px.p0 + dv.dist) / px.p0 * 100, px.ticker = 'QYLD'), 1) AS covered_call_total_pct
FROM px
INNER JOIN dv ON px.regime = dv.regime AND px.ticker = dv.ticker
GROUP BY regime
ORDER BY regime