How often a buy limit under the prior close was reached (AAPL, one year of sessions)

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 sessions AS
(
    SELECT
        date,
        toFloat64(any(low))   AS low_px,
        toFloat64(any(close)) AS close_px
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'AAPL'
      AND date >= '2025-10-01'
      AND date <  '2026-10-01'
    GROUP BY date
),
framed AS
(
    SELECT
        low_px,
        lagInFrame(close_px) OVER (
            ORDER BY date ASC
            ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) AS prev_close
    FROM sessions
)
SELECT
    concat(toString(offset_pct), '%')                AS limit_below_prior_close,
    round(100 * countIf(low_px <= prev_close * (1 - offset_pct / 100))
              / count(), 1)                          AS sessions_filled_pct
FROM framed
ARRAY JOIN [0., 0.25, 0.5, 1., 2., 3.] AS offset_pct
WHERE prev_close > 0
GROUP BY offset_pct
ORDER BY offset_pct