STRASMORE/EXPLORE 2,170 QUERIES

Data points per dataset: AAPL, last 60 days

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-22, from Short Interest vs Short Volume: The Difference.

as 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)33
Rows × columns
2 × 2
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for Data points per dataset: AAPL, last 60 days, derived from the stored result.
ColumnTypeRangeNotes
dataset text 2 distinct values
data_points number 3 to 33

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

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

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

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 How liquid US stocks distribute by short interest as a percent of shares outstanding ranking 5×4 TSLA short interest vs. average daily volume, bi-monthly (last 2 years) series 47×3 See all 2,170 queries →