3,256 answered market questions

SELECT
    ticker                                            AS symbol,
    round(10000 * avg(
        toFloat64(ask_price - bid_price)
        / toFloat64((ask_price + bid_price) / 2)), 2) AS avg_spread_bps,
    count()                                           AS quote_count
FROM global_markets.cache_stocks_quotes
WHERE ticker IN ('AAPL', 'KO', 'MSFT', 'NVDA', 'SPY')
  AND sip_timestamp >= '2026-09-16 13:00:00'
  AND sip_timestamp <  '2026-09-16 21:00:00'
  AND bid_price > 0
  AND ask_price > bid_price
GROUP BY ticker
ORDER BY avg_spread_bps DESC