2,236 answered market questions

SELECT
    toString(date)                                                              AS session_date,
    concat(formatDateTime(date, '%b'), ' ', toString(toDayOfMonth(date)))       AS session_label,
    round(100 * toFloat64(max(short_volume)) / toFloat64(max(total_volume)), 1) AS short_marked_pct,
    round(toFloat64(max(total_volume)) / 1e6, 2)                                AS reported_volume_millions
FROM global_markets.stocks_short_volume
WHERE ticker = 'AAPL'
  AND date >= '2026-08-01'
  AND date <  '2026-09-01'
GROUP BY date
HAVING max(total_volume) > 0
ORDER BY date