STRASMORE/EXPLORE 2,170 QUERIES

Options contracts, same-day share, and call share by session, July 20-24

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-12, from Market Recap: Week of July 20, 2026.

as of series 5×5read in context →
Options contracts, same-day share, and call share by session, July 20-24 — 5 rows by 5 columns, computed from US exchange, SIP and OPRA data.
datecontracts_mpct_0dtepct_callpct_expiring_jul24
2026-07-206440.255.315.1
2026-07-2157.329.553.917
2026-07-2255.836.156.419.9
2026-07-2366.226.453.426.4
2026-07-2471.14953.549
Rows × columns
5 × 5
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 Options contracts, same-day share, and call share by session, July 20-24, derived from the stored result.
ColumnTypeRangeNotes
date date 2026-07-20 to 2026-07-24
contracts_m number 55.8 to 71.1 count
pct_0dte number 26.4 to 49 percent
pct_call number 53.4 to 56.4 percent
pct_expiring_jul24 number 15.1 to 49 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(toDate(sip_timestamp)) AS date,
       round(toFloat64(sum(size)) / 1e6, 1) AS contracts_m,
       round(100.0 * sumIf(size, substring(ticker, length(ticker) - 14, 6) = formatDateTime(toDate(sip_timestamp), '%y%m%d')) / sum(size), 1) AS pct_0dte,
       round(100.0 * sumIf(size, substring(ticker, length(ticker) - 8, 1) = 'C') / sum(size), 1) AS pct_call,
       round(100.0 * sumIf(size, substring(ticker, length(ticker) - 14, 6) = '260724') / sum(size), 1) AS pct_expiring_jul24
FROM global_markets.options_trades
WHERE sip_timestamp >= '2026-07-20 00:00:00' AND sip_timestamp < '2026-07-25 00:00:00'
GROUP BY toDate(sip_timestamp)
ORDER BY toDate(sip_timestamp)

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 July 20, 2026
Treasury curve by session, July 17 print through July 24 series 6×6 SPY median quoted spread and NBBO updates per session, regular hours, July 20-24 series 5×5 SPY by session: close, change, and share volume, July 20-24 series 5×4 SEC filings by session and form type, July 20-24 series 5×5 Advancers and decliners per session, names with $5M+ traded, July 20-24 series 5×5 Daily short-volume file coverage: tickers on file and short shares, July 20-24 series 5×4 See all 2,170 queries →