Fund profile — fund_profile_YYYYMMDD.txt.gz
Part of the SQXray data dictionary. Field list (.csv)
Fund profile — fund_profile_YYYYMMDD.txt.gz
A daily compressed file with one row per fund share class: the disclosed facts about the fund — its minimum investment, whether it tracks an index, the wrapper it is issued under and where it is domiciled, how it pays income out, how it replicates its index and in which countries it is registered for sale, the facets of that index, its adviser and sub-advisers, its stated objective, and its portfolio managers. Fee facts live in fund fees; the stated benchmark name lives in fund portfolio analytics; the proxy-voting posture (share of matters voted with and against management, ESG support) lives in fund proxy summary on the portfolio's ALL row for each proxy year.
| Field | Type | Nullable | Description | Example |
|---|---|---|---|---|
analysis_date | DATE | never blank | The date the row was computed for. | |
fund_isin | VARCHAR(12) | never blank (key) | The share class's ISIN and this file's key: one row per fund_isin. The JOIN key for the fund reference, fund liquidity and every other share-class file. | |
class_id | VARCHAR(12) | may be blank | SEC class identifier (C000...) of the share class. Blank for a vehicle the SEC does not assign one to. | |
portfolio_id | BIGINT | may be blank | The portfolio (SEC series or umbrella fund) the class belongs to, as published in the fund reference and portfolio holdings files. | |
series_id | VARCHAR(12) | may be blank | SEC series identifier (S000...) of the portfolio. Blank for a non-SEC vehicle. | |
min_initial_investment | DECIMAL(14,2) | may be blank | Minimum initial investment in the share class, in US dollars. 0 when the prospectus states there is no minimum. | |
min_initial_investment_source | VARCHAR(32) | may be blank | The source of min_initial_investment. | |
min_subsequent_investment | DECIMAL(14,2) | may be blank | Minimum subsequent (additional) investment in the share class, in US dollars. 0 when the prospectus states there is no minimum. | |
min_subsequent_investment_source | VARCHAR(32) | may be blank | The source of min_subsequent_investment. | |
min_investment_method | VARCHAR(8) | may be blank | How the minimum-investment amount was read: table or regex for a prospectus parse, web for a sponsor page, EMT or KID value (min_initial_investment_source names the sponsor). | |
is_index_fund | TINYINT(1) | may be blank | 1 when the fund seeks to track an index, 0 when it does not, blank when no source states it; an N-CEN filing with no fund-type census states nothing. | |
is_index_fund_source | VARCHAR(32) | may be blank | The source of is_index_fund. | |
fund_structure | VARCHAR(32) | may be blank | The legal wrapper the class is issued under. | |
fund_structure_source | VARCHAR(32) | may be blank | The source of fund_structure. | |
jurisdiction | VARCHAR(64) | may be blank | The country the fund is domiciled in, as the sponsor states it. | |
jurisdiction_source | VARCHAR(32) | may be blank | The source of jurisdiction. | |
dividend_policy | VARCHAR(16) | may be blank | Whether the class pays income out (distributing) or reinvests it (accumulating). | |
dividend_policy_source | VARCHAR(32) | may be blank | The source of dividend_policy. | |
replication_method | VARCHAR(24) | may be blank | How the fund gains its exposure: physical when it holds securities, synthetic when it holds a derivative on the index. | |
replication_method_source | VARCHAR(32) | may be blank | The source of replication_method. | |
replication_model | VARCHAR(24) | may be blank | How closely a physical fund holds the index: full_replication holds every constituent at index weight, sampled and optimised hold a subset. A swap value names the funding of a synthetic fund. | |
replication_model_source | VARCHAR(32) | may be blank | The source of replication_model. | |
is_semi_transparent | VARCHAR(1) | may be blank | Y when the class discloses a proxy basket rather than its full holdings, N when it discloses the book. | |
is_semi_transparent_source | VARCHAR(32) | may be blank | The source of is_semi_transparent. | |
semi_transparent_strategy | VARCHAR(128) | may be blank | The named proxy-basket model a semi-transparent class uses, as the sponsor brands it. | |
semi_transparent_strategy_source | VARCHAR(32) | may be blank | The source of semi_transparent_strategy. | |
tracking_since | DATE | may be blank | The date the class began tracking its current index. Distinct from the launch date: a class that changed index carries the change date here. | |
tracking_since_source | VARCHAR(32) | may be blank | The source of tracking_since. | |
distribution_countries | VARCHAR(512) | may be blank | The countries the class is registered for distribution in, ISO 3166-1 alpha-2, semicolon-separated. | |
distribution_countries_source | VARCHAR(32) | may be blank | The source of distribution_countries. | |
jurisdiction_zone | VARCHAR(24) | may be blank | The geographical zone of jurisdiction. Derived from it, so it carries no source field of its own. | |
generic_index | VARCHAR(255) | may be blank | The index's name without its calculation detail — no dividend treatment, no currency and no hedging leg. The full stated name is delivered on fund_portfolio_analytics as stated_benchmark. | |
generic_index_source | VARCHAR(32) | may be blank | The source of generic_index. | |
index_currency | VARCHAR(3) | may be blank | The currency the index is calculated in, ISO 4217. Blank when the index name does not state one. | |
index_currency_source | VARCHAR(32) | may be blank | The source of index_currency. | |
index_dividend_policy | VARCHAR(24) | may be blank | How the index treats dividends in its own calculation: net of withholding tax, gross of it, or excluded altogether (a price index). | |
index_dividend_policy_source | VARCHAR(32) | may be blank | The source of index_dividend_policy. | |
index_provider | VARCHAR(32) | may be blank | The administrator of the index the fund tracks. | |
index_provider_source | VARCHAR(32) | may be blank | The source of index_provider. | |
adviser_name | VARCHAR(512) | may be blank | Name of the portfolio's longest-serving current adviser (earliest start; ties to the lowest file number), spelt as the fund adviser file spells the firm under adviser_file_no. Every adviser is a row of fund_manager. | |
adviser_name_source | VARCHAR(32) | may be blank | The source of adviser_name. | |
adviser_file_no | VARCHAR(128) | may be blank | SEC investment-adviser file number (801-...) of the adviser named in adviser_name. The join to the fund adviser file; the portfolio's full adviser roster is in fund_manager, one row per adviser. | |
adviser_since | DATE | may be blank | The earliest date the current adviser is known to have served from. Read with adviser_since_is_exact. | |
adviser_since_is_exact | TINYINT(1) | may be blank | 1 when a filing stated the adviser's start date, 0 when adviser_since is the first annual census the adviser appears in and the appointment began on or before it. | |
sub_adviser_names | VARCHAR(512) | may be blank | Names of the sub-advisers currently appointed to the portfolio, semicolon-separated. | |
objective | VARCHAR(1000) | may be blank | The fund's stated investment objective, as the prospectus summary states it, truncated to 1,000 characters. | |
objective_source | VARCHAR(32) | may be blank | The source of objective. | |
pm_names | VARCHAR(1024) | may be blank | Names of the portfolio managers currently named in the prospectus, semicolon-separated. | |
pm_names_source | VARCHAR(32) | may be blank | The source of pm_names. | |
pm_count | INT | may be blank | Number of portfolio managers in pm_names. | |
pm_longest_since | DATE | may be blank | The earliest stated tenure start among the current portfolio managers. |
Appendix: canonical values
| Field | Values |
|---|---|
min_investment_method | table, regex, web |