STRASMORE/EXPLORE 3,094 QUERIES

Put/call volume ratio by session, trailing three weeks

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

as of series 15×5read in context →
Put/call volume ratio by session, trailing three weeks — 15 rows by 5 columns, computed from US exchange, SIP and OPRA data.
session_datesession_labelpc_ratiocall_volput_vol
2026-09-14Sep 140.55436852241781
2026-09-15Sep 150.71532335378266
2026-09-16Sep 160.68711485484512
2026-09-17Sep 171.12672551750533
2026-09-18Sep 180.571027174581079
2026-09-21Sep 210.65493806322763
2026-09-22Sep 220.92323961298206
2026-09-23Sep 230.85349025296794
2026-09-24Sep 240.78410115320922
2026-09-25Sep 250.66472003312292
2026-09-28Sep 280.64367289235809
2026-09-29Sep 290.52475801247958
2026-09-30Sep 300.62438347270427
2026-10-01Oct 10.66455750300312
2026-10-02Oct 20.81938299762034
Rows × columns
15 × 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 Put/call volume ratio by session, trailing three weeks, derived from the stored result.
ColumnTypeRangeNotes
session_date date 2026-09-14 to 2026-10-02
session_label text 15 distinct values (Oct 1, Oct 2, Sep 14…)
pc_ratio number 0.52 to 1.12 ratio or rate
call_vol number 323,961 to 1,027,174
put_vol number 235,809 to 762,034

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
    toDate(toTimeZone(sip_timestamp, 'America/New_York')) AS session_date,
    formatDateTime(toDate(toTimeZone(sip_timestamp, 'America/New_York')), '%b %e') AS session_label,
    round(sumIf(size, substring(ticker, 13, 1) = 'P') / sumIf(size, substring(ticker, 13, 1) = 'C'), 2) AS pc_ratio,
    sumIf(size, substring(ticker, 13, 1) = 'C') AS call_vol,
    sumIf(size, substring(ticker, 13, 1) = 'P') AS put_vol
FROM global_markets.options_trades
WHERE ticker LIKE 'O:SPCX%'
  AND length(ticker) = 21
  AND sip_timestamp >= now() - INTERVAL 21 DAY AND sip_timestamp < now()
GROUP BY session_date, session_label
HAVING sumIf(size, substring(ticker, 13, 1) = 'C') > 0
ORDER BY session_date
⌘/Ctrl + Enter

Fanya kazi na data hii kwenye msaidizi wako wa AI

Hufunguka tayari kuuliza, na data ya ukurasa huu. Bure, bila akaunti.

Claude ChatGPT Gemini Muse Wakala wako mwenyewe
More from this analysisSPCX: SpaceX Stock Price Decline From Peak
Regular-hours session scoreboard: open, close, low, high, volume for every SPCX session since listing series 78×7 → Stock quote spread and depth by session: the four weeks from listing and the trailing three series 34×5 → SPY vs SPCX open-to-close, regular hours, trailing three weeks series 15×4 → Latest complete session, half-hour path: closes, lows, and volume series 13×4 → Options quote spread and size at the touch, the sessions on file in the past week and a half series 5×6 → Latest session on file: the busiest SPCX option contracts by volume table 10×5 → See all 3,094 queries →