3,293 answered market questions

SELECT
    ticker,
    round(cap / 1e9, 1)                    AS market_cap_bn,
    round(100 * cap / sum(cap) OVER (), 2) AS cap_weight_pct_of_basket,
    round(100.0 / count() OVER (), 2)      AS equal_weight_pct,
    toString(snapshot_date)                AS as_of_date
FROM
(
    SELECT
        ticker,
        toFloat64(argMax(market_cap, date)) AS cap,
        max(date)                           AS snapshot_date
    FROM global_markets.stocks_ratios
    WHERE ticker IN ('NVDA', 'MSFT', 'AAPL', 'AMZN', 'GOOGL', 'META', 'KO', 'MMM', 'MOS', 'HAS')
      AND date >= today() - 45
      AND market_cap > 0
    GROUP BY ticker
)
ORDER BY cap DESC