lookback_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.

SELECT
    toString(d)                AS date,
    formatDateTime(d, '%b %e') AS day_label,
    round(vol / avg5, 2)       AS rvol_5d,
    round(vol / avg20, 2)      AS rvol_20d,
    round(vol / avg50, 2)      AS rvol_50d
FROM
(
    SELECT
        d,
        vol,
        avg(vol) OVER (ORDER BY d ROWS BETWEEN 5 PRECEDING AND 1 PRECEDING)  AS avg5,
        avg(vol) OVER (ORDER BY d ROWS BETWEEN 20 PRECEDING AND 1 PRECEDING) AS avg20,
        avg(vol) OVER (ORDER BY d ROWS BETWEEN 50 PRECEDING AND 1 PRECEDING) AS avg50
    FROM
    (
        SELECT
            date                   AS d,
            toFloat64(max(volume)) AS vol
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'AAPL'
          AND date >= '2025-10-01'
          AND date <= '2026-06-30'
        GROUP BY date
    )
)
WHERE d >= '2026-04-01'
ORDER BY d