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

3,256 answered market questions

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

Why Stocks Halt: Limit Up-Limit Down Bands
Where listed symbols sit by price, and which band rule governs each zoneranking · 2026-10-04 · 6×3Preview: 6 ranked values, largest first. Average minute range through the session, five liquid namesseries · 2026-10-04 · 26×3Preview: a 16-point series, ending lower. How far eight stocks move in a five minute window, trailing yearranking · 2026-10-04 · 8×4Preview: 8 ranked values, largest first. What a 5 percent band is worth in dollars, by price levelranking · 2026-10-04 · 8×4Preview: 8 ranked values, largest first.
US Stocks 23/5 Trading: The December 2026 Plan
Extended-hours sale conditions defined on the taperanking · 2026-10-04 · 3×3Preview: 3 ranked values, smallest first. SPY daily bar volume vs. the regular-session slice (trailing month)series · 2026-10-04 · 19×5Preview: a 16-point series, roughly flat. Where SPY volume prints today, by ET clock hour (trailing month)ranking · 2026-10-04 · 16×4Preview: 16 ranked values, largest first. Share of volume printed outside 9:30 to 4:00 ET, seven household names (trailing month)ranking · 2026-10-04 · 7×4Preview: 7 ranked values, smallest first.
Market-Wide Circuit Breakers Explained
SPY-equivalent circuit breaker levels for the next sessiontable · 2026-10-04 · 3×7 March 2020 session by session: open, low and close versus the prior closeseries · 2026-10-04 · 22×6Preview: a 16-point series, ending lower. The four Level 1 halt sessions of March 2020series · 2026-10-04 · 4×8Preview: a 4-point series, ending lower. How the three lines move with each SPY closeseries · 2026-10-04 · 15×5Preview: a 15-point series, ending higher.
Where listed symbols sit by price, and which band rule governs each zone

Where listed symbols sit by price, and which band rule governs each zone

most recentas of ranking 6×3read in context →
Where listed symbols sit by price, and which band rule governs each zone — 6 rows by 3 columns, computed from US exchange, SIP and OPRA data.
price_zonestock_countshare_of_tape_pct
under $0.756985.4
$0.75 to $310268
$3 to $20358027.9
$20 to $100642050
$100 to $50010228
$500 and up840.7
the exact SQL behind every number 
SELECT
    price_zone,
    stock_count,
    round(stock_count * 100.0 / sum(stock_count) OVER (), 1) AS share_of_tape_pct
FROM
(
    SELECT
        multiIf(last_price < 0.75, 'under $0.75',
                last_price < 3,    '$0.75 to $3',
                last_price < 20,   '$3 to $20',
                last_price < 100,  '$20 to $100',
                last_price < 500,  '$100 to $500',
                                   '$500 and up') AS price_zone,
        count()                                   AS stock_count
    FROM
    (
        SELECT
            ticker,
            toFloat64(argMax(close, window_start)) AS last_price
        FROM global_markets.delayed_stocks_minute_aggs
        WHERE window_start >= today() - 8
          AND window_start <  today() - 1
          AND volume > 0
        GROUP BY ticker
        HAVING last_price > 0
    )
    GROUP BY price_zone
)
ORDER BY multiIf(price_zone = 'under $0.75', 1,
                 price_zone = '$0.75 to $3', 2,
                 price_zone = '$3 to $20', 3,
                 price_zone = '$20 to $100', 4,
                 price_zone = '$100 to $500', 5,
                 6)
More from this analysisWhy Stocks Halt: Limit Up-Limit Down Bands
How far eight stocks move in a five minute window, trailing year ranking 8×4 → What a 5 percent band is worth in dollars, by price level ranking 8×4 → Average minute range through the session, five liquid names series 26×3 → March 2020 session by session: open, low and close versus the prior close series 22×6 → See all 3,256 queries →
$