Fund profile — fund_profile_YYYYMMDD.txt.gz
One file 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, its adviser and sub-advisers, its stated objective, and its portfolio managers. Fee facts live in fund fees; the stated benchmark 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. | |
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 |