Opendatabay APP

Financial Instrument Composition Data

Finance & Banking Analytics

Tags and Keywords

Finance

Investing

Business

Tabular

Etfs

Trusted By
Trusted by company1Trusted by company2Trusted by company3
Financial Instrument Composition Data Dataset on Opendatabay data marketplace

"No reviews yet"

Free

About

This resource contains detailed metrics and composition data for a substantial collection of Exchange Traded Funds (ETFs) and mutual funds. The information facilitates sophisticated research, analysis, and comparison of these investment vehicles across many factors. Key data points include fund size, total expense ratio, asset allocation, sector allocation, geographic distribution, dividend yield, auditing company, legal structure, distribution strategies, and measures of past performance.

Columns

The dataset contains up to 129 potential columns. A selection of key fields includes:
  • isin: The unique ISIN identifier for the fund product. This field has 2264 unique values.
  • wkn: The WKN identifier for the fund product, also featuring 2264 unique values.
  • name: The established name of the fund (e.g., SPDR Bloomberg Emerging Markets Local Bond UCITS ETF).
  • fundProvider: Identifies the company managing the fund, with examples including iShares (22%) and Xtrackers (13%).
  • legalStructure: Details the legal organisation of the fund, typically ETF (95%) or ETN (3%).
  • quote: The current price of the fund, ranging from 0.34 to 4.91k.
  • quote52Low: The lowest recorded price of the fund over the preceding 52 weeks, with values between 0 and 911.
  • quote52High: The highest recorded price of the fund over the preceding 52 weeks, ranging from 0.52 to 966.
  • ytdReturnCUR: The year-to-date return percentage for the fund, with observed values between -0.22 and 1.46.
  • ter: The Total Expense Ratio (fees) associated with the fund, ranging from 0 to 0.03.

Distribution

The raw data is typically structured as a tabular CSV file. The sample file, named justetf.csv, is 2.19 MB in size and contains 2264 records, detailing attributes across 129 potential columns. The data is expected to be updated monthly.

Usage

Ideal applications include detailed financial market research, developing quantitative investment strategies, performing due diligence on competing funds, and constructing optimised portfolios based on structural characteristics and yield metrics. This dataset is designed for in-depth analysis and comparison.

Coverage

The scope focuses on the structural composition and yield metrics for Exchange Traded Funds and mutual funds. The data includes specific details regarding asset, sector, and geographical allocations, alongside various measures of fund performance.

License

CC0: Public Domain.

Who Can Use It

Intended users include financial data scientists, portfolio managers, investment analysts seeking to model market behaviour, academic researchers studying capital markets, and individual investors who require detailed insight into fund characteristics for comparison and research.

Dataset Name Suggestions

  • Global Fund Structure and Metrics
  • Investment Vehicle Composition Data
  • ETF and Mutual Fund Yield Analysis
  • ETFs and Funds Composition & Yield Metrics

Attributes

Listing Stats

VIEWS

12

DOWNLOADS

1

LISTED

18/11/2025

REGION

GLOBAL

Universal Data Quality Score Logo UDQSQUALITY

5 / 5

VERSION

1.0

Loading...

Free

Download Dataset in CSV Format