short volume — 5 answered market questions

Data points per dataset: AAPL, last 60 days

most recentas of 2026-08-22 ranking 2×2read in context →

Data points per dataset: AAPL, last 60 days — 2 rows by 2 columns, computed 2026-08-22 from US exchange, SIP and OPRA data.
dataset	data_points
Short interest (bi-monthly snapshot)	3
Short volume (daily flow)	33

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

More from this analysisShort Interest vs Short Volume: The Difference

Highest days to cover, latest settlement date (min 1M shares/day traded) ranking 10×3 → AAPL short interest vs. average daily volume, bi-monthly (last 2 years) series 47×3 → AAPL days to cover at each settlement date (last 2 years) series 47×3 → AAPL daily short volume ratio (last ~60 days) series 33×2 → See all 2,170 queries →