Options quote spread and size at the touch, the sessions on file in the past week and a half
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.
| session_date | session_label | opt_spread_bps | avg_size | dropped_invalid | quotes |
|---|---|---|---|---|---|
| 2026-09-28 | Sep 28 | 1085.63 | 176 | 5674 | 87096587 |
| 2026-09-29 | Sep 29 | 1092.22 | 189 | 5051 | 89869721 |
| 2026-09-30 | Sep 30 | 1073.98 | 166 | 3614 | 88081039 |
| 2026-10-01 | Oct 1 | 1143.86 | 171 | 4435 | 84085472 |
| 2026-10-02 | Oct 2 | 1191.78 | 237 | 9404 | 114550454 |
- Rows × columns
- 5 × 6
- Period covered
- to
- Computed
- Completeness
- No missing values
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
session_date |
date | 2026-09-28 to 2026-10-02 | |
session_label |
text | 5 distinct values (Oct 1, Oct 2, Sep 28…) | |
opt_spread_bps |
number | 1,073.98 to 1,191.78 | |
avg_size |
number | 166 to 237 | |
dropped_invalid |
number | 3,614 to 9,404 | |
quotes |
number | 84,085,472 to 114,550,454 |
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(avgIf((toFloat64(ask_price) - toFloat64(bid_price)) / ((toFloat64(ask_price) + toFloat64(bid_price)) / 2) * 10000, bid_price > 0 AND ask_price > bid_price), 2) AS opt_spread_bps,
round(avgIf((toFloat64(ask_size) + toFloat64(bid_size)) / 2, bid_price > 0 AND ask_price > bid_price), 0) AS avg_size,
countIf(NOT (bid_price > 0 AND ask_price > bid_price)) AS dropped_invalid,
count() AS quotes
FROM global_markets.cache_options_quotes
WHERE ticker LIKE 'O:SPCX%'
AND sip_timestamp >= now() - INTERVAL 8 DAY AND sip_timestamp < now()
AND (toHour(toTimeZone(sip_timestamp, 'America/New_York')) * 60 + toMinute(toTimeZone(sip_timestamp, 'America/New_York'))) BETWEEN 570 AND 959
GROUP BY session_date, session_label
HAVING countIf(bid_price > 0 AND ask_price > bid_price) > 0
ORDER BY session_date
עבדו עם הנתונים האלה בעוזר ה-AI שלכם
נפתח מוכן לשאילתות, עם הנתונים של העמוד הזה. בחינם, בלי חשבון.