vocabulary — 3 answered market questions

AAPL quote states in the first five minutes of June 18, 2026: normal, locked, crossed

most recentas of 2026-09-28 ranking 3×4read in context →

AAPL quote states in the first five minutes of June 18, 2026: normal, locked, crossed — 3 rows by 4 columns, computed 2026-09-28 from US exchange, SIP and OPRA data.
quote_state	quotes	share_pct	all_quotes_thousands
normal (bid below ask)	38410	99.595	38.6
locked (bid equals ask)	102	0.264	38.6
crossed (bid above ask)	54	0.14	38.6

the exact SQL behind every number

SELECT
    multiIf(bid_price > ask_price, 'crossed (bid above ask)',
            bid_price = ask_price, 'locked (bid equals ask)',
            'normal (bid below ask)')                       AS quote_state,
    count()                                                 AS quotes,
    round(100 * count() / sum(count()) OVER (), 3)          AS share_pct,
    round(sum(count()) OVER () / 1000, 1)                   AS all_quotes_thousands
FROM global_markets.cache_stocks_quotes
WHERE ticker = 'AAPL'
  AND sip_timestamp >= toDateTime('2026-06-18 13:30:00', 'UTC')
  AND sip_timestamp <  toDateTime('2026-06-18 13:35:00', 'UTC')
  AND bid_price > 0
  AND ask_price > 0
GROUP BY quote_state
ORDER BY quotes DESC

More from this analysisWhat Does Cross Mean in Trading? 4 Meanings

Equities condition codes that mark a cross, an opening, a closing, or an official print table 13×5 → AAPL average volume by clock minute, June 2026: the two cross minutes vs ordinary ones series 7×4 → Trade condition codes whose names mark an opening or reopening print ranking 14×3 → Listed versus traded strikes by moneyness (SPY, Sep 18 2026 expiry, as of Aug 14 2026) ranking 10×3 → See all 3,293 queries →