good faith violations — 4 answered market questions

Reported short sale volume as a share of total volume, past six months

most recentas of 2026-10-09 ranking 5×3read in context →

Reported short sale volume as a share of total volume, past six months — 5 rows by 3 columns, computed 2026-10-09 from US exchange, SIP and OPRA data.
ticker	short_share_pct	busiest_day_pct
SPY	54.2	76.2
AAPL	46.5	63.3
KO	43.2	65.6
NVDA	38.7	57.4
MSFT	36.8	61.4

the exact SQL behind every number

WITH daily AS
(
    SELECT
        date,
        ticker,
        max(toFloat64(short_volume)) AS short_vol,
        max(toFloat64(total_volume)) AS total_vol
    FROM global_markets.stocks_short_volume
    WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'KO')
      AND ticker NOT IN ('SPCX')
      AND date >= today() - 180
    GROUP BY date, ticker
    HAVING max(toFloat64(total_volume)) > 0
)
SELECT
    ticker,
    round(100 * sum(short_vol) / sum(total_vol), 1) AS short_share_pct,
    round(100 * max(short_vol / total_vol), 1)      AS busiest_day_pct
FROM daily
GROUP BY ticker
ORDER BY short_share_pct DESC

More from this analysisLimited Margin in an IRA: Rules and Limits

How often the settlement wait is overnight, and how often it is longer ranking 4×3 → Calendar days from a sale to its settlement date, session by session series 70×3 → Front-end Treasury yields, monthly averages series 14×3 → What one fully collateralized contract ties up, by underlying ranking 6×4 → See all 3,256 queries →