More than a top-ten list
Use complete constituent records with weights, shares, market value and sponsor-supplied details instead of a short public holdings summary.
Daily ETF Holdings Download
Download daily ETF holdings data.
AmericanETP gives analysts, developers and data teams current ETF holdings files with portfolio weights, identifiers, fund details 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 |
Download the records behind the ETF, not just a headline snapshot.
A useful holdings download needs to do more than name the largest positions. It should give your team the fields, dates and delivery pattern needed to inspect a portfolio, map it into existing systems and retain the record used in an analysis.
Fields ready to inspect
Check identifiers, classifications, fixed-income attributes and ETF-level fundamentals before you build the download into a workflow.
A clear daily rhythm
Review current files after the overnight update cycle, with selected noon updates for certain ETF sponsors.
A dated record when needed
Qualifying subscribers can work with historical constituent-list archives beginning as early as July 2009.
Evaluation Path
See the download before it becomes part of your process.
Start with current files, compare the columns to the questions your team needs to answer, then confirm the coverage and subscription rights before making the data a regular dependency.
Start Trial AccessNo credit card requiredView Pricing
Download current files
Open the current constituent, ETF fundamentals and coverage files to see the actual CSV layout your team would receive.
Check the columns that matter
Confirm holdings, weights, dates, identifiers, classifications and fund-level details against the import or analysis you need to support.
Confirm the history you need
Review archive availability when your workflow needs a dated constituent list, not only the latest portfolio view.
Built for holdings work that needs to be repeatable.
AmericanETP is a stronger fit when the download needs to support a continuing research, reporting or data-product workflow rather than a one-time fund lookup.
Repeatable research
Keep a local record of the holdings, weights and fund details used in a screen, report or portfolio review rather than relying on a changing web page.
Data imports
Load a consistent CSV structure into a database, spreadsheet, model or internal tool with the fields your team has reviewed in advance.
Historical comparisons
Compare a current constituent list with a dated archive when a result, exposure or report needs to be explained in its original context.
| File area | What your team can review |
|---|---|
| Holdings detail | Constituent ticker, name, composite, shares held, portfolio weight, market value and sponsor-provided data where available. |
| Identifiers | CUSIP, ISIN, FIGI, Bloomberg symbols, exchange information and other fields that help match records across systems. |
| Classification | Sector, industry, security type, fixed-income and dividend fields where the underlying sponsor data provides them. |
| ETF-level context | Fundamentals such as net asset value, assets, expense ratio, leverage, average volume and total holdings. |
| Archive access | Dated constituent-list archives beginning as early as July 2009 for qualifying subscribers. |
Before You Automate
Make the first download answer the questions your process cannot leave open.
A file can look usable on the first open and still create rework later. Before your team schedules an import or builds a report around it, confirm the exact portfolio record, the timing of each file and the identifiers that let you reconcile a constituent across systems.
AmericanETP makes the current files, field definitions and coverage information available for review so your team can test those details against the work it already performs. That lets you make a decision based on the actual columns and delivery pattern, not a generic product description. It also gives the person approving the data a clearer basis for deciding whether a recurring download can support the records, reports and historical checks the business expects to keep.
Confirm what the file represents
Decide whether you need the fund's available holdings records, an index constituent list, ETF-level fundamentals or a combination of those views. Similar labels can describe different data objects, so the use case should lead the review.
Check the as-of date and delivery time
Keep the source date separate from the time a file becomes available for download. That distinction matters when your process compares portfolios across dates, reconciles an exception or runs before the next business day.
Map identity before relying on tickers
Review the identifiers, exchanges and classifications your workflow needs. Ticker symbols are useful, but identifiers such as CUSIP, ISIN, FIGI and Bloomberg symbols can make matching and historical review more dependable when they are available.
Choose the download that matches the job in front of you.
There is a practical difference between reading a fund's most visible positions and downloading the full records required for a dependable workflow. The right choice depends on what you need to retain, reconcile and explain later.
For a spreadsheet review
Use the current files to filter holdings, compare portfolio weights and test whether the fields are enough for the questions your analysts answer most often.
For a data pipeline
Review the schema first, including stable identifiers and dates, so your team can map the files into a database or internal process without guessing what each column means.
For a historical question
Use dated archive files when the answer depends on what a covered ETF or index contained at a particular time, rather than what it contains today.
Review the source records before you rely on them.
AmericanETP publishes current constituent and fundamentals files, field definitions and coverage information so your team can evaluate the practical fit before subscribing.
Frequently asked questions
What can I download during trial access?
Trial access lets you review current AmericanETP files, including constituent data, ETF-level fundamentals and the current coverage list, so you can assess the format and field set before subscribing.
Does the download include complete ETF holdings?
The constituent files include the available holdings records for covered ETFs and indexes, with fields such as ticker, name, portfolio weight, shares held, market value, identifiers and sponsor-provided classifications.
Can I download ETF holdings data as CSV?
Yes. AmericanETP is built around flat CSV files delivered through subscriber HTTP and FTP access, which makes the files practical for repeatable database, spreadsheet and internal-system imports.
Is historical ETF holdings data available to download?
Archive access is available for annual subscribers and qualifying monthly subscribers. Historical constituent-list files begin as early as July 2009, subject to the coverage and subscription terms that apply to the account.
Test the holdings download against your own workflow.
Open current files, inspect the fields and confirm the coverage, timing and archive access before you subscribe.
