> ## 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.

# Overview

> Macro metrics to granular transaction details of stablecoin movements across all chains.

Allium's `stablecoins` schema gives you a full stack of stablecoin data: a cross-chain product/deployment registry, raw transfers and supply events, daily supply and balance snapshots, and pre-built volume metrics. All `stablecoins.core.*` and `stablecoins.metrics.*` tables include a `chain` column, so you can filter to one chain or aggregate across many without joining separate per-chain tables.

The stablecoin vertical supports currencies beyond USD (e.g. CNY, JPY, TRY, EUR, CAD, etc).

## Tables

All new stablecoin work should build on the `stablecoins.*` schema below. It replaces the `crosschain.stablecoin.*` tables (see **Legacy Tables** at the bottom of this page), which are deprecated but still queryable.

<table>
  <thead>
    <tr><th width="340">Table Name</th><th>Description</th></tr>
  </thead>

  <tbody>
    <tr><td><a href="/historical-data/stablecoins/registry"><code>stablecoins.registry.deployments</code></a></td><td>Per-(chain, address) registry of every tracked stablecoin deployment, with product, issuer, and peg metadata.</td></tr>
    <tr><td><a href="/historical-data/stablecoins/registry"><code>stablecoins.registry.catalog</code></a></td><td>Product-grain registry: one row per stablecoin product (e.g. USDC), independent of chain.</td></tr>
    <tr><td><a href="/historical-data/stablecoins/transfers"><code>stablecoins.core.transfers</code></a></td><td>Raw, unfiltered stablecoin transfers across all supported chains.</td></tr>
    <tr><td><a href="/historical-data/stablecoins/balances-daily"><code>stablecoins.core.balances\_daily</code></a></td><td>Daily forward-filled stablecoin balances by holder address.</td></tr>
    <tr><td><a href="/historical-data/stablecoins/supply-change"><code>stablecoins.core.supply\_change</code></a></td><td>Individual mint/burn events behind supply changes.</td></tr>
    <tr><td><a href="/historical-data/stablecoins/supply-daily"><code>stablecoins.core.supply\_daily</code></a></td><td>Daily total, circulating, and adjusted circulating supply per stablecoin deployment.</td></tr>
    <tr><td><a href="/historical-data/stablecoins/volume-daily"><code>stablecoins.metrics.volume\_daily</code></a></td><td>Pre-built daily transfer volume metrics, including organic-activity adjusted volume where available.</td></tr>
  </tbody>
</table>

For a single canonical product, filter directly: `where product_id = 'usdt'`. The same `product_id` filter works on `stablecoins.core.transfers`, `stablecoins.core.supply_change`, `stablecoins.core.supply_daily`, `stablecoins.metrics.volume_daily`, and other stablecoin tables.

We are currently working on expanding stablecoin coverage for more chains, and add on a case by case basis. Please reach out to us if you have any questions or would like to request coverage for a specific chain or stablecoin.

## Filtering by Stablecoin Product

The legacy `base_asset` column (e.g. `base_asset = 'usdt'`) is removed in the new schema. Use `product_id` together with `stablecoins.registry.catalog` to achieve the same result — including all native, bridged, and DeFi-wrapped variants of a stablecoin family.

**Replace `base_asset = 'usdt'` with:**

```sql theme={null}
where product_id in (
    select product_id
    from stablecoins.registry.catalog
    where underlying_product_id = 'usdt'
        or product_id = 'usdt'
)
```

This pattern works on any `stablecoins.core.*` or `stablecoins.metrics.*` table, and on the per-chain `<chain>.stablecoins.transfers` tables. For a single canonical token (e.g. only native USDT, not bridged variants), filter `where product_id = 'usdt' and is_native = true`.

See [`stablecoins.registry.catalog`](/historical-data/stablecoins/registry) for the full catalog schema and more examples.

## Chain-Level Stablecoin Transfers

* Each supported chain also exposes a chain-scoped transfers table — `<chain>.stablecoins.transfers` — for workloads that query a single chain.
* These tables are identical in schema to `stablecoins.core.transfers` (minus the `chain` column) and are updated on the same cadence.
* This replaces the legacy `<chain>.assets.stablecoin_transfers` tables. The new tables include additional columns: `product_id`, `is_native`, `stablecoin_type`, and `usd_exchange_rate`.

<Accordion title="Legacy Tables">
  The tables below live under `crosschain.stablecoin.*` and `crosschain.metrics.*`. They are deprecated in favor of the `stablecoins.*` tables above, but remain queryable for existing use cases.

  <table>
    <thead>
      <tr><th width="300">Table Name</th><th>Description</th><th width="280">Replacement</th></tr>
    </thead>

    <tbody>
      <tr><td><code>crosschain.stablecoin.list</code></td><td>Table of main stablecoins and their contract addresses across chains.</td><td><a href="/historical-data/stablecoins/registry"><code>stablecoins.registry.deployments</code></a></td></tr>
      <tr><td><code>crosschain.stablecoin.catalog</code></td><td>Product-grain stablecoin catalog.</td><td><a href="/historical-data/stablecoins/registry"><code>stablecoins.registry.catalog</code></a></td></tr>
      <tr><td><code>crosschain.stablecoin.deployments</code></td><td>Per-(chain, address) deployment records.</td><td><a href="/historical-data/stablecoins/registry"><code>stablecoins.registry.deployments</code></a></td></tr>
      <tr><td><a href="/historical-data/stablecoins/transfers"><code>crosschain.stablecoin.transfers</code></a></td><td>Transfers of all stablecoins indexed by Allium.</td><td><a href="/historical-data/stablecoins/transfers"><code>stablecoins.core.transfers</code></a></td></tr>
      <tr><td><code>crosschain.stablecoin.supply\_beta</code></td><td>Daily snapshot of stablecoin total supply.</td><td><a href="/historical-data/stablecoins/supply-daily"><code>stablecoins.core.supply\_daily</code></a></td></tr>
      <tr><td><code>crosschain.stablecoin.supply\_delta\_beta</code></td><td>Individual mint/burn events.</td><td><a href="/historical-data/stablecoins/supply-change"><code>stablecoins.core.supply\_change</code></a></td></tr>
      <tr><td><code>crosschain.metrics.stablecoin\_volume</code></td><td>Pre-built metrics for stablecoin transfer activity, aggregated by day, chain and token address.</td><td><a href="/historical-data/stablecoins/volume-daily"><code>stablecoins.metrics.volume\_daily</code></a></td></tr>
    </tbody>
  </table>
</Accordion>