US Funds Dataset From Yahoo Finance

23k+ Mutual Funds and 2k+ ETFs scraped from Yahoo Finance

@kaggle.stefanoleone992_mutual_funds_and_etfs

Table List

7 tables(321.04 MB)

Etf Prices

Etfs

Mutualfund Prices A E

Mutualfund Prices F K

Mutualfund Prices L P

Mutualfund Prices Q Z

Mutualfunds

Etfs

@kaggle.stefanoleone992_mutual_funds_and_etfs.etfs

1.14 MB
2310 rows
142 columns
Only the first 100 columns are shown

fund_symbol Fund Symbol	quote_type Quote Type	region Region	fund_short_name Fund Short Name	fund_long_name Fund Long Name	currency Currency	fund_category Fund Category	fund_family Fund Family	exchange_code Exchange Code	exchange_name Exchange Name	exchange_timezone Exchange Timezone	avg_vol_3month Avg Vol 3month	avg_vol_10day Avg Vol 10day	total_net_assets Total Net Assets	day50_moving_average Day50 Moving Average	day200_moving_average Day200 Moving Average	week52_high_low_change Week52 High Low Change	week52_high_low_change_perc Week52 High Low Change Perc	week52_high Week52 High	week52_high_change Week52 High Change	week52_high_change_perc Week52 High Change Perc	week52_low Week52 Low	week52_low_change Week52 Low Change	week52_low_change_perc Week52 Low Change Perc	investment_strategy Investment Strategy	fund_yield Fund Yield	inception_date Inception Date	annual_holdings_turnover Annual Holdings Turnover	investment_type Investment Type	size_type Size Type	fund_annual_report_net_expense_ratio Fund Annual Report Net Expense Ratio	category_annual_report_net_expense_ratio Category Annual Report Net Expense Ratio	asset_stocks Asset Stocks	fund_sector_basic_materials Fund Sector Basic Materials	fund_sector_communication_services Fund Sector Communication Services	fund_sector_consumer_cyclical Fund Sector Consumer Cyclical	fund_sector_consumer_defensive Fund Sector Consumer Defensive	fund_sector_energy Fund Sector Energy	fund_sector_financial_services Fund Sector Financial Services	fund_sector_healthcare Fund Sector Healthcare	fund_sector_industrials Fund Sector Industrials	fund_sector_real_estate Fund Sector Real Estate	fund_sector_technology Fund Sector Technology	fund_sector_utilities Fund Sector Utilities	fund_price_book_ratio Fund Price Book Ratio	fund_price_cashflow_ratio Fund Price Cashflow Ratio	fund_price_earning_ratio Fund Price Earning Ratio	fund_price_sales_ratio Fund Price Sales Ratio	top10_holdings Top10 Holdings	top10_holdings_total_assets Top10 Holdings Total Assets	returns_as_of_date Returns As Of Date	fund_return_ytd Fund Return Ytd	category_return_ytd Category Return Ytd	fund_return_1month Fund Return 1month	category_return_1month Category Return 1month	fund_return_3months Fund Return 3months	category_return_3months Category Return 3months	fund_return_1year Fund Return 1year	category_return_1year Category Return 1year	fund_return_3years Fund Return 3years	category_return_3years Category Return 3years	fund_return_5years Fund Return 5years	category_return_5years Category Return 5years	fund_return_10years Fund Return 10years	category_return_10years Category Return 10years	years_up Years Up	years_down Years Down	fund_return_2020 Fund Return 2020	fund_return_2019 Fund Return 2019	fund_return_2018 Fund Return 2018	fund_return_2017 Fund Return 2017	fund_return_2016 Fund Return 2016	fund_return_2015 Fund Return 2015	category_return_2015 Category Return 2015	fund_return_2014 Fund Return 2014	category_return_2014 Category Return 2014	fund_return_2013 Fund Return 2013	category_return_2013 Category Return 2013	fund_return_2012 Fund Return 2012	category_return_2012 Category Return 2012	fund_return_2011 Fund Return 2011	category_return_2011 Category Return 2011	fund_return_2010 Fund Return 2010
AAAU	ETF	US	DWS RREEF Real Assets Fund - Cl	DWS RREEF Real Assets Fund - Class A	USD	nan	DWS	PCX	NYSEArca	America/New_York	239238	255410	384448608	17.807	17.818	2.75	0.14146	19.44	-1.72	-0.08848	16.69	1.03	0.06171	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…		Tue Jul 24 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		nan	nan	0.0018																		"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…	1	Tue Aug 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-0.0465				-0.0467		-0.079		0.146						2		0.23963	0.18579
AADR	ETF	US	AllianzGI Health Sciences Fund	Virtus AllianzGI Health Sciences Fund Class P	USD	Foreign Large Growth	Virtus	NGM	NasdaqGM	America/New_York	2596	3170	88836160	64.555	65.297	11.82	0.17042	69.36	-7.8645	-0.11339	57.54	3.9555	0.06874	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 …	0.0031	Tue Jul 20 2010 00:00:00 GMT+0000 (Coordinated Universal Time)		Blend	Large	0.011	0.0066		0.2536	0.0736	0.1164		0.0455	0.1125	0.0799	0.1394		0.1791		1.71	7.46	13.34	1.2	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.388	Wed Jun 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	0.094	0.041	0.0049	0.0161	0.0688	0.0508	0.2587	0.1047	0.0803	0.0233	0.1188	0.0824	0.083	0.0243	7	3	0.12619	0.35885	-0.31185	0.46928	0.05575	0.0438	0.01427	-0.0083	-0.03065	0.20878	0.26387	0.12653	0.14598	-0.05806	-0.09042
AAXJ	ETF	US	nan	American Century One Choice Blend+ 2015 Portfolio Investor Class	USD	Pacific/Asia ex-Japan Stk	American Century Investments	NGM	NasdaqGM	America/New_York	1036417	1287600	5574671872	86.132	90.435	19.99	0.19514	102.44	-19.43	-0.18967	82.45	0.56001	0.00679	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…	0.011	Wed Aug 13 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	0.23	Blend	Large	0.007	0.0054		0.0523	0.1053	0.1683	0.0474	0.0266	0.1824	0.0524	0.0579	0.0391	0.2444	0.0239	2.03	11.7	18	1.42	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.3005	Sat Jul 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-0.0173	0.0984	-0.0709	-0.0199	-0.06	0.01	0.1859	0.0708	0.0804	0.0024	0.1067	0.0352	0.0535	0.0467	9	3	0.23865	0.17398	-0.14814	0.40517	0.04833	-0.0985	-0.08923	0.03925	0.02285	0.02478	0.02827	0.21386	0.20639	-0.20008	-0.20255	0.15532
ABEQ	ETF	US	Thrivent Large Cap Growth Fund	Thrivent Large Cap Growth Fund Class A	USD	Large Value	Thrivent Funds	PCX	NYSEArca	America/New_York	4280	8540	49694168	27.639	27.389	4.34	0.15069	28.8	-1.69	-0.05868	24.46	2.65	0.10834	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…	0.0049	Tue Jan 21 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	0.36	Value	Large	0.0088	0.0034		0.2174	0.028	0.042	0.1042	0.0606	0.2352	0.1335	0.0147	0.0625	0.0597	0.0422	1.79	12.48	16.71	1.91	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.4456	Wed Jun 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	0.07	0.109	-0.0383	-0.001	0.0378	0.0326	0.2252	0.1704		0.1053		0.1536		0.0655									-0.0189		0.1253		0.30048		0.14025		0.04626
ACES	ETF	US	nan	American Century One Choice Blend+ 2015 Portfolio I Class	USD	Miscellaneous Sector	American Century Investments	PCX	NYSEArca	America/New_York	106048	51400	1007483264	73.532	72.601	40.67	0.39982	101.72	-33.89	-0.33317	61.05	6.78	0.11106	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…	0.0053	Wed Jun 27 2018 00:00:00 GMT+0000 (Coordinated Universal Time)		Growth	Medium	0.0055	0.0067	0.9992	0.0096		0.1412		0.0301			0.1956	0.0353	0.3491	0.239	3.62	15.08	31.27	4.09	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.5039	Wed Jun 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	-0.0511		0.0988		-0.026		0.9507		0.462						2		1.40147	0.5151							-0.02795		0.39785		0.25423		-0.02663
ACIO	ETF	US	American Century Strategic Allo	American Century Strategic Allocation: Aggressive Fund I Class	USD	nan	American Century Investments	BTS	BATS	America/New_York	48422	47780	232107728	31.239	30.098	5.85	0.17884	32.71	-1.39	-0.04249	26.86	4.46	0.16605	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.0075	Tue Jul 09 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	0.46	Blend	Large	0.0079		1	0.0299	0.105	0.0895	0.0783	0.0334	0.1489	0.1366	0.1059	0.0259	0.221	0.0256	5.41	18.73	27.27	3.23	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.3143	Wed Jun 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	0.0876		0.013		0.0655		0.2055								1		0.09655
ACSI	ETF	US	nan	American Century One Choice Blend+ 2015 Portfolio A Class	USD	Large Blend	American Century Investments	BTS	BATS	America/New_York	627	450	80720528	51.63	49.636	11.548	0.21473	53.778	-3.25	-0.06043	42.23	8.298	0.1965	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…	0.007	Mon Oct 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	0.67	Blend	Large	0.0066	0.0036	0.9995		0.1555	0.2836	0.1045		0.1188	0.0801	0.0763		0.1401	0.041	3.95	16.7	23.53	1.88	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.4424	Sat Jul 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1666	0.075	0.0064	-0.0025	0.035	0.032	0.4211	0.1345	0.1706	0.1014		0.1576		0.0733	3	1	0.22844	0.24468	-0.04415	0.15521			-0.00632		0.11786		0.31437		0.14212		0.01683
ACTV	ETF	US	nan	American Century One Choice Blend+ 2015 Portfolio R Class	USD	Small Value	American Century Investments	PCX	NYSEArca	America/New_York	7411	5280	71334696	38.506	37.796	9.77	0.24486	39.9	-3.2061	-0.08035	30.13	6.5639	0.21785	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…		Mon Oct 26 2020 00:00:00 GMT+0000 (Coordinated Universal Time)		Value	Small	0.0075	0.0035	0.9908	0.0283		0.0857	0.0757	0.082	0.1641	0.2019	0.111	0.0271	0.2242		2.27	9.53	15.47	1.11	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.2976	Tue Aug 31 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	0.2287	0.1188	0.0082	-0.0328	-0.0064	-0.0132		0.085		0.0496		0.1252		0.0574									-0.07817		0.05709		0.3919		0.19569		-0.04368
ACWI	ETF	US	nan	American Century One Choice Blend+ 2015 Portfolio R6 Class	USD	nan	American Century Investments	NGM	NasdaqGM	America/New_York	3294372	4508530	16854806528	104.135	100.907	19.52	0.18165	107.46	-5.13	-0.04774	87.94	14.39	0.16363	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…	0.0139	Wed Mar 26 2008 00:00:00 GMT+0000 (Coordinated Universal Time)	0.16	Blend	Large	0.0032		0.9954	0.0473	0.0987	0.1201	0.0715	0.0348	0.1558	0.1174	0.0965	0.0275	0.2041	0.0261	2.9	14.2	22.87	2.16	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.1504	Wed Jun 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	0.1234		0.0126		0.0711		0.3932		0.1465		0.147		0.1001		9	3	0.16381	0.26697	-0.09149	0.24346	0.0822	-0.02386		0.04643		0.22908		0.15986		-0.07597		0.12314
ACWV	ETF	US	nan	American Century One Choice Blend+ 2020 Portfolio Investor Class	USD	nan	American Century Investments	BTS	BATS	America/New_York	151474	192740	5115469824	105.153	103.063	14.8	0.13686	108.14	-3.72	-0.0344	93.34	11.08	0.11871	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…	0.0169	Tue Oct 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	0.22	Blend	Large	0.002		0.9981	0.0473	0.137	0.0587	0.1355	0.0038	0.1121	0.1673	0.0886	0.0292	0.1476	0.073	3.12	12.95	22.88	2.09	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.1197	Wed Jun 30 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	0.0711		0.0034		0.0521		0.1951		0.0977		0.0854				8	1	0.02926	0.21321	-0.01345	0.18178	0.07709	0.03048		0.11128		0.17279		0.10313


CREATE TABLE etfs (
  "fund_symbol" VARCHAR,
  "quote_type" VARCHAR,
  "region" VARCHAR,
  "fund_short_name" VARCHAR,
  "fund_long_name" VARCHAR,
  "currency" VARCHAR,
  "fund_category" VARCHAR,
  "fund_family" VARCHAR,
  "exchange_code" VARCHAR,
  "exchange_name" VARCHAR,
  "exchange_timezone" VARCHAR,
  "avg_vol_3month" BIGINT,
  "avg_vol_10day" DOUBLE,
  "total_net_assets" 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,
  "inception_date" TIMESTAMP,
  "annual_holdings_turnover" DOUBLE,
  "investment_type" VARCHAR,
  "size_type" VARCHAR,
  "fund_annual_report_net_expense_ratio" DOUBLE,
  "category_annual_report_net_expense_ratio" DOUBLE,
  "asset_stocks" DOUBLE,
  "asset_bonds" 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,
  "fund_price_cashflow_ratio" DOUBLE,
  "fund_price_earning_ratio" DOUBLE,
  "fund_price_sales_ratio" DOUBLE,
  "fund_bond_maturity" DOUBLE,
  "fund_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,
  "returns_as_of_date" TIMESTAMP,
  "fund_return_ytd" DOUBLE,
  "category_return_ytd" DOUBLE,
  "fund_return_1month" DOUBLE,
  "category_return_1month" DOUBLE,
  "fund_return_3months" DOUBLE,
  "category_return_3months" DOUBLE,
  "fund_return_1year" DOUBLE,
  "category_return_1year" DOUBLE,
  "fund_return_3years" DOUBLE,
  "category_return_3years" DOUBLE,
  "fund_return_5years" DOUBLE,
  "category_return_5years" DOUBLE,
  "fund_return_10years" DOUBLE,
  "category_return_10years" DOUBLE,
  "years_up" DOUBLE,
  "years_down" DOUBLE,
  "fund_return_2020" DOUBLE,
  "category_return_2020" VARCHAR,
  "fund_return_2019" DOUBLE,
  "category_return_2019" VARCHAR,
  "fund_return_2018" DOUBLE,
  "category_return_2018" VARCHAR,
  "fund_return_2017" DOUBLE,
  "category_return_2017" VARCHAR,
  "fund_return_2016" DOUBLE,
  "category_return_2016" VARCHAR,
  "fund_return_2015" DOUBLE,
  "category_return_2015" DOUBLE,
  "fund_return_2014" DOUBLE,
  "category_return_2014" DOUBLE,
  "fund_return_2013" DOUBLE,
  "category_return_2013" DOUBLE,
  "fund_return_2012" DOUBLE,
  "category_return_2012" DOUBLE,
  "fund_return_2011" DOUBLE,
  "category_return_2011" DOUBLE,
  "fund_return_2010" DOUBLE
);