Dataset Name: etfglobal_industry_legacy
Group: reference_data
Vendor: ETF Global
Symbol Set: ETFs
Asset Class: Equity
Data Update Time(s): 8:00 AM EST
Data Update Frequency: month
Detailed information on each ETF - around 2200+ rows/tickers/symbols per day, 56 columns including Industry Group, Industry and Sub Industry exposure.
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 (weekdays only) |
| Issuer | string | Issuing firm of the product |
| Description | string | The name and description of the product |
| Inception_Date | string | Inception date of the product |
| Primary_Benchmark | string | Underlying index as per the prospectus |
| Tax_Classification | string | RIC/Partnership/UIT - 1099 vs K1 |
| ETN | bool | Boolean field to indicate if product is an ETN |
| Fund_AUM | double | Daily total AUM of the product |
| Average_Daily_Trading_Volume | double | 1 month average daily trading volume |
| Asset_Class | string | Asset Class (eg Blank, Equity , Real Estate, Fixed Income, Stock - Preferred, Commodity, Currency, etc.) |
| Category | string | Broad category description |
| Focus | string | Specific exposure description |
| Development_Class | string | ETFG developmental class |
| Region | string | Regional focus |
| Levered | bool | Boolean field to indicate if product is levered |
| Leverage_Factor | double | Leverage factor. i.e., -1, 2, 3, -3 |
| Active | bool | Boolean field to indicate if product is an "Active" product per SEC |
| Administrator | string | The ETF Administrator |
| Advisor | string | The ETF Advisor |
| Custodian | string | The ETF Custodian |
| Distributor | string | ETF Distributor |
| Portfolio_Manager | string | Portfolio Manager |
| Subadvisor | string | ETF Subadvisor |
| Transfer_Agent | string | Transfer Agent |
| Trustee | string | ETF Trustee |
| Futures_Commission_Merchant | string | Futures Commission Merchant |
| Fiscal_Year_End | string | Fiscal Year End |
| Distribution_Frequency | string | Distribution Frequency |
| Listing_Exchange | string | Listing Exchange |
| Creation_Unit_Size | double | Number of shares needed for a creation unit |
| Creation_Fee | double | Fee for creating a unit of shares |
| Geographic_Exposure | string | Geographic breakdown based on country of domicile |
| Currency_Exposure | string | Currency breakdown |
| Sector_Exposure | string | Sector breakdown |
| Industry_Group_Exposure | string | Industry Group breakdown |
| Industry_Exposure | string | Industry breakdown |
| Sub_Industry_Exposure | string | Sub-Industry breakdown |
| Coupon_Exposure | string | Coupon breakdown |
| Maturity_Exposure | string | Maturity breakdown |
| Options_Available | double | Are options available on product |
| Options_Volume | double | Aggregated Put and Call Volume |
| Short_Interest | double | Number of shares sold short |
| Put_Call_Ratio | double | Put/Call ratio for product with options |
| Number_Of_Holdings | double | Number of Holdings |
| Discount_Premium | double | Discount/Premium |
| Bid_Ask_Spread | double | Average intra-day Bid/Ask divided by lowest sample intra day Ask |
| Put_Volume | double | Put Options Volume |
| Call_Volume | double | Call Options Volume |
| Management_Fee | double | Management Fee Charged |
| Other_Expenses | double | Other fund expenses |
| Total_Expenses | double | Total Fund Expense |
| Fee_Waivers | double | Fee Waivers |
| Net_Expenses | double | Net Expense Ratio |
| Lead_Market_Maker | string | Listed Lead Market Maker for product |