---
title: "Weekly ETF + mutual fund flow aggregates (ICI public press release)"
method: GET
path: "/api/v1/etf/flows/aggregate"
tags: ["Funds & ETFs"]
---

# Weekly ETF + mutual fund flow aggregates (ICI public press release)

`GET /api/v1/etf/flows/aggregate`

Returns the most-recent ICI Weekly Estimated Long-Term Flows + ETF Net Issuance release, including a 5-week history strip. Source: ICI public press release (Investment Company Institute, Tier I non-profit trade association). 6 buckets (Equity Domestic/World, Hybrid, Bond Taxable/Municipal, Commodity) + Total + a separate ETF net issuance figure. Cadence: weekly, ICI publishes Wednesday afternoon ET; ingest captures Thursday morning UTC. Use case: ``UC-3 Sector Rotation Detector`` aggregate macro context to complement per-ETF flow estimates.

## Response `200`

ICI weekly flows aggregate payload.

- EnvelopeEtfFlowsAggregatePayload
  - `data` EtfFlowsAggregatePayload, required — UC-3 weekly aggregate flows + ETF net issuance read from the ICI public release. Reflects the most-recent press release captured by the daily 03:00 UTC ingest cycle. Press release publishes Wednesday ~16:00 ET; the Thursday morning ingest catches it ~6h later. Data integrity is surfaced via `parse_status`: clients should treat `partial_parse` data as best-effort with the `parse_warnings` array listing what was lost.
    - `source` string — Source slug echoed from blob.
    - `source_url` string, required — Press release URL.
    - `license_attribution` string, required — Provenance string echoed from blob.
    - `release_date` string, required — ISO date of the press release (publish day, typically Wednesday).
    - `week_ending` string, required — ISO date of the latest reported week-ending Wednesday.
    - `fetched_at` string, required — ISO timestamp of the ingest fetch.
    - `parse_status` string, required — Enum: ok | partial_parse | unchanged | upstream_unreachable.
    - `parse_warnings` string[], nullable — Present when parse_status != ok; lists which data points were lost.
    - `latest_week` IciFlowWeek, required — One week's worth of flow data.
      - `week_ending` string, required — ISO date of the week-ending Wednesday.
      - `total_long_term_flows_million_usd` integer, nullable — Headline total long-term flows in millions of USD. Sourced from prose; may be null when prose regex fails.
      - `mutual_fund_outflows_million_usd` integer, nullable — Mutual fund net new cash flow in millions of USD. Stored negative when the press release labels them as 'outflows', positive when 'inflows'. Per-week scope.
      - `etf_net_issuance_million_usd` integer, nullable — ETF net issuance (gross issuance less gross redemptions) in millions of USD. Per-week scope.
      - `buckets` IciFlowBucket[], required — Per-bucket breakdown (equity/hybrid/bond/commodity with subbucket rollups). 8 entries when fully parsed.
        - `bucket` string, required — Top-level bucket: equity | hybrid | bond | commodity.
        - `subbucket` string, required — Subdivision within the bucket: total | domestic | world | taxable | municipal. 'total' is the parent rollup.
        - `value_million_usd` integer, nullable — Net flow in millions of USD. Negative = net outflow. Null when ICI parse extracted no value for this bucket.
    - `history` IciFlowWeek[], required — Multi-week history captured from the press release inline table (typically 5 entries, newest first).
      - `week_ending` string, required — ISO date of the week-ending Wednesday.
      - `total_long_term_flows_million_usd` integer, nullable — Headline total long-term flows in millions of USD. Sourced from prose; may be null when prose regex fails.
      - `mutual_fund_outflows_million_usd` integer, nullable — Mutual fund net new cash flow in millions of USD. Stored negative when the press release labels them as 'outflows', positive when 'inflows'. Per-week scope.
      - `etf_net_issuance_million_usd` integer, nullable — ETF net issuance (gross issuance less gross redemptions) in millions of USD. Per-week scope.
      - `buckets` IciFlowBucket[], required — Per-bucket breakdown (equity/hybrid/bond/commodity with subbucket rollups). 8 entries when fully parsed.
        - `bucket` string, required — Top-level bucket: equity | hybrid | bond | commodity.
        - `subbucket` string, required — Subdivision within the bucket: total | domestic | world | taxable | municipal. 'total' is the parent rollup.
        - `value_million_usd` integer, nullable — Net flow in millions of USD. Negative = net outflow. Null when ICI parse extracted no value for this bucket.
  - `meta` SugraMeta, required — Metadata attached to every /api/v1/* response envelope.
    - `endpoint` string, required — Requested endpoint path.
    - `data_time` string, required — ISO 8601 UTC timestamp of the source data, not of the request.
    - `response_time` string, required — ISO 8601 UTC timestamp when this response was produced.
    - `provider` string, required — API name and version.
    - `source` string, nullable — Identifier of the primary upstream source used for this response.
    - `attribution` string, nullable — Human-readable attribution mandated by an upstream source (e.g. a securities regulator or self-regulatory organization). Present only on responses whose source requires the owner and source to be clearly identified. Do not remove or alter it when using the response.
    - `fallback_used` boolean, nullable — True when the primary source failed and a fallback produced the data.
    - `fallback_chain` string[], nullable — Ordered list of sources attempted, in the order they were tried.
    - `cached` boolean, nullable — True when this response was served from the internal cache.
    - `stale` boolean, nullable — True when the cached response was returned after the upstream rate-limited or errored. Clients can use this to detect degraded data.

## Other responses

- `401` — Missing or invalid `x-api-key` header. JSON body with a stable `code` distinguishing `missing_api_key` (no header sent) from `invalid_api_key` (header sent, key not accepted); any other 401 source carries the generic `unauthorized` with its detail as `reason`. Plus `hint`. `plan` is always null on 401 - an unauthenticated request has no plan; quota exhaustion is 429, not 401.
- `429` — Daily rate limit exceeded. Check `X-RateLimit-Reset` for the next window.
- `503` — Upstream source is temporarily unavailable. Retry after a short delay.

---

[API](https://skmtc.net/sugra/apis/sugra-api.md) · [All operations](https://skmtc.net/sugra/apis/sugra-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/sugra/sugra-api/versions/4c4530760ba1/schema)