Ticker Table¶
Total rows: 196,501
Columns: 52
Column names: is_active, security_type, security_id, security_label, ticker, isin, sector, industry, country, country_id, currency, exchange_id, exchange, fund_id, family_id, portfolio_id, provider_id, asset_class, region, bond_sector, credit_rating, display_rank, esg_index, hedged, market_development, rebalance_date, return_type, size, style, strategic_beta, performance_id, company_id, master_portfolio_id, security_type_id, stock_style_box, dividend_distribution_frequency, inception_date, broad_category_group, morningstar_category, distribution_fund_type, replication_method, is_index_fund, primary_benchmark, management_expense_ratio, has_performance_fee, fund_star_rating, morningstar_risk_rating, medalist_rating, sustainability_rating, fund_equity_style_box, fund_fixed_income_style_box, fund_alternative_style_box
Interactive Table¶
Sample Data¶
| is_active | security_type | security_id | security_label | ticker | isin | sector | industry | country | country_id | currency | exchange_id | exchange | fund_id | family_id | portfolio_id | provider_id | asset_class | region | bond_sector | credit_rating | display_rank | esg_index | hedged | market_development | rebalance_date | return_type | size | style | strategic_beta | performance_id | company_id | master_portfolio_id | security_type_id | stock_style_box | dividend_distribution_frequency | inception_date | broad_category_group | morningstar_category | distribution_fund_type | replication_method | is_index_fund | primary_benchmark | management_expense_ratio | has_performance_fee | fund_star_rating | morningstar_risk_rating | medalist_rating | sustainability_rating | fund_equity_style_box | fund_fixed_income_style_box | fund_alternative_style_box |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| True | index | FOUSA06B9O | Morningstar Wide Moat Foc | Broad | United States | AUD,CHF,CAD,USD,EUR,GBP,JPY | FSUSA07Z10 | IS000014DI | P000000153 | 0C000023GE | Equity | North America | 1 | False | True | Developed | 2025-12-22 | PR,ER,TR,NR | Broad | Broad | True | nan | nan | nan | |||||||||||||||||||||||||||
| True | index | F000016HBU | Morningstar Global Mkts Sust Moat | Broad | USD,CAD,EUR,AUD,GBP,CHF,JPY | FS0000GM8W | IS0000148X | 2552068 | 0C000023GE | Equity | Global | 2 | True | True | Broad | 2025-12-22 | TR,PR,NR | Broad | Broad | True | nan | nan | nan | ||||||||||||||||||||||||||||
| True | index | F00000T5WT | Morningstar DM | Broad | KRW,NZD,GBP,JPY,NOK,SEK,AUD,DKK,USD,CAD,CHF,EUR | FS0000AQEN | IS0000148T | P000001046 | 0C000023GE | Equity | Europe | 3 | False | True | Developed | 2025-12-22 | PR,TR,NR | Broad | Broad | False | nan | nan | nan | ||||||||||||||||||||||||||||
| True | index | F000016AXE | Morningstar DM Gen Di | Broad | USD,AUD,CAD,CHF,EUR,GBP,JPY | FS0000GJRL | IS0000149A | 2531393 | 0C000023GE | Equity | Global | 4 | True | True | Developed | 2025-12-22 | PR,TR,NR | Large And Mid | Broad | False | nan | nan | nan | ||||||||||||||||||||||||||||
| True | index | F00000GWXN | Morningstar Gbl Mkts | Broad | CAD,CHF,AUD,NOK,DKK,EUR,JPY,SEK,USD,GBP,LCL,ZAR | FSUSA0AOJI | IS0000148T | P000000050 | 0C000023GE | Equity | Global | 5 | False | True | Broad | 2025-12-22 | TR,PR,NR | Broad | Broad | False | nan | nan | nan | ||||||||||||||||||||||||||||
| True | index | F00000XN8O | Morningstar GblMkt Sustainability | Broad | JPY,GBP,USD,AUD,CHF,EUR,CAD | FS0000CPHS | IS0000148X | 1225976 | 0C000023GE | Equity | Global | 6 | True | True | Broad | 2025-12-22 | PR,TR,NR | Large And Mid | Broad | False | nan | nan | nan | ||||||||||||||||||||||||||||
| True | index | F00001EACT | Morningstar LSTA US LL | United States | CHF,NOK,PLN,USD,SEK,SGD,CAD,AUD,EUR,JPY,GBP | FS0000HS4A | IS000014DH | 2931083 | 0C000023GE | Fixed Income | North America | Corporate | 7 | False | True | Developed | TR,IR,PR | False | nan | nan | nan | ||||||||||||||||||||||||||||||
| True | index | F00001E9T3 | Morningstar LSTA US LL100 | United States | USD,JPY,EUR,CHF,GBP,SGD,AUD,CAD | FS0000HS44 | IS000014DG | 2931856 | 0C000023GE | Fixed Income | North America | Corporate | 8 | False | True | Developed | IR,TR,PR | False | nan | nan | nan | ||||||||||||||||||||||||||||||
| True | index | F00001E9QG | Morningstar ELL | EUR,JPY,SGD,USD,LCL,CAD,CHF,AUD,GBP | FS0000HS3S | IS000014DF | 2928559 | 0C000023GE | Fixed Income | Europe | Corporate | 9 | False | True | Developed | TR,IR,PR | False | nan | nan | nan | |||||||||||||||||||||||||||||||
| True | index | F0000119FA | Morningstar US Core Bd | AUD,KRW,CAD,DKK,USD,GBP,EUR,CHF,SEK,NOK,JPY,LCL | FS0000E0HM | IS00001491 | 1861102 | 0C000023GE | Fixed Income | North America | Broad | Investment grade | 10 | False | True | Developed | PR,TR | False | nan | nan | nan |