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

2,173 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-08-22 · 5×2Preview: 5 ranked values, largest first. Recent share-count adjustments on large foreign issuer receiptsranking · 2026-08-22 · 8×3Preview: 8 ranked values, largest first. Dividend cadence and annual cash per share, receipts against US payersranking · 2026-08-22 · 8×4Preview: 8 ranked values, largest first. Days from ex-dividend date to payment, four years of distributionsranking · 2026-08-22 · 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
TSM4620.82
ASML2328.9
NVO821.82
SAP516.69
UL227.36
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 → How a two-decade streak compounds: Microsoft's annual dividend, year by year ranking 22×2 → See all 2,173 queries →
$