Stablecoins

Ethereum stablecoins are the Assets layer under asset_type = 'stablecoin': the registry rows describe each coin’s deployments and metrics.asset_tokens_daily carries their daily supply, holders and transfer activity. Individual transfers sit on Tokens. Every column is documented at Stablecoins.

Sample queries

Largest stablecoins
One coin's series

Rank the stablecoins issued on Ethereum by native circulating supply.

select
    symbol,
    market_cap_circulating_native,
    holders_native,
    transfer_volume_native
from `metrics.asset_tokens_daily`
where timestamp >= timestamp('2026-08-22')
  and timestamp < timestamp('2026-08-23')
  and chain_id = 'ethereum'
  and asset_type = 'stablecoin'
  and bridged_status = 'native'
order by market_cap_circulating_native desc
limit 20

Read one stablecoin’s daily supply and holders on Ethereum.

select
    timestamp,
    market_cap_circulating_native,
    holders_native,
    transfer_count_native
from `metrics.asset_tokens_daily`
where timestamp >= timestamp('2026-06-01')
  and timestamp < timestamp('2026-08-23')
  and asset_token_id = 'usdc-0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48-ethereum'
order by timestamp

⌘I

Overview

Core entities

Market verticals

Chain verticals

Sample queries

​Sample queries

Sample queries