| key |
id |
string(500)* |
= |
Unique Identifier |
| timeline |
effectiveDate |
date* |
=< >= |
Indicative of when the constituent level data is applicable.
CLS.SDC file shows the close constituents as of the
trading date. ADJ.SDC file shows constituents as of the
open of the next index trading date. |
| query_stats |
audCreatedDate |
dateTime |
|
Timestamp of the record created in DataBase |
|
alternateClassificationCode |
string(200) |
|
This field is reserved for alternate, product-specific
classification schemes. Alternate classifications comprise
all sectors not starting with a digit or the letter D |
|
asOfInd |
string(50) |
|
Represents if the file contains close or adjusted close data |
|
awf |
decimal |
|
Additional weight factor as needed for certain
methodologies. For methodologies not using AWF, the
value will be 1. For ADJ.SDC files, this value represents
the end-of-day AWF taking into account adjustments
reflected in the next trading day. For PRO.SDC files, this
value represents the end-of-day AWF taking into account
adjustments reflected in the rebalancing date. |
| link |
batch |
Batch* |
= |
The Batch for which this BatchRun is an instance. |
| link |
batchRun |
BatchRun* |
= |
The BatchRun in which the data is calculated. |
|
bloombergTicker |
string(200) |
|
Bloomberg ticker, provided on a best effort basis. |
|
capRange |
string(20) |
|
Available for index families with breakdown by a market
cap bracket. For example, a stock that is classified to be
over $25 billion will have the code RO25B. |
|
company |
string(200) |
|
The name of the constituent. |
|
countryOfDomicile |
string(2) |
|
ISO country/region code that is associated
with the constituents country/region of domicile. |
|
countryOfListing |
string(2) |
|
ISO country/region code that is associated
with the constituents country/region of exchange. |
|
currencyCode |
string(3) |
|
The ISO currency code in which the closing price of the
stock is stated. |
|
cusip |
string(200) |
|
Constituents CUSIP identifier, provided on a
best effort basis. |
|
dailyPriceReturn |
decimal |
|
Daily stock % price return in index currency. Calculated
as (((End-of-day LOCAL PRICE * End-of-day FX RATE)
/ (Start- of-day LOCAL PRICE * Start-of-day FX RATE))
- 1). If a stock did not trade on a day but the index FX
RATE did, then the return is still impacted by the change
in FX RATE. |
|
dailyTotalReturn |
decimal |
|
Daily stock % total return in index currency. Same as the
DAILY PRICE RETURN but factoring in any dividends if
current day is the dividend ex-date. Calculated as
((((End- of-day LOCAL PRICE * End-of-day FX RATE) +
(DIVIDEND * End-of-day FX RATE))/ (Start-of-day
LOCAL PRICE * Start- of-day FX RATE)) - 1). |
|
dividend |
decimal |
|
Dividend as reported by the constituent with an ex-date
of the current day. Field is NULL if no dividends are
issued on that day. Dividend Adjustment (primarily
applicable for Japanese and Korean companies) is also
reflected in this field.* |
|
djiIndustryCode |
string(200) |
|
Dow Jones Indexes' proprietary industry classification
code associated with the constituent. |
|
fileDate |
date |
|
Date on which the file is distributed |
|
fxRate |
decimal |
|
Foreign exchange rate required in order to translate the
stocks market value from local to index currency. A
stock can have different exchange rates across different
families in the event that families close at different time
zones. |
|
gicsCode |
string(1000) |
|
The Global Industry Classification Standard code
associated with the constituent. |
|
growth |
decimal |
|
The growth weight factor associated with the stock. |
|
gvKey |
string(200) |
|
Constituents Compustat permanent company identifier,
provided on a best effort basis. |
|
indexCode |
string(200) |
|
Defines the index code that this stock is related to. |
|
indexKey |
string(200) |
|
Defines the index key that this stock is related to. See
chapter Index Keys for more information. |
|
indexMarketCap |
decimal |
|
The portion of the constituent's market cap that is part of
the index (i.e. INDEX SHARES * LOCAL PRICE * FX
RATE). |
|
indexName |
string(200) |
|
Defines the index name that this stock is related to. |
|
indexShares |
decimal |
|
The total number of shares determined and used by the
index calculation methodology (i.e. SHARES
OUSTANDING * IWF * AWF). |
|
indexWeight |
decimal |
|
The weight of the stock within the parent index.
Calculated as the INDEX MARKET CAP of the stock /
Sum of INDEX MARKET CAPs of all stocks in the index. |
|
isin |
string(200) |
|
Constituents ISIN identifier, provided on a
best effort basis. |
|
iwf |
decimal |
|
The investible weight factor of the stock in the index. A
value of 1 = 100% Free Float. For ADJ.SDC files, this
value represents the end-of-day IWF taking into account
adjustments reflected in the next trading day. For
PRO.SDC files, this value represents the end-of-day
IWF taking into account adjustments reflected in the
rebalancing date. |
|
localPrice |
decimal |
|
The end-of-day closing price of the stock, represented in
the local currency of the stock. For ADJ.SDC files, this
value represents today's price taking into account
adjustments reflected in the next trading day. For
PRO.SDC files, this value represents today's price taking
into account adjustments reflected in the rebalancing
date only for FMC indices, while for weighted indices, the
Local Price is as of the next open following the Report
Date |
|
marketCap |
decimal |
|
The total unadjusted market capitalization of the stock,
representing the SHARES OUTSTANDING * LOCAL
PRICE * FX RATE. Value is represented in the currency
of the parent index. |
|
mic |
string(10) |
|
Market Identification Code
ISO Code of the exchange the constituent is traded on.
Provided on a best effort basis. |
|
netDividend |
decimal |
|
Net dividend amount issued by the constituent with an
ex-date of the current day (after subtracting taxes and
franking). Tax and franking rates used are as of ex-date.
Field is NULL if no dividends are issued on that day. Net
Dividend Adjustment (primarily applicable for Japanese
and Korean companies) is also reflected in this field.* |
|
region |
string(200) |
|
Available for the Global BMI & GIVI families and indicates
if the stock is considered part of a developed or emerging
market. |
|
ric |
string(200) |
|
Reuters Instrument Code, provided on a best effort
basis. |
|
sedol |
string(200) |
|
Constituents SEDOL identifier, provided on a
best effort basis. |
|
sharesOutstanding |
decimal{26,0} |
|
The latest number of shares outstanding for the
constituent. For ADJ.SDC files, this value represents the
end-of-day shares outstanding taking into account
adjustments reflected in the next trading day. For
PRO.SDC files, this value represents the end-of-day
shares outstanding taking into account adjustments
reflected in the rebalancing date. |
|
size |
string(10) |
|
Indicates if the stock is classified as a large, mid or small
cap stock within the methodology of the index. A stock
may be classified as large in one index family, and mid in
another. Value is left blank for indices not providing size
breakdown. |
|
stockKey |
long(0,9223372036854775806) |
|
Unique S&P Dow Jones Indices identifier. This key will
be persistent regardless of other identifier changes. |
|
ticker |
string(200) |
|
Constituents stock ticker, associated with the exchange
the constituent is traded on, provided on a best effort
basis. |
|
value |
decimal |
|
The value weight factor associated with the stock. |