Share of June 2026 volume reported to FINRA facilities

SELECT
    off.ticker                                                      AS ticker,
    round(100 * sum(off.off_exchange_volume) / sum(cons.volume), 1) AS off_exchange_pct,
    count()                                                         AS days_matched
FROM
(
    SELECT date, ticker, max(total_volume) AS off_exchange_volume
    FROM global_markets.stocks_short_volume
    WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'KO', 'SPY')
      AND date >= '2026-06-01'
      AND date <= '2026-06-30'
    GROUP BY date, ticker
) AS off
INNER JOIN
(
    SELECT date, ticker, max(volume) AS volume
    FROM global_markets.stocks_daily_aggs
    WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'KO', 'SPY')
      AND date >= '2026-06-01'
      AND date <= '2026-06-30'
    GROUP BY date, ticker
) AS cons ON off.date = cons.date AND off.ticker = cons.ticker
GROUP BY ticker
ORDER BY off_exchange_pct DESC