Percent of reported volume marked short: five large caps on an ordinary day (July 10, 2026)

WITH covered AS (
    SELECT ticker,
           max(short_volume) AS short_vol,
           max(total_volume) AS covered_vol
    FROM global_markets.stocks_short_volume
    WHERE date = '2026-07-10'
      AND ticker IN ('AAPL', 'MSFT', 'NVDA', 'TSLA', 'KO')
    GROUP BY ticker
),
tape AS (
    SELECT ticker, sum(volume) AS tape_vol
    FROM global_markets.delayed_stocks_minute_aggs
    WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'TSLA', 'KO')
      AND window_start >= toDateTime('2026-07-10 04:00:00', 'America/New_York')
      AND window_start < toDateTime('2026-07-10 20:00:00', 'America/New_York')
    GROUP BY ticker
)
SELECT covered.ticker AS ticker,
       round(covered.short_vol / 1e6, 1) AS marked_short_mn,
       round(covered.covered_vol / 1e6, 1) AS file_total_mn,
       round(covered.short_vol / covered.covered_vol * 100, 1) AS pct_marked_short,
       round(tape.tape_vol / 1e6, 1) AS consolidated_tape_mn,
       round(covered.covered_vol / tape.tape_vol * 100, 1) AS file_share_of_tape_pct
FROM covered
JOIN tape ON covered.ticker = tape.ticker
ORDER BY indexOf(['AAPL', 'MSFT', 'NVDA', 'TSLA', 'KO'], covered.ticker)