dia_iyt_trace

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(date)                AS month_start,
        argMax(toFloat64(close), date)      AS month_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('DIA', 'IYT')
      AND date >= '2024-01-01'
      AND date <  '2026-07-01'
    GROUP BY ticker, month_start
),
base AS
(
    SELECT
        ticker,
        argMin(month_close, month_start) AS base_close
    FROM monthly
    GROUP BY ticker
),
rebased AS
(
    SELECT
        formatDateTime(m.month_start, '%Y-%m')                                  AS month,
        round(100 * anyIf(m.month_close / b.base_close, m.ticker = 'DIA'), 1)   AS dia_index,
        round(100 * anyIf(m.month_close / b.base_close, m.ticker = 'IYT'), 1)   AS iyt_index
    FROM monthly AS m
    INNER JOIN base AS b ON b.ticker = m.ticker
    GROUP BY m.month_start
)
SELECT
    month,
    dia_index,
    iyt_index,
    round(dia_index - iyt_index, 1) AS spread
FROM rebased
ORDER BY month