Stablecoins

Celo stablecoins are the Assets layer under asset_type = 'stablecoin': the registry rows describe each coin’s deployments and metrics_asset_tokens carries their daily supply, holders and transfer activity in one table per measure. Every column is documented at Stablecoins.

Sample queries

Largest stablecoins
One coin's series

Rank the stablecoins issued on Celo by native circulating supply.

select
    assets.symbol,
    daily.market_cap_circulating_native
from `metrics_asset_tokens.market_cap_circulating_native_daily` as daily
join `dimensions.asset_tokens` as deployments
    using (asset_token_id)
join `dimensions.assets` as assets
    using (asset_id)
where daily.timestamp >= timestamp('2026-08-22')
  and daily.timestamp < timestamp('2026-08-23')
  and deployments.chain_id = 'celo'
  and assets.asset_type = 'stablecoin'
order by daily.market_cap_circulating_native desc
limit 20

Read one stablecoin’s daily supply and holders on Celo. Each measure is its own table, so reading two means a join on asset_token_id and timestamp.

with supply as (
    select
        timestamp,
        market_cap_circulating_native
    from `metrics_asset_tokens.market_cap_circulating_native_daily`
    where asset_token_id = 'usdc-0xceba9300f2b948710d2653dd7b07f33a8b32118c-celo'
      and timestamp >= timestamp('2026-06-01')
      and timestamp < timestamp('2026-08-23')
),

holders as (
    select
        timestamp,
        holders_native
    from `metrics_asset_tokens.holders_native_daily`
    where asset_token_id = 'usdc-0xceba9300f2b948710d2653dd7b07f33a8b32118c-celo'
      and timestamp >= timestamp('2026-06-01')
      and timestamp < timestamp('2026-08-23')
)

select
    timestamp,
    supply.market_cap_circulating_native,
    holders.holders_native
from supply
left join holders
    using (timestamp)
order by timestamp

Overview

Core entities

Core datasets

Market verticals

Chain verticals

Sample queries

​Sample queries

Sample queries