cap_by_year

Run it yourself

This is the exact query behind the result above. Change a ticker, a date or a column and run it against the warehouse — no account, no key. The no-signup tier is smaller than the one this page was computed on; a query that reaches past it comes back saying which plan runs it.

WITH
    share_counts AS
    (
        SELECT
            toYear(period_end)                                                      AS yr,
            argMax(toFloat64(diluted_shares_outstanding), (period_end, filing_date)) AS shares_out
        FROM global_markets.stocks_income_statements
        WHERE has(tickers, 'AAPL')
          AND period_end >= '2021-01-01'
          AND diluted_shares_outstanding > 0
        GROUP BY yr
    ),
    last_prices AS
    (
        SELECT
            toYear(date)                   AS yr,
            argMax(toFloat64(close), date) AS last_close
        FROM global_markets.stocks_daily_aggs
        WHERE ticker = 'AAPL'
          AND date >= '2021-01-01'
        GROUP BY yr
    )
SELECT
    toString(p.yr)                                     AS year,
    round(s.shares_out * p.last_close / 1e12, 3)       AS market_cap_usd_tn
FROM last_prices AS p
INNER JOIN share_counts AS s ON s.yr = p.yr
ORDER BY year