STRASMORE/EXPLORE 3,293 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,293 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

How to Download FINRA Daily Short Volume Data
Short volume ratio on June 12, 2026 for six household namesranking · 2026-09-19 · 6×4Preview: 6 ranked values, smallest first. Symbols carried in each June 2026 daily short volume fileseries · 2026-09-19 · 21×5Preview: a 16-point series, ending lower. Where AAPL's off-exchange short volume was reported on June 12, 2026ranking · 2026-09-19 · 5×3Preview: 5 ranked values, largest first.
Short Selling Bans Explained: US, Germany, EU
What ESMA measured during the 2020 bans (published estimates, % versus the control group)ranking · 2026-09-15 · 4×2Preview: 4 ranked values, largest first. Every outright short selling ban since 2008, dated to the order that set ittable · 2026-09-15 · 9×5
Short volume ratio on June 12, 2026 for six household names

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

most recentas of ranking 6×4read in context →
Short volume ratio on June 12, 2026 for six household names — 6 rows by 4 columns, computed from US exchange, SIP and OPRA data.
tickershort_volume_millionstotal_volume_millionsshort_pct
AAPL6.6613.1650.6
AMZN5.8821.7627
KO2.063.6556.3
MSFT3.7314.2426.2
NVDA15.1945.3433.5
SPY7.4815.4848.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
$