capitalizacion

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
    (
        SELECT argMax(basic_shares_outstanding, (filing_date, period_end))
        FROM global_markets.stocks_income_statements
        WHERE has(tickers, 'NKE')
          AND timeframe = 'quarterly'
    ) AS acciones_ultimas
SELECT
    toString(d.date)                                                  AS date,
    formatDateTime(d.date, '%d/%m/%Y')                                AS fecha_label,
    round(toFloat64(d.close), 2)                                      AS precio_cierre_usd,
    round(toFloat64(d.close) * toFloat64(acciones_ultimas) / 1e9, 1)  AS capitalizacion_mil_mm_usd
FROM global_markets.stocks_daily_aggs AS d
WHERE d.ticker = 'NKE'
  AND d.date >= today() - 120
ORDER BY d.date