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

Most Shorted Stocks Right Now, Measured
The receipts: universe size, filter bite, median crowding, and list churn at the latest printscalar · 2026-08-25 · 1×522,339 Largest short positions by shares: latest settlement, liquid namesranking · 2026-08-25 · 10×4Preview: 10 ranked values, largest first. Crowding leaders vs. their own price: about one month of sessionsseries · 2026-08-25 · 4×5Preview: a 4-point series, ending higher. GME through the January 2021 squeeze: the same three columns, settlement by settlementseries · 2026-08-25 · 10×4Preview: a 10-point series, ending lower. Today's top-3 crowding leaders, traced back eight settlementsseries · 2026-08-25 · 8×4Preview: a 8-point series, ending higher. Biggest days-to-cover increases, latest settlement vs. the prior printranking · 2026-08-25 · 8×4Preview: 8 ranked values, largest first. Highest days to cover among liquid names: latest settlement on filetable · 2026-08-25 · 10×5
The receipts: universe size, filter bite, median crowding, and list churn at the latest print

The receipts: universe size, filter bite, median crowding, and list churn at the latest print

most recentas of scalar 1×5read in context →
tickers reported
22,339
liquid tickers
722
liquid median dtc
2.1
dtc top10 repeats
4
size top10 min dtc
1.9
the exact SQL behind every number 
WITH dates AS (
    SELECT DISTINCT settlement_date AS d
    FROM global_markets.stocks_short_interest
    ORDER BY d DESC
    LIMIT 2
),
top10_dtc_latest AS (
    SELECT ticker FROM global_markets.stocks_short_interest
    WHERE settlement_date = (SELECT max(d) FROM dates) AND avg_daily_volume >= 5000000
      AND days_to_cover IS NOT NULL AND ticker NOT IN ('SPCX')
    ORDER BY days_to_cover DESC, ticker LIMIT 10
),
top10_dtc_prior AS (
    SELECT ticker FROM global_markets.stocks_short_interest
    WHERE settlement_date = (SELECT min(d) FROM dates) AND avg_daily_volume >= 5000000
      AND days_to_cover IS NOT NULL AND ticker NOT IN ('SPCX')
    ORDER BY days_to_cover DESC, ticker LIMIT 10
),
size10_latest AS (
    SELECT ticker, days_to_cover FROM global_markets.stocks_short_interest
    WHERE settlement_date = (SELECT max(d) FROM dates) AND avg_daily_volume >= 5000000
      AND short_interest IS NOT NULL AND ticker NOT IN ('SPCX')
    ORDER BY short_interest DESC, ticker LIMIT 10
)
SELECT
    (SELECT count() FROM global_markets.stocks_short_interest
     WHERE settlement_date = (SELECT max(d) FROM dates)) AS tickers_reported,
    (SELECT count() FROM global_markets.stocks_short_interest
     WHERE settlement_date = (SELECT max(d) FROM dates) AND avg_daily_volume >= 5000000) AS liquid_tickers,
    (SELECT round(quantileDeterministic(0.5)(days_to_cover, cityHash64(ticker)), 1)
     FROM global_markets.stocks_short_interest
     WHERE settlement_date = (SELECT max(d) FROM dates) AND avg_daily_volume >= 5000000
       AND days_to_cover IS NOT NULL) AS liquid_median_dtc,
    (SELECT count() FROM top10_dtc_latest
     WHERE ticker IN (SELECT ticker FROM top10_dtc_prior)) AS dtc_top10_repeats,
    (SELECT round(min(days_to_cover), 1) FROM size10_latest) AS size_top10_min_dtc
More from this analysisMost Shorted Stocks Right Now, Measured
Largest short positions by shares: latest settlement, liquid names ranking 10×4 → GME through the January 2021 squeeze: the same three columns, settlement by settlement series 10×4 → Highest days to cover among liquid names: latest settlement on file table 10×5 → Today's top-3 crowding leaders, traced back eight settlements series 8×4 → See all 2,170 queries →
$