Mutual Funds India - Detailed

Comprehensive web scraped data of mutual funds available in India

@kaggle.ravibarnawal_mutual_funds_india_detailed

Table List

1 table(54.43 KB)

Comprehensive Mutual Funds Data

@kaggle.ravibarnawal_mutual_funds_india_detailed.comprehensive_mutual_funds_data

54.43 KB
814 rows
20 columns

scheme_name Scheme Name	min_sip Min Sip	min_lumpsum Min Lumpsum	expense_ratio Expense Ratio	fund_size_cr Fund Size Cr	fund_age_yr Fund Age Yr	fund_manager Fund Manager	sortino Sortino	alpha Alpha	sd Sd	beta Beta	sharpe Sharpe	risk_level Risk Level	amc_name Amc Name	rating Rating	category Category	sub_category Sub Category	returns_1yr Returns 1yr	returns_3yr Returns 3yr	returns_5yr Returns 5yr
Aditya Birla SL Active Debt Multi-Mgr FoF-Dir Growth	100	100	0.27	10	10	Kaustubh Gupta	0.32	2.24	9.39	0.01	0.24	3	Aditya Birla Sun Life Mutual Fund	3	Other	FoFs Domestic	4	6.5	6.9
Aditya Birla SL Arbitrage Fund	1000	1000	0.36	4288	10	Lovelish Solanki	1.33	1.53	0.72	0.56	1.1	1	Aditya Birla Sun Life Mutual Fund	3	Hybrid	Arbitrage Mutual Funds	5.6	4.8	5.5
Aditya Birla SL Asset Allocator FoF-Dir Growth	1000	1000	0.53	157	10	Vinod Narayan Bhat	3.44	2.67	10.58	0.67	1.42	5	Aditya Birla Sun Life Mutual Fund	3	Other	FoFs Domestic	2	18.9	9.7
Aditya Birla SL Bal Bhavishya Yojna – Dir Growth	500	1000	0.76	637	4	Atul Penkar	2.18	-6.37	14.99	0.85	0.9	6	Aditya Birla Sun Life Mutual Fund	2	Solution Oriented	Childrens Funds	-0.7	17.1
Aditya Birla SL Balanced Advantage Fund	100	100	0.61	6386	10	Mohit Sharma	3.69	1.99	10.38	0.68	1.39	6	Aditya Birla Sun Life Mutual Fund	4	Hybrid	Dynamic Asset Allocation or Balanced Advantage	4.5	18.6	9.7
Aditya Birla SL Banking&Financial Services-DirGrowth	1000	1000	1.17	2384	9	Dhaval Gala	2.07	1.24	25.53	0.96	0.97	6	Aditya Birla Sun Life Mutual Fund	2	Equity	Sectoral / Thematic Mutual Funds	5.3	24.6	9.2
Aditya Birla SL Banking&PSU Debt Fund	1000	1000	0.37	7994	10	Kaustubh Gupta	1.92	4.46	1.91	1.78	1.09	3	Aditya Birla Sun Life Mutual Fund	4	Debt	Banking and PSU Mutual Funds	4.5	6.8	7.3
Aditya Birla SL CEF – Global Agri Plan-Direct Growth	1000	1000	1.29	15	10	Vinod Narayan Bhat	1.42	-	20.18	-	1.06	6	Aditya Birla Sun Life Mutual Fund		Equity	Sectoral / Thematic Mutual Funds	-10.3	29.4	9.3
Aditya Birla SL Corporate Bond Fund	100	100	0.31	12120	10	Kaustubh Gupta	2.28	2.38	1.93	0.78	1.35	2	Aditya Birla Sun Life Mutual Fund	4	Debt	Corporate Bond Mutual Funds	4.9	7.1	7.4
Aditya Birla SL Credit Risk Fund	100	100	0.69	1032	8	Sunaina da Cunha	1.82	3.01	2.9	-0.95	1.47	4	Aditya Birla Sun Life Mutual Fund	4	Debt	Credit Risk Funds	8.7	9	7.2


CREATE TABLE comprehensive_mutual_funds_data (
  "scheme_name" VARCHAR,
  "min_sip" BIGINT,
  "min_lumpsum" BIGINT,
  "expense_ratio" DOUBLE,
  "fund_size_cr" DOUBLE,
  "fund_age_yr" BIGINT,
  "fund_manager" VARCHAR,
  "sortino" VARCHAR,
  "alpha" VARCHAR,
  "sd" VARCHAR,
  "beta" VARCHAR,
  "sharpe" VARCHAR,
  "risk_level" BIGINT,
  "amc_name" VARCHAR,
  "rating" BIGINT,
  "category" VARCHAR,
  "sub_category" VARCHAR,
  "returns_1yr" DOUBLE,
  "returns_3yr" DOUBLE,
  "returns_5yr" DOUBLE
);