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

请用认证信息登录，可解锁此内容

Other Queries for this Dataset(s)

指数数据

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

指数数据

Available TOPIX Security Identifiers

指数数据

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

指数数据

CiqGvkeyIID Linking For The Current S&P 1200 Constituents

指数数据

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

指数数据

Constructing The TOPIX Index Market Cap