STRASMORE/EXPLORE 3,293 QUERIES 22Y EQUITIES · 12Y OPTIONS

3,293 answered market questions

every one with its exact SQL, its result and the date it was computed · free, no signup

Full options quote history: clean NBBO bid/ask snapshots for any US option contract at the interval you choose, by SQL API, $79 a month. See the options quotes plan
What Does Cross Mean in Trading? 4 Meanings
AAPL quote states in the first five minutes of June 18, 2026: normal, locked, crossedranking · 2026-09-28 · 3×4Preview: 3 ranked values, largest first. AAPL average volume by clock minute, June 2026: the two cross minutes vs ordinary onesseries · 2026-09-28 · 7×4Preview: a 7-point series, roughly flat. Equities condition codes that mark a cross, an opening, a closing, or an official printtable · 2026-09-28 · 13×5
Nasdaq Opening Cross Explained: 4 a.m. to 9:30
Share of regular-session volume in the opening minute, the 12:30 minute, and the closing cross, August 2026ranking · 2026-09-28 · 5×4Preview: 5 ranked values, largest first. Trade condition codes whose names mark an opening or reopening printranking · 2026-09-28 · 14×3Preview: 14 ranked values, smallest first. AAPL: opening-minute and closing-cross share of regular-session volume, by sessionseries · 2026-09-28 · 21×4Preview: a 16-point series, ending higher.
How an IPO's Opening Price Is Set
A seasoned ticker's opening auction: QQQ minute volume around 9:30 ET, September 4, 2026series · 2026-09-12 · 5×2Preview: a 5-point series, ending higher. New symbols since June 2026: minutes between the 9:30 bell and the first print, ten heaviest first minutesseries · 2026-09-12 · 10×4Preview: a 10-point series, roughly flat.
AAPL quote states in the first five minutes of June 18, 2026: normal, locked, crossed

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

most recentas of 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 from US exchange, SIP and OPRA data.
quote_statequotesshare_pctall_quotes_thousands
normal (bid below ask)3841099.59538.6
locked (bid equals ask)1020.26438.6
crossed (bid above ask)540.1438.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 →
$