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

Highest Days to Cover Stocks Right Now
The receipts: file size, liquid names, thin names, and the liquid medianscalar · 2026-09-26 · 1×522,593 Highest days to cover among liquid names: 5M average-volume floorranking · 2026-09-26 · 12×4Preview: 12 ranked values, largest first. Today's liquid top-3 days-to-cover names, traced back eight settlementsseries · 2026-09-26 · 8×4Preview: a 8-point series, ending higher. Highest days to cover, latest settlement: 500k average-volume floortable · 2026-09-26 · 12×5 Days to cover by liquidity band: median stays low, the extremes live in thin namesranking · 2026-09-26 · 5×4Preview: 5 ranked values, smallest first.
The receipts: file size, liquid names, thin names, and the liquid median

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

most recentas of scalar 1×5read in context →
tickers reported
22,593
liquid names
693
thin names
19,951
liquid median dtc
2.2
settled
2026-09-15
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 3,256 queries →
$