STRASMORE/EXPLORE 3,256 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,256 answered market questions

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

Self-Help Declarations Under Reg NMS Rule 611
US equity venues and reporting facilities in the exchange registrytable · 2026-09-30 · 27×5 Locked NBBO rate before the open versus midday, five liquid namesranking · 2026-09-30 · 5×4Preview: 5 ranked values, largest first. Locked and crossed NBBO rates in AAPL by ET hour, June 10, 2026table · 2026-09-30 · 16×5 Which venues supplied the national best bid in AAPL on June 10, 2026ranking · 2026-09-30 · 12×3Preview: 12 ranked values, largest first.
Mass Cancels and Purge Ports Explained
AAPL quoted spread in basis points, first hour of April 7, 2025series · 2026-09-30 · 60×3Preview: a 16-point series, ending lower. AAPL quote updates per second, volatile session vs quiet sessionseries · 2026-09-30 · 54×4Preview: a 16-point series, ending lower. How far AAPL travelled in each ten-minute bucket, same two sessionsseries · 2026-09-30 · 54×3Preview: a 16-point series, ending lower. Distinct option contracts that printed a trade on April 7, 2025ranking · 2026-09-30 · 5×2Preview: 5 ranked values, largest first.
Can You Trade US Stocks 24 Hours a Day?
Shares printed by New York clock hour: AAPL, MSFT, NVDA, SPY and TSLA, week of July 13, 2026series · 2026-09-28 · 16×3Preview: a 16-point series, roughly flat. AAPL quoted spread by New York clock hour, July 14, 2026: median and 90th percentile minuteranking · 2026-09-28 · 7×4Preview: 7 ranked values, smallest first. Share of weekly volume by session window: seven household names, week of July 13, 2026ranking · 2026-09-28 · 7×4Preview: 7 ranked values, largest first. NVDA on July 14, 2026: price and volume in 30 minute buckets, 4:00 a.m. to 8:00 p.m. ETseries · 2026-09-28 · 32×3Preview: a 16-point series, roughly flat.
Due Bills and Stock Splits: Ex-Date Timing
US stock splits by year, sorted by size of the distributionranking · 2026-09-26 · 10×4Preview: 10 ranked values, smallest first. NVDA across its June 2024 split: stored close and one pre-split shareseries · 2026-09-26 · 10×5Preview: a 10-point series, ending higher. Days between pay date and ex-date, cash distributions that went ex lateranking · 2026-09-26 · 12×3Preview: 12 ranked values, largest first. Recent household-name splits: shares from one shareranking · 2026-09-26 · 15×4Preview: 15 ranked values, largest first.
US equity venues and reporting facilities in the exchange registry

US equity venues and reporting facilities in the exchange registry

most recentas of table 27×5read in context →
US equity venues and reporting facilities in the exchange registry — 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
the exact SQL behind every number 
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
More from this analysisSelf-Help Declarations Under Reg NMS Rule 611
Locked and crossed NBBO rates in AAPL by ET hour, June 10, 2026 table 16×5 → Which venues supplied the national best bid in AAPL on June 10, 2026 ranking 12×3 → Locked NBBO rate before the open versus midday, five liquid names ranking 5×4 → Executed volume by price level: the traded ladder (KO, 30 minutes) table 63×3 → See all 3,256 queries →
$