US Funds Dataset From Yahoo Finance
23k+ Mutual Funds and 2k+ ETFs scraped from Yahoo Finance
@kaggle.stefanoleone992_mutual_funds_and_etfs
Mutualfunds
@kaggle.stefanoleone992_mutual_funds_and_etfs.mutualfunds
- 17.01 MB
- 23783 rows
- 298 columns
- Only the first 100 columns are shown
fund_symbolFund Symbol | quote_typeQuote Type | regionRegion | fund_short_nameFund Short Name | fund_long_nameFund Long Name | currencyCurrency | initial_investmentInitial Investment | subsequent_investmentSubsequent Investment | fund_categoryFund Category | fund_familyFund Family | exchange_codeExchange Code | exchange_nameExchange Name | exchange_timezoneExchange Timezone | management_nameManagement Name | management_bioManagement Bio | management_start_dateManagement Start Date | total_net_assetsTotal Net Assets | year_to_date_returnYear To Date Return | day50_moving_averageDay50 Moving Average | day200_moving_averageDay200 Moving Average | week52_high_low_changeWeek52 High Low Change | week52_high_low_change_percWeek52 High Low Change Perc | week52_highWeek52 High | week52_high_changeWeek52 High Change | week52_high_change_percWeek52 High Change Perc | week52_lowWeek52 Low | week52_low_changeWeek52 Low Change | week52_low_change_percWeek52 Low Change Perc | investment_strategyInvestment Strategy | fund_yieldFund Yield | morningstar_overall_ratingMorningstar Overall Rating | morningstar_risk_ratingMorningstar Risk Rating | inception_dateInception Date | last_dividendLast Dividend | last_cap_gainLast Cap Gain | annual_holdings_turnoverAnnual Holdings Turnover | investment_typeInvestment Type | size_typeSize Type | fund_annual_report_net_expense_ratioFund Annual Report Net Expense Ratio | category_annual_report_net_expense_ratioCategory Annual Report Net Expense Ratio | fund_prospectus_net_expense_ratioFund Prospectus Net Expense Ratio | fund_prospectus_gross_expense_ratioFund Prospectus Gross Expense Ratio | fund_max_12b1_feeFund Max 12b1 Fee | fund_max_front_end_sales_loadFund Max Front End Sales Load | category_max_front_end_sales_loadCategory Max Front End Sales Load | fund_max_deferred_sales_loadFund Max Deferred Sales Load | category_max_deferred_sales_loadCategory Max Deferred Sales Load | fund_year3_expense_projectionFund Year3 Expense Projection | fund_year5_expense_projectionFund Year5 Expense Projection | fund_year10_expense_projectionFund Year10 Expense Projection | asset_cashAsset Cash | asset_stocksAsset Stocks | asset_bondsAsset Bonds | asset_othersAsset Others | asset_preferredAsset Preferred | asset_convertibleAsset Convertible | fund_sector_basic_materialsFund Sector Basic Materials | fund_sector_communication_servicesFund Sector Communication Services | fund_sector_consumer_cyclicalFund Sector Consumer Cyclical | fund_sector_consumer_defensiveFund Sector Consumer Defensive | fund_sector_energyFund Sector Energy | fund_sector_financial_servicesFund Sector Financial Services | fund_sector_healthcareFund Sector Healthcare | fund_sector_industrialsFund Sector Industrials | fund_sector_real_estateFund Sector Real Estate | fund_sector_technologyFund Sector Technology | fund_sector_utilitiesFund Sector Utilities | fund_price_book_ratioFund Price Book Ratio | category_price_book_ratioCategory Price Book Ratio | fund_price_cashflow_ratioFund Price Cashflow Ratio | category_price_cashflow_ratioCategory Price Cashflow Ratio | fund_price_earning_ratioFund Price Earning Ratio | category_price_earning_ratioCategory Price Earning Ratio | fund_price_sales_ratioFund Price Sales Ratio | category_price_sales_ratioCategory Price Sales Ratio | fund_median_market_capFund Median Market Cap | category_median_market_capCategory Median Market Cap | fund_year3_earnings_growthFund Year3 Earnings Growth | category_year3_earnings_growthCategory Year3 Earnings Growth | fund_bond_maturityFund Bond Maturity | category_bond_maturityCategory Bond Maturity | fund_bond_durationFund Bond Duration | category_bond_durationCategory Bond Duration | fund_bonds_us_governmentFund Bonds Us Government | fund_bonds_aaaFund Bonds Aaa | fund_bonds_aaFund Bonds Aa | fund_bonds_aFund Bonds A | fund_bonds_bbbFund Bonds Bbb | fund_bonds_bbFund Bonds Bb | fund_bonds_bFund Bonds B | fund_bonds_below_bFund Bonds Below B | fund_bonds_othersFund Bonds Others | top10_holdingsTop10 Holdings | top10_holdings_total_assetsTop10 Holdings Total Assets | morningstar_return_ratingMorningstar Return Rating | returns_as_of_dateReturns As Of Date | fund_return_ytdFund Return Ytd | category_return_ytdCategory Return Ytd | fund_return_1monthFund Return 1month | category_return_1monthCategory Return 1month | fund_return_3monthsFund Return 3months | category_return_3monthsCategory Return 3months | fund_return_1yearFund Return 1year | category_return_1yearCategory Return 1year | fund_return_3yearsFund Return 3years | category_return_3yearsCategory Return 3years | fund_return_5yearsFund Return 5years | category_return_5yearsCategory Return 5years | fund_return_10yearsFund Return 10years | category_return_10yearsCategory Return 10years | fund_return_last_bull_marketFund Return Last Bull Market | category_return_last_bull_marketCategory Return Last Bull Market | fund_return_last_bear_marketFund Return Last Bear Market | category_return_last_bear_marketCategory Return Last Bear Market | years_upYears Up | years_downYears Down | fund_return_2020Fund Return 2020 | category_return_2020Category Return 2020 | fund_return_2019Fund Return 2019 | category_return_2019Category Return 2019 | fund_return_2018Fund Return 2018 | category_return_2018Category Return 2018 | fund_return_2017Fund Return 2017 | category_return_2017Category Return 2017 | fund_return_2016Fund Return 2016 | category_return_2016Category Return 2016 | fund_return_2015Fund Return 2015 | category_return_2015Category Return 2015 | fund_return_2014Fund Return 2014 | category_return_2014Category Return 2014 | fund_return_2013Fund Return 2013 | category_return_2013Category Return 2013 | fund_return_2012Fund Return 2012 | category_return_2012Category Return 2012 | fund_return_2011Fund Return 2011 | category_return_2011Category Return 2011 | fund_return_2010Fund Return 2010 | category_return_2010Category Return 2010 | fund_return_2009Fund Return 2009 | category_return_2009Category Return 2009 | fund_return_2008Fund Return 2008 | category_return_2008Category Return 2008 | fund_return_2007Fund Return 2007 | category_return_2007Category Return 2007 | fund_return_2006Fund Return 2006 | category_return_2006Category Return 2006 | fund_return_2005Fund Return 2005 | category_return_2005Category Return 2005 | fund_return_2004Fund Return 2004 | category_return_2004Category Return 2004 | fund_return_2003Fund Return 2003 | category_return_2003Category Return 2003 | fund_return_2002Fund Return 2002 | category_return_2002Category Return 2002 | fund_return_2001Fund Return 2001 | category_return_2001Category Return 2001 | fund_return_2000Fund Return 2000 | category_return_2000Category Return 2000 | quarters_upQuarters Up | quarters_downQuarters Down | fund_return_2021_q3Fund Return 2021 Q3 | fund_return_2021_q2Fund Return 2021 Q2 | fund_return_2021_q1Fund Return 2021 Q1 | fund_return_2020_q4Fund Return 2020 Q4 | fund_return_2020_q3Fund Return 2020 Q3 | fund_return_2020_q2Fund Return 2020 Q2 | fund_return_2020_q1Fund Return 2020 Q1 | fund_return_2019_q4Fund Return 2019 Q4 | fund_return_2019_q3Fund Return 2019 Q3 | fund_return_2019_q2Fund Return 2019 Q2 | fund_return_2019_q1Fund Return 2019 Q1 | fund_return_2018_q4Fund Return 2018 Q4 | fund_return_2018_q3Fund Return 2018 Q3 | fund_return_2018_q2Fund Return 2018 Q2 | fund_return_2018_q1Fund Return 2018 Q1 | fund_return_2017_q4Fund Return 2017 Q4 | fund_return_2017_q3Fund Return 2017 Q3 | fund_return_2017_q2Fund Return 2017 Q2 | fund_return_2017_q1Fund Return 2017 Q1 | fund_return_2016_q4Fund Return 2016 Q4 | fund_return_2016_q3Fund Return 2016 Q3 | fund_return_2016_q2Fund Return 2016 Q2 | fund_return_2016_q1Fund Return 2016 Q1 | fund_return_2015_q4Fund Return 2015 Q4 | fund_return_2015_q3Fund Return 2015 Q3 | fund_return_2015_q2Fund Return 2015 Q2 | fund_return_2015_q1Fund Return 2015 Q1 | fund_return_2014_q4Fund Return 2014 Q4 | fund_return_2014_q3Fund Return 2014 Q3 | fund_return_2014_q2Fund Return 2014 Q2 | fund_return_2014_q1Fund Return 2014 Q1 | fund_return_2013_q4Fund Return 2013 Q4 | fund_return_2013_q3Fund Return 2013 Q3 | fund_return_2013_q2Fund Return 2013 Q2 | fund_return_2013_q1Fund Return 2013 Q1 | fund_return_2012_q4Fund Return 2012 Q4 | fund_return_2012_q3Fund Return 2012 Q3 | fund_return_2012_q2Fund Return 2012 Q2 | fund_return_2012_q1Fund Return 2012 Q1 | fund_return_2011_q4Fund Return 2011 Q4 | fund_return_2011_q3Fund Return 2011 Q3 | fund_return_2011_q2Fund Return 2011 Q2 | fund_return_2011_q1Fund Return 2011 Q1 | fund_return_2010_q4Fund Return 2010 Q4 | fund_return_2010_q3Fund Return 2010 Q3 | fund_return_2010_q2Fund Return 2010 Q2 | fund_return_2010_q1Fund Return 2010 Q1 | fund_return_2009_q4Fund Return 2009 Q4 | fund_return_2009_q3Fund Return 2009 Q3 | fund_return_2009_q2Fund Return 2009 Q2 | fund_return_2009_q1Fund Return 2009 Q1 | fund_return_2008_q4Fund Return 2008 Q4 | fund_return_2008_q3Fund Return 2008 Q3 | fund_return_2008_q2Fund Return 2008 Q2 | fund_return_2008_q1Fund Return 2008 Q1 | fund_return_2007_q4Fund Return 2007 Q4 | fund_return_2007_q3Fund Return 2007 Q3 | fund_return_2007_q2Fund Return 2007 Q2 | fund_return_2007_q1Fund Return 2007 Q1 | fund_return_2006_q4Fund Return 2006 Q4 | fund_return_2006_q3Fund Return 2006 Q3 | fund_return_2006_q2Fund Return 2006 Q2 | fund_return_2006_q1Fund Return 2006 Q1 | fund_return_2005_q4Fund Return 2005 Q4 | fund_return_2005_q3Fund Return 2005 Q3 | fund_return_2005_q2Fund Return 2005 Q2 | fund_return_2005_q1Fund Return 2005 Q1 | fund_return_2004_q4Fund Return 2004 Q4 | fund_return_2004_q3Fund Return 2004 Q3 | fund_return_2004_q2Fund Return 2004 Q2 | fund_return_2004_q1Fund Return 2004 Q1 | fund_return_2003_q4Fund Return 2003 Q4 | fund_return_2003_q3Fund Return 2003 Q3 | fund_return_2003_q2Fund Return 2003 Q2 | fund_return_2003_q1Fund Return 2003 Q1 | fund_return_2002_q4Fund Return 2002 Q4 | fund_return_2002_q3Fund Return 2002 Q3 | fund_return_2002_q2Fund Return 2002 Q2 | fund_return_2002_q1Fund Return 2002 Q1 | fund_return_2001_q4Fund Return 2001 Q4 | fund_return_2001_q3Fund Return 2001 Q3 | fund_return_2001_q2Fund Return 2001 Q2 | fund_return_2001_q1Fund Return 2001 Q1 | fund_return_2000_q4Fund Return 2000 Q4 | fund_return_2000_q3Fund Return 2000 Q3 | fund_return_2000_q2Fund Return 2000 Q2 | fund_return_2000_q1Fund Return 2000 Q1 | fund_alpha_3yearsFund Alpha 3years | fund_beta_3yearsFund Beta 3years | fund_mean_annual_return_3yearsFund Mean Annual Return 3years | fund_r_squared_3yearsFund R Squared 3years | fund_stdev_3yearsFund Stdev 3years | fund_sharpe_ratio_3yearsFund Sharpe Ratio 3years | fund_treynor_ratio_3yearsFund Treynor Ratio 3years | fund_alpha_5yearsFund Alpha 5years | fund_beta_5yearsFund Beta 5years | fund_mean_annual_return_5yearsFund Mean Annual Return 5years | fund_r_squared_5yearsFund R Squared 5years | fund_stdev_5yearsFund Stdev 5years | fund_sharpe_ratio_5yearsFund Sharpe Ratio 5years | fund_treynor_ratio_5yearsFund Treynor Ratio 5years | fund_alpha_10yearsFund Alpha 10years | fund_beta_10yearsFund Beta 10years | fund_mean_annual_return_10yearsFund Mean Annual Return 10years | fund_r_squared_10yearsFund R Squared 10years | fund_stdev_10yearsFund Stdev 10years | fund_sharpe_ratio_10yearsFund Sharpe Ratio 10years | fund_treynor_ratio_10yearsFund Treynor Ratio 10years | fund_return_category_rank_ytdFund Return Category Rank Ytd | fund_return_category_rank_1monthFund Return Category Rank 1month | fund_return_category_rank_3monthsFund Return Category Rank 3months | fund_return_category_rank_1yearFund Return Category Rank 1year | fund_return_category_rank_3yearsFund Return Category Rank 3years | fund_return_category_rank_5yearsFund Return Category Rank 5years | load_adj_return_1yearLoad Adj Return 1year | load_adj_return_3yearsLoad Adj Return 3years | load_adj_return_5yearsLoad Adj Return 5years | load_adj_return_10yearsLoad Adj Return 10years | sustainability_scoreSustainability Score | sustainability_rankSustainability Rank | esg_peer_groupEsg Peer Group | esg_peer_countEsg Peer Count | esg_scoreEsg Score | peer_esg_minPeer Esg Min | peer_esg_avgPeer Esg Avg | peer_esg_maxPeer Esg Max | environment_scoreEnvironment Score | peer_environment_minPeer Environment Min | peer_environment_avgPeer Environment Avg | peer_environment_maxPeer Environment Max | social_scoreSocial Score | peer_social_minPeer Social Min | peer_social_avgPeer Social Avg | peer_social_maxPeer Social Max | governance_scoreGovernance Score | peer_governance_minPeer Governance Min | peer_governance_avgPeer Governance Avg | peer_governance_maxPeer Governance Max |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AAAAX | MutualFund | US | DWS RREEF Real Assets Fund - Cl | DWS RREEF Real Assets Fund - Class A | USD | 1000 | 50 | World Allocation | DWS | NAS | Nasdaq | America/New_York | John Vojticek | Co-Head of Liquid Real Assets / Chief Investment Officer of Liquid Real Assets John W. Vojticek has served as a Managing Director and Chief Investment Officer of Real Estate & Infrastructure Securities and Global Portfolio Manager, DWS since July 2011 and was Co-Head of Americas Real Estate Securiti… | Thu Jan 15 2015 00:00:00 GMT+0000 (Coordinated Universal Time) | 2979347456 | 0.21026 | 12.788 | 12.369 | 2.44 | 0.18683 | 13.06 | -0.51 | -0.03905 | 10.62 | 1.93 | 0.18173 | The investment seeks total return in excess of inflation through capital growth and current income. The fund will invest at least 80% of its net assets, plus the amount of any borrowings for investment purposes, in a combination of investments that the Advisor believes offer exposure to "real assets… | 0.0186 | 3 | 3 | Mon Jul 30 2007 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.1466 | 0.74 | Value | Large | 0.0122 | 0.0102 | 0.0122 | 0.0136 | 0.0024 | 0.0575 | 0.0504 | 0.0136 | 968 | 1264 | 2105 | 0.0167 | 0.6436 | 0.1142 | 0.2255 | 0.1607 | 0.0088 | 0.019 | 0.0293 | 0.1852 | 0.1413 | 0.352 | 0.0012 | 0.1025 | 1.91 | 2.28 | 12.09 | 11.96 | 23.34 | 19.86 | 2.36 | 1.73 | 22401.91 | 68472.9 | -1.39 | 9.16 | 6.11 | 5.8 | "Cayman Real Assets Fund Ltd.": 0.1098, CCI ("Crown Castle International Corp"): 0.0258, LNG ("Cheniere Energy Inc"): 0.0241, "United States Treasury Notes 1.62%": 0.0189, FCX ("Freeport-McMoRan Inc"): 0.0175, "United States Treasury Notes 0.12%": 0.0156, AMT ("American Tower Corp"): 0.0146, WMB ("W… | 0.2546 | 3 | Wed Nov 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.21026 | 0.0858 | 0.00077 | 0.0172 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| AAAEX | MutualFund | US | AllianzGI Health Sciences Fund | Virtus AllianzGI Health Sciences Fund Class P | USD | 1000000 | Health | Virtus | NAS | Nasdaq | America/New_York | Christopher Chin | nan | Thu Aug 27 2020 00:00:00 GMT+0000 (Coordinated Universal Time) | 195348944 | 0.19077 | 40.513 | 38.65 | 8.53 | 0.20256 | 42.11 | -2.77 | -0.06578 | 33.58 | 5.76 | 0.17153 | The investment seeks long-term capital appreciation. The fund seeks to achieve its objective by normally investing at least 80% of its net assets (plus borrowings made for investment purposes) in health sciences-related companies. The portfolio manager considers health sciences-related companies to … | 3 | 2 | Mon Jul 13 2020 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.24262 | 0.91 | Blend | Large | 0.0109 | 0.0103 | 0.0109 | 0.0109 | 0.0537 | 0.0119 | 346 | 599 | 1326 | 0.0309 | 0.9691 | 0.0368 | 0.0034 | 0.9598 | 4.68 | 5.09 | 14.38 | 18.76 | 26.87 | 27.55 | 2.13 | 4.21 | 56096.51 | 34189.17 | 11.95 | 30.26 | AZN. L ("AstraZeneca PLC ADR"): 0.0585, MDT ("Medtronic PLC"): 0.0551, BMY ("Bristol-Myers Squibb Company"): 0.0534, PFE ("Pfizer Inc"): 0.0498, LLY ("Eli Lilly and Co"): 0.049, AVTR ("Avantor Inc"): 0.0357, ANTM ("Anthem Inc"): 0.0349, NVS ("Novartis AG ADR"): 0.0341, HZNP ("Horizon Therapeutics PL… | 0.4285 | 3 | Wed Nov 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.19077 | 0.0315 | -0.00662 | -0.0117 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| AAAFX | MutualFund | US | nan | American Century One Choice Blend+ 2015 Portfolio Investor Class | USD | 2500 | 50 | Target-Date 2015 | American Century Investments | NAS | Nasdaq | America/New_York | Scott A. Wilson | Mr. Wilson, Vice President and Portfolio Manager, has been a member of the team since 2013. He joined American Century Investments in 1992, became an analyst in 1994 and a portfolio manager in 2011. He has a bachelor's degree in business administration from Pepperdine University and is a CFA charter… | Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | 25946 | 10.544 | 10.392 | 0.76 | 0.07096 | 10.71 | -0.29 | -0.02708 | 9.95 | 0.47 | 0.04724 | The investment seeks the highest total return consistent with its asset mix. The fund is a "fund of funds," meaning that it seeks to achieve its objective by investing in other mutual funds and exchange-traded funds (ETFs) advised by American Century (collectively, the underlying funds) that represe… | Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | Blend | Large | 0.0058 | 0.0041 | 0.0058 | 0.006 | 0.0525 | 0.01 | 186 | 0.092 | 0.3496 | 0.4897 | 0.0575 | 0.0013 | 0.0029 | 0.029 | 0.072 | 0.1184 | 0.0822 | 0.0355 | 0.1679 | 0.1342 | 0.1277 | 0.0376 | 0.1696 | 0.0258 | 2.57 | 2.93 | 13.06 | 13.7 | 24.95 | 22.88 | 1.99 | 2.16 | 48155.1 | 76075.75 | 12.51 | 11.39 | 7.6 | 5.77 | 5.97 | 5.7 | 0.4425 | 0.0638 | 0.1628 | 0.1958 | 0.0621 | 0.0411 | 0.0152 | 0.0166 | AVBNX ("Avantis© Core Fixed Income G"): 0.2708, AGBGX ("American Century Global Bond G"): 0.1237, AVUNX ("Avantis© U.S. Equity G"): 0.081, ACLLX ("American Century NT Focused Lg Cap Val G"): 0.0649, APOGX ("American Century Short Dur Infl ProBd G"): 0.0622, AVGNX ("Avantis© Short-Term Fixed Income G… | 0.8558 | Wed Nov 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.0446 | -0.00095 | 0.0089 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| AAAGX | MutualFund | US | Thrivent Large Cap Growth Fund | Thrivent Large Cap Growth Fund Class A | USD | 2000 | 50 | Large Growth | Thrivent Funds | NAS | Nasdaq | America/New_York | Lauri Brunner | Ms. Brunner has been with Thrivent Financial since 2007 and currently is a Senior Equity Portfolio Manager. | Sun Sep 30 2018 00:00:00 GMT+0000 (Coordinated Universal Time) | 2078606848 | 0.24559 | 18.485 | 17.294 | 4.64 | 0.23955 | 19.37 | -1.34 | -0.06918 | 14.73 | 3.3 | 0.22403 | The investment seeks long-term capital appreciation. The fund invests at least 80% of its net assets (plus the amount of any borrowing for investment purposes) in equity securities of large companies. The Adviser focuses mainly on the equity securities of large domestic and international companies w… | 4 | 4 | Fri Oct 29 1999 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.44 | Growth | Large | 0.0108 | 0.0099 | 0.0108 | 0.0112 | 0.0025 | 0.045 | 0.0536 | 0.0133 | 786 | 1035 | 1748 | 0.0182 | 0.9818 | 0.1617 | 0.1957 | 0.0046 | 0.1458 | 0.1326 | 0.0346 | 0.325 | 10.2 | 8.12 | 26.3 | 23.44 | 37.45 | 33.85 | 5.74 | 4.75 | 337976.7 | 304809.9 | 32.36 | 23.69 | 3.63 | 2.73 | AMZN ("Amazon.com Inc"): 0.1102, MSFT ("Microsoft Corp"): 0.0755, AAPL ("Apple Inc"): 0.0752, GOOGL ("Alphabet Inc A"): 0.0749, PYPL ("PayPal Holdings Inc"): 0.0469, FB ("Facebook Inc A"): 0.0464, MA ("Mastercard Inc A"): 0.0374, ADBE ("Adobe Inc"): 0.0313, SQ ("Square Inc A"): 0.0295, NVDA ("NVIDIA… | 0.5565 | 4 | Wed Nov 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.24559 | 0.0706 | 0.03698 | -0.0101 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| AAAHX | MutualFund | US | nan | American Century One Choice Blend+ 2015 Portfolio I Class | USD | 5000000 | Target-Date 2015 | American Century Investments | NAS | Nasdaq | America/New_York | Scott A. Wilson | Mr. Wilson, Vice President and Portfolio Manager, has been a member of the team since 2013. He joined American Century Investments in 1992, became an analyst in 1994 and a portfolio manager in 2011. He has a bachelor's degree in business administration from Pepperdine University and is a CFA charter… | Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | 25946 | 10.552 | 10.398 | 0.77 | 0.07183 | 10.72 | -0.29 | -0.02705 | 9.95 | 0.48 | 0.04824 | The investment seeks the highest total return consistent with its asset mix. The fund is a "fund of funds," meaning that it seeks to achieve its objective by investing in other mutual funds and exchange-traded funds (ETFs) advised by American Century (collectively, the underlying funds) that represe… | Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | Blend | Large | 0.0038 | 0.0041 | 0.0038 | 0.004 | 0.0525 | 0.01 | 122 | 0.092 | 0.3496 | 0.4897 | 0.0575 | 0.0013 | 0.0029 | 0.029 | 0.072 | 0.1184 | 0.0822 | 0.0355 | 0.1679 | 0.1342 | 0.1277 | 0.0376 | 0.1696 | 0.0258 | 2.57 | 2.93 | 13.06 | 13.7 | 24.95 | 22.88 | 1.99 | 2.16 | 48155.1 | 76075.75 | 12.51 | 11.39 | 7.6 | 5.77 | 5.97 | 5.7 | 0.4425 | 0.0638 | 0.1628 | 0.1958 | 0.0621 | 0.0411 | 0.0152 | 0.0166 | AVBNX ("Avantis© Core Fixed Income G"): 0.2708, AGBGX ("American Century Global Bond G"): 0.1237, AVUNX ("Avantis© U.S. Equity G"): 0.081, ACLLX ("American Century NT Focused Lg Cap Val G"): 0.0649, APOGX ("American Century Short Dur Infl ProBd G"): 0.0622, AVGNX ("Avantis© Short-Term Fixed Income G… | 0.8558 | Wed Nov 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.0446 | 0.0089 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| AAAIX | MutualFund | US | American Century Strategic Allo | American Century Strategic Allocation: Aggressive Fund I Class | USD | 5000000 | 50 | Allocation--70% to 85% Equity | American Century Investments | NAS | Nasdaq | America/New_York | Scott A. Wilson | Mr. Wilson, Vice President and Portfolio Manager, has been a member of the team since 2013. He joined American Century Investments in 1992, became an analyst in 1994 and a portfolio manager in 2011. He has a bachelor's degree in business administration from Pepperdine University and is a CFA charter… | Fri Apr 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | 848319040 | 0.1505 | 9.149 | 8.884 | 1.43 | 0.15197 | 9.41 | -0.46 | -0.04888 | 7.98 | 0.97 | 0.12155 | The investment seeks the highest level of total return consistent with its asset mix. The fund's asset allocation strategy diversifies investments among equity securities, bonds and money market instruments. It usually invests 79% of its assets in stocks, 20% of its assets in bonds, and 1% of its as… | 0.0083 | 4 | 3 | Tue Aug 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.0775 | 1.09 | Blend | Large | 0.0063 | 0.007 | 0.0063 | 0.0112 | 0.0501 | 0.0142 | 273 | 499 | 1148 | 0.0343 | 0.7687 | 0.1935 | 0.0001 | 0.0007 | 0.0009 | 0.0379 | 0.0709 | 0.1316 | 0.0736 | 0.0263 | 0.1357 | 0.1299 | 0.1274 | 0.0563 | 0.1857 | 0.0246 | 2.73 | 3.32 | 12.72 | 15.12 | 23.74 | 24.11 | 1.75 | 2.31 | 33125.21 | 79528.12 | 13.58 | 15.53 | 6.82 | 6.72 | 5.05 | 5.19 | 0.5065 | 0.0518 | 0.1608 | 0.1404 | 0.0638 | 0.0585 | 0.011 | 0.0072 | AVUS ("Avantis© U.S. Equity ETF"): 0.077, QGRO ("American Century US Quality Growth ETF"): 0.0637, FDG ("American Century Foc Dynmc Gr ETF"): 0.0605, VALQ ("American Century STOXX US Qlty Val ETF"): 0.0575, FLV ("American Century Foc Lrg Cp Val ETF"): 0.0562, AVEM ("Avantis© Emerging Markets Equity … | 0.4799 | 4 | Wed Nov 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.1505 | 0.1022 | 0.00434 | 0.011 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| AAAJX | MutualFund | US | nan | American Century One Choice Blend+ 2015 Portfolio A Class | USD | 2500 | 50 | Target-Date 2015 | American Century Investments | NAS | Nasdaq | America/New_York | Scott A. Wilson | Mr. Wilson, Vice President and Portfolio Manager, has been a member of the team since 2013. He joined American Century Investments in 1992, became an analyst in 1994 and a portfolio manager in 2011. He has a bachelor's degree in business administration from Pepperdine University and is a CFA charter… | Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | 25946 | 10.523 | 10.381 | 0.75 | 0.07016 | 10.69 | -0.29 | -0.02713 | 9.94 | 0.46 | 0.04628 | The investment seeks the highest total return consistent with its asset mix. The fund is a "fund of funds," meaning that it seeks to achieve its objective by investing in other mutual funds and exchange-traded funds (ETFs) advised by American Century (collectively, the underlying funds) that represe… | Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | Blend | Large | 0.0083 | 0.0041 | 0.0083 | 0.0085 | 0.0025 | 0.0575 | 0.0525 | 0.01 | 825 | 0.092 | 0.3496 | 0.4897 | 0.0575 | 0.0013 | 0.0029 | 0.029 | 0.072 | 0.1184 | 0.0822 | 0.0355 | 0.1679 | 0.1342 | 0.1277 | 0.0376 | 0.1696 | 0.0258 | 2.57 | 2.93 | 13.06 | 13.7 | 24.95 | 22.88 | 1.99 | 2.16 | 48155.1 | 76075.75 | 12.51 | 11.39 | 7.6 | 5.77 | 5.97 | 5.7 | 0.4425 | 0.0638 | 0.1628 | 0.1958 | 0.0621 | 0.0411 | 0.0152 | 0.0166 | AVBNX ("Avantis© Core Fixed Income G"): 0.2708, AGBGX ("American Century Global Bond G"): 0.1237, AVUNX ("Avantis© U.S. Equity G"): 0.081, ACLLX ("American Century NT Focused Lg Cap Val G"): 0.0649, APOGX ("American Century Short Dur Infl ProBd G"): 0.0622, AVGNX ("Avantis© Short-Term Fixed Income G… | 0.8558 | Wed Nov 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.0446 | 0.0089 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| AAAKX | MutualFund | US | nan | American Century One Choice Blend+ 2015 Portfolio R Class | USD | 2500 | Target-Date 2015 | American Century Investments | NAS | Nasdaq | America/New_York | Scott A. Wilson | Mr. Wilson, Vice President and Portfolio Manager, has been a member of the team since 2013. He joined American Century Investments in 1992, became an analyst in 1994 and a portfolio manager in 2011. He has a bachelor's degree in business administration from Pepperdine University and is a CFA charter… | Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | 25946 | 10.506 | 10.371 | 0.73 | 0.06842 | 10.67 | -0.29 | -0.02718 | 9.94 | 0.44 | 0.04427 | The investment seeks the highest total return consistent with its asset mix. The fund is a "fund of funds," meaning that it seeks to achieve its objective by investing in other mutual funds and exchange-traded funds (ETFs) advised by American Century (collectively, the underlying funds) that represe… | Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | Blend | Large | 0.0108 | 0.0041 | 0.0108 | 0.011 | 0.005 | 0.0525 | 0.01 | 344 | 0.092 | 0.3496 | 0.4897 | 0.0575 | 0.0013 | 0.0029 | 0.029 | 0.072 | 0.1184 | 0.0822 | 0.0355 | 0.1679 | 0.1342 | 0.1277 | 0.0376 | 0.1696 | 0.0258 | 2.57 | 2.93 | 13.06 | 13.7 | 24.95 | 22.88 | 1.99 | 2.16 | 48155.1 | 76075.75 | 12.51 | 11.39 | 7.6 | 5.77 | 5.97 | 5.7 | 0.4425 | 0.0638 | 0.1628 | 0.1958 | 0.0621 | 0.0411 | 0.0152 | 0.0166 | AVBNX ("Avantis© Core Fixed Income G"): 0.2708, AGBGX ("American Century Global Bond G"): 0.1237, AVUNX ("Avantis© U.S. Equity G"): 0.081, ACLLX ("American Century NT Focused Lg Cap Val G"): 0.0649, APOGX ("American Century Short Dur Infl ProBd G"): 0.0622, AVGNX ("Avantis© Short-Term Fixed Income G… | 0.8558 | Wed Nov 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.0446 | -0.00095 | 0.0089 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| AAALX | MutualFund | US | nan | American Century One Choice Blend+ 2015 Portfolio R6 Class | USD | Target-Date 2015 | American Century Investments | NAS | Nasdaq | America/New_York | Scott A. Wilson | Mr. Wilson, Vice President and Portfolio Manager, has been a member of the team since 2013. He joined American Century Investments in 1992, became an analyst in 1994 and a portfolio manager in 2011. He has a bachelor's degree in business administration from Pepperdine University and is a CFA charter… | Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | 25946 | 10.564 | 10.404 | 0.78 | 0.07269 | 10.73 | -0.28 | -0.0261 | 9.95 | 0.5 | 0.05025 | The investment seeks the highest total return consistent with its asset mix. The fund is a "fund of funds," meaning that it seeks to achieve its objective by investing in other mutual funds and exchange-traded funds (ETFs) advised by American Century (collectively, the underlying funds) that represe… | Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | Blend | Large | 0.0023 | 0.0041 | 0.0023 | 0.0025 | 0.0525 | 0.01 | 74 | 0.092 | 0.3496 | 0.4897 | 0.0575 | 0.0013 | 0.0029 | 0.029 | 0.072 | 0.1184 | 0.0822 | 0.0355 | 0.1679 | 0.1342 | 0.1277 | 0.0376 | 0.1696 | 0.0258 | 2.57 | 2.93 | 13.06 | 13.7 | 24.95 | 22.88 | 1.99 | 2.16 | 48155.1 | 76075.75 | 12.51 | 11.39 | 7.6 | 5.77 | 5.97 | 5.7 | 0.4425 | 0.0638 | 0.1628 | 0.1958 | 0.0621 | 0.0411 | 0.0152 | 0.0166 | AVBNX ("Avantis© Core Fixed Income G"): 0.2708, AGBGX ("American Century Global Bond G"): 0.1237, AVUNX ("Avantis© U.S. Equity G"): 0.081, ACLLX ("American Century NT Focused Lg Cap Val G"): 0.0649, APOGX ("American Century Short Dur Infl ProBd G"): 0.0622, AVGNX ("Avantis© Short-Term Fixed Income G… | 0.8558 | Wed Nov 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.0446 | 0.0089 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| AAAMX | MutualFund | US | nan | American Century One Choice Blend+ 2020 Portfolio Investor Class | USD | 2500 | Target-Date 2020 | American Century Investments | NAS | Nasdaq | America/New_York | Scott A. Wilson | Mr. Wilson, Vice President and Portfolio Manager, has been a member of the team since 2013. He joined American Century Investments in 1992, became an analyst in 1994 and a portfolio manager in 2011. He has a bachelor's degree in business administration from Pepperdine University and is a CFA charter… | Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | 59322 | 10.625 | 10.437 | 0.86 | 0.07963 | 10.8 | -0.31 | -0.0287 | 9.94 | 0.55 | 0.05533 | The investment seeks the highest total return consistent with its asset mix. The fund is a "fund of funds," meaning that it seeks to achieve its objective by investing in other mutual funds and exchange-traded funds (ETFs) advised by American Century (collectively, the underlying funds) that represe… | Wed Mar 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | Blend | Large | 0.0058 | 0.0042 | 0.0058 | 0.0059 | 0.0525 | 0.0125 | 186 | 0.0908 | 0.3775 | 0.4796 | 0.041 | 0.0013 | 0.0029 | 0.0298 | 0.0722 | 0.1218 | 0.0806 | 0.0356 | 0.1675 | 0.132 | 0.1263 | 0.038 | 0.1704 | 0.0257 | 2.57 | 2.92 | 13.09 | 14.39 | 24.85 | 23.52 | 1.98 | 2.17 | 46216.95 | 71741.37 | 12.62 | 12.09 | 7.67 | 5.85 | 5.98 | 5.65 | 0.4223 | 0.0629 | 0.1623 | 0.1982 | 0.0713 | 0.0484 | 0.0181 | 0.0164 | AVBNX ("Avantis© Core Fixed Income G"): 0.2666, AGBGX ("American Century Global Bond G"): 0.1177, AVUNX ("Avantis© U.S. Equity G"): 0.0896, ACLLX ("American Century NT Focused Lg Cap Val G"): 0.0685, ACFGX ("American Century Focused Dynamic Gr G"): 0.0596, APOGX ("American Century Short Dur Infl Pro… | 0.8331 | Wed Nov 24 2021 00:00:00 GMT+0000 (Coordinated Universal Time) | 0.0492 | 0.0092 |
CREATE TABLE mutualfunds (
"fund_symbol" VARCHAR,
"quote_type" VARCHAR,
"region" VARCHAR,
"fund_short_name" VARCHAR,
"fund_long_name" VARCHAR,
"currency" VARCHAR,
"initial_investment" DOUBLE,
"subsequent_investment" DOUBLE,
"fund_category" VARCHAR,
"fund_family" VARCHAR,
"exchange_code" VARCHAR,
"exchange_name" VARCHAR,
"exchange_timezone" VARCHAR,
"management_name" VARCHAR,
"management_bio" VARCHAR,
"management_start_date" TIMESTAMP,
"total_net_assets" DOUBLE,
"year_to_date_return" DOUBLE,
"day50_moving_average" DOUBLE,
"day200_moving_average" DOUBLE,
"week52_high_low_change" DOUBLE,
"week52_high_low_change_perc" DOUBLE,
"week52_high" DOUBLE,
"week52_high_change" DOUBLE,
"week52_high_change_perc" DOUBLE,
"week52_low" DOUBLE,
"week52_low_change" DOUBLE,
"week52_low_change_perc" DOUBLE,
"investment_strategy" VARCHAR,
"fund_yield" DOUBLE,
"morningstar_overall_rating" DOUBLE,
"morningstar_risk_rating" DOUBLE,
"inception_date" TIMESTAMP,
"last_dividend" DOUBLE,
"last_cap_gain" DOUBLE,
"annual_holdings_turnover" DOUBLE,
"investment_type" VARCHAR,
"size_type" VARCHAR,
"fund_annual_report_net_expense_ratio" DOUBLE,
"category_annual_report_net_expense_ratio" DOUBLE,
"fund_prospectus_net_expense_ratio" DOUBLE,
"fund_prospectus_gross_expense_ratio" DOUBLE,
"fund_max_12b1_fee" DOUBLE,
"fund_max_front_end_sales_load" DOUBLE,
"category_max_front_end_sales_load" DOUBLE,
"fund_max_deferred_sales_load" DOUBLE,
"category_max_deferred_sales_load" DOUBLE,
"fund_year3_expense_projection" DOUBLE,
"fund_year5_expense_projection" DOUBLE,
"fund_year10_expense_projection" DOUBLE,
"asset_cash" DOUBLE,
"asset_stocks" DOUBLE,
"asset_bonds" DOUBLE,
"asset_others" DOUBLE,
"asset_preferred" DOUBLE,
"asset_convertible" DOUBLE,
"fund_sector_basic_materials" DOUBLE,
"fund_sector_communication_services" DOUBLE,
"fund_sector_consumer_cyclical" DOUBLE,
"fund_sector_consumer_defensive" DOUBLE,
"fund_sector_energy" DOUBLE,
"fund_sector_financial_services" DOUBLE,
"fund_sector_healthcare" DOUBLE,
"fund_sector_industrials" DOUBLE,
"fund_sector_real_estate" DOUBLE,
"fund_sector_technology" DOUBLE,
"fund_sector_utilities" DOUBLE,
"fund_price_book_ratio" DOUBLE,
"category_price_book_ratio" DOUBLE,
"fund_price_cashflow_ratio" DOUBLE,
"category_price_cashflow_ratio" DOUBLE,
"fund_price_earning_ratio" DOUBLE,
"category_price_earning_ratio" DOUBLE,
"fund_price_sales_ratio" DOUBLE,
"category_price_sales_ratio" DOUBLE,
"fund_median_market_cap" DOUBLE,
"category_median_market_cap" DOUBLE,
"fund_year3_earnings_growth" DOUBLE,
"category_year3_earnings_growth" DOUBLE,
"fund_bond_maturity" DOUBLE,
"category_bond_maturity" DOUBLE,
"fund_bond_duration" DOUBLE,
"category_bond_duration" DOUBLE,
"fund_bonds_us_government" DOUBLE,
"fund_bonds_aaa" DOUBLE,
"fund_bonds_aa" DOUBLE,
"fund_bonds_a" DOUBLE,
"fund_bonds_bbb" DOUBLE,
"fund_bonds_bb" DOUBLE,
"fund_bonds_b" DOUBLE,
"fund_bonds_below_b" DOUBLE,
"fund_bonds_others" DOUBLE,
"top10_holdings" VARCHAR,
"top10_holdings_total_assets" DOUBLE,
"morningstar_return_rating" DOUBLE,
"returns_as_of_date" TIMESTAMP,
"fund_return_ytd" DOUBLE,
"category_return_ytd" DOUBLE,
"fund_return_1month" DOUBLE,
"category_return_1month" DOUBLE
);