recent_events

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
        ticker,
        date,
        toFloat64(open)  AS o,
        toFloat64(high)  AS h,
        toFloat64(low)   AS l,
        toFloat64(close) AS c
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('AAPL','MSFT','NVDA','AMZN','GOOGL','META','JPM','XOM','JNJ','KO','PG','WMT','HD','UNH','CVX','MRK','CSCO','PEP','SPY','QQQ')
      AND date >= '2006-01-01'
      AND date <  '2026-10-01'
      AND high > low
      AND low > 0
),
shaped AS
(
    SELECT
        ticker,
        date,
        c,
        h - l              AS rng,
        abs(c - o)         AS body,
        h - greatest(o, c) AS upper_wick,
        0.01 * o           AS min_range,
        leadInFrame(c, 1)  OVER (PARTITION BY ticker ORDER BY date ASC ROWS BETWEEN CURRENT ROW AND 20 FOLLOWING) AS c_fwd1,
        leadInFrame(c, 5)  OVER (PARTITION BY ticker ORDER BY date ASC ROWS BETWEEN CURRENT ROW AND 20 FOLLOWING) AS c_fwd5,
        leadInFrame(c, 20) OVER (PARTITION BY ticker ORDER BY date ASC ROWS BETWEEN CURRENT ROW AND 20 FOLLOWING) AS c_fwd20
    FROM bars
)
SELECT
    toString(date)                        AS session_date,
    formatDateTime(date, '%d-%m-%Y')      AS session_label,
    ticker,
    round(100 * (c_fwd1  / c - 1), 2)     AS fwd_1_pct,
    round(100 * (c_fwd5  / c - 1), 2)     AS fwd_5_pct,
    round(100 * (c_fwd20 / c - 1), 2)     AS fwd_20_pct
FROM
(
    SELECT *
    FROM shaped
    WHERE rng >= min_range
      AND body       <= 0.10 * rng
      AND upper_wick <= 0.10 * rng
      AND c_fwd1  > 0
      AND c_fwd5  > 0
      AND c_fwd20 > 0
    ORDER BY date DESC
    LIMIT 12
)
ORDER BY session_date