Dataset: ETFs And Mutual Funds Composition & Yield Metrics

About this Dataset

ETFs And Mutual Funds Composition & Yield Metrics

This dataset allows to research, analyze, and compare ETFs using a wide range of data and metrics. These include fund size, expense ratio, asset allocation, sector allocation, geographic distribution, dividend yield, auditing company, legal structure, distribution strategies, and past performance among many others.

Tables

Justetf

@kaggle.andrezaza_large_etfs_with_size_allocations_and_exposures.justetf

629.47 KB
2264 rows
129 columns


CREATE TABLE justetf (
  "isin" VARCHAR,
  "wkn" VARCHAR,
  "name" VARCHAR,
  "fundprovider" VARCHAR,
  "legalstructure" VARCHAR,
  "quote" DOUBLE,
  "quote52low" DOUBLE,
  "quote52high" DOUBLE,
  "ytdreturncur" DOUBLE,
  "ter" DOUBLE,
  "fiveyearvolatilitycur" DOUBLE,
  "fiveyearreturnperriskcur" DOUBLE,
  "yearvolatilitycur" DOUBLE,
  "distributionpolicy" VARCHAR,
  "fundcurrency" VARCHAR,
  "yeardividendyield" DOUBLE,
  "threemonthreturncur" DOUBLE,
  "monthreturncur" DOUBLE,
  "sixmonthreturncur" DOUBLE,
  "inceptiondate" TIMESTAMP,
  "threeyearvolatilitycur" DOUBLE,
  "yearreturnperriskcur" DOUBLE,
  "yearreturn2cur" DOUBLE,
  "yearreturn4cur" DOUBLE,
  "replicationmethod" VARCHAR,
  "hassecuritieslending" VARCHAR,
  "ticker" VARCHAR,
  "yearreturncur" DOUBLE,
  "threeyearreturnperriskcur" DOUBLE,
  "domicilecountry" VARCHAR,
  "threeyearreturncur" DOUBLE,
  "valornumber" DOUBLE,
  "currentdividendyield" DOUBLE,
  "yearreturn3cur" DOUBLE,
  "fiveyearreturncur" DOUBLE,
  "weekreturncur" DOUBLE,
  "yearreturn1cur" DOUBLE,
  "quotemarket" VARCHAR,
  "quotedate" TIMESTAMP,
  "labels" VARCHAR,
  "replicationstrategy" VARCHAR,
  "fundstructure" VARCHAR,
  "distributionfrequency" VARCHAR,
  "currencyrisk" VARCHAR,
  "fiscalyearend" VARCHAR,
  "ucitscompliance" VARCHAR,
  "revisioncompany" VARCHAR,
  "indextype" VARCHAR,
  "securitieslending" VARCHAR,
  "top10holdings" VARCHAR,
  "exposurecountry_netherlands" DOUBLE,
  "exposurecountry_united_kingdom" DOUBLE,
  "exposurecountry_luxembourg" DOUBLE,
  "exposurecountry_other" DOUBLE,
  "exposuresector_technology" DOUBLE,
  "exposuresector_consumer_staples" DOUBLE,
  "exposuresector_industrials" DOUBLE,
  "exposuresector_consumer_discretionary" DOUBLE,
  "exposuresector_other" DOUBLE,
  "fundsizemillions" DOUBLE,
  "exposurecountry_belgium" DOUBLE,
  "exposurecountry_france" DOUBLE,
  "exposuresector_financials" DOUBLE,
  "exposuresector_basic_materials" DOUBLE,
  "exposuresector_real_estate" DOUBLE,
  "exposurecountry_austria" DOUBLE,
  "exposuresector_utilities" DOUBLE,
  "exposuresector_energy" DOUBLE,
  "exposurecountry_serbia" DOUBLE,
  "exposurecountry_romania" DOUBLE,
  "exposuresector_health_care" DOUBLE,
  "exposurecountry_china" DOUBLE,
  "exposurecountry_mexico" DOUBLE,
  "exposurecountry_indonesia" DOUBLE,
  "exposurecountry_saudi_arabia" DOUBLE,
  "exposurecountry_united_arab_emirates" DOUBLE,
  "exposurecountry_malaysia" DOUBLE,
  "exposurecountry_south_korea" DOUBLE,
  "exposurecountry_brazil" DOUBLE,
  "exposurecountry_israel" DOUBLE,
  "exposurecountry_south_africa" DOUBLE,
  "exposurecountry_qatar" DOUBLE,
  "exposurecountry_uruguay" DOUBLE,
  "exposurecountry_dominican_republic" DOUBLE,
  "exposurecountry_italy" DOUBLE,
  "exposurecountry_germany" DOUBLE,
  "exposurecountry_spain" DOUBLE,
  "exposurecountry_united_states" DOUBLE,
  "exposuresector_telecommunication" DOUBLE,
  "exposurecountry_japan" DOUBLE,
  "exposurecountry_canada" DOUBLE,
  "exposurecountry_australia" DOUBLE,
  "exposurecountry_ireland" DOUBLE,
  "exposurecountry_cayman_islands" DOUBLE,
  "exposurecountry_hong_kong" DOUBLE,
  "exposurecountry_bermuda" DOUBLE,
  "exposurecountry_liberia" DOUBLE,
  "exposurecountry_hungary" DOUBLE,
  "exposurecountry_switzerland" DOUBLE,
  "exposurecountry_singapore" DOUBLE
);