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

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.
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
$