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

2,170 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-08-22 · 6×3Preview: 6 ranked values, largest first. New listings landing on a symbol that already had historyranking · 2026-08-22 · 11×3Preview: 11 ranked values, smallest first. Which share-class spellings actually carry historyranking · 2026-08-22 · 4×4Preview: 4 ranked values, smallest first. Trading sessions per year under FB and METAranking · 2026-08-22 · 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-08-22 · 4×6 One expiration, four strikes: every OSI field cut out of the symboltable · 2026-08-22 · 8×7
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, 20221395
ABMDDec 21, 20221340
ATVIOct 12, 20231045
VMWNov 21, 20231005
SGENDec 13, 2023983
AAPLAug 21, 20261
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 2,170 queries →
$