STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 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-08-22 · 6×3Preview: 6 ranked values, largest first. Average minute range through the session, five liquid namesseries · 2026-08-22 · 26×3Preview: a 16-point series, ending lower. How far eight stocks move in a five minute window, trailing yearranking · 2026-08-22 · 8×4Preview: 8 ranked values, largest first. What a 5 percent band is worth in dollars, by price levelranking · 2026-08-22 · 8×4Preview: 8 ranked values, largest first.
GameStop, Jan 28, 2021: $483 to $112 by Noon
GME reported short interest by settlement date: November 2020 to February 2021ranking · 2026-07-26 · 8×3Preview: 8 ranked values, largest first. GME daily close and volume: December 1, 2020 to January 27, 2021 (as-traded prices)series · 2026-07-26 · 39×4Preview: a 16-point series, ending higher. GME by half-hour: January 28, 2021 regular sessionseries · 2026-07-26 · 13×4Preview: a 13-point series, ending lower. GME options trades by session: January 25–28, 2021series · 2026-07-26 · 4×6Preview: a 4-point series, ending lower. GME on January 28, 2021: receipted (as-traded, pre-2022-split prices)scalar · 2026-07-26 · 1×14345 The restricted names on January 28, 2021: prior close vs close (ET regular session)ranking · 2026-07-26 · 5×4Preview: 5 ranked values, largest first. GME daily close and volume: January 29 to February 9, 2021series · 2026-07-26 · 8×4Preview: a 8-point series, ending lower.
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.757205.6
$0.75 to $39467.3
$3 to $20356027.5
$20 to $100656250.7
$100 to $50010838.4
$500 and up820.6
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 → SPY open, midday and close volume against an average minute, by year ranking 8×4 → See all 2,170 queries →
$