All Posts
ComparisonETF Holdings APIDaily HoldingsAPI Comparison

Which API Gives Daily ETF Holdings? 9 Compared

Which API gives daily ETF holdings? 9 providers compared on source, as-of dates, history and price, plus a freshness test of 300 funds.

Published November 18, 202611 min readAndy Reimann
Which API Gives Daily ETF Holdings? 9 Compared

If you ask an AI assistant which API gives daily ETF holdings, you get a list of big names and the word "daily" next to each of them. I wanted to know what that word actually means, so I read the docs and pricing pages of 16 ETF holdings providers and then measured the freshness of our own daily data across 300 random funds. The short version: only a handful of vendors document daily holdings in plain words, and even a real daily feed hands you an older snapshot for some funds. The date to trust is the as-of date in the response, not the word on the pricing page.

Which API gives daily ETF holdings?

Four providers say in their own docs that their ETF holdings are daily: Massive, Intrinio and Nasdaq Data Link (all three resell ETF Global data in some form) and LSEG Lipper. StockFit is the fifth, built on the files each issuer publishes on its own website, for 5,791 funds. Financial Datasets lists a daily update too, but its holdings come from SEC fund filings, so the data refreshes daily while the holdings themselves are dated by filing. FMP, EODHD and Finnhub sell ETF holdings inside a broader plan and don't say how often the holdings change or where they come from.

Pricing splits the same way. Massive is the only one of the four with a self-serve price ($99 a month on an individual plan, with separate business plans). Intrinio sells holdings on its Enterprise plan, and Nasdaq Data Link and LSEG don't publish a price. On StockFit, daily holdings are on the Pro plan, and every free account includes 50 premium calls, so you can before you pay anything.

What "daily" means in an ETF holdings API

There are two things a vendor can mean by daily, and they are easy to mix up. One is how often the vendor refreshes its database. The other is how current the holdings data is, meaning the date the portfolio actually represents. A database that refreshes every night can still hold a portfolio from June.

Where the holdings come from decides which one you get. Under Rule 6c-11, most ETFs post their full portfolio on their own website every business day, before the market opens, as of the prior close. An API built on those issuer files can give you holdings that are one or two days old. The other source is Form N-PORT, which funds file with the SEC. Its holdings become public about 60 days after the end of each quarter, so an API built only on N-PORT data is months behind no matter how often it refreshes. I went deeper into the two sources in our ETF holdings API comparison by data source, and into how much a fund's portfolio actually moves between them in how often ETF holdings change.

That's why the most useful field in any ETF holdings data response is the as-of date. Most vendors in the table below document one: effective_date at Massive, as_of_date at Intrinio and Nasdaq Data Link, atDate at Finnhub, reportDate at StockFit. Massive's docs even warn that some issuers, Vanguard among them, release their data on a delay. Keep that in mind for the test further down.

9 ETF holdings APIs compared on what they document

Here are the nine providers with enough documentation to compare. I only list what each vendor's own pages say. Where a column reads "not stated", the vendor might still offer it, I just couldn't find it written down.

StockFit
Source: Issuer website files, 5,791 funds
Daily: Yes, newest issuer file per fund
As-of field: reportDate
History: About 45 days (since August 2026)
Access: Pro plan; 50 premium calls on every free account
Massive
Source: ETF Global
Daily: Says "Updated daily"
As-of field: effective_date, processed_date
History: Since April 3, 2017
Access: $99/month individual plan; business plans separate
Intrinio
Source: Not stated (separate ETF Global endpoint)
Daily: Says "Daily"
As-of field: as_of_date
History: 10+ years (historical entitlement)
Access: Enterprise plan, contact sales
Nasdaq Data Link
Source: ETF Global (ETFG/CONST table)
Daily: Refresh listed as continuous
As-of field: as_of_date, etfg_date
History: Not stated
Access: Premium table, price not public
LSEG Lipper
Source: Lipper
Daily: Says "Daily"
As-of field: Not stated
History: From 2025
Access: Contact sales
Financial Datasets
Source: SEC fund holdings filings
Daily: No, holdings come from SEC filings ("daily" is the refresh)
As-of field: as_of, filing_date
History: 5+ years
Access: Paid only; business use on the $1,000/month plan
FMP
Source: Not stated
Daily: Says "real-time updates"
As-of field: Not stated (separate holding-dates endpoint)
History: Not stated
Access: Ultimate plan, personal use
EODHD
Source: Not stated
Daily: Not stated
As-of field: Only a general UpdatedAt
History: None (current snapshot)
Access: Fundamentals feed, $59.99/month, personal use
Finnhub
Source: Not stated
Daily: Not stated
As-of field: atDate
History: Historical dates queryable, depth not stated
Access: Premium plan

Vendor columns as stated on each vendor's own docs, product and pricing pages on 2026-11-18. "Not stated" means I couldn't find it there. StockFit figures are from our production API the same day.

What stands out

  • History is where the enterprise feeds shine. Massive has daily ETF Global constituents back to April 3, 2017, and Intrinio lists 10+ years. StockFit keeps about 45 days of daily snapshots per fund, accumulating since August 2026, plus quarterly N-PORT holdings that go back years. If you need years of daily constituents for a backtest, StockFit isn't the right source today.
  • Read the license next to the price. Massive's $99 price is for an individual plan and business plans are listed separately, FMP and EODHD price their plans for personal use, and Financial Datasets asks for its $1,000 a month plan for business use. If you are building a product, check the commercial terms before you compare numbers.
  • Three providers resell the same data. Massive, Intrinio (on one of its two endpoints) and Nasdaq Data Link all carry ETF Global data, so a difference between them is more likely in coverage, history and price than in the holdings themselves.

Also checked, and why they're not in the table

AxionQuant has a full-holdings endpoint but documents no source, no refresh schedule and no history. Tradefeeds names partners and issuers as its source but documents no fields. Xignite's ETF pages now redirect to QUODD, so there are no public docs left to read. Unusual Whales returns holdings without a holdings date and its plans are for personal use only. Eulerpool's docs say top holdings while its blog says complete holdings. Finnworlds builds on fund report periods, not daily files. API Ninjas returns full holdings without saying where they come from. And the most visible result in search, an Apify actor, scrapes a third-party website and mixes a daily top 25 with an older N-PORT tail.

I tested how fresh "daily" is across 300 funds

Docs only tell you what a vendor promises. So I did what I'd tell anyone to do before signing up: I pulled the as-of date. On 2026-11-18 I picked 300 funds at random from the 5,791 funds on our /api/fund/holdings/daily/supported-funds list, requested each one from /api/fund/holdings/daily and from the N-PORT endpoint /api/fund/holdings, and measured how old each newest snapshot was.

How old is the newest holdings snapshot? 300 random funds
StockFit daily and N-PORT holdings endpoints, ages measured on 2026-11-18.

283 of the 300 funds (94.3%) came back with a daily snapshot that was 0 to 3 days old, and the median age was 2 days. The latest public N-PORT holdings for the same funds had a median age of 110 days, and 22 funds had no N-PORT holdings at all. That gap is the whole reason daily holdings exist.

The interesting part is the other 16. Their newest snapshot from the daily endpoint was a month-end or quarter-end file, 18 to 49 days old: JCE, JLS, NEA, NMAI, PDCC, VGMS, VPL, VSDB, FDMO, FLRG, FNCL, FQAL, FSOL, EEA, ETX, VBIL. Seven of them are closed-end funds (Nuveen, Eaton Vance, Pearl Diver and others), which have no daily disclosure rule at all. The rest are Vanguard and Fidelity funds, and those surprised me more.

Why Vanguard's ETFs don't come back daily

Vanguard's big index ETFs, such as VOO, VTI and BND, are a share class of its index mutual funds, and that structure sits outside the daily posting rule. The SEC's compliance guide for Rule 6c-11 says the rule "does not include the following types of ETFs and these ETFs will continue to operate pursuant to their exemptive orders", and the list includes "an ETF that is structured as a share class of a fund that issues multiple classes of shares". In my watchlist test below, VOO, VTI and BND all return the October 31 month-end file, and so did the Vanguard funds in my random sample (VBIL, VGMS, VSDB and VPL). If you need the current portfolio of a Vanguard fund, don't assume any daily feed has it. Check the as-of date.

Being outside the rule doesn't mean there's no daily file, though. SPY is a unit investment trust, which the same guide also lists as excluded, and its daily snapshot was 2 days old. The four Fidelity ETFs and the Fidelity Solana Fund in my sample are regular ETFs, and the newest file I have for them is the October 30 month-end one. So check each fund you care about instead of trusting a label, ours included.

One small thing to watch for: 8 of the 300 snapshots were dated on a Saturday or Sunday. That is the date the issuer printed on its file, and I keep it as published rather than moving it to a trading day.

Check the as-of date yourself in Python

This is the script I used for the watchlist. It asks the daily endpoint and the N-PORT endpoint for one row per fund (pageSize=1, so it costs two small requests per fund), reads the reportDate each one returns, and flags any daily snapshot older than five days. Run the same idea against any provider you're evaluating, with their as-of field instead of ours.

python
import os
from datetime import date

import requests

BASE_URL = "https://api.stockfit.io/v1"
WATCHLIST = ["SPY", "QQQ", "IVV", "VOO", "VTI", "ARKK", "SCHD", "JEPI", "AGG", "BND", "FNCL", "VSDB", "NEA"]

session = requests.Session()
session.headers["Authorization"] = f"Bearer {os.environ['STOCKFIT_API_KEY']}"


def as_of(path, symbol):
    r = session.get(BASE_URL + path, params={"symbol": symbol, "pageSize": 1}, timeout=30)
    if r.status_code == 400:
        return None, 0
    r.raise_for_status()
    body = r.json()
    if not body.get("data"):
        return None, 0
    return date.fromisoformat(body["reportDate"]), body["totalResults"]


def age(d, today):
    return "-" if d is None else f"{(today - d).days}d"


today = date.today()
print(f"{'fund':6} {'daily as-of':12} {'age':>5} {'lines':>6}   {'N-PORT as-of':12} {'age':>5}")
for symbol in WATCHLIST:
    daily, lines = as_of("/api/fund/holdings/daily", symbol)
    nport, _ = as_of("/api/fund/holdings", symbol)
    flag = "  <- not a daily file" if daily and (today - daily).days > 5 else ""
    print(f"{symbol:6} {str(daily or '-'):12} {age(daily, today):>5} {lines:>6}   {str(nport or '-'):12} {age(nport, today):>5}{flag}")

Here's what it printed on 2026-11-18:

text
fund   daily as-of    age  lines   N-PORT as-of   age
SPY    2026-11-16      2d    505   2026-06-30    141d
QQQ    2026-11-16      2d    106   2026-06-30    141d
IVV    2026-11-16      2d    509   2026-06-30    141d
VOO    2026-10-31     18d    503   2026-06-30    141d  <- not a daily file
VTI    2026-10-31     18d   3475   2026-06-30    141d  <- not a daily file
ARKK   2026-11-18      0d     43   2026-07-31    110d
SCHD   2026-11-16      2d    102   2026-08-31     79d
JEPI   2026-11-17      1d    135   2026-06-30    141d
AGG    2026-11-16      2d  13544   2026-08-31     79d
BND    2026-10-31     18d  10083   2026-06-30    141d  <- not a daily file
FNCL   2026-10-30     19d    389   2026-07-31    110d  <- not a daily file
VSDB   2026-10-31     18d   1579   2026-06-30    141d  <- not a daily file
NEA    2026-10-31     18d   1061   2026-07-31    110d  <- not a daily file

SPY, QQQ, IVV, ARKK, SCHD, JEPI and AGG are 0 to 2 days old, while their latest public N-PORT holdings are 79 to 141 days old. The lines column is worth a look too: AGG returns 13,544 positions and VTI 3,475, so this is the full portfolio, not a top 10. If you want to follow a fund over time, /api/fund/holdings/daily/history returns the stored snapshots for up to 45 days in one call, and my post on how to detect when an ETF adds a stock compares dated daily snapshots to catch the exact day. For the details of how we read six different issuer file formats into one JSON shape, see daily ETF holdings: six file formats, one API.

Questions to ask before you build on a holdings feed

The as-of date tells you whether the data is current. These questions tell you whether you can actually use it:

  • Can I show it in my product? Several plans in the table are personal use only. On StockFit, the commercial license covers showing the data in your own app.
  • Can I store and cache it? Daily holdings are only useful if you keep yesterday's snapshot to compare against.
  • Can I pass the raw holdings on? Redistributing raw data usually needs its own license. With us that's a custom license, and I'm happy to talk about it.
  • Which identifiers come back? CUSIP, ISIN or SEDOL decide how much join code you write. Rule 6c-11 only asks for "CUSIP or other identifier", so issuer files differ.
  • How many days of history do I get? This is where the providers differ most, from 45 days to more than ten years.

None of this is investment advice. It's about data you can check.

FAQ

Q.Which API gives daily ETF holdings?
Massive, Intrinio, Nasdaq Data Link and LSEG Lipper say in their docs that their ETF holdings are daily, and StockFit serves the daily files each issuer publishes on its own website for 5,791 funds. Financial Datasets refreshes daily but its holdings come from SEC filings. FMP, EODHD and Finnhub sell ETF holdings without saying how often they change. Check the as-of date in each response before you trust the label.
Q.Is there a free daily ETF holdings API?
Not a fully free one among the providers I checked. On StockFit, daily holdings are on the Pro plan, but every free account includes 50 premium calls, enough to test the funds you care about, and the list of covered funds is free. Issuer websites also publish their daily files for free, one fund and one file format at a time.
Q.How current are daily ETF holdings?
Usually one or two days old. Issuers post holdings as of the prior close before the next market open. In my test of 300 random funds, 94.3% returned a snapshot 0 to 3 days old, with a median age of 2 days. The latest public N-PORT holdings for the same funds had a median age of 110 days.
Q.Why are Vanguard ETF holdings not updated daily?
Vanguard's index ETFs are a share class of its index mutual funds, a structure that Rule 6c-11, the rule behind daily holdings disclosure, does not include. In my test, VOO, VTI and BND returned the month-end file. Check the as-of date for Vanguard funds in any API.
Q.What is the difference between daily ETF holdings and N-PORT holdings?
Daily holdings come from the issuer's website and show the portfolio as of the prior close. N-PORT holdings come from the fund's SEC filing and become public about 60 days after quarter end, but they carry standardized fields such as asset category and fair-value level. StockFit serves both on one key, through /api/fund/holdings/daily and /api/fund/holdings.
Q.Do all ETFs publish their holdings every day?
No. Rule 6c-11 does not cover share class ETFs such as Vanguard's, unit investment trusts or actively managed ETFs without daily portfolio transparency, and closed-end funds have no daily rule at all. Some of these still post daily files, like SPY, and some only post month-end holdings.

Ready to build?

Free API key, no credit card.