STRASMORE/EXPLORE 2,170 QUERIES

FINRA off-exchange short volume by session: coverage and marked-short share

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 Market Recap: Week of June 29, 2026.

as of ranking 4×4read in context →
FINRA off-exchange short volume by session: coverage and marked-short share — 4 rows by 4 columns, computed from US exchange, SIP and OPRA data.
dtickers_on_filealphabetical_endmarked_short_pct
2026-06-295489SSUS45.8
2026-06-3015362ZYME48.8
2026-07-0114995ZYME49.7
2026-07-0215288ZYME46.9
Rows × columns
4 × 4
Period covered
to
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 FINRA off-exchange short volume by session: coverage and marked-short share, derived from the stored result.
ColumnTypeRangeNotes
d date 2026-06-29 to 2026-07-02
tickers_on_file number 5,489 to 15,362
alphabetical_end text 2 distinct values (SSUS, ZYME)
marked_short_pct number 45.8 to 49.7 percent

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 toString(date) AS d,
    uniqExact(ticker) AS tickers_on_file,
    max(ticker) AS alphabetical_end,
    round(100 * sum(toFloat64(short_volume)) / sum(toFloat64(total_volume)), 1) AS marked_short_pct
FROM (
    SELECT date, ticker, any(short_volume) AS short_volume, any(total_volume) AS total_volume
    FROM global_markets.stocks_short_volume
    WHERE date >= toDate('2026-06-29') AND date <= toDate('2026-07-02')
    GROUP BY date, ticker
)
GROUP BY date
ORDER BY 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 analysisMarket Recap: Week of June 29, 2026
Regular-hours dollar volume, week of June 29 (one reused-symbol listing excluded pending entity verification) ranking 8×3 Contracts traded during the week, by expiry date (single-pass scan; batch-generated) ranking 6×3 Treasury yields through the week (July 2 print not yet ingested at generation) ranking 5×4 Session by session: SPY close, change, and full-day volume series 4×4 Week-over-week: the four index ETFs against the prior Friday's close table 4×5 The session receipt: four traded days, one Friday closure, verified from the tape scalar 1×3 See all 2,170 queries →