Dataset Name: etfglobal_constituents_legacy
Group: etf
Vendor: ETF Global
Data Starts at: 2012-01-03 00:00:00
Symbol Set: ETFs
Asset Class: Equity
Data Update Time(s): 8:00 AM EST
Data Update Frequency: day
ETF Constituents (Full Holdings) - A full look-through of an ETF's portfolio - provides unique identifiers for each underlying security, country, exchange, and currency traded in, constituent asset class & security type, market value, shares and weight in each ETF.
ETF Global® (ETFG®) is a leading, independent provider of data, research, investment decision support applications, proprietary risk analytics and invest.
Legacy version goes further back in time but has a slightly different structure than the current dataset.
Data Contained in this Dataset
| Column | Type | Description |
|---|---|---|
| _seq | uint | Internal sequence number used to keep data rows in order |
| timestamp | string | Timestamp of the Data - America/New York Time. |
| muts | uint64 | Microseconds Unix Timestamp. An integer representation of a timestamp with microsecond precision that can be compared directly to other timestamps. |
| symbol | string | Trading Symbol or Ticker |
| date | string | Date |
| constituent_ticker | string | Ticker/Symbol of the ETFs underlying constituent |
| constituent_name | string | Full Text name of the ETFs underlying constituent |
| constituent_weight | double | Weight of the ETFs underlying Constituent/Ticker |
| constituent_market_value | double | Market Value of shares of the underlying constituent Ticker/Symbol held by the ETF |
| constituent_cusip | string | CUSIP for underlying constituent. Committee on Uniform Security Identification Procedures identifier owned by American Bankers Association operated by Standard and Poor's, requires CUSIP license. |
| constituent_isin | string | ISIN for underlying constituent. International Securities Identification Number. An international code which identifies a securities issue |
| constituent_figi | string | FIGI for underlying constituent. The FIGI code (https://www.openfigi.com) that identifies the stock across related exchanges in the same country. |
| constituent_sedol | string | Sedol for underlying constituent. Stock Exchange Daily Official List identifier assigned by the London Stock Exchange, requires SEDOL license |
| constituent_exchange | string | Exchange - eg , NEW YORK STOCK EXCHANGE, INC., NASDAQ/NGS (GLOBAL SELECT MARKET), NYSE MKT LLC, NASDAQ CAPITAL MARKET, US, BATS Z-EXCHANGE, NYSE ARCA, NYSE Arca, NASDAQ/NMS (GLOBAL MARKET), OTC BULLETIN BOARD - OTHER OTC |
| constituent_iso_country | string | constituent_iso_country - Country in which Primary Exchange of the constituent Ticker/Symbol is locaed (eg blank, US, DE, CA, CH, PE, GR, BER) |
| total_shares_held | double | Number of shares of underlying constituent held by the ETP |
| asset_class | string | Asset Class (eg Blank, Equity , Real Estate, Fixed Income, Stock - Preferred, Commodity, Currency, etc.) |
| security_type | string | Security Type - ETFG Taxonomy Classification (eg Blank, ADR, Common Stock, REIT, Ltd Part, MLP, Tracking Stk, ETP, Closed-End Fund, Unit, NY Reg Shrs, PUBLIC, PRIVATE, Royalty Trst, Right,Common Equity, Domestic, Global etc.) |