Name: ETFs And Mutual Funds Composition & Yield Metrics
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

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

644.58 kB
2,264 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
);