US equity exchanges that feed the consolidated tape

Name: US equity exchanges that feed the consolidated tape
Creator: Strasmore
Published: 2026-08-09
License: https://www.strasmore.com/terms/

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-09, from SIP Feeds vs Direct Exchange Feeds.

as of 2026-08-09 table 18×4read in context →

US equity exchanges that feed the consolidated tape — 18 rows by 4 columns, computed 2026-08-09 from US exchange, SIP and OPRA data.
venue	venue_code	market_identifier_code	sip_participant_code
24X National Exchange LLC	24X	24EQ	G
Cboe BYX		BATY	Y
Cboe BZX		BATS	Z
Cboe EDGA		EDGA	J
Cboe EDGX		EDGX	K
Investors Exchange		IEXG	V
Long-Term Stock Exchange		LTSE	L
MIAX Pearl		EPRL	H
Members Exchange		MEMX	U
NYSE American, LLC	AMEX	XASE	A
NYSE Arca, Inc.		ARCX	P
NYSE National, Inc.	NSX	XCIS	C
NYSE Texas, Inc.		XCHI	M
Nasdaq		XNAS	T
Nasdaq Philadelphia Exchange LLC		XPHL	X
Nasdaq Texas, Inc.		XBOS	B
New York Stock Exchange		XNYS	N
Texas Stock Exchange LLC	TXSE	TXSE	F

Rows × columns: 18 × 4
Computed: 2026-08-09
Completeness: Some fields are partly empty — see the columns below
Source: US exchange, SIP and OPRA market data
Licence: Strasmore terms · free, no signup
Formats: JSON · CSV · the SQL below

What each column holds

Column definitions for US equity exchanges that feed the consolidated tape, derived from the stored result.
Column	Type	Range	Notes
`venue`	text	18 distinct values
`venue_code`	text	4 distinct values (24X, AMEX, NSX…)	4 of 18 rows populated
`market_identifier_code`	text	18 distinct values (24EQ, ARCX, BATS…)
`sip_participant_code`	text	18 distinct values (A, B, C…)

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 2026-08-09, and the query below is what returned them.

the exact SQL behind every number

SELECT
    name                     AS venue,
    acronym                  AS venue_code,
    mic                      AS market_identifier_code,
    toString(participant_id) AS sip_participant_code
FROM global_markets.stocks_exchanges
WHERE lower(asset_class) = 'stocks'
  AND lower(locale) = 'us'
  AND lower(type) = 'exchange'
ORDER BY name

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 analysisSIP Feeds vs Direct Exchange Feeds

Quote update traffic across five household tickers, 10:00 to 11:00 a.m. ET on June 16, 2026 table 5×5 → Which venues sat on the bid side of the quote record, KO on June 16, 2026 ranking 17×3 → Venue clock to consolidated tape clock, KO quotes on June 16, 2026 series 15×4 → The same twelve prints, ranked by venue clock and by tape clock table 12×7 → Live price against a 15 minute delayed view, one SPY session series 37×5 → SIP receive lag by venue, AAPL, 10 June 2026 (microseconds) ranking 11×4 → See all 2,170 queries →