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 ADRs Work: Ratios, Fees and Dividends
A year of tape on five large exchange-listed foreign issuer receiptsranking · 2026-10-04 · 5×2Preview: 5 ranked values, largest first. Recent share-count adjustments on large foreign issuer receiptsranking · 2026-10-04 · 8×3Preview: 8 ranked values, largest first. Dividend cadence and annual cash per share, receipts against US payersranking · 2026-10-04 · 8×4Preview: 8 ranked values, largest first. Days from ex-dividend date to payment, four years of distributionsranking · 2026-10-04 · 8×3Preview: 8 ranked values, largest first.
A year of tape on five large exchange-listed foreign issuer receipts

A year of tape on five large exchange-listed foreign issuer receipts

most recentas of ranking 5×2read in context →
A year of tape on five large exchange-listed foreign issuer receipts — 5 rows by 2 columns, computed from US exchange, SIP and OPRA data.
tickeravg_daily_usd_millions
TSM4776.6
ASML2438.42
NVO789.95
SAP514.01
UL237.01
the exact SQL behind every number 
SELECT
    ticker,
    round(avg(toFloat64(close) * volume) / 1e6, 2) AS avg_daily_usd_millions
FROM global_markets.stocks_daily_aggs
WHERE ticker IN ('TSM', 'ASML', 'SAP', 'NVO', 'UL')
  AND date >= today() - 365
  AND date <  today()
GROUP BY ticker
ORDER BY avg_daily_usd_millions DESC
More from this analysisHow ADRs Work: Ratios, Fees and Dividends
Recent share-count adjustments on large foreign issuer receipts ranking 8×3 → Dividend cadence and annual cash per share, receipts against US payers ranking 8×4 → Days from ex-dividend date to payment, four years of distributions ranking 8×3 → KO dividend per share by calendar year, with year over year growth ranking 22×3 → See all 3,256 queries →
$