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

3,293 answered market questions

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

Full options quote history: clean NBBO bid/ask snapshots for any US option contract at the interval you choose, by SQL API, $79 a month. See the options quotes plan
Stop Order vs Limit Order: Trigger or Price
AAPL sessions touched at each stop distance, and how many closed back above the open (2024-2025)ranking · 2026-10-02 · 5×3Preview: 5 ranked values, largest first. AAPL sessions that opened at least 1.5% below the prior close, 2025series · 2026-10-02 · 16×2Preview: a 16-point series, ending higher. AAPL one minute range and volume by ET clock hour, September 2025ranking · 2026-10-02 · 16×3Preview: 16 ranked values, largest first. Median daily range and sub-open dips across five household names, 2025ranking · 2026-10-02 · 5×3Preview: 5 ranked values, largest first.
Stop Orders on Options: What Actually Triggers
One near-the-money SPY put, July 6 to July 17, 2026: daily close and day-over-day move next to SPY'sseries · 2026-09-11 · 10×5Preview: a 10-point series, ending lower. Near-the-money SPY puts (20-45 days to expiry), July 2026: size of the day-over-day close moveranking · 2026-09-11 · 4×3Preview: 4 ranked values, smallest first. AAPL option contracts on July 15, 2026, bucketed by full-day volumeranking · 2026-09-11 · 5×3Preview: 5 ranked values, largest first.
AAPL sessions touched at each stop distance, and how many closed back above the open (2024-2025)

AAPL sessions touched at each stop distance, and how many closed back above the open (2024-2025)

most recentas of ranking 5×3read in context →
AAPL sessions touched at each stop distance, and how many closed back above the open (2024-2025) — 5 rows by 3 columns, computed from US exchange, SIP and OPRA data.
stop_distancesessions_triggered_pctclosed_above_open_pct
1%36.95.8
2%10.41
3%3.20.2
4%1.20
5%0.40
the exact SQL behind every number 
SELECT
    concat(toString(dist), '%')                                                   AS stop_distance,
    round(countIf(low_pct <= -1 * dist) * 100.0 / count(), 1)                     AS sessions_triggered_pct,
    round(countIf(low_pct <= -1 * dist AND close_pct > 0) * 100.0 / count(), 1)   AS closed_above_open_pct
FROM
(
    SELECT
        arrayJoin([1, 2, 3, 4, 5])                      AS dist,
        (toFloat64(low) / toFloat64(open) - 1) * 100    AS low_pct,
        (toFloat64(close) / toFloat64(open) - 1) * 100  AS close_pct
    FROM global_markets.stocks_daily_aggs
    WHERE ticker = 'AAPL'
      AND date >= '2024-01-01'
      AND date <  '2026-01-01'
      AND toFloat64(open) > 0
)
GROUP BY dist
ORDER BY dist
More from this analysisStop Order vs Limit Order: Trigger or Price
AAPL one minute range and volume by ET clock hour, September 2025 ranking 16×3 → Median daily range and sub-open dips across five household names, 2025 ranking 5×3 → AAPL sessions that opened at least 1.5% below the prior close, 2025 series 16×2 → How often a resting limit was reached, by distance from the prior close (SPY, 2021 to Sep 2026) ranking 6×3 → See all 3,293 queries →
$