Full holdings detail
Work with constituent tickers, names, weights, shares, market value and sponsor-provided classifications instead of a short top-holdings table.
ETF Holdings Database
ETF Holdings Database for Daily Fund Analysis
AmericanETP gives analysts, developers and data teams daily ETF holdings files with portfolio weights, identifiers, fundamentals and archive access in a clean CSV format.
Real current files.
3,775ETPs CoveredUS-traded ETFs and ETPs
123IndexesMajor 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 |
A database built for the full ETF portfolio, not just the headline holdings.
Inspect the complete files, confirm the fields and put a consistent daily source behind the analysis your team already performs.
Stable identifiers
Map CUSIP, ISIN, FIGI, Bloomberg symbols and exchange details into the systems your team already uses.
Current files every day
Use overnight files, with selected noon updates, to keep research, reporting and monitoring workflows current.
Historical context
Qualifying subscribers can compare archived constituent files going back as early as July 2009.
Evaluation Path
Start with the records your analysis needs.
The practical test is simple: open current holdings files, map the fields, then compare the delivery and archive access to your workflow.
Start Trial AccessNo credit card requiredView Reports
Inspect current holdings
Open ConstituentData42.csv, ETFDATA42.csv and the current coverage list with real current data.
Map the fields
Confirm the weights, identifiers, classifications, fixed-income attributes and fundamentals your process requires.
Compare across dates
Use historical constituent archives to investigate portfolio changes and support repeatable reporting.
Useful when ETF holdings need to stand up to real analysis.
AmericanETP helps teams move from scattered sponsor pages to files they can inspect, load, compare and retain.
Portfolio and exposure analysis
Compare ETF holdings, portfolio weights, sectors and constituent identifiers across the covered universe.
Research and reporting
Use current and historical holdings files to answer allocation, change and coverage questions with a repeatable source.
Data products and workflows
Load daily holdings into internal models, dashboards or client-facing products with the subscription rights that fit your use.
| Field area | Examples available in the holdings files |
|---|---|
| Portfolio detail | Constituent ticker, name, shares held, portfolio weight, 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. |
| ETF fundamentals | Net asset value, assets, expense ratio, average volume, leverage and total holdings. |
Core files for ETF holdings work.
Review the source files most teams need first, then use the full definitions page for detailed field 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 does the ETF holdings database include?
The constituent files include ETF and index holdings details such as tickers, names, portfolio weights, shares held, market value, identifiers, sector and industry fields, plus fixed-income and dividend fields where available.
How current is the holdings data?
AmericanETP publishes current files overnight and provides selected noon updates for certain ETF sponsors. Each file is designed for a repeatable daily workflow rather than a one-time lookup.
Can I review the fields before subscribing?
Yes. The public field definitions show the constituent and ETF-level fundamentals fields before your team maps or imports the data.
Is historical ETF holdings data available?
Archive access is available for annual subscribers and qualifying monthly subscribers, with historical constituent lists beginning as early as July 2009.
Test current ETF holdings files before you subscribe.
Open current data, check the records and confirm the delivery pattern against your workflow.
