STRASMORE/EXPLORE 2,830 QUERIES

protected_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.

as of table 27×5read in context →
protected_venues — 27 rows by 5 columns, computed from US exchange, SIP and OPRA data.
venueacronymmicvenue_typetape_code
OTC Equity SecurityOOTCORF
Consolidated Tape AssociationSIPS
Unlisted Trading PrivilegesSIPE
Cboe Stock ExchangeCBSXTRFW
FINRA Alternative Display FacilityXADFTRFD
FINRA NYSE TRFFINYTRF
FINRA Nasdaq TRF CarteretFINNTRF
FINRA Nasdaq TRF ChicagoFINCTRF
International Securities Exchange, LLC - StocksXISETRFI
24X National Exchange LLC24X24EQexchangeG
Cboe BYXBATYexchangeY
Cboe BZXBATSexchangeZ
Cboe EDGAEDGAexchangeJ
Cboe EDGXEDGXexchangeK
Investors ExchangeIEXGexchangeV
Long-Term Stock ExchangeLTSEexchangeL
MIAX PearlEPRLexchangeH
Members ExchangeMEMXexchangeU
NYSE American, LLCAMEXXASEexchangeA
NYSE Arca, Inc.ARCXexchangeP
NYSE National, Inc.NSXXCISexchangeC
NYSE Texas, Inc.XCHIexchangeM
NasdaqXNASexchangeT
Nasdaq Philadelphia Exchange LLCXPHLexchangeX
Nasdaq Texas, Inc.XBOSexchangeB
New York Stock ExchangeXNYSexchangeN
Texas Stock Exchange LLCTXSETXSEexchangeF
Rows × columns
27 × 5
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
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for protected_venues, derived from the stored result.
ColumnTypeRangeNotes
venue text 27 distinct values
acronym text 4 distinct values (24X, AMEX, NSX…) 4 of 27 rows populated
mic text 25 distinct values (24EQ, ARCX, BATS…) 25 of 27 rows populated
venue_type text 4 distinct values (ORF, SIP, TRF…)
tape_code text 23 distinct values (A, B, C…) 23 of 27 rows populated

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
    name           AS venue,
    acronym,
    mic,
    type           AS venue_type,
    participant_id AS tape_code
FROM global_markets.stocks_exchanges
WHERE asset_class = 'stocks'
  AND locale = 'us'
ORDER BY venue_type, venue
⌘/Ctrl + Enter

Work with this data in your AI assistant

Opens ready to query, with this page's data. Free, no account.

Claude ChatGPT Gemini Muse Your own agent
More from this analysisself-help-declarations-in-reg-nms
locked_clock table 16×5 → best_bid_venues ranking 12×3 → locked_names ranking 5×4 → The 2s10s spread, every print of the half table 124×2 → The 2s10s spread, every print of the half table 124×2 → Every half-year since 1976: the 2y and 10y change, the twist between them, and the half's lowest 2s10s print table 100×7 → See all 2,830 queries →