STRASMORE/EXPLORE 3,293 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-17, 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-28Sep 280.64367289235809
2026-09-29Sep 290.52475801247958
2026-09-30Sep 300.62438347270427
2026-10-01Oct 10.66455750300312
2026-10-02Oct 20.81938299762034
2026-10-05Oct 50.621044687646917
2026-10-06Oct 60.73653328479866
2026-10-07Oct 70.85584405497058
2026-10-08Oct 80.99531400525781
2026-10-09Oct 90.59877288513379
2026-10-12Oct 120.53647832341399
2026-10-13Oct 130.54640269345626
2026-10-14Oct 140.71604790429970
2026-10-15Oct 150.8701857562244
2026-10-16Oct 160.9698656630590
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-28 to 2026-10-16
session_label text 15 distinct values (Oct 1, Oct 12, Oct 13…)
pc_ratio number 0.52 to 0.99 ratio or rate
call_vol number 367,289 to 1,044,687
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

在你的 AI 助手中使用这些数据

打开即可查询，已带上本页数据。免费，无需账号。

Claude ChatGPT Gemini Muse 你自己的智能体
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 87×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 14×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,293 queries →