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

2,707 answered market questions

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

SPLG Is Now SPYM: What Changed for Holders
Both symbols on the daily tape: where one span ends and the next beginstable · 2026-09-27 · 2×5 Daily bars printed each month under each symbolseries · 2026-09-27 · 18×3Preview: a 16-point series, ending higher. Average daily traded value across the SPDR core familyranking · 2026-09-27 · 4×3Preview: 4 ranked values, largest first. Listed option contracts with volume, by underlying symbol and monthseries · 2026-09-27 · 14×3Preview: a 14-point series, ending higher. The last sessions as SPLG and the first as SPYM, close by closeseries · 2026-09-27 · 20×5Preview: a 16-point series, roughly flat. Quarterly distributions across the symbol changeseries · 2026-09-27 · 11×4Preview: a 11-point series, ending higher.
Both symbols on the daily tape: where one span ends and the next begins

Both symbols on the daily tape: where one span ends and the next begins

most recentas of table 2×5read in context →
Both symbols on the daily tape: where one span ends and the next begins — 2 rows by 5 columns, computed from US exchange, SIP and OPRA data.
symbolfirst_printlast_printdaily_barsyears_covered
SPLGOct 16, 2017Oct 30, 202520228
SPYMSep 3, 2024Sep 25, 20263442.1
the exact SQL behind every number 
SELECT
    ticker                                                   AS symbol,
    formatDateTime(min(date), '%b %e, %Y')                   AS first_print,
    formatDateTime(max(date), '%b %e, %Y')                   AS last_print,
    countDistinct(date)                                      AS daily_bars,
    round(dateDiff('day', min(date), max(date)) / 365.25, 1) AS years_covered
FROM global_markets.stocks_daily_aggs
WHERE ticker IN ('SPLG', 'SPYM')
GROUP BY ticker
ORDER BY min(date)
More from this analysisSPLG Is Now SPYM: What Changed for Holders
The last sessions as SPLG and the first as SPYM, close by close series 20×5 → Daily bars printed each month under each symbol series 18×3 → Listed option contracts with volume, by underlying symbol and month series 14×3 → Quarterly distributions across the symbol change series 11×4 → See all 2,707 queries →
$