> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Stablecoin Schema Deprecation

> Legacy crosschain stablecoin schemas are deprecated in favor of the new stablecoins schema.

<Info>
  Unlike the [asset schema deprecations](/changelog/deprecated-schemas), **no
  removal date has been set yet** for `crosschain.stablecoin.*` or
  `crosschain.metrics.stablecoin_volume`. They remain queryable today, but all
  new stablecoin work should target the `stablecoins.*` schema — see the table
  mapping below and the [Stablecoins](/historical-data/stablecoins) docs for
  full column-level detail on each replacement table.
</Info>

## Table Mappings

| Legacy Table                                       | New Table                                                                                                         |
| -------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------- |
| `crosschain.stablecoin.list`                       | [`stablecoins.registry.deployments`](/historical-data/stablecoins/registry)                                       |
| `crosschain.stablecoin.catalog`                    | [`stablecoins.registry.catalog`](/historical-data/stablecoins/registry)                                           |
| `crosschain.stablecoin.deployments`                | [`stablecoins.registry.deployments`](/historical-data/stablecoins/registry)                                       |
| `crosschain.stablecoin.transfers`                  | [`stablecoins.core.transfers`](/historical-data/stablecoins/transfers)                                            |
| `crosschain.stablecoin.supply_beta`                | [`stablecoins.core.supply_daily`](/historical-data/stablecoins/supply-daily)                                      |
| `crosschain.stablecoin.supply_delta`               | [`stablecoins.core.supply_change`](/historical-data/stablecoins/supply-change)                                    |
| `crosschain.metrics.stablecoin_volume`             | [`stablecoins.metrics.volume_daily`](/historical-data/stablecoins/volume-daily)                                   |
| `<chain>.assets.stablecoin_transfers` (EVM chains) | [`<chain>.stablecoins.transfers`](/historical-data/stablecoins/transfers)                                         |
| `<chain>.assets.stablecoin_list` (EVM chains)      | [`stablecoins.registry.deployments`](/historical-data/stablecoins/registry) (crosschain-level; filter by `chain`) |

## EVM Chain-Level Tables Removed (`assets.stablecoin_*`)

<Warning>
  An in-progress migration is removing `<chain>.assets.stablecoin_transfers`
  and `<chain>.assets.stablecoin_list` for all EVM chains listed below.
  Existing Snowflake tables are **not** dropped immediately, but they will
  soon stop receiving new data — queries against them will return
  increasingly stale results. Migrate to `<chain>.stablecoins.transfers`
  (transfers) and `stablecoins.registry.deployments` filtered by chain (list)
  now.
</Warning>

**Affected chains (28)**: arbitrum, avalanche, base, berachain, blast, bsc,
celo, codex, ethereum, hyperevm, ink, linea, mode, monad, optimism, plasma,
plume, polygon, polygon\_zkevm, scroll, sei, soneium, sonic, stable, tempo,
unichain, worldchain, zksync. (`tempo` only ever had `stablecoin_transfers`,
no `stablecoin_list`.)

**Not affected**: Solana, Tron, Aptos, and other non-EVM chains — their
`assets.stablecoin_*` tables are unchanged for now.

## Why we're migrating

The `stablecoins.*` schema replaces the `crosschain.stablecoin.*` family with:

* **Registry metadata joined in** — `product_id`, `issuer_id`, `is_native`, and `stablecoin_type` are available directly on `stablecoins.core.transfers`, `stablecoins.core.supply_daily`, and `stablecoins.metrics.volume_daily`, without a separate join.
* **A cleaner registry split** — `stablecoins.registry.deployments` (per chain/address) and `stablecoins.registry.catalog` (per product) replace the overlapping `crosschain.stablecoin.list`, `.catalog`, and `.deployments` tables.
* **New tables with no legacy equivalent** — `stablecoins.core.supply_change` (mint/burn events) and `stablecoins.core.balances_daily` (daily forward-filled holder balances).
* **A more conservative supply methodology** — `stablecoins.core.supply_daily` adds `adjusted_circulating_supply`, which nets out bridge escrows, protocol collateral, and savings-vault deposits on top of the issuer-basis exclusions already in `circulating_supply`.

## Migration Checklist

* **Review the new schema** — See the [Stablecoins](/historical-data/stablecoins) docs for full column-level detail on each `stablecoins.*` table.
* **Update your queries** — Replace legacy `crosschain.stablecoin.*` / `crosschain.metrics.stablecoin_volume` references using the mapping above.
* **Test your applications** — Run existing queries against the new schema to confirm parity.
* **Deploy changes** — Update your workflows to use `stablecoins.*` going forward.

### Support

If you need help with migration or have questions about this deprecation, reach out to our support team for assistance.