Returns S&P500, R2000 And FALLWORLD Index Constituents And Market Data By Sector As Of A Specified Date

This SQL query returns the constituents of the S&P 500 Index, categorized by sector, as of a specified date. It collects various data points including company names, unique identifiers (GVKEY), index weights, market capitalization, share prices, and sector classifications.

Enhancement Date: 2/6/2025

  • SourceMarket Intelligence
  • Data Packages Required
    BECRS SNLRussell Global Constituent CurrentCRS Cross Reference CoreBase CompanyBase Exchange RatesGVKey IID EnhancedFTSE Index LevelRussell Global Constituent HistoryS&P TMI/CI Constituent Deep HistoryMarket CapitalizationPrices Intraday Recent HistoryBase SecurityBase Foundation Company Daily
  • Associated Datasets
    Index Data

Query Types

  • Snowflake