Venues publishing a bid in AAPL over one half hour, July 16 2026

SELECT
    ex.venue_name                  AS venue,
    ex.venue_code                  AS venue_code,
    q.bids                         AS quote_update_count,
    formatReadableQuantity(q.bids) AS updates_label
FROM
(
    SELECT
        toUInt32(bid_exchange) AS exchange_id,
        count()                AS bids
    FROM global_markets.cache_stocks_quotes
    WHERE ticker = 'AAPL'
      AND sip_timestamp >= toDateTime('2026-07-16 16:00:00')
      AND sip_timestamp <  toDateTime('2026-07-16 16:30:00')
      AND bid_price > 0
    GROUP BY exchange_id
) AS q
INNER JOIN
(
    SELECT
        toUInt32(id)   AS exchange_id,
        any(name)      AS venue_name,
        any(acronym)   AS venue_code
    FROM global_markets.stocks_exchanges
    WHERE asset_class = 'stocks'
    GROUP BY exchange_id
) AS ex ON ex.exchange_id = q.exchange_id
ORDER BY q.bids DESC