2,178 answered market questions

WITH base AS (
    SELECT ticker,
           toDate(toTimeZone(window_start, 'America/New_York')) AS d,
           argMax(close, window_start) AS c
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('SOXX', 'SOXL')
      AND window_start >= '2026-01-02 00:00:00' AND window_start < '2026-07-14 00:00:00'
      AND (toHour(toTimeZone(window_start, 'America/New_York')) * 60
           + toMinute(toTimeZone(window_start, 'America/New_York'))) BETWEEN 570 AND 959
    GROUP BY ticker, d
),
f AS (SELECT ticker, argMin(c, d) AS c0 FROM base GROUP BY ticker)
SELECT base.d AS date,
    round(maxIf(base.c / f.c0 * 100, base.ticker = 'SOXX'), 1) AS soxx_growth,
    round(maxIf(base.c / f.c0 * 100, base.ticker = 'SOXL'), 1) AS soxl_growth
FROM base INNER JOIN f ON base.ticker = f.ticker
GROUP BY base.d
ORDER BY base.d