Which venues sat on the bid side of the quote record, KO on June 16, 2026

SELECT
    ex.venue_name                                     AS venue,
    qt.bid_updates                                    AS bid_quote_update_count,
    round(100 * qt.bid_updates / qt.total_updates, 1) AS share_of_updates_pct
FROM
(
    SELECT
        toUInt32(bid_exchange) AS venue_id,
        count()                AS bid_updates,
        sum(count()) OVER ()   AS total_updates
    FROM global_markets.cache_stocks_quotes
    WHERE ticker = 'KO'
      AND sip_timestamp >= '2026-06-16 12:00:00'
      AND sip_timestamp <  '2026-06-16 22:00:00'
    GROUP BY venue_id
) AS qt
INNER JOIN
(
    SELECT
        toUInt32(id) AS venue_id,
        name         AS venue_name
    FROM global_markets.stocks_exchanges
    WHERE lower(asset_class) = 'stocks'
) AS ex ON ex.venue_id = qt.venue_id
ORDER BY bid_quote_update_count DESC