STRASMORE/EXPLORE 2,170 QUERIES

Days to cover: household names against the most in-demand liquid borrows

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 Fully Paid Securities Lending Explained.

as of ranking 10×2read in context →
Days to cover: household names against the most in-demand liquid borrows — 10 rows by 2 columns, computed from US exchange, SIP and OPRA data.
tickerdays_to_cover
MPT30.82
OCGN21.55
INDI16.62
IBRX14.49
NWBO10.82
JNJ2.99
XOM2.94
AAPL2.42
KO2.39
MSFT2.03
Rows × columns
10 × 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 Days to cover: household names against the most in-demand liquid borrows, derived from the stored result.
ColumnTypeRangeNotes
ticker text 10 distinct values (AAPL, IBRX, INDI…)
days_to_cover number 2.03 to 30.82

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
    ticker,
    round(argMax(days_to_cover, settlement_date), 2) AS days_to_cover
FROM global_markets.stocks_short_interest
WHERE settlement_date >= today() - 45
  AND ticker NOT IN ('SPCX')
  AND (
        ticker IN ('AAPL', 'MSFT', 'KO', 'XOM', 'JNJ')
        OR ticker IN (
            SELECT ticker
            FROM
            (
                SELECT
                    ticker,
                    argMax(days_to_cover, settlement_date) AS dtc
                FROM global_markets.stocks_short_interest
                WHERE settlement_date >= today() - 45
                  AND avg_daily_volume > 5000000
                  AND ticker NOT IN ('SPCX')
                GROUP BY ticker
                ORDER BY dtc DESC
                LIMIT 5
            )
        )
      )
GROUP BY ticker
ORDER BY days_to_cover DESC

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 analysisFully Paid Securities Lending Explained
Cash paid per share and payment count, trailing year ranking 8×3 → Share of reported KO volume marked short, by session series 69×3 → Days to cover for two large dividend payers, by settlement date series 47×4 → Reported short interest across the same dividend payers ranking 11×3 → PFE short interest by settlement date, Aug 2025 through Jul 2026 series 24×3 → Ex-dividend events per month across the whole US calendar series 12×4 → See all 2,170 queries →