The new entity's short-interest prints to date, with implied days-to-cover

Name: The new entity's short-interest prints to date, with implied days-to-cover
Creator: Strasmore
Published: 2026-07-26
License: https://www.strasmore.com/terms/

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-07-26, from SPCX: The Week It Went Underwater.

as of 2026-07-26 table 2×5read in context →

The new entity's short-interest prints to date, with implied days-to-cover — 2 rows by 5 columns, computed 2026-07-26 from US exchange, SIP and OPRA data.
settlement	shares_short_m	avg_daily_volume_m	vendor_days_to_cover	implied_days_to_cover
2026-06-15	23.3	69.2	1	0.34
2026-06-30	111.3	151.6	1	0.73

Rows × columns: 2 × 5
Period covered: 2026-06-15 to 2026-06-30
Computed: 2026-07-26
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 The new entity's short-interest prints to date, with implied days-to-cover, derived from the stored result.
Column	Type	Range	Notes
`settlement`	date	2026-06-15 to 2026-06-30
`shares_short_m`	number	23.3 to 111.3	count
`avg_daily_volume_m`	number	69.2 to 151.6	count
`vendor_days_to_cover`	number	every row is 1
`implied_days_to_cover`	number	0.34 to 0.73

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 2026-07-26, and the query below is what returned them.

the exact SQL behind every number

SELECT toString(settlement_date) AS settlement,
       round(toFloat64(max(short_interest)) / 1e6, 1) AS shares_short_m,
       round(toFloat64(max(avg_daily_volume)) / 1e6, 1) AS avg_daily_volume_m,
       max(days_to_cover) AS vendor_days_to_cover,
       round(toFloat64(max(short_interest)) / toFloat64(max(avg_daily_volume)), 2) AS implied_days_to_cover
FROM global_markets.stocks_short_interest
WHERE ticker = 'SPCX' AND settlement_date >= toDate('2026-06-01') AND settlement_date <= toDate('2026-06-30')
GROUP BY settlement_date
ORDER BY settlement_date

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 analysisSPCX: The Week It Went Underwater

The week's contracts by strike bucket ($20 buckets; tails capped at $80 and $240) table 9×6 → Large recent debuts, first month on one ruler: first trade to the day-28 close (ET regular hours) table 7×8 → The symbol's trading history by month: the gap and the new entity's arrival series 12×5 → The week's heaviest tickers by regular-hours dollar volume: where the newcomer now sits ranking 12×4 → Median quoted spread by session, regular hours (bps of midpoint) series 5×3 → SPCX by session: close, change, shares, dollars series 5×5 → See all 2,170 queries →