Daily holdings files
Current ETF and index constituent files are published overnight, with selected sponsor updates around noon Eastern.
ETF Data API Alternative
AmericanETP gives data teams daily ETF holdings, index constituents, fundamentals and archives as clean CSV files, delivered through subscriber access.
Real current files. No credit card required.
| Ticker | Security Name | Exchange | ETF / Index | Weight (%) | Bloomberg FIGI |
|---|---|---|---|---|---|
| AAPL | Apple Inc. | NASDAQ | SPY | 7.21 | BBG000B9XRY4 |
| MSFT | Microsoft Corp. | NASDAQ | SPY | 6.34 | BBG000BPH459 |
| NVDA | NVIDIA Corp. | NASDAQ | SPY | 6.15 | BBG000BBJQV0 |
| AMZN | Amazon.com Inc. | NASDAQ | SPY | 3.67 | BBG000BVPV84 |
| GOOGL | Alphabet Inc. Class A | NASDAQ | SPY | 2.45 | BBG009S39JX6 |
| Ticker | Fund Name | Exchange | Currency | Type | Expense Ratio |
|---|---|---|---|---|---|
| SPY | SPDR S&P 500 ETF | NYSE Arca | USD | ETF | 0.0945 |
| QQQ | Invesco QQQ Trust | NASDAQ | USD | ETF | 0.20 |
| IWM | iShares Russell 2000 ETF | NYSE Arca | USD | ETF | 0.19 |
| DIA | SPDR Dow Jones Industrial Average | NYSE Arca | USD | ETF | 0.16 |
| TLT | iShares 20+ Year Treasury Bond ETF | NASDAQ | USD | Fixed Income | 0.15 |
Broad APIs can be useful. AmericanETP is more focused: repeatable ETF and index files with the fields, timing and archives a data desk needs.
Current ETF and index constituent files are published overnight, with selected sponsor updates around noon Eastern.
Flat files are easier to inspect, version and automate when your workflow already expects repeatable file imports.
Constituent and fundamentals definitions are public before you subscribe, so your team can map the schema early.
Annual subscribers can work with historical constituent list archives beginning as early as July 2009.
Evaluation Path
Start with current files, review field definitions, then choose internal use or distribution rights once the data fits your workflow.
Review ConstituentData42.csv, ETFDATA42.csv, Fundamentals.csv and coverage lists using real current data.
Use the public definitions to align holdings, weights, identifiers, classifications and fundamentals with your system.
Subscriber HTTP and FTP access support repeatable daily imports after the overnight update cycle.
AmericanETP is made for workflows that care about coverage, fields, timing and rights, not just a quick quote lookup.
Pull holdings, weights, identifiers, sectors and fundamentals into internal analytics without rebuilding sponsor collection.
Use distribution or website rights when ETF and index data needs to support a client-facing workflow.
Track coverage, new ETF additions, constituent changes and breadth reports across the covered universe.
| File | What it helps evaluate | Delivery |
|---|---|---|
| ConstituentData42.csv | Primary daily constituent file with weights, sponsor values, identifiers, prices, sectors and fundamentals. | Subscriber HTTP and FTP |
| ETFDATA42.csv | Current ETF constituent holdings and related data in a clean CSV structure. | Subscriber HTTP and FTP |
| Fundamentals.csv | ETF-level data such as description, NAV, AUM, leverage, inception date and expense ratio. | Subscriber HTTP and FTP |
| AllComposites.csv | Current coverage list of indexes and ETFs in the constituent list file. | Subscriber HTTP |
| Individual constituent lists | Separate files for specific indexes and ETFs when a focused list is easier to automate. | Available by account access |
AmericanETP primarily delivers ETF and index data as daily CSV files through subscriber HTTP and FTP access. For many data teams, that works better than a broad API because the files are simple to inspect, archive and load into existing systems.
The file set includes current constituent data, ETF-level fundamentals, coverage lists, individual constituent lists and historical archives for qualifying subscribers.
Yes. Trial access opens real current files, not a frozen sample, so your team can check coverage, fields and delivery fit before choosing a subscription.
AmericanETP fits analysts, data vendors, developers and internal teams that need repeatable ETF and index constituent data in a clean file format.
Open current ETF and index files, check the fields, then decide whether an internal or distribution subscription fits.