3,256 answered market questions

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