2,173 answered market questions

SELECT
    ticker,
    round(100 * (sum(short_vol) / sum(total_vol)), 1) AS short_volume_pct,
    round(sum(total_vol) / 1e6, 1)                    AS reported_volume_millions
FROM
(
    SELECT
        ticker,
        date              AS session_date,
        max(short_volume) AS short_vol,
        max(total_volume) AS total_vol
    FROM global_markets.stocks_short_volume
    WHERE ticker IN ('NVDA', 'AAPL', 'MSFT', 'SPY', 'KO')
      AND date >= '2026-04-01'
      AND date <= '2026-05-15'
    GROUP BY ticker, session_date
)
GROUP BY ticker
HAVING sum(total_vol) > 0
ORDER BY short_volume_pct DESC