expiry_weekdays
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-09-13, from ndx-vs-qqq-options.
| label | qqq_expirations |
|---|---|
| Mon | 5 |
| Tue | 6 |
| Wed | 6 |
| Thu | 6 |
| Fri | 7 |
- Rows × columns
- 5 × 2
- 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 |
|---|---|---|---|
label |
text | 5 distinct values (Fri, Mon, Thu…) | |
qqq_expirations |
number | 5 to 7 |
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
SELECT
formatDateTime(expiration_date, '%a') AS label,
countDistinct(expiration_date) AS qqq_expirations
FROM global_markets.options_greeks
WHERE underlying_symbol = 'QQQ'
AND date >= today() - 45
AND date < today()
AND expiration_date >= today() - 45
AND expiration_date < today()
AND volume > 0
GROUP BY label, toDayOfWeek(expiration_date)
ORDER BY toDayOfWeek(expiration_date)
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 analysisndx-vs-qqq-options
qqq_dividends
series 8×4
→
qqq_liquidity
scalar 1×7
→
contract_size
scalar 1×4
→
Top 25 weekly-options underlyings by distinct contracts traded, with expiration weekdays
ranking 25×4
→
Annualized volatility vs total return, 25 large caps, calmest to wildest (~2 years)
ranking 25×3
→
SPY options median spread by expiration date, near-the-money strikes only
ranking 25×4
→
See all 2,225 queries →