Two crowding measures, six names: short interest as % of shares outstanding vs. days to cover

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH share_counts AS (
    SELECT ticker,
           argMax(market_cap / price, date) AS shares_outstanding,
           argMax(date, date) AS as_of
    FROM global_markets.stocks_ratios
    WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'TSLA', 'MU', 'GME')
      AND market_cap > 0
      AND price > 0
    GROUP BY ticker
)
SELECT si.ticker AS ticker,
       round(si.short_interest / 1e6, 1) AS shares_short_m,
       round(si.short_interest / sc.shares_outstanding * 100, 2) AS pct_of_shares_out,
       round(si.days_to_cover, 2) AS days_to_cover,
       formatDateTimeInJodaSyntax(sc.as_of, 'MMMM d, yyyy') AS share_count_as_of
FROM global_markets.stocks_short_interest AS si
INNER JOIN share_counts AS sc ON sc.ticker = si.ticker
WHERE si.settlement_date = '2026-06-30'
ORDER BY pct_of_shares_out DESC