The penny tick and the quoted gap, in basis points

WITH best_quote AS
(
    SELECT
        ticker,
        toStartOfSecond(sip_timestamp) AS sec,
        toFloat64(max(bid_price))      AS best_bid,
        toFloat64(min(ask_price))      AS best_ask
    FROM global_markets.cache_stocks_quotes
    WHERE ticker IN ('MSFT', 'AAPL', 'NVDA', 'KO', 'BAC', 'T', 'F')
      AND sip_timestamp >= '2026-06-17 14:00:00'
      AND sip_timestamp <  '2026-06-17 14:15:00'
      AND bid_price > 0
      AND ask_price > bid_price
    GROUP BY ticker, sec
    HAVING min(ask_price) > max(bid_price)
)
SELECT
    concat(ticker, ' ($', toString(round(avg((best_bid + best_ask) / 2), 0)), ')') AS name,
    round(avg(best_ask - best_bid) * 100, 2)                                       AS avg_spread_cents,
    round(10000 * 0.01 / avg((best_bid + best_ask) / 2), 2)                        AS one_cent_bps,
    round(10000 * avg(best_ask - best_bid) / avg((best_bid + best_ask) / 2), 2)    AS spread_bps,
    if(avg(best_ask - best_bid) <= 0.015, 'at or under $0.015', 'above $0.015')     AS tier
FROM best_quote
GROUP BY ticker
ORDER BY avg((best_bid + best_ask) / 2) DESC