US and UCITS ETFs with their full portfolio — and every stock with its ETFs

{ "security": { "isin": "US0378331005", "ticker": "AAPL", "name": "Apple Inc." }, "count": 675, "total_market_value_usd": 598129067750.42, "funds": [ { "fund_ticker": "XVAP", "fund_name": "FT Vest AAPL & Target Income ETF", "issuer": "First Trust", "weight_pct": 49.3, "market_value_usd": 801635.64, "shares": 2334.0, "as_of": "2026-10-16", "source": "issuer.firsttrust" } ] }

What you can do with it

Fetch an ETF's complete portfolioEvery position with weight, shares, value and identifiers (ISIN, CUSIP, LEI). Not just the top 10 from the product page.

See which ETFs hold a stockA ticker or ISIN is enough. Apple sits in more than 650 US ETFs — sorted by weight, with the value held per fund.

List all ETFs of an issuerMore than 600 issuers from Vanguard to single-fund boutiques, determined via the adviser in the SEC filing N-CEN — with brands, advisers and the largest positions across all ETFs. Platform trusts such as Tidal are mapped to their brands, not the other way round.

Find European ETFs by ISIN, WKN or Xetra symbolEvery UCITS ETF tradable on Xetra, with distribution policy (distributing or accumulating), currency, domicile and replication. Portfolios from iShares, Xtrackers and Amundi; swap ETFs flagged as substitute basket. US ETFs are flagged: without a PRIIPs key information document they cannot be bought by retail investors in the EU.

Know how fresh a portfolio isEvery response names source and as-of date: the issuer's daily file (previous day) or the SEC N-PORT filing (quarter-end).

Why we built it this way

Every US ETF must publish its full portfolio daily on its own website (SEC Rule 6c-11) — but each issuer in a different format, at a different address, some behind bot protection. We checked 30 issuers one by one and connect those reachable without detours.

The foundation for all of them is the N-PORT filing with the SEC: complete for every fund, but only at quarter-end and about 60 days later. The more recent snapshot wins — and a daily file that can map fewer positions to an ISIN than N-PORT does not replace it. Fresher but worse would be no gain.

Weights stay as the issuer reports them: share of net assets. For leveraged funds they therefore add up to 200 or 300 %.

UCITS ETFs come from Deutsche Börse's list of all instruments tradable on Xetra, names and CFI code from the ESMA register FIRDS. We take the distribution policy from the issuer, otherwise from the share class in the name (“Acc”, “Dist”, “1C”) and only last from the CFI code — which was wrong in 17 of 909 cases checked against iShares and Amundi, the name in none of 871.

A swap ETF holds a substitute basket and receives the index return via the swap. We show the basket as its portfolio but do not count it in “which ETFs hold this stock”.

Improvements

New: ETF holdings for 5,787 US ETFs, issuer list, reverse lookup per stock

Daily portfolios from seven issuers, latest N-PORT snapshot for all others

SPY, DIA and MDY (unit investment trusts without N-PORT) from State Street's daily file

Issuers determined from the SEC filing N-CEN: adviser or sub-adviser instead of the first word of the fund name; drill-down per issuer with brands, advisers and largest positions across all its ETFs

Asset classes: equities, bonds, precious metals, commodities, crypto, real estate, money market — from N-PORT portfolio and fund name, leveraged funds flagged

Distribution frequency for 1,333 US ETFs straight from the issuers (weekly to annual, no distributions)

Themes per ETF: from its positions and their investment themes, by weight and count (S&P 500: semiconductors 16.8 %, AI 14.4 %, cloud 10.2 %)

Daily portfolios now for 1,770 ETFs from 16 issuers (was 1,182); iShares equity funds such as EFA, EEM, IEMG with ISIN

Cash ratio per ETF (cash, money market, T-bills separately); ETFs by ISIN; issuers by brand too (“xtrackers”)

Readable derivatives: options, futures, FX forwards and swaps with underlying, strike, expiry, long/short instead of “N/A”

UCITS ETFs: all 3,039 tradable on Xetra, by ISIN, WKN and Xetra symbol; distribution policy; portfolios from iShares, Xtrackers and Amundi

Distribution frequency for 680 distributing UCITS ETFs straight from iShares, Amundi, Xtrackers, Invesco, SPDR, Vanguard and Global X

Fund ownership over time per stock: per quarter since 2019 the number of US funds, shares held, share of shares outstanding and the largest funds — all mutual funds and ETFs from N-PORT, split-adjusted

Fund ownership now shows ETFs: count, shares, value and largest ETFs per quarter (ETF or not per quarter from the SEC's Form N-CEN), all US funds via a toggle

Endpoints

GET	`/v1/funds`	Search and filter ETFs
GET	`/v1/funds/issuers`	All issuers with their number of ETFs
GET	`/v1/funds/asset-classes`	ETFs per asset class
GET	`/v1/funds/issuers/{issuer}`	One issuer: brands, advisers, largest positions
GET	`/v1/funds/{ticker}`	One ETF (ticker, ISIN, WKN, Xetra symbol) with distribution policy and cash ratio
GET	`/v1/funds/{ticker}/holdings`	Full portfolio of an ETF
GET	`/v1/funds/{ticker}/themes`	Investment themes of an ETF from its positions
GET	`/v1/securities/{identifier}/funds`	All ETFs holding a security
GET	`/v1/securities/{identifier}/fund-ownership`	Fund ownership per quarter since 2019: number of funds, shares, share of outstanding
GET	`/v1/underlyings/{code}/funds`	ETPs holding physical gold, silver, bitcoin …

Give feedback or ask a question

Something missing, something off, or an answer you don't understand? Write it here — it reaches us directly.