etf_screen
Every fund matching some filters, each with its net assets and the source and date that number came from. Filters: desk, issuer, max_fee_pct, min_assets_usd; and, from the ETFIQ screener, tracks (the index the funds track, such as "S&P 500"), min_yield_pct (12-month yield of at least that percent), pays (payout frequency: weekly, monthly, quarterly, semiannual or annual, published for income ETFs) and sort (assets, largest first; fee, lowest first; yield, highest first). count is the whole matching set: when fewer rows come back, truncated and note say so, so the rows are part of the set, not all of it. first names every fund tied at the top of the order. Use for "find me all X" and "cheapest X" questions rather than repeated searches. Fees are percentages, not basis points. Funds with no published data for a filter are set aside and counted, not treated as failing it.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| desk | No | ||
| pays | No | Payout frequency, published for income ETFs. | |
| sort | No | assets: largest first; fee: lowest first; yield: highest first. | |
| limit | No | ||
| issuer | No | ||
| tracks | No | The index the funds track, such as S&P 500. | |
| max_fee_pct | No | ||
| min_yield_pct | No | 12-month yield of at least this many percent (10 is 10%). | |
| min_assets_usd | No |