3,256 answered market questions

SELECT
    toString(date)                                        AS session_date,
    formatDateTime(date, '%b %e')                         AS session_label,
    round(100 * max(short_volume) / max(total_volume), 1) AS short_volume_pct
FROM global_markets.stocks_short_volume
WHERE ticker = 'KO'
  AND date >= today() - 120
GROUP BY date
HAVING max(total_volume) > 0
ORDER BY date