short interest ratio — 5 answered market questions

The receipts: file size, liquid names, thin names, and the liquid median

most recentas of 2026-08-22 scalar 1×5read in context →

tickers reported

22,339

liquid names

722

thin names

19,707

liquid median dtc

2.1

settled

2026-07-31

the exact SQL behind every number

SELECT count() AS tickers_reported,
       countIf(avg_daily_volume >= 5e6 AND days_to_cover > 0) AS liquid_names,
       countIf(avg_daily_volume < 1e6 AND days_to_cover > 0) AS thin_names,
       round(quantileDeterministicIf(0.5)(days_to_cover, cityHash64(ticker), avg_daily_volume >= 5e6), 1) AS liquid_median_dtc,
       toString(max(settlement_date)) AS settled
FROM global_markets.stocks_short_interest
WHERE settlement_date = (SELECT max(settlement_date) FROM global_markets.stocks_short_interest)
  AND days_to_cover > 0

More from this analysisHighest Days to Cover Stocks Right Now

Highest days to cover among liquid names: 5M average-volume floor ranking 12×4 → Highest days to cover, latest settlement: 500k average-volume floor table 12×5 → Today's liquid top-3 days-to-cover names, traced back eight settlements series 8×4 → Days to cover by liquidity band: median stays low, the extremes live in thin names ranking 5×4 → See all 2,170 queries →