growth_path

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
    base AS
    (
        SELECT
            ticker,
            argMin(toFloat64(close), date) AS base_close
        FROM global_markets.stocks_daily_aggs
        WHERE ticker IN ('AIQ', 'BOTZ', 'XLK', 'QQQ')
          AND date >= '2021-10-01'
          AND date <  '2021-11-01'
        GROUP BY ticker
    ),
    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 ('AIQ', 'BOTZ', 'XLK', 'QQQ')
          AND date >= '2021-10-01'
        GROUP BY ticker, month_start
    )
SELECT
    formatDateTime(m.month_start, '%Y-%m')                                 AS month,
    round(maxIf(100 * m.month_close / b.base_close, m.ticker = 'AIQ'), 1)  AS aiq_index,
    round(maxIf(100 * m.month_close / b.base_close, m.ticker = 'BOTZ'), 1) AS botz_index,
    round(maxIf(100 * m.month_close / b.base_close, m.ticker = 'XLK'), 1)  AS xlk_index,
    round(maxIf(100 * m.month_close / b.base_close, m.ticker = 'QQQ'), 1)  AS qqq_index
FROM monthly AS m
INNER JOIN base AS b ON b.ticker = m.ticker
GROUP BY month
HAVING countIf(m.ticker = 'AIQ')  = 1
   AND countIf(m.ticker = 'BOTZ') = 1
   AND countIf(m.ticker = 'XLK')  = 1
   AND countIf(m.ticker = 'QQQ')  = 1
ORDER BY month