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

3,256 answered market questions

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

Short Interest vs Short Volume: The Difference
Data points per dataset: AAPL, last 60 daysranking · 2026-10-04 · 2×2Preview: 2 ranked values, smallest first. Highest days to cover, latest settlement date (min 1M shares/day traded)ranking · 2026-10-04 · 10×3Preview: 10 ranked values, largest first. AAPL daily short volume ratio (last ~60 days)series · 2026-10-04 · 32×2Preview: a 16-point series, ending higher. AAPL short interest vs. average daily volume, bi-monthly (last 2 years)series · 2026-10-04 · 47×3Preview: a 16-point series, roughly flat. AAPL days to cover at each settlement date (last 2 years)series · 2026-10-04 · 47×3Preview: a 16-point series, roughly flat.
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.
Data points per dataset: AAPL, last 60 days

Data points per dataset: AAPL, last 60 days

most recentas of ranking 2×2read in context →
Data points per dataset: AAPL, last 60 days — 2 rows by 2 columns, computed from US exchange, SIP and OPRA data.
datasetdata_points
Short interest (bi-monthly snapshot)3
Short volume (daily flow)32
the exact SQL behind every number
SELECT dataset, data_points
FROM
(
    SELECT 'Short interest (bi-monthly snapshot)' AS dataset,
           count(DISTINCT settlement_date) AS data_points
    FROM global_markets.stocks_short_interest
    WHERE ticker = 'AAPL'
      AND settlement_date >= today() - INTERVAL 60 DAY
    UNION ALL
    SELECT 'Short volume (daily flow)' AS dataset,
           count(DISTINCT date) AS data_points
    FROM global_markets.stocks_short_volume
    WHERE ticker = 'AAPL'
      AND date >= today() - INTERVAL 60 DAY
)
ORDER BY data_points ASC
$