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

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.

SourceMarket Intelligence
Data Packages Required
BECRS SNL Russell Global Constituent Current CRS Cross Reference Core Base Company Base Exchange Rates GVKey IID Enhanced FTSE Index Level Russell Global Constituent History S&P TMI/CI Constituent Deep History Market Capitalization Prices Intraday Recent History Base Security Base Foundation Company Daily

To unlock this content, please sign in with your credentials

Other Queries for this Dataset(s)

Index Data

Returns Levels Of Index Hierarchy Using Index Key For A BMI Index

Index Data

Available TOPIX Security Identifiers

Index Data

Returns Constituents And Weights Using MSCI Daily Index Data Using S&P Capital IQ Index Data Xpressfeed

Index Data

CiqGvkeyIID Linking For The Current S&P 1200 Constituents

Index Data

Returns Constituents And Weights Using MSCI Month-End Index Data Using S&P Capital IQ Index Data Xpressfeed

Index Data

Constructing The TOPIX Index Market Cap