STRASMORE/EXPLORE 2,170 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,170 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Professional vs Non-Professional Market Data
US equity and options venues in the exchange reference listranking · 2026-08-08 · 6×3Preview: 6 ranked values, largest first. AAPL quote messages per 15 minutes, pinned session of Jun 16, 2026series · 2026-08-08 · 36×2Preview: a 16-point series, ending higher. Listed option contracts that traded on Jun 16, 2026, by underlyingranking · 2026-08-08 · 5×4Preview: 5 ranked values, largest first. Quote message rate by symbol, 10:00 to 11:00 a.m. ET on Jun 16, 2026ranking · 2026-08-08 · 5×3Preview: 5 ranked values, largest first.
US equity and options venues in the exchange reference list

US equity and options venues in the exchange reference list

most recentas of ranking 6×3read in context →
US equity and options venues in the exchange reference list — 6 rows by 3 columns, computed from US exchange, SIP and OPRA data.
categoryvenuesoperating_groups
options exchange198
stocks exchange189
stocks TRF63
stocks SIP22
options SIP11
stocks ORF11
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
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 → See all 2,170 queries →
$