STRASMORE/EXPLORE 2,173 QUERIES

Dual class tickers and the market cap printed against each

Answered against 22 years of US equities and 12 years of US options data and published with the query that produced it. This result is stored as of 2026-08-22, from Market Cap and Which Share Count It Uses.

as of ranking 4×4read in context →
Dual class tickers and the market cap printed against each — 4 rows by 4 columns, computed from US exchange, SIP and OPRA data.
tickermarket_cap_bnimplied_shares_mmpriced_on
GOOGL4166.412230Aug 20, 2026
GOOG4136.212230Aug 20, 2026
FOXA28.5420Aug 20, 2026
FOX25.4420Aug 20, 2026
Rows × columns
4 × 4
Computed
Completeness
No missing values
Source
US exchange, SIP and OPRA market data
Licence
Strasmore terms · free, no signup
Formats
JSON · CSV · the SQL below

What each column holds

Column definitions for Dual class tickers and the market cap printed against each, derived from the stored result.
ColumnTypeRangeNotes
ticker text 4 distinct values (FOX, FOXA, GOOG…)
market_cap_bn number 25.4 to 4,166.4
implied_shares_mm number 420 to 12,230 count
priced_on text 1 distinct value (Aug 20, 2026)

Computed from Strasmore's warehouse of US exchange, SIP and OPRA market data. Equity prices are delayed; options greeks and implied volatility are end-of-day. This result is stored, not recomputed on load — it is exactly the numbers that were returned on , and the query below is what returned them.

the exact SQL behind every number
SELECT
    ticker,
    round(argMax(toFloat64(market_cap), date) / 1e9, 1)                 AS market_cap_bn,
    round(argMax(toFloat64(market_cap) / toFloat64(price), date) / 1e6) AS implied_shares_mm,
    argMax(formatDateTime(date, '%b %e, %Y'), date)                     AS priced_on
FROM global_markets.stocks_ratios
WHERE ticker IN ('GOOGL', 'GOOG', 'FOXA', 'FOX')
  AND price > 0
  AND market_cap > 0
GROUP BY ticker
ORDER BY market_cap_bn DESC

Run your own version of this

The same 22 years of US equities and 12 years of options data are queryable in SQL or plain English. A free account runs 100 queries a day and takes no card.

More from this analysisMarket Cap and Which Share Count It Uses
Days since the period each filed share count covers ranking 8×3 Apple's basic and diluted share counts, quarter by quarter series 20×4 The recovered share count against the filed diluted count table 5×6 An illustrative $10,000 SPY stake from year end 2005, marked at each year end ranking 21×3 SPY calendar-year price change vs the 12% assumption, 2006-2025 ranking 20×3 Annualized SPY price growth over rolling eight-year windows, by starting year end ranking 14×3 See all 2,173 queries →