STRASMORE/EXPLORE 3,127 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,127 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Buy Stop vs Sell Stop Orders: How Each Fires
How often a 2 percent stop distance gets touched, by nameranking · 2026-10-06 · 6×3Preview: 6 ranked values, largest first. KO quoted spread by half hour of the ET clock, one pinned sessionseries · 2026-10-06 · 14×3Preview: a 14-point series, ending lower. SPY: share of sessions opening a given distance from the prior closeranking · 2026-10-06 · 5×3Preview: 5 ranked values, largest first. Apple's eight widest downside opening gaps since 2021ranking · 2026-10-06 · 8×4Preview: 8 ranked values, largest first.
How often a 2 percent stop distance gets touched, by name

How often a 2 percent stop distance gets touched, by name

most recentas of ranking 6×3read in context →
How often a 2 percent stop distance gets touched, by name — 6 rows by 3 columns, computed from US exchange, SIP and OPRA data.
tickerdown_touch_pctup_touch_pct
NVDA32.838
MSFT20.825.2
T18.419.2
AAPL12.819.2
KO6.410.8
SPY2.82.8
the exact SQL behind every number 
WITH px AS
(
    SELECT
        ticker,
        date,
        toFloat64(low)  AS low_px,
        toFloat64(high) AS high_px,
        toFloat64(lagInFrame(close, 1) OVER (PARTITION BY ticker ORDER BY date)) AS prev_close
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('AAPL', 'KO', 'MSFT', 'NVDA', 'SPY', 'T')
      AND date >= '2025-10-01'
      AND date <  '2026-10-01'
      AND (ticker, date) NOT IN (SELECT ticker, execution_date FROM global_markets.stocks_splits)
)
SELECT
    ticker,
    round(100 * countIf(low_px  <= prev_close * 0.98) / count(), 1) AS down_touch_pct,
    round(100 * countIf(high_px >= prev_close * 1.02) / count(), 1) AS up_touch_pct
FROM px
WHERE prev_close > 0
GROUP BY ticker
ORDER BY down_touch_pct DESC
More from this analysisBuy Stop vs Sell Stop Orders: How Each Fires
Apple's eight widest downside opening gaps since 2021 ranking 8×4 → SPY: share of sessions opening a given distance from the prior close ranking 5×3 → KO quoted spread by half hour of the ET clock, one pinned session series 14×3 → AAPL's ten largest overnight gaps down, Jan 2023 to Jun 2026 ranking 10×2 → See all 3,127 queries →
$