best_bid_venues
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-30, from self-help-declarations-in-reg-nms.
| venue | mic | best_bid_share_pct |
|---|---|---|
| Nasdaq | XNAS | 37.11 |
| Investors Exchange | IEXG | 24.54 |
| NYSE Arca, Inc. | ARCX | 21.32 |
| Cboe BZX | BATS | 7.31 |
| Members Exchange | MEMX | 3.44 |
| Cboe EDGX | EDGX | 2.68 |
| Binance | 1.5 | |
| New York Stock Exchange | XNYS | 1.5 |
| NYSE Texas, Inc. | XCHI | 0.51 |
| MIAX Pearl | EPRL | 0.37 |
| Cboe EDGA | EDGA | 0.35 |
| Cboe BYX | BATY | 0.33 |
- Rows × columns
- 12 × 3
- Computed
- Completeness
- Some fields are partly empty — see the columns below
- Source
- US exchange, SIP and OPRA market data
- Licence
- Strasmore terms · free, no signup
What each column holds
| Column | Type | Range | Notes |
|---|---|---|---|
venue |
text | 12 distinct values (Binance, Cboe BYX, Cboe BZX…) | |
mic |
text | 11 distinct values (ARCX, BATS, BATY…) | 11 of 12 rows populated |
best_bid_share_pct |
number | 0.33 to 37.11 | percent |
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
ex.name AS venue,
ex.mic AS mic,
round(100 * count() / (
SELECT count()
FROM global_markets.cache_stocks_quotes
WHERE ticker = 'AAPL'
AND sip_timestamp >= toDateTime('2026-06-10 08:00:00', 'UTC')
AND sip_timestamp < toDateTime('2026-06-11 00:00:00', 'UTC')
AND bid_price > 0
), 2) AS best_bid_share_pct
FROM global_markets.cache_stocks_quotes AS q
INNER JOIN global_markets.stocks_exchanges AS ex ON ex.id = q.bid_exchange
WHERE q.ticker = 'AAPL'
AND q.sip_timestamp >= toDateTime('2026-06-10 08:00:00', 'UTC')
AND q.sip_timestamp < toDateTime('2026-06-11 00:00:00', 'UTC')
AND q.bid_price > 0
GROUP BY venue, mic
ORDER BY best_bid_share_pct DESC
LIMIT 12
Work with this data in your AI assistant
Opens ready to query, with this page's data. Free, no account.