STRASMORE/EXPLORE 2,170 QUERIES

Latest session on file: the busiest SPCX option contracts by volume

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-20, from SPCX: SpaceX Stock Price Decline From Peak.

as of table 10×5read in context →
Latest session on file: the busiest SPCX option contracts by volume — 10 rows by 5 columns, computed from US exchange, SIP and OPRA data.
labelexpiry_labelsession_labelvolumenotional_m
145-strike callAug 21, 2026Aug 19, 2026294580.04
140-strike callAug 21, 2026Aug 19, 2026259760.08
140-strike putAug 21, 2026Aug 19, 2026255830.1
150-strike callAug 21, 2026Aug 19, 2026247960.01
160-strike callAug 21, 2026Aug 19, 2026247000
135-strike putAug 21, 2026Aug 19, 2026187050.03
140-strike callAug 28, 2026Aug 19, 2026129810.07
155-strike callAug 21, 2026Aug 19, 2026124860
130-strike putAug 21, 2026Aug 19, 2026105120.01
138-strike putAug 21, 2026Aug 19, 2026102300.03
Rows × columns
10 × 5
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 Latest session on file: the busiest SPCX option contracts by volume, derived from the stored result.
ColumnTypeRangeNotes
label text 9 distinct values
expiry_label text 2 distinct values (Aug 21, 2026, Aug 28, 2026)
session_label text 1 distinct value (Aug 19, 2026)
volume number 10,230 to 29,458 count
notional_m number 0 to 0.1

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 
WITH latest_opt_session AS (
    SELECT max(toDate(toTimeZone(sip_timestamp, 'America/New_York'))) AS d
    FROM global_markets.options_trades
    WHERE ticker LIKE 'O:SPCX%'
      AND length(ticker) = 21
      AND sip_timestamp >= now() - INTERVAL 8 DAY AND sip_timestamp < now()
)
SELECT
    concat(toString(toUInt32OrZero(substring(ticker, 14, 8)) / 1000), '-strike ', if(substring(ticker, 13, 1) = 'C', 'call', 'put')) AS label,
    formatDateTime(toDate(concat('20', substring(ticker, 7, 2), '-', substring(ticker, 9, 2), '-', substring(ticker, 11, 2))), '%b %e, %Y') AS expiry_label,
    formatDateTime(max(toDate(toTimeZone(sip_timestamp, 'America/New_York'))), '%b %e, %Y') AS session_label,
    sum(size) AS volume,
    round(sum(toFloat64(size) * toFloat64(price)) / 1e6, 2) AS notional_m
FROM global_markets.options_trades
WHERE ticker LIKE 'O:SPCX%'
  AND length(ticker) = 21
  AND sip_timestamp >= now() - INTERVAL 8 DAY AND sip_timestamp < now()
  AND toDate(toTimeZone(sip_timestamp, 'America/New_York')) = (SELECT d FROM latest_opt_session)
GROUP BY label, expiry_label
ORDER BY volume DESC
LIMIT 10

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: SpaceX Stock Price Decline From Peak
Sessions from listing to the first close below the first print: SPCX vs four recent IPOs table 5×11 → Regular-hours session scoreboard: open, close, low, high, volume for every SPCX session since listing series 47×7 → Stock quote spread and depth by session: the four weeks from listing and the trailing three series 33×5 → SPY vs SPCX open-to-close, regular hours, trailing three weeks series 15×4 → Put/call volume ratio by session, trailing three weeks series 15×5 → Latest complete session, half-hour path: closes, lows, and volume series 7×4 → See all 2,170 queries →