Holdings and weights
Review constituent tickers, names, weights, shares, market value and sponsor data in a repeatable file structure.
ETF Constituent Data
Daily ETF constituent data your systems can trust.
AmericanETP gives analysts, developers and data teams clean constituent files with holdings, weights, identifiers, fundamentals and archives for covered ETFs and indexes.
Real current files. No credit card required.
3,000+ETPs CoveredUS-traded ETFs and ETPs
122IndexesMajor US and global indexes
2009Archives SinceConstituent files from July 2009
DailyCSV UpdatesNightly and selected noon updates
Latest FilesView All Files
ConstituentData42.csv2:00 AM ET
| 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 |
Fundamentals.csv12:00 PM ET
| 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 |
Built for teams that need constituent files they can actually load.
AmericanETP keeps the evaluation practical: inspect the file, check the fields, then automate delivery when the structure fits your workflow.
Identifiers included
Map CUSIP, ISIN, FIGI, Bloomberg symbols and exchange details without stitching together scattered sponsor pages.
Daily update rhythm
Use overnight files, with selected noon updates, to keep holdings workflows close to the current market day.
Archives for context
Qualifying subscribers can work backward through historical constituent list archives beginning as early as July 2009.
Evaluation Path
Start with the fields your model already needs.
The fastest way to evaluate fit is to compare the constituent fields against your exposure, identifier, archive and reporting requirements.
Inspect current files
Open ConstituentData42.csv, ETFDATA42.csv and the current coverage list with real current data.
Map required fields
Confirm holdings, weights, identifiers, classifications, fixed income attributes and fundamentals before subscribing.
Automate updates
Subscriber HTTP and FTP access support repeatable daily imports after the overnight update cycle.
Useful when holdings accuracy and repeatability matter.
The files are made for teams that care about coverage, schema clarity, delivery timing and the ability to audit past holdings.
Portfolio exposure checks
Compare ETF holdings, sector classifications, weights and constituent identifiers across covered funds.
Data feeds and products
Feed current constituent data into internal dashboards, client-facing tools or distribution workflows with the right subscription.
Research and monitoring
Track new coverage, constituent changes, fundamentals and breadth reports without rebuilding the daily collection process.
| Field area | Examples available in the constituent file |
|---|---|
| Holdings | Constituent ticker, name, shares held, weighting, market value and notional value. |
| Identifiers | CUSIP, ISIN, Bloomberg Global ID, Bloomberg symbol, exchange and location. |
| Classification | Sponsor sector, sector, industry, security type and currency. |
| Fixed Income | Coupon, maturity and rating fields where applicable. |
| Fundamentals | Dividend amount, dividend yield, shares outstanding, market capitalization, earnings and P/E ratio. |
Core files for constituent data work.
Start with the files most teams review first, then use the full definitions page for detailed mapping.
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
Need the full schema?
The constituent definitions page lists 32 constituent-level fields and the fundamentals fields used for ETF-level data.
Frequently asked questions
What is included in the ETF constituent data?
The core constituent file includes holdings details such as ticker, name, composite, weight, identifiers, exchange, market value, sector, industry, fixed income fields and dividend fields where available.
How is the data delivered?
AmericanETP delivers current files through subscriber HTTP and FTP access. The files are designed for repeatable import into databases, spreadsheets and internal systems.
Can I see the fields before subscribing?
Yes. The public field definitions show the constituent and fundamentals fields before your team maps the files.
Does AmericanETP include historical constituent files?
Archive access is available for annual subscribers and qualifying monthly subscribers, with historical constituent lists beginning as early as July 2009.
Test current constituent files before you subscribe.
Open the current data, check the fields and confirm the delivery pattern against your workflow.
