US equity and options venues in the exchange reference list
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-08, from Professional vs Non-Professional Market Data.
| category | venues | operating_groups |
|---|---|---|
| options exchange | 19 | 8 |
| stocks exchange | 18 | 9 |
| stocks TRF | 6 | 3 |
| stocks SIP | 2 | 2 |
| options SIP | 1 | 1 |
| stocks ORF | 1 | 1 |
- Rows × columns
- 6 × 3
- 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 |
|---|---|---|---|
category |
text | 6 distinct values | |
venues |
number | 1 to 19 | |
operating_groups |
number | 1 to 9 |
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
concat(asset_class, ' ', type) AS category,
count() AS venues,
countDistinct(operating_mic) AS operating_groups
FROM global_markets.stocks_exchanges
WHERE asset_class IN ('stocks', 'options')
GROUP BY category
ORDER BY venues DESC
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 analysisProfessional vs Non-Professional Market Data
Listed option contracts that traded on Jun 16, 2026, by underlying
ranking 5×4
→
Quote message rate by symbol, 10:00 to 11:00 a.m. ET on Jun 16, 2026
ranking 5×3
→
AAPL quote messages per 15 minutes, pinned session of Jun 16, 2026
series 36×2
→
How often the last price changes, minute by minute (June 2026)
ranking 6×3
→
The 15 minute gap across six household tickers (June 2026)
ranking 6×3
→
Live price against a 15 minute delayed view, one SPY session
series 37×5
→
See all 2,170 queries →