Skip to main content
Allium’s stablecoins schema provides a unified view of stablecoin activity across every supported chain — from raw transfer events and holder balances to daily supply snapshots and adjusted volume metrics. All crosschain models 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.) For a single canonical product only, 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.

​
Schema Structure

SchemaTablesDescription
stablecoins.registrydeployments, catalogStablecoin product metadata and per-chain contract deployments
stablecoins.coretransfers, balances_daily, supply_change, supply_dailyEvent-level and daily aggregated stablecoin activity
stablecoins.metricsvolume_dailyPre-aggregated daily transfer volume with adjusted metrics

​
Migration from crosschain.stablecoin

Old TableNew TableNotes
crosschain.stablecoin.liststablecoins.registry.deployments + stablecoins.registry.catalogMetadata split into product catalog and per-chain deployment. See Filtering by stablecoin product to replace base_asset
crosschain.stablecoin.transfersstablecoins.core.transfersExtended with product_id, is_native, stablecoin_type, usd_exchange_rate. Replace base_asset filters via catalog — see Filtering by stablecoin product
crosschain.metrics.stablecoin_volumestablecoins.metrics.volume_dailySame adjusted methodology; column names updated
For per-chain transfers, <chain>.assets.stablecoin_transfers is replaced by <chain>.stablecoins.transfers. See chain-specific stablecoin transfers below.

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