Overview

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 Name	Description
`stablecoins.registry.deployments`	Per-(chain, address) registry of every tracked stablecoin deployment, with product, issuer, and peg metadata.
`stablecoins.registry.catalog`	Product-grain registry: one row per stablecoin product (e.g. USDC), independent of chain.
`stablecoins.core.transfers`	Raw, unfiltered stablecoin transfers across all supported chains.
`stablecoins.core.balances_daily`	Daily forward-filled stablecoin balances by holder address.
`stablecoins.core.supply_change`	Individual mint/burn events behind supply changes.
`stablecoins.core.supply_daily`	Daily total, circulating, and adjusted circulating supply per stablecoin deployment.
`stablecoins.metrics.volume_daily`	Pre-built daily transfer volume metrics, including organic-activity adjusted volume where available.

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:

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

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 Name	Description	Replacement
`crosschain.stablecoin.list`	Table of main stablecoins and their contract addresses across chains.	`stablecoins.registry.deployments`
`crosschain.stablecoin.catalog`	Product-grain stablecoin catalog.	`stablecoins.registry.catalog`
`crosschain.stablecoin.deployments`	Per-(chain, address) deployment records.	`stablecoins.registry.deployments`
`crosschain.stablecoin.transfers`	Transfers of all stablecoins indexed by Allium.	`stablecoins.core.transfers`
`crosschain.stablecoin.supply_beta`	Daily snapshot of stablecoin total supply.	`stablecoins.core.supply_daily`
`crosschain.stablecoin.supply_delta`	Individual mint/burn events.	`stablecoins.core.supply_change`
`crosschain.metrics.stablecoin_volume`	Pre-built metrics for stablecoin transfer activity, aggregated by day, chain and token address.	`stablecoins.metrics.volume_daily`

Data Verticals

Solana

Hyperliquid

Lighter

Bitcoin Ecosystem

EVM

Cosmos Ecosystem

Move Ecosystem

Other Ecosystems

Overview

Tables

Filtering by Stablecoin Product

Chain-Level Stablecoin Transfers

​Tables

​Filtering by Stablecoin Product

​Chain-Level Stablecoin Transfers

Tables

Filtering by Stablecoin Product

Chain-Level Stablecoin Transfers