exchange rules — 4 answered market questions

Venues quoting and printing the same stock in one 15-minute window

most recentas of 2026-08-13 ranking 6×3read in context →

Venues quoting and printing the same stock in one 15-minute window — 6 rows by 3 columns, computed 2026-08-13 from US exchange, SIP and OPRA data.
ticker	quoting_venues	printing_venues
AAPL	16	17
MSFT	16	17
NVDA	16	17
JNJ	14	16
SPY	14	17
KO	11	17

the exact SQL behind every number

SELECT
    q.ticker          AS ticker,
    q.quoting_venues  AS quoting_venues,
    t.printing_venues AS printing_venues
FROM
(
    SELECT
        ticker,
        countDistinct(bid_exchange) AS quoting_venues
    FROM global_markets.cache_stocks_quotes
    WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'KO', 'JNJ')
      AND sip_timestamp >= toDateTime('2026-06-10 14:00:00', 'UTC')
      AND sip_timestamp <  toDateTime('2026-06-10 14:15:00', 'UTC')
      AND bid_price > 0
    GROUP BY ticker
) AS q
INNER JOIN
(
    SELECT
        ticker,
        countDistinct(exchange) AS printing_venues
    FROM global_markets.stocks_trades
    WHERE ticker IN ('AAPL', 'MSFT', 'NVDA', 'SPY', 'KO', 'JNJ')
      AND sip_timestamp >= toDateTime('2026-06-10 14:00:00', 'UTC')
      AND sip_timestamp <  toDateTime('2026-06-10 14:15:00', 'UTC')
    GROUP BY ticker
) AS t ON t.ticker = q.ticker
ORDER BY quoting_venues DESC, ticker

More from this analysisSelf-Match Prevention and Wash Trades

Trade condition flags on one full session ranking 10×3 → Prints per 15-minute bucket, one full session series 64×2 → Option contracts with volume on one underlying, June 2026 series 21×3 → Average shares per trade print, June 2026 ranking 8×2 → See all 2,170 queries →