3,256 answered market questions

SELECT
    if(ex.name = '', concat('Venue ', toString(d.exchange)), ex.name) AS venue,
    round(d.trades / 1000, 1)                                         AS trade_thousands,
    round(100 * d.trades / sum(d.trades) OVER (), 1)                  AS share_pct
FROM
(
    SELECT
        toInt32(exchange) AS exchange,
        count()           AS trades
    FROM global_markets.stocks_trades
    WHERE ticker = 'SPY'
      AND sip_timestamp >= toDateTime('2026-08-19 08:00:00')
      AND sip_timestamp <  toDateTime('2026-08-20 08:00:00')
    GROUP BY exchange
) AS d
LEFT JOIN
(
    SELECT
        toInt32(id) AS id,
        any(name)   AS name
    FROM global_markets.stocks_exchanges
    WHERE asset_class = 'stocks'
    GROUP BY id
) AS ex ON ex.id = d.exchange
ORDER BY d.trades DESC
LIMIT 12