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

Why Ticker Symbols Break Your Dataset
When each symbol last printed a daily barranking · 2026-10-04 · 6×3Preview: 6 ranked values, largest first. New listings landing on a symbol that already had historyranking · 2026-10-04 · 11×3Preview: 11 ranked values, smallest first. Which share-class spellings actually carry historyranking · 2026-10-04 · 4×4Preview: 4 ranked values, smallest first. Trading sessions per year under FB and METAranking · 2026-10-04 · 15×3Preview: 15 ranked values, smallest first.
How to Read an Options Symbol (OSI Format)
One eight-digit field, from single-dollar strikes to index levelstable · 2026-10-04 · 4×6 One expiration, four strikes: every OSI field cut out of the symboltable · 2026-10-04 · 8×7
Tape A, B, and C Explained: CTA and UTP
Share of prints on each tape, by ET clock hour, across the same basketseries · 2026-10-01 · 16×4Preview: a 16-point series, ending higher. The tape carried by a basket of household symbols, one September 2026 sessionranking · 2026-10-01 · 12×4Preview: 12 ranked values, smallest first. US listing exchanges and the tape each one assignstable · 2026-10-01 · 7×5 Class-share symbols and the notation each tape usesranking · 2026-10-01 · 10×4Preview: 10 ranked values, smallest first.
Eurex Option Codes: ODAX, ODAP, OESX
One US options symbol, taken apart: busiest SPY contracts on 17 June 2026table · 2026-09-22 · 8×6 Distinct expirations traded per underlying, 17 June 2026ranking · 2026-09-22 · 5×2Preview: 5 ranked values, largest first. SPY option volume by days left to expiry, 17 June 2026ranking · 2026-09-22 · 5×3Preview: 5 ranked values, largest first. What one US equity option contract covers, 17 June 2026ranking · 2026-09-22 · 5×3Preview: 5 ranked values, largest first.
How to Read a Futures Symbol (ESZ6, CLF27)
Volume around one quarterly expiry: SPY June 19 vs September 18, 2026series · 2026-08-09 · 38×3Preview: a 16-point series, ending higher. Delivery years live at the same time on one option calendar (SPY, July 2026)ranking · 2026-08-09 · 3×4Preview: 3 ranked values, smallest first. Where long-dated option volume lands, by expiry month coderanking · 2026-08-09 · 11×3Preview: 11 ranked values, largest first.
When each symbol last printed a daily bar

When each symbol last printed a daily bar

most recentas of ranking 6×3read in context →
When each symbol last printed a daily bar — 6 rows by 3 columns, computed from US exchange, SIP and OPRA data.
tickerlast_print_labeldays_since_last_print
TWTROct 27, 20221438
ABMDDec 21, 20221383
ATVIOct 12, 20231088
VMWNov 21, 20231048
SGENDec 13, 20231026
AAPLOct 2, 20262
the exact SQL behind every number 
SELECT
    ticker,
    formatDateTime(max(date), '%b %e, %Y') AS last_print_label,
    dateDiff('day', max(date), today())    AS days_since_last_print
FROM global_markets.stocks_daily_aggs
WHERE ticker IN ('ABMD', 'TWTR', 'ATVI', 'VMW', 'SGEN', 'AAPL')
  AND date >= '2014-01-01'
GROUP BY ticker
ORDER BY days_since_last_print DESC
More from this analysisWhy Ticker Symbols Break Your Dataset
Trading sessions per year under FB and META ranking 15×3 → New listings landing on a symbol that already had history ranking 11×3 → Which share-class spellings actually carry history ranking 4×4 → Options volume by time left to expiry, AAPL, April to June 2026 ranking 5×2 → See all 3,256 queries →
$