Why crypto no get NBBO, SIP or one tape
Crypto no get NBBO, SIP or consolidated tape. See why venues fit show different prices, and how index and reference rates fill the gap.
Crypto no get NBBO. National best bid and offer na product of one rulebook, Regulation NMS, wey dey govern US exchanges wey trade NMS stocks. Crypto venues no get anything equivalent. Two exchanges fit quote different prices for the same coin at the same instant. Both quotes dey real, but neither one be the price. No mechanism anywhere for crypto get the job to produce one single price.
Why crypto no get NBBO: the two things wey dey missing
US equities dey get one price at a time through two parts of the market plumbing.
The first one na consolidated tape. Every registered exchange dey send im quotes and trades to securities information processor, SIP. SIP dey merge everything into one public stream. The highest bid anywhere for that stream and the lowest offer anywhere na the NBBO. Our guide on SIP versus direct exchange feeds explain how that data dey reach different subscribers at different speeds.
The second one na Rule 611, the order protection rule. Venue no fit execute order at price wey worse pass another venue’s protected quote. That one turn NBBO from ordinary published statistic into restriction on where order fit print.
Crypto no get either one. No processor dey merge venue feeds, and no rule dey stop venue from trading through better price wey dey elsewhere. Each exchange dey match im own orders against im own book, and na there e stop.
The equity version worth seeing closely. The panel below dey use one popular name, AAPL, across fixed half hour for morning of June 10, 2026. E split every share wey print according to the venue wey print am.
The exact SQL behind every number
WITH
win AS
(
SELECT
toUInt16(exchange) AS ex_id,
toFloat64(price) * toFloat64(size) AS notional,
toFloat64(size) AS shares
FROM global_markets.stocks_trades
WHERE ticker = 'AAPL'
AND sip_timestamp >= '2026-06-10 14:00:00'
AND sip_timestamp < '2026-06-10 14:30:00'
AND price > 0
AND size > 0
),
venues AS
(
SELECT
toUInt16(id) AS ex_id,
name
FROM global_markets.stocks_exchanges
WHERE asset_class = 'stocks'
),
by_venue AS
(
SELECT
ex_id,
sum(notional) AS notional,
sum(shares) AS shares,
count() AS print_count
FROM win
GROUP BY ex_id
)
SELECT
ifNull(nullIf(v.name, ''), concat('Venue ', toString(b.ex_id))) AS venue,
round(100 * b.shares / sum(b.shares) OVER (), 2) AS pct_of_shares,
b.print_count AS print_count,
round(abs(10000 * ((b.notional / b.shares)
/ (sum(b.notional) OVER () / sum(b.shares) OVER ()) - 1)), 2) AS abs_gap_bps
FROM by_venue AS b
LEFT JOIN venues AS v ON v.ex_id = b.ex_id
ORDER BY abs_gap_bps DESCShares change hands across 17 venues within thirty minutes. The panel rank dem by how far dem dey from the window’s overall volume-weighted average price. The venue wey dey furthest, 24X National Exchange LLC, dey 5.21 basis points away from am while e handle 0.01% of the shares. The closest one, Investors Exchange, print within 0.01 basis points. Basis point na one hundredth of one percent. This clustering no be because competitors dey cooperate politely. Na Rule 611 plus consolidated quote dey hold many separate order books to one price.
Why two crypto venues dey show different prices at the same instant?
The books separate, and capital wey fit join dem dey move slowly. To buy for cheap venue and sell for expensive one at the same moment, you need coins already dey for selling venue and cash already dey for buying venue. Transfers need network confirmations and withdrawal review windows. The process fit take from minutes to days, and every transfer get fee. Gap go survive until person wey already position for both sides see say e worth taking.
The quoted spread na only the smaller part of the real cost. Take hypothetical example: venue wey charge 0.10% to take liquidity on each side go collect 20 basis points for round trip. That one far pass 2 basis points quoted spread.
Locked and crossed quotes dey normal for crypto?
Market dey locked when best bid equal best offer. E dey crossed when bid higher than offer. For displayed equity quotes, both conditions na violations, and exchanges clear dem within moments, as locked and crossed markets explain. If you assemble top of book by hand, you go see the sequencing work wey consolidated feed dey perform. The panel below group the same ticker and window into one-second buckets. E take highest bid and lowest offer for each bucket, without considering which venue post am or the exact time e post am.
The exact SQL behind every number
WITH
q AS
(
SELECT
toDateTime(toTimeZone(sip_timestamp, 'America/New_York')) AS sec,
toFloat64(bid_price) AS bid,
toFloat64(ask_price) AS ask
FROM global_markets.cache_stocks_quotes
WHERE ticker = 'AAPL'
AND sip_timestamp >= '2026-06-10 14:00:00'
AND sip_timestamp < '2026-06-10 14:30:00'
AND bid_price > 0
AND ask_price > bid_price
),
per_sec AS
(
SELECT
sec,
max(bid) AS top_bid,
min(ask) AS top_ask,
avg(ask - bid) AS venue_spread,
avg((ask + bid) / 2) AS mid
FROM q
GROUP BY sec
)
SELECT
formatDateTime(toStartOfMinute(sec), '%H:%i') AS et_time,
round(100 * countIf(top_bid >= top_ask) / count(), 1) AS locked_or_crossed_pct,
round(avgIf(10000 * (top_ask - top_bid) / mid, top_bid < top_ask), 2) AS top_of_book_spread_bps,
round(avg(10000 * venue_spread / mid), 2) AS venue_quote_spread_bps
FROM per_sec
GROUP BY toStartOfMinute(sec)
HAVING countIf(top_bid < top_ask) > 0
ORDER BY toStartOfMinute(sec)For 10:00 minute, 88.3% of the seconds come out locked or crossed under this rough construction. The remaining uncrossed seconds average 0.49 basis points wide, compared with 1.27 basis points for average single-venue quote during the same seconds. Assembled top of book no fit ever be wider than any one venue quote at the same instant. The best bid go come from whichever venue get the highest one, while best offer go come from whichever venue get the lowest one. For equities, processor timestamp and arrange that stream, and the locks resolve. For crypto, nobody dey assemble the stream. Bid for one venue wey stand above offer for another venue na normal state, no be error wey dey wait for correction.
What replaces NBBO: index and reference rates
Because legal best price no dey, crypto dey depend on published reference rates. Reference rate na number wey dem calculate according to written method. E dey use named group of venues observed across defined window, then aggregate dem with stated formula, such as volume-weighted median of trades. The method na the whole product. Spot crypto ETFs dey strike net asset value against this kind rate, and cash-settled index products dey settle against one.
Two things follow from this. Reference rate na convention, no be direct price discovery. If you change venue set or shift the window, you go get different number, and both numbers fit still make sense under their own published methods. Reference rate also describe prints wey don already happen on venues wey particular trader fit never get account with. So e be mark, no be quote wey anybody fit hit.
Depth too dey different. Consolidated equity feed carry only top of book. Full depth dey come from each exchange own feed, as level 1 versus level 2 market data explain. Crypto venues publish their full book through public APIs, with nothing consolidated above dem. No licensed consolidated product dey, so crypto no get equivalent of the lag explained in why stock quotes are delayed 15 minutes.
Best execution fit exist without NBBO?
For equities, yardstick dey public: NBBO at the moment order get handled. You fit reconstruct am later from the tape. For crypto, yardstick na router’s own policy. The venues wey e connect to and the fee tier wey e pay for each one determine the fill. Two routers with different venue lists fit produce different fills at the same instant, and neither one break equity-style rule.
Why crypto no get closing price
A 24/7 market no get close. Nothing mark the end of a session, and every daily candle wey provider draw dey start from timestamp wey provider choose, commonly 00:00 UTC. Equity close na scheduled mechanism. The panel below dey follow the last half hour of that same June 10 session, minute by minute.
The exact SQL behind every number
WITH bars AS
(
SELECT
toTimeZone(window_start, 'America/New_York') AS et,
toFloat64(volume) AS vol
FROM global_markets.delayed_stocks_minute_aggs
WHERE ticker = 'AAPL'
AND window_start >= '2026-06-10 19:30:00'
AND window_start < '2026-06-10 20:01:00'
)
SELECT
formatDateTime(et, '%H:%i') AS et_time,
round(vol / 1e6, 2) AS volume_millions,
round(100 * vol / sum(vol) OVER (), 2) AS share_of_window_pct
FROM bars
ORDER BY etVolume dey concentrate as auction dey near. The 15:30 minute trade 0.1 million shares. The 16:00 minute trade 0.46 million, equal to 8.6% of the whole half hour. That final bar carry closing auction: one price, one moment, and every participant wey want official close dey stand for the same queue. Funds dey price against that print, and index providers dey rebalance to am. For crypto position, end-of-day mark na whichever venue, timestamp and method accounting policy name. So two statements wey cover the same position for the same hour fit disagree by more than quoted spread.
How dem build these panels
The venue panel count every AAPL print between 10:00 and 10:30 a.m. ET on June 10, 2026, then map each exchange code to im name. If code no get name, dem resolve am as numbered venue. Quote panel group the same window into one-second buckets and ignore the order wey quotes arrive. That method deliberately rougher than real consolidated feed. Dem drop quotes with non-positive or inverted price, and exclude minutes wey no get uncrossed second. Closing panel use one-minute bars, and final bar carry closing auction print.
FAQ
Crypto get NBBO?
No. Regulation NMS define national best bid and offer for US-listed stocks, while crypto trading dey outside that rulebook. No processor dey consolidate crypto venue quotes into one stream, and no rule dey stop venue from trading through better price elsewhere.
Why crypto prices dey differ between exchanges at the same moment?
Each venue dey match orders only against im own book. Capital wey fit close the gap must already dey positioned for both venues. Transfers cost time and fees, and difference go remain until e worth more than the round-trip cost of capturing am.
Wetin be crypto equivalent of consolidated tape?
Published index and reference rates dey come closest. Each one dey calculate from named venue set across defined window, using stated method. Two providers fit publish different numbers for the same asset at the same second. None get the legal force wey NBBO get for equities.
Crypto get closing price?
No, no be the way equities get one. 24/7 market no hold closing auction, and any daily close na timestamp convention wey data provider choose, commonly 00:00 UTC. Equity closing price come from real auction wey match all closing interest at one price.
Every panel here come with SQL wey produce am. You fit ask the same questions, venue by venue and minute by minute, for any ticker and any window on the Strasmore terminal.