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

3,256 answered market questions

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

How to Read the US Equity Trade Tape
Two companies behind one symbol: TWTR on the daily barsseries · 2026-09-15 · 2×5Preview: a 2-point series, ending higher. The tape column on eight symbols, 2023-03-15ranking · 2026-09-15 · 8×3Preview: 8 ranked values, smallest first. Sessions and symbols on the tape, by yearseries · 2026-09-15 · 24×4Preview: a 16-point series, ending higher. Share of prints with a placeholder participant timestamp, one March session per year (IBM and MSFT)ranking · 2026-09-15 · 24×4Preview: 16 ranked values, smallest first. IBM's NYSE closing auction print: seconds after 4:00 p.m. ET, one March session per yearranking · 2026-09-15 · 17×4Preview: 16 ranked values, smallest first. Placeholder share by session, five large names, July to August 2015series · 2026-09-15 · 15×3Preview: a 15-point series, ending lower. The first session with a populated participant timestampscalar · 2026-09-15 · 1×26.41M Correction indicator counts on one session, fifteen large names, 2023-03-15ranking · 2026-09-15 · 5×3Preview: 5 ranked values, smallest first.
How Block Trades Print on the Tape
Which venues reported AAPL's largest prints, June 10, 2026ranking · 2026-08-20 · 12×3Preview: 12 ranked values, largest first. Execution-to-tape lag by print size, AAPL, June 10, 2026ranking · 2026-08-20 · 4×3Preview: 4 ranked values, smallest first. How AAPL's prints and volume split by trade size, June 10, 2026ranking · 2026-08-20 · 5×3Preview: 5 ranked values, largest first. AAPL volume minute by minute, 3:00 to 4:00 p.m. ET, June 10, 2026series · 2026-08-20 · 60×4Preview: a 16-point series, roughly flat. Sale conditions that flag a specially priced or out-of-sequence printtable · 2026-08-20 · 17×4
What Is the Closing Auction? (Closing Cross)
Quarter-end (June 30) vs. mid-month (June 16, 2026): the same three closing auctionstable · 2026-07-26 · 3×8 The tape's own labels for the close, straight from the code dictionaryranking · 2026-07-26 · 4×3Preview: 4 ranked values, smallest first. The closing auction vs. everything else: SPY, AAPL, NVDA on July 2, 2026table · 2026-07-26 · 3×10 The receipt: AAPL's auction print vs. its last continuous trade, July 2, 2026scalar · 2026-07-26 · 1×12390
Microstructure Deep-Dive: June 29, 2026
Raw vs SIP-counted volume, applying the derived exclusion setscalar · 2026-07-26 · 1×424.79 One day of trades: session check plus the size of every printscalar · 2026-07-26 · 1×80 SPY's median quoted spread by half hour, 4:00 am to 8:00 pm ETseries · 2026-07-26 · 32×3Preview: a 16-point series, roughly flat. SPY under the microscope: nanosecond gaps, the spread two ways, quote qualityscalar · 2026-07-26 · 1×123.98 Completeness probe: FINRA short-volume file coverage, June 26-30series · 2026-07-26 · 3×6Preview: a 3-point series, ending higher. The whole NBBO stream in one row: QQQ and NVDA pinned by namescalar · 2026-07-26 · 1×5505.38 NBBO quote updates for eight heavily-quoted tickers (millions)ranking · 2026-07-26 · 8×2Preview: 8 ranked values, largest first. How many of the ten busiest minutes fall outside the open and the closescalar · 2026-07-26 · 1×41 The largest single prints of June 29 (dictionary-excluded codes stripped)series · 2026-07-26 · 9×7Preview: a 9-point series, ending lower. The exclusion set, derived from the tape's own code dictionary (one row)scalar · 2026-07-26 · 1×33 The receipt: CAG's closing auction and its code-15 re-report, side by sidescalar · 2026-07-26 · 1×661.69 The ten busiest minutes of the trade tape (millions of prints)ranking · 2026-07-26 · 10×2Preview: 10 ranked values, largest first.
Two companies behind one symbol: TWTR on the daily bars

Two companies behind one symbol: TWTR on the daily bars

most recentas of series 2×5read in context →
Two companies behind one symbol: TWTR on the daily bars — 2 rows by 5 columns, computed from US exchange, SIP and OPRA data.
issuerfirst_sessionlast_sessionsessionsavg_close
Tweeter Home Entertainment2003-09-102007-06-209515.41
Twitter2013-11-072022-10-27225936
the exact SQL behind every number 
SELECT
    if(date < '2010-01-01', 'Tweeter Home Entertainment', 'Twitter')   AS issuer,
    toString(min(date))                                                 AS first_session,
    toString(max(toDate(date)))                                         AS last_session,
    count()                                                             AS sessions,
    round(avg(toFloat64(close)), 2)                                     AS avg_close
FROM global_markets.stocks_daily_aggs
WHERE ticker = 'TWTR' AND date >= '2003-09-10' AND date <= '2022-10-31'
GROUP BY issuer
ORDER BY first_session
More from this analysisHow to Read the US Equity Trade Tape
Sessions and symbols on the tape, by year series 24×4 → Placeholder share by session, five large names, July to August 2015 series 15×3 → Share of prints with a placeholder participant timestamp, one March session per year (IBM and MSFT) ranking 24×4 → IBM's NYSE closing auction print: seconds after 4:00 p.m. ET, one March session per year ranking 17×4 → See all 3,256 queries →
$