# etf_holders

ETFs that hold this ticker, ordered by the ticker's weight within each (the reverse of ETF holdings). Filter with array operators in /v2/scan, e.g. `'SPY' = ANY(etf_holders)` to find SPY constituents. Refreshed nightly post-close.

A text[] signal column on the Tickerbot computed state table (20,798+ ticker rows) — computed by the platform, queryable by bare name across the API. Values are NULL on rows the signal doesn't apply to.

- Group: Fundamentals
- Category: Share structure & ownership
- Type: text[]
- Update cadence: post-close daily
- Universe: all tickers
- History: none — live row only, not historized (no as-of reads for this column)
- Nullable: yes

## Query it

Every applicable form factor, grouped by endpoint family. Response payloads are real captures, sampled 2026-08-18 and trimmed; your run's values and dates will differ.

### Use scan — `/v2/scan`

The whole market through a WHERE clause — this signal composed freely with any other column. (https://tickerbot.io/docs/endpoints/scan.md)

#### Live — the whole market, ranked by this column

```bash
curl -G "https://api.tickerbot.io/v2/scan" \
  --data-urlencode "q=etf_holders IS NOT NULL" \
  -d "order=etf_holders" -d "columns=etf_holders" \
  -H "Authorization: Bearer YOUR_KEY"
```

Response (sampled 2026-08-18, trimmed):

```json
{
 "as_of": "2026-08-18T00:23:48.276Z",
 "query": {
  "q": "etf_holders IS NOT NULL",
  "limit": 2,
  "order": "etf_holders",
  "dir": "desc",
  "fields": [
   "etf_holders"
  ],
  "full": false,
  "universe": null,
  "asset_class": null
 },
 "count": 2,
 "results": [
  {
   "ticker": "EAF",
   "name": "GrafTech International Ltd.",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 7.35,
   "day_change_pct": -0.0342,
   "gap_pct": 0.0013,
   "relative_volume": null,
   "market_cap": 198561368,
   "etf_holders": [
    "ZSB",
    "EART",
    "PRFZ"
   ]
  },
  {
   "ticker": "BBWI",
   "name": "Bath & Body Works, Inc.",
   "asset_class": "stocks",
   "asset_type": "CS",
   "price": 18.975,
   "day_change_pct": -0.0224,
   "gap_pct": -0.0216,
   "relative_volume": null,
   "market_cap": 3912314770,
   "etf_holders": [
    "ZIG",
    "XRT",
    "WBIY"
   ]
  }
 ]
}
```

## Related signals (Share structure & ownership)

- [basic_average_shares](https://tickerbot.io/docs/signals/basic_average_shares.md)
- [diluted_average_shares](https://tickerbot.io/docs/signals/diluted_average_shares.md)
- [float_shares](https://tickerbot.io/docs/signals/float_shares.md)
- [free_float_percent](https://tickerbot.io/docs/signals/free_float_percent.md)
- [low_float](https://tickerbot.io/docs/signals/low_float.md)
- [percent_insiders](https://tickerbot.io/docs/signals/percent_insiders.md)
- [percent_institutions](https://tickerbot.io/docs/signals/percent_institutions.md)
- [shares_outstanding](https://tickerbot.io/docs/signals/shares_outstanding.md)
- [ultra_low_float](https://tickerbot.io/docs/signals/ultra_low_float.md)
- [weighted_shares_outstanding](https://tickerbot.io/docs/signals/weighted_shares_outstanding.md)

---

Full catalog: https://tickerbot.io/docs/signals.md · Schema: https://tickerbot.io/docs/schema.md · Interactive: https://tickerbot.io/explore?signal=etf_holders · HTML: https://tickerbot.io/docs/signals/etf_holders/