STRASMORE/EXPLORE 2,985 QUERIES

Where the contracts landed: call and put volume by strike bucket

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-13, from MU: The Biggest Tape of June 2026.

as of ranking 16×4read in context →
Where the contracts landed: call and put volume by strike bucket — 16 rows by 4 columns, computed from US exchange, SIP and OPRA data.
strike_bucketcall_contractsput_contractsput_share_pct
$0866432910497.4
$100662833021898
$200537211175195.4
$300885520491395.9
$4002505035861793.5
$5002365466979896.6
$6003005994070696.9
$7006779487024292.8
$800209357125782985.7
$9001137271146023656.2
$10001923982107658935.9
$1100167873559600426.2
$120012890971092087.8
$1300601699172282.8
$140033043187072.6
$15001056463189161.8
Rows × columns
16 × 4
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 Where the contracts landed: call and put volume by strike bucket, derived from the stored result.
ColumnTypeRangeNotes
strike_bucket text 16 distinct values ($0, $100, $1000…)
call_contracts number 5,372 to 1,923,982 count
put_contracts number 8,707 to 1,460,236 count
put_share_pct number 1.8 to 98 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.

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

SELECT
    concat('$', toString(toUInt32(bucket))) AS strike_bucket,
    call_contracts,
    put_contracts,
    round(100.0 * put_contracts / (call_contracts + put_contracts), 1) AS put_share_pct
FROM (
    SELECT
        least(floor(toFloat64(toUInt32OrZero(substring(ticker, 12, 8))) / 1000 / 100) * 100, 1500) AS bucket,
        toUInt64(sumIf(size, substring(ticker, 11, 1) = 'C')) AS call_contracts,
        toUInt64(sumIf(size, substring(ticker, 11, 1) = 'P')) AS put_contracts
    FROM global_markets.options_trades
    WHERE startsWith(ticker, 'O:MU') AND length(ticker) = 19
      AND sip_timestamp >= toDateTime64('2026-06-01 00:00:00', 9) AND sip_timestamp < toDateTime64('2026-07-01 00:00:00', 9)
    GROUP BY bucket
)
ORDER BY toUInt32OrZero(substring(strike_bucket, 2))
⌘/Ctrl + Enter

在你的 AI 助理中使用這些資料

開啟即可查詢,已帶入本頁資料。免費,無需帳號。

More from this analysisMU: The Biggest Tape of June 2026
FINRA off-exchange short volume: MU's June coverage and marked-short share ranking 16×3 → What June's MU coverage was about: the vendor's own article tags, counted ranking 10×3 → The whole US tape ranked by June 2026 regular-hours dollar volume (one reused-symbol listing excluded pending entity verification) ranking 10×3 → MU month by month, recomputed live: return, close, and regular-hours turnover ranking 6×4 → The spread by session: regular-hours median in cents and basis points series 21×5 → The 21 sessions: close, close-over-close change, full-day volume series 21×4 → See all 2,985 queries →