Price path indexed to 100: two index funds and their covered call counterparts, month ends

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 px AS (
    SELECT toStartOfMonth(toDate(toTimeZone(window_start, 'America/New_York'))) AS m,
           ticker,
           argMax(close, window_start) AS price
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('QYLD', 'XYLD', 'QQQ', 'SPY')
      AND toDate(toTimeZone(window_start, 'America/New_York')) BETWEEN toDate('2023-07-01') AND toDate('2026-06-30')
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY m, ticker
),
base AS (
    SELECT ticker, argMin(price, m) AS p0
    FROM px
    GROUP BY ticker
)
SELECT formatDateTime(px.m, '%Y-%m') AS month,
       round(maxIf(px.price / base.p0 * 100, px.ticker = 'QQQ'), 1) AS nasdaq_fund_price,
       round(maxIf(px.price / base.p0 * 100, px.ticker = 'QYLD'), 1) AS nasdaq_covered_call_price,
       round(maxIf(px.price / base.p0 * 100, px.ticker = 'SPY'), 1) AS sp500_fund_price,
       round(maxIf(px.price / base.p0 * 100, px.ticker = 'XYLD'), 1) AS sp500_covered_call_price
FROM px
INNER JOIN base ON px.ticker = base.ticker
GROUP BY px.m
ORDER BY px.m