bigdata_market_tearsheet

​

Overview

The Market Tearsheet provides a comprehensive multi-asset market snapshot covering eight asset classes: global equity ETFs, major stock market indexes, commodities, currencies, equity sectors, fixed income, US Treasury yields, and equity factors. This tool delivers current prices and multi-period performance data (1D, 5D, 1M, 3M, 6M, YTD, 1Y) across all markets in a single call, enabling quick assessment of worldwide market conditions and cross-asset performance trends.

​

When to Use

The Market Tearsheet is ideal for:

• Global Market Overview: Quick snapshot of worldwide equity market conditions
• Major Index Levels: Actual index levels for S&P 500, Dow Jones, NASDAQ, DAX, FTSE 100, Nikkei, etc.
• Country Performance: How specific country stock markets are performing (via ETFs or indexes)
• Regional Comparisons: Comparing equity performance across regions (Europe, Asia, Emerging Markets)
• Commodity Prices: Current prices and trends for energy, metals, and agricultural commodities
• Currency Performance: Major fiat pairs, emerging market currencies, and crypto assets
• Equity Sector Performance: Technology, Health Care, Financials, Energy, and all 11 US sectors
• Fixed Income Markets: Bond ETF performance across Treasuries, corporate credit, and international bonds
• US Treasury Yield Curve: Current rates across all maturities from 1-month to 30-year
• Equity Factor Performance: Growth vs value, momentum, quality, size factors, and more
• Cross-Asset Analysis: Understanding correlations and flows across all asset classes
• Multi-Period Trends: Tracking performance across 1-day to 1-year timeframes

Note: This tool is purely for market price and performance data. For macroeconomic context (GDP, CPI, interest rates, economic calendar), use the Country Tearsheet instead.

​

How It Works

The Market Tearsheet aggregates real-time pricing and performance data across eight major asset classes:

1. Equity ETFs: Tracks country and region-specific ETFs from iShares MSCI, SPDR, and Vanguard families
2. Major Indexes: Monitors actual index levels for major stock market benchmarks globally
3. Commodities: Monitors futures prices for energy, metals, and agricultural products
4. Currencies: Captures forex rates for major fiat pairs, emerging market currencies, and cryptocurrencies
5. Equity Sectors: Tracks US sector performance via SPDR Select Sector ETFs
6. Fixed Income: Monitors bond ETF performance across duration, credit quality, and geography
7. Yields: Captures US Treasury rates across the full yield curve
8. Equity Factors: Tracks factor-based investing strategies (growth, value, momentum, quality, size)
9. Multi-Period Calculation: Computes percentage changes across seven timeframes (1D, 5D, 1M, 3M, 6M, YTD, 1Y)
10. Markdown Tables: Presents all data in clean, scannable tables organized by asset class

ETF prices closely track their underlying benchmark indexes and serve as reliable proxies for country equity performance. For example:

• SPY tracks the S&P 500 (US market)
• EWG tracks the MSCI Germany Index (German market)
• EWJ tracks the MSCI Japan Index (Japanese market)

​

Parameters

No parameters required. Simply call the tool to receive the complete market snapshot across all eight asset classes.

​

Data Returned

The Market Tearsheet returns eight comprehensive markdown tables, one for each asset class:

​

Common Data Structure

Each table includes the following columns for every instrument:

​

Section 1: Global Markets (38 ETFs)

Country and regional equity market ETFs tracking global stock market performance.

​

Americas (7)

• United States - SPDR S&P 500 ETF Trust (SPY)
• Canada - iShares MSCI Canada ETF (EWC)
• Mexico - iShares MSCI Mexico ETF (EWW)
• Brazil - iShares MSCI Brazil ETF (EWZ)
• Chile - iShares MSCI Chile ETF (ECH)
• Colombia - iShares MSCI Colombia ETF (ICOL)
• Argentina - Global X MSCI Argentina ETF (ARGT)

​

Europe (10)

• United Kingdom - iShares MSCI United Kingdom ETF (EWU)
• Germany - iShares MSCI Germany ETF (EWG)
• France - iShares MSCI France ETF (EWQ)
• Italy - iShares MSCI Italy ETF (EWI)
• Spain - iShares MSCI Spain ETF (EWP)
• Netherlands - iShares MSCI Netherlands ETF (EWN)
• Switzerland - iShares MSCI Switzerland ETF (EWL)
• Sweden - iShares MSCI Sweden ETF (EWD)
• Poland - iShares MSCI Poland ETF (EPOL)
• Turkey - iShares MSCI Turkey ETF (TUR)

​

Asia-Pacific (13)

• Japan - iShares MSCI Japan ETF (EWJ)
• China - iShares MSCI China ETF (MCHI)
• Hong Kong - iShares MSCI Hong Kong ETF (EWH)
• South Korea - iShares MSCI South Korea ETF (EWY)
• Taiwan - iShares MSCI Taiwan ETF (EWT)
• Australia - iShares MSCI Australia ETF (EWA)
• India - iShares MSCI India ETF (INDA)
• Singapore - iShares MSCI Singapore ETF (EWS)
• Malaysia - iShares MSCI Malaysia ETF (EWM)
• Thailand - iShares MSCI Thailand ETF (THD)
• Indonesia - iShares MSCI Indonesia ETF (EIDO)
• Philippines - iShares MSCI Philippines ETF (EPHE)
• New Zealand - iShares MSCI New Zealand ETF (ENZL)

​

Middle East & Africa (4)

• South Africa - iShares MSCI South Africa ETF (EZA)
• Israel - iShares MSCI Israel ETF (EIS)
• Saudi Arabia - iShares MSCI Saudi Arabia ETF (KSA)
• Qatar - iShares MSCI Qatar ETF (QAT)

​

Broad Market / Regional ETFs (4)

• Emerging Markets - iShares MSCI Emerging Markets ETF (EEM)
• Emerging Markets - Vanguard FTSE Emerging Markets ETF (VWO)
• EAFE (Developed ex-US) - iShares MSCI EAFE ETF (EFA)
• All World ex-US - Vanguard FTSE All-World ex-US ETF (VEU)

Total: 38 country and region ETFs

---

​

Section 2: Major Indexes (38 Indexes)

Actual index levels for major stock market benchmarks worldwide.

​

North America (11)

• S&P 500 - US large-cap benchmark
• Dow Jones Industrial Average - 30 blue-chip US stocks
• NASDAQ Composite - All NASDAQ-listed stocks
• NASDAQ 100 - 100 largest non-financial NASDAQ stocks
• Russell 2000 - US small-cap index
• Russell 1000 - US large-cap index
• Wilshire 5000 - Total US market
• NYSE Composite - All NYSE-listed stocks
• VIX - CBOE Volatility Index (market fear gauge)
• S&P/TSX Composite - Canadian stock market index
• S&P/BMV IPC - Mexican stock market index

​

Europe (13)

• FTSE 100 - UK’s top 100 companies
• DAX 40 - German blue-chip index
• CAC 40 - French blue-chip index
• Euro Stoxx 50 - Eurozone’s top 50 companies
• STOXX 600 - 600 European companies
• IBEX 35 - Spanish stock market index
• FTSE MIB - Italian stock market index
• AEX - Dutch stock market index
• SMI - Swiss stock market index
• OMX Stockholm 30 - Swedish stock market index
• BEL 20 - Belgian stock market index
• ATX - Austrian stock market index
• MOEX Russia - Russian stock market index

​

Asia-Pacific (12)

• Nikkei 225 - Japanese stock market index
• Hang Seng - Hong Kong stock market index
• S&P/ASX 200 - Australian stock market index
• KOSPI - South Korean stock market index
• TAIEX - Taiwan stock market index
• NIFTY 50 - Indian stock market index (NSE)
• BSE SENSEX - Indian stock market index (BSE)
• STI - Singapore stock market index
• NZX 50 - New Zealand stock market index
• SET - Thai stock market index
• Jakarta Composite - Indonesian stock market index
• KLCI - Malaysian stock market index

​

Other (5)

• Bovespa - Brazilian stock market index
• Merval - Argentine stock market index
• JSE Top 40 - South African stock market index
• EGX 30 - Egyptian stock market index
• Tadawul All Share - Saudi Arabian stock market index

Total: 38 major stock market indexes

---

​

Section 3: Commodities (30 Instruments)

Futures prices for energy, metals, and agricultural commodities.

​

Energy (5)

• Crude Oil WTI - West Texas Intermediate crude oil
• Brent Crude - International benchmark crude oil
• Natural Gas - Henry Hub natural gas
• Gasoline RBOB - Reformulated blendstock for oxygenate blending
• Heating Oil - No. 2 heating oil

​

Metals (8)

• Gold - Gold futures
• Silver - Silver futures
• Platinum - Platinum futures
• Palladium - Palladium futures
• Micro Gold - Micro gold futures (smaller contract size)
• Micro Silver - Micro silver futures (smaller contract size)
• Copper - Copper futures
• Aluminum - Aluminum futures

​

Agricultural (17)

• Corn - Corn futures
• Wheat - Wheat futures
• Soybeans - Soybean futures
• Soybean Oil - Soybean oil futures
• Soybean Meal - Soybean meal futures
• Oats - Oat futures
• Rough Rice - Rough rice futures
• Sugar - Sugar No. 11 futures
• Coffee - Coffee ‘C’ futures
• Cocoa - Cocoa futures
• Cotton - Cotton No. 2 futures
• Orange Juice - Frozen concentrated orange juice futures
• Live Cattle - Live cattle futures
• Feeder Cattle - Feeder cattle futures
• Lean Hogs - Lean hog futures
• Lumber - Lumber futures
• Class III Milk - Class III milk futures

Total: 30 commodity instruments

---

​

Section 4: Currencies (49 Pairs)

Forex rates for major fiat pairs, emerging market currencies, and cryptocurrencies.

​

Fiat Currencies (34 Pairs)

​

Major Pairs (7)

• EUR/USD, GBP/USD, USD/JPY, USD/CHF, USD/CAD, AUD/USD, NZD/USD

​

Cross Pairs (Examples)

• EUR/GBP, EUR/JPY, GBP/JPY, AUD/JPY, and others

​

Emerging Market Pairs (Examples)

• USD/CNY (Chinese Yuan)
• USD/INR (Indian Rupee)
• USD/MXN (Mexican Peso)
• USD/BRL (Brazilian Real)
• USD/ZAR (South African Rand)
• USD/TRY (Turkish Lira)
• And more…

​

Cryptocurrencies (15 Pairs)

• BTC/USD - Bitcoin
• ETH/USD - Ethereum
• SOL/USD - Solana
• XRP/USD - Ripple
• ADA/USD - Cardano
• DOGE/USD - Dogecoin
• AVAX/USD - Avalanche
• And 8 more crypto pairs

Total: 49 currency pairs (34 fiat + 15 crypto)

---

​

Section 5: Equity Sectors (11 US Sector ETFs)

SPDR Select Sector ETFs tracking the 11 Global Industry Classification Standard (GICS) sectors within the S&P 500.

• Technology (XLK) - Information Technology Select Sector SPDR Fund
• Health Care (XLV) - Health Care Select Sector SPDR Fund
• Financials (XLF) - Financial Select Sector SPDR Fund
• Consumer Discretionary (XLY) - Consumer Discretionary Select Sector SPDR Fund
• Communication Services (XLC) - Communication Services Select Sector SPDR Fund
• Industrials (XLI) - Industrial Select Sector SPDR Fund
• Consumer Staples (XLP) - Consumer Staples Select Sector SPDR Fund
• Energy (XLE) - Energy Select Sector SPDR Fund
• Utilities (XLU) - Utilities Select Sector SPDR Fund
• Real Estate (XLRE) - Real Estate Select Sector SPDR Fund
• Materials (XLB) - Materials Select Sector SPDR Fund

Total: 11 US sector ETFs Use Cases:

• Sector rotation strategies (identifying which sectors are leading/lagging)
• Economic cycle positioning (cyclical vs defensive sectors)
• Portfolio diversification across economic sectors
• Thematic investing (e.g., technology leadership, energy transition)

---

​

Section 6: Fixed Income (26 Bond ETFs)

Bond ETF performance across US Treasury duration, government agencies, corporate credit, and international bonds.

​

US Treasury Duration

Treasury bonds across the yield curve:

• Short-term Treasury ETFs (1-3 year maturities)
• Intermediate Treasury ETFs (3-10 year maturities)
• Long-term Treasury ETFs (10-20 year maturities)
• Ultra-long Treasury ETFs (20-30 year maturities)

​

US Government Agencies

Government-sponsored enterprise and agency bonds:

• Mortgage-backed securities (MBS)
• Agency bonds (Fannie Mae, Freddie Mac, Ginnie Mae)

​

US Corporate Credit

Investment-grade and high-yield corporate bonds:

• Investment-grade corporate bond ETFs (BBB- and above)
• High-yield corporate bond ETFs (below BBB-, “junk bonds”)
• Short-term, intermediate, and long-term corporate bonds

​

International Credit

Non-US sovereign and corporate bonds:

• Developed market government bonds
• Emerging market government bonds
• International corporate bonds

Total: 26 bond ETFs Use Cases:

• Duration positioning (interest rate sensitivity management)
• Credit quality allocation (investment-grade vs high-yield)
• Yield curve strategies (short-term vs long-term bonds)
• International diversification in fixed income
• Flight-to-quality analysis (Treasuries vs corporate credit spreads)

---

​

Section 7: Yields (12 US Treasury Maturities)

Current yield rates across the full US Treasury curve, from 1-month bills to 30-year bonds.

​

Maturities Covered

• 1-Month - Treasury bill
• 3-Month - Treasury bill
• 6-Month - Treasury bill
• 1-Year - Treasury note
• 2-Year - Treasury note
• 3-Year - Treasury note
• 5-Year - Treasury note
• 7-Year - Treasury note
• 10-Year - Treasury note
• 20-Year - Treasury bond
• 30-Year - Treasury bond

Data for Each Maturity:

• Current yield rate (%)
• 1-day change (basis points and %)
• 5-day, 1-month, 3-month, 6-month, YTD, 1-year changes

Total: 12 maturities Use Cases:

• Yield curve analysis (normal, flat, inverted)
• Recession indicators (2s10s spread inversion)
• Real rates assessment (nominal yields vs inflation expectations)
• Duration risk management
• Relative value across the curve
• Central bank policy expectations (front-end sensitivity to Fed)

---

​

Section 8: Equity Factors (20 Factor ETFs)

Factor-based investing strategies tracking specific equity characteristics and styles.

​

Style Factors

Growth vs value orientation:

• Large-cap growth
• Large-cap value
• Mid-cap growth
• Mid-cap value
• Small-cap growth
• Small-cap value

​

Qualitative Factors

Company quality and characteristics:

• Quality - High-quality companies (strong balance sheets, profitability)
• Momentum - Stocks with strong recent performance trends
• Low Volatility - Stocks with below-average volatility
• Dividend - High dividend-yielding stocks
• Equal Weight - Equal-weighted S&P 500 (vs market-cap weighted)

​

Size & Style Combinations

Multi-factor strategies combining size and style:

• Large-cap blend
• Mid-cap blend
• Small-cap blend
• Multi-cap strategies

Total: 20 factor ETFs Use Cases:

• Factor rotation strategies (growth vs value cycles)
• Risk-adjusted return optimization
• Smart beta portfolio construction
• Market regime identification (growth leadership = risk-on)
• Defensive positioning (low volatility, quality factors)
• Income strategies (dividend factors)

---

​

Understanding the Data

​

Global Markets vs Major Indexes

The tearsheet provides two complementary views of equity markets: Global Markets (ETFs):

• Country/region equity exposure via tradable ETFs
• Prices in USD reflecting investable returns
• Useful for portfolio allocation and cross-border comparisons
• Example: SPY at $500 represents S&P 500 exposure

Major Indexes (Actual Levels):

• Direct index point values as reported by exchanges
• The “headline numbers” you see in financial news
• Useful for precise index level tracking and benchmarking
• Example: S&P 500 at 5,000 points

When to use which:

• Major Indexes: When you need exact index levels (e.g., “What’s the S&P 500 at?”)
• Global Markets: When comparing country allocations or building ETF portfolios
• Both: For comprehensive market analysis combining index benchmarks with investable vehicles

​

Equity Sectors - Economic Cycle Positioning

Sectors perform differently across economic cycles: Early Cycle (Recovery):

• Financials, Industrials, Materials lead
• Economy improving, credit spreads tightening
• Cyclical sectors outperform defensive

Mid Cycle (Expansion):

• Technology, Consumer Discretionary lead
• Sustained growth, rising confidence
• Growth sectors extend leadership

Late Cycle (Peak):

• Energy, Materials outperform
• Inflation concerns, capacity constraints
• Commodity-sensitive sectors benefit

Recession:

• Consumer Staples, Health Care, Utilities lead
• Flight to defensive, stable earnings
• Non-cyclical sectors provide downside protection

​

Fixed Income - Understanding Bond Performance

Bond prices and yields move inversely: Yields Rising → Bond Prices Falling:

• Negative returns for bond ETFs
• Indicates rising interest rates or improving growth
• Duration matters (long-term bonds more sensitive)

Yields Falling → Bond Prices Rising:

• Positive returns for bond ETFs
• Indicates falling interest rates or flight-to-quality
• Treasuries outperform in risk-off environments

Credit Spreads:

• Compare corporate bond yields to Treasury yields
• Widening spreads = increasing credit risk/risk-off
• Tightening spreads = improving credit conditions/risk-on

​

Yields - Yield Curve Shapes

Normal Curve:

• Long-term yields > short-term yields
• Healthy economy with growth expectations
• Steep curve = strong growth outlook

Flat Curve:

• Similar yields across maturities
• Economic uncertainty, policy transition
• Often occurs before inversions

Inverted Curve:

• Short-term yields > long-term yields
• Recession warning (historically reliable predictor)
• 2s10s inversion most watched

​

Equity Factors - Factor Cycles

Growth Outperforms Value:

• Risk-on environment
• Low interest rates
• Technology and innovation leadership

Value Outperforms Growth:

• Rising rates, inflation concerns
• Economic recovery phases
• Cyclical sectors leadership

Momentum Strong:

• Trending markets, clear directional moves
• Low volatility, high confidence

Low Volatility/Quality Lead:

• Risk-off, market stress
• Defensive positioning
• Flight to safety

​

Multi-Period Performance Analysis

The seven timeframes enable different analytical approaches: 1D (1-Day): Current market sentiment and intraday volatility
5D (5-Day): Weekly trends and short-term momentum
1M (1-Month): Near-term trends, filters out daily noise
3M (3-Month): Quarterly trends, captures seasonal patterns
6M (6-Month): Medium-term trends, business cycle positioning
YTD (Year-to-Date): Calendar year performance tracking
1Y (1-Year): Long-term trends, filters out short-term volatility How to Use Multiple Timeframes:

• Consistent momentum: Asset positive across all periods (strong trend)
• Acceleration: Returns increasing as timeframe shortens (1D > 5D > 1M)
• Deceleration: Returns decreasing as timeframe shortens (potential reversal)
• Divergence: 1D/5D negative but 3M/6M positive (pullback in uptrend)

---

​

Use Cases

​

Index Level Tracking

Monitor exact S&P 500, NASDAQ, DAX, or Nikkei levels for precise benchmarking and headline reporting.

​

Sector Rotation

Identify which sectors are leading/lagging to make tactical tilts or confirm economic cycle positioning.

​

Yield Curve Analysis

Monitor curve shape (normal/flat/inverted) for recession signals and interest rate policy expectations.

​

Factor Investing

Track growth vs value, momentum, quality, and other factors to optimize portfolio construction.

​

Duration Management

Use Treasury ETF performance and yield changes to manage interest rate risk in fixed income portfolios.

​

Credit Risk Assessment

Compare investment-grade vs high-yield bond ETF performance to gauge credit market stress.

​

Cross-Asset Risk Assessment

Check correlations across equities, bonds, commodities, and currencies to assess portfolio diversification.

​

Inflation Hedging

Monitor commodities, TIPS (Treasury Inflation-Protected Securities), and real asset performance.

​

Global Diversification

Compare performance across countries, regions, and asset classes for international allocation decisions.

​

Defensive Positioning

Use VIX, safe-haven assets (gold, Treasuries, JPY), and defensive sectors/factors to manage downside risk.

​

Market Breadth Analysis

Compare S&P 500 vs Russell 2000, equal-weight vs cap-weight, and sector dispersion to assess market health.

---

​

Practical Tips

​

Quick Cross-Asset Scan Workflow

1. Major US indexes → S&P 500, NASDAQ, Russell 2000 (market leadership)
2. VIX → Fear gauge (high = elevated risk)
3. Equity sectors → Which sectors leading/lagging (cycle positioning)
4. Equity factors → Growth vs value, momentum (style leadership)
5. Yields → Curve shape, 10-year level (rates environment)
6. Fixed income → Treasuries vs corporates (credit spreads)
7. Commodities → Oil, copper, gold (growth/inflation/fear)
8. Currencies → USD, EM currencies (capital flows)
9. Global markets → US vs International, EM vs DM (geographic flows)

​

Spotting Market Regimes

Risk-On:

• Equities up (especially EM, small-caps, growth)
• Cyclical sectors lead (Tech, Discretionary, Financials)
• Growth factors outperform value
• High-yield credit outperforms Treasuries
• Commodities strong, VIX low
• USD weak, crypto strong

Risk-Off:

• Equities down (especially high-beta)
• Defensive sectors lead (Staples, Utilities, Health Care)
• Quality/low vol factors outperform
• Treasuries outperform credit (spreads widen)
• Gold/JPY/CHF strong, VIX elevated
• USD strong, crypto weak

Inflation Regime:

• Commodities strong
• Energy/Materials sectors lead
• Value outperforms growth
• TIPS outperform nominal Treasuries
• Yields rising (especially long-end)
• Commodity currencies strong

Recession Watch:

• Yield curve inverted (2s10s negative)
• Defensive sectors/factors outperform
• Credit spreads widening
• Small-caps underperform large-caps
• VIX elevated, flight to Treasuries

​

Combining with Other Tearsheets

• Country Tearsheet: Deep dive into economic data when equity indexes show unusual moves
• Company Tearsheet: Analyze sector leaders when commodity prices signal sector rotation
• Search Tool: Find news explaining cross-asset moves or commodity shocks

---