Mag 7 Market Capitalization vs. Major Indexes¶
© 2026 Jim Domeij
Get current market cap (bn USD) for Magnificient 7 companies and other major stock indices. This comparison highlights the dominance of a small number of large firms in global equity markets and the associated concentration risk
Out[1]:
In [2]:
Copied!
from polars_bloomberg import BQuery
query = """
let(
#name = if(security_typ=='Common Stock', name(), id());
#mkt_cap = cur_mkt_cap(currency=USD)/1e9;
)
get(#name, #mkt_cap)
for([
'AAPL US Equity',
'AMZN US Equity',
'GOOGL US Equity',
'META US Equity',
'MSFT US Equity',
'NVDA US Equity',
'TSLA US Equity',
'SXXP Index',
'DAX Index',
'UKX Index',
'CAC Index',
'TPX Index',
'SHCOMP Index'
])
preferences(dropCols=ALL)
"""
with BQuery() as bq:
df = bq.bql(query).combine()
df.head()
from polars_bloomberg import BQuery
query = """
let(
#name = if(security_typ=='Common Stock', name(), id());
#mkt_cap = cur_mkt_cap(currency=USD)/1e9;
)
get(#name, #mkt_cap)
for([
'AAPL US Equity',
'AMZN US Equity',
'GOOGL US Equity',
'META US Equity',
'MSFT US Equity',
'NVDA US Equity',
'TSLA US Equity',
'SXXP Index',
'DAX Index',
'UKX Index',
'CAC Index',
'TPX Index',
'SHCOMP Index'
])
preferences(dropCols=ALL)
"""
with BQuery() as bq:
df = bq.bql(query).combine()
df.head()
Out[2]:
shape: (5, 3)
| ID | #name | #mkt_cap |
|---|---|---|
| str | str | f64 |
| "AAPL US Equity" | "Apple Inc" | 3808.309621 |
| "AMZN US Equity" | "Amazon.com Inc" | 2620.118506 |
| "GOOGL US Equity" | "Alphabet Inc" | 3971.064028 |
| "META US Equity" | "Meta Platforms Inc" | 1636.967446 |
| "MSFT US Equity" | "Microsoft Corp" | 3528.075367 |