STRASMORE/EXPLORE 2,249 QUERIES 22Y EQUITIES · 12Y OPTIONS

2,249 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.
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 2,249 queries →
$