How often each limit price below the 10:00 a.m. anchor was reached

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 anchor AS
(
    SELECT toFloat64(close) AS anchor_price
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker = 'AAPL'
      AND window_start >= toDateTime('2026-09-16 14:00:00')
      AND window_start <  toDateTime('2026-09-16 15:00:00')
    ORDER BY window_start
    LIMIT 1
)
SELECT
    off                                                                      AS cents_below,
    round(anchor_price - (off / 100), 2)                                     AS limit_price,
    round(100 * countIf(bar_low <= anchor_price - (off / 100)) / count(), 1) AS minutes_reached_pct
FROM
(
    SELECT
        toFloat64(m.low)                      AS bar_low,
        a.anchor_price                        AS anchor_price,
        arrayJoin([0, 2, 5, 10, 25, 50, 100]) AS off
    FROM global_markets.delayed_stocks_minute_aggs AS m
    CROSS JOIN anchor AS a
    WHERE m.ticker = 'AAPL'
      AND m.window_start >  toDateTime('2026-09-16 14:00:00')
      AND m.window_start <  toDateTime('2026-09-17 00:00:00')
)
GROUP BY off, anchor_price
ORDER BY off