awk — 3 answered market questions

Short volume ratio on June 12, 2026 for six household names

most recentas of 2026-09-19 ranking 6×4read in context →

Short volume ratio on June 12, 2026 for six household names — 6 rows by 4 columns, computed 2026-09-19 from US exchange, SIP and OPRA data.
ticker	short_volume_millions	total_volume_millions	short_pct
AAPL	6.66	13.16	50.6
AMZN	5.88	21.76	27
KO	2.06	3.65	56.3
MSFT	3.73	14.24	26.2
NVDA	15.19	45.34	33.5
SPY	7.48	15.48	48.3

the exact SQL behind every number

SELECT
    ticker,
    round(toFloat64(max(short_volume)) / 1e6, 2)                                  AS short_volume_millions,
    round(toFloat64(max(total_volume)) / 1e6, 2)                                  AS total_volume_millions,
    round(100 * toFloat64(max(short_volume)) / toFloat64(max(total_volume)), 1)   AS short_pct
FROM global_markets.stocks_short_volume
WHERE ticker IN ('AAPL', 'AMZN', 'KO', 'MSFT', 'NVDA', 'SPY')
  AND date = '2026-06-12'
GROUP BY ticker
HAVING max(total_volume) > 0
ORDER BY ticker

More from this analysisHow to Download FINRA Daily Short Volume Data

Where AAPL's off-exchange short volume was reported on June 12, 2026 ranking 5×3 → Symbols carried in each June 2026 daily short volume file series 21×5 → Month-end closes that set a new high for the window, by year (SPY) ranking 21×4 → Highest days to cover, latest settlement date (min 1M shares/day traded) ranking 10×3 → See all 2,433 queries →