STRASMORE/EXPLORE 3,094 QUERIES

Where one session of AAPL prints actually happened, by venue

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-10-05, from Why a Limit Order Didn't Fill: 5 Causes.

as of ranking 15×4read in context →
Where one session of AAPL prints actually happened, by venue — 15 rows by 4 columns, computed from US exchange, SIP and OPRA data.
venueshares_millionspct_of_sharesprints
FINRA Alternative Display Facility11.4847.6381723
Nasdaq5.723.6112627
NYSE Arca, Inc.1.93858899
Cboe BZX1.295.434106
Investors Exchange0.933.923913
New York Stock Exchange0.83.321812
Cboe EDGX0.672.814560
Members Exchange0.411.710334
NYSE Texas, Inc.0.31.31310
Cboe BYX0.120.53199
Cboe EDGA0.120.54146
Nasdaq Texas, Inc.0.110.43516
MIAX Pearl0.070.31645
Texas Stock Exchange LLC0.060.31720
Nasdaq Philadelphia Exchange LLC0.050.21272
Rows × columns
15 × 4
Computed
Completeness
No missing values
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 Where one session of AAPL prints actually happened, by venue, derived from the stored result.
ColumnTypeRangeNotes
venue text 15 distinct values (Cboe BYX, Cboe BZX, Cboe EDGA…)
shares_millions number 0.05 to 11.48 count
pct_of_shares number 0.2 to 47.6 percent
prints number 1,272 to 381,723

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
    venue,
    round(shares / 1e6, 2)                        AS shares_millions,
    round(100 * shares / sum(shares) OVER (), 1)  AS pct_of_shares,
    prints
FROM
(
    SELECT
        any(if(empty(x.name), concat('Venue ', toString(t.exchange)), x.name)) AS venue,
        sum(t.size)                                                           AS shares,
        count()                                                               AS prints
    FROM global_markets.stocks_trades AS t
    LEFT JOIN global_markets.stocks_exchanges AS x ON x.id = t.exchange
    WHERE t.ticker = 'AAPL'
      AND t.sip_timestamp >= '2026-09-15 00:00:00'
      AND t.sip_timestamp <  '2026-09-16 00:00:00'
      AND (toHour(toTimeZone(t.sip_timestamp, 'America/New_York')) * 60
           + toMinute(toTimeZone(t.sip_timestamp, 'America/New_York'))) >= 570
      AND (toHour(toTimeZone(t.sip_timestamp, 'America/New_York')) * 60
           + toMinute(toTimeZone(t.sip_timestamp, 'America/New_York'))) < 960
    GROUP BY t.exchange
)
ORDER BY shares_millions DESC
LIMIT 15
⌘/Ctrl + Enter

Work with this data in your AI assistant

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

More from this analysisWhy a Limit Order Didn't Fill: 5 Causes
Shares traded at KO's lowest price levels in one session ranking 8×3 → Odd lots versus round lots in one AAPL session: prints and shares ranking 5×4 → Minutes a session spends near its own low, five household names series 5×4 → Average gap between tape prints, regular session, Sep 15 2026 ranking 6×3 → How often a resting limit was reached, by distance from the prior close (SPY, 2021 to Sep 2026) ranking 6×3 → A 1% buy limit vs a 1% sell limit: share of SPY sessions reached, by year ranking 6×3 → See all 3,094 queries →