trace_aapl

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
    bars AS (
        SELECT
            date,
            argMax(toFloat64(close), _ingest_time) AS close,
            argMax(toFloat64(high),  _ingest_time) AS high,
            argMax(toFloat64(low),   _ingest_time) AS low
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'AAPL'
          AND date >= '2026-02-01'
          AND date <  '2026-09-01'
        GROUP BY date
    ),
    ranges AS (
        SELECT
            date,
            close,
            count()   OVER w14 AS n14,
            max(high) OVER w14 AS hh14,
            min(low)  OVER w14 AS ll14
        FROM bars
        WINDOW w14 AS (ORDER BY date ROWS BETWEEN 13 PRECEDING AND CURRENT ROW)
    ),
    fast AS (
        SELECT
            date,
            if(hh14 > ll14, 100 * (close - ll14) / (hh14 - ll14), 50) AS k_fast
        FROM ranges
        WHERE n14 = 14
    ),
    slow AS (
        SELECT
            date,
            k_fast,
            avg(k_fast) OVER w3 AS k_slow,
            count()     OVER w3 AS n3
        FROM fast
        WINDOW w3 AS (ORDER BY date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW)
    ),
    lines AS (
        SELECT
            date,
            k_fast,
            k_slow,
            avg(k_slow) OVER w3b AS d_slow,
            count()     OVER w3b AS n3b
        FROM slow
        WHERE n3 = 3
        WINDOW w3b AS (ORDER BY date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW)
    )
SELECT
    date,
    round(k_fast, 1) AS k_fast_pct,
    round(k_slow, 1) AS k_slow_pct,
    round(d_slow, 1) AS d_slow_pct
FROM lines
WHERE n3b = 3
  AND date >= '2026-05-01'
ORDER BY date