Metrics

Supply, holders, transfer activity, price and peg deviation. One row per thing per day, at three grains: stablecoin, stablecoin and chain, and deployment.

Tables

A tab per grain. Coverage shows which issuers report which measure.

Stablecoin
Stablecoin and chain
Deployment

One row per stablecoin per day.

Table	Value column	What it holds
`metrics_assets.market_cap_circulating_daily`	`market_cap_circulating`	Circulating market cap across every representation of the asset, native issuance plus bridged wrappers plus any off-chain component.
`metrics_assets.app_tvl_daily`	`app_tvl`	Value of the asset deposited into onchain apps — lending markets, DEX pools and vaults
`metrics_assets.app_trading_volume_daily`	`app_trading_volume`	Value of spot trades involving the asset on onchain venues — DEX pools and onchain order books — USD
`metrics_assets.market_cap_circulating_native_daily`	`market_cap_circulating_native`	Circulating market cap of natively-issued deployments only.
`metrics_assets.market_cap_circulating_bridged_daily`	`market_cap_circulating_bridged`	Circulating market cap of bridged deployments only, wrapped representations of supply issued elsewhere.
`metrics_assets.market_cap_circulating_offchain_daily`	`market_cap_circulating_offchain`	Circulating market cap the issuer reports off-chain, the portion of a fund’s NAV no token contract represents.
`metrics_assets.price_daily`	`price`	Asset price in USD (canonical across sources).
`metrics_assets.off_peg_daily`	`off_peg`	Deviation from the asset’s peg.
`metrics_assets.holders_daily`	`holders`	Distinct holders summed across every deployment of the asset; an address on two chains counts twice.
`metrics_assets.holders_native_daily`	`holders_native`	Distinct holders across the asset’s natively-issued deployments only.
`metrics_assets.holders_bridged_daily`	`holders_bridged`	Distinct holders across the asset’s bridged deployments only.
`metrics_assets.mints_daily`	`mints`	Value minted (issued) across every deployment; a bridged mint is a distinct event, so this is a real total.
`metrics_assets.mints_native_daily`	`mints_native`	Value minted (issued) on natively-issued deployments only.
`metrics_assets.mints_bridged_daily`	`mints_bridged`	Value minted (issued) on bridged deployments only.
`metrics_assets.redemptions_daily`	`redemptions`	Value redeemed (burned) across every deployment; a bridged burn is a distinct event, so this is a real total.
`metrics_assets.redemptions_native_daily`	`redemptions_native`	Value redeemed (burned) on natively-issued deployments only.
`metrics_assets.redemptions_bridged_daily`	`redemptions_bridged`	Value redeemed (burned) on bridged deployments only.
`metrics_assets.transfer_count_daily`	`transfer_count`	Number of transfers across every deployment; a bridged transfer is a distinct event, so this is a real total.
`metrics_assets.transfer_count_native_daily`	`transfer_count_native`	Number of transfers on natively-issued deployments only.
`metrics_assets.transfer_count_bridged_daily`	`transfer_count_bridged`	Number of transfers on bridged deployments only.
`metrics_assets.transfer_volume_daily`	`transfer_volume`	Value transferred across every deployment; a bridged transfer is a distinct event, so this is a real total.
`metrics_assets.transfer_volume_native_daily`	`transfer_volume_native`	Value transferred on natively-issued deployments only.
`metrics_assets.transfer_volume_bridged_daily`	`transfer_volume_bridged`	Value transferred on bridged deployments only.
`metrics_assets.daily_active_users_daily`	`daily_active_users`	Distinct addresses sending the asset on the day, across every deployment.
`metrics_assets.weekly_active_users_daily`	`weekly_active_users`	Distinct addresses sending the asset in the trailing 7 days, across every deployment.
`metrics_assets.monthly_active_users_daily`	`monthly_active_users`	Distinct addresses sending the asset in the trailing 30 days, across every deployment.

One row per stablecoin per chain per day. Keyed on asset_chain_id and timestamp, which is written {asset_id}-{chain_id} and joins dimensions.assets_by_chain. Every measure rolls up the stablecoin’s deployments on that chain.

Table	Value column	What it holds
`metrics_assets_by_chain.app_tvl_daily`	`app_tvl`	Value of the asset deposited into onchain apps — lending markets, DEX pools and vaults
`metrics_assets_by_chain.app_trading_volume_daily`	`app_trading_volume`	Value of spot trades involving the asset on onchain venues — DEX pools and onchain order books — USD
`metrics_assets_by_chain.market_cap_circulating_native_daily`	`market_cap_circulating_native`	Circulating market cap of natively-issued deployments only
`metrics_assets_by_chain.market_cap_circulating_bridged_daily`	`market_cap_circulating_bridged`	Circulating market cap of bridged deployments only, wrapped representations of supply issued elsewhere
`metrics_assets_by_chain.market_cap_circulating_daily`	`market_cap_circulating`	Circulating market cap of the asset on the chain, USD, summed across every deployment there, native and bridged.
`metrics_assets_by_chain.holders_daily`	`holders`	Distinct holders summed across every deployment of the asset, native and bridged
`metrics_assets_by_chain.holders_native_daily`	`holders_native`	Distinct holders across the asset’s natively-issued deployments only
`metrics_assets_by_chain.holders_bridged_daily`	`holders_bridged`	Distinct holders across the asset’s bridged deployments only
`metrics_assets_by_chain.mints_native_daily`	`mints_native`	Value minted (issued) on natively-issued deployments only
`metrics_assets_by_chain.mints_bridged_daily`	`mints_bridged`	Value minted (issued) on bridged deployments only
`metrics_assets_by_chain.mints_daily`	`mints`	Value minted (issued) across every deployment; a bridged mint is a distinct event, so this is a real total
`metrics_assets_by_chain.redemptions_native_daily`	`redemptions_native`	Value redeemed (burned) on natively-issued deployments only
`metrics_assets_by_chain.redemptions_bridged_daily`	`redemptions_bridged`	Value redeemed (burned) on bridged deployments only
`metrics_assets_by_chain.redemptions_daily`	`redemptions`	Value redeemed (burned) across every deployment; a bridged burn is a distinct event, so this is a real total
`metrics_assets_by_chain.transfer_count_native_daily`	`transfer_count_native`	Number of transfers on natively-issued deployments only
`metrics_assets_by_chain.transfer_count_bridged_daily`	`transfer_count_bridged`	Number of transfers on bridged deployments only
`metrics_assets_by_chain.transfer_count_daily`	`transfer_count`	Number of transfers across every deployment; a bridged transfer is a distinct event, so this is a real total
`metrics_assets_by_chain.transfer_volume_native_daily`	`transfer_volume_native`	Value transferred on natively-issued deployments only
`metrics_assets_by_chain.transfer_volume_bridged_daily`	`transfer_volume_bridged`	Value transferred on bridged deployments only
`metrics_assets_by_chain.transfer_volume_daily`	`transfer_volume`	Value transferred across every deployment; a bridged transfer is a distinct event, so this is a real total
`metrics_assets_by_chain.daily_active_users_daily`	`daily_active_users`	Distinct addresses sending the asset on the day, across every deployment
`metrics_assets_by_chain.weekly_active_users_daily`	`weekly_active_users`	Distinct addresses sending the asset in the trailing 7 days, across every deployment
`metrics_assets_by_chain.monthly_active_users_daily`	`monthly_active_users`	Distinct addresses sending the asset in the trailing 30 days, across every deployment

One row per deployment per day.

Table	Value column	What it holds
`metrics_asset_tokens.app_tvl_daily`	`app_tvl`	Value of the deployment deposited into onchain apps — lending markets, DEX pools and vaults
`metrics_asset_tokens.app_trading_volume_daily`	`app_trading_volume`	Value of spot trades involving the deployment on onchain venues — DEX pools and onchain order books — USD, all venues together
`metrics_asset_tokens.market_cap_circulating_daily`	`market_cap_circulating`	Circulating market cap of the deployment, native or bridged.
`metrics_asset_tokens.market_cap_circulating_native_daily`	`market_cap_circulating_native`	Circulating market cap of the deployment; natively-issued deployments only.
`metrics_asset_tokens.market_cap_circulating_bridged_daily`	`market_cap_circulating_bridged`	Circulating market cap of the deployment; bridged deployments only, wrapped representations of supply issued elsewhere.
`metrics_asset_tokens.holders_daily`	`holders`	Addresses holding a non-zero balance of the deployment, native or bridged.
`metrics_asset_tokens.holders_native_daily`	`holders_native`	Addresses holding a non-zero balance of the deployment; natively-issued deployments only.
`metrics_asset_tokens.holders_bridged_daily`	`holders_bridged`	Addresses holding a non-zero balance of the deployment; bridged deployments only.
`metrics_asset_tokens.mints_daily`	`mints`	Value minted (issued) on the deployment, native or bridged.
`metrics_asset_tokens.mints_native_daily`	`mints_native`	Value minted (issued) on the deployment; natively-issued deployments only.
`metrics_asset_tokens.mints_bridged_daily`	`mints_bridged`	Value minted (issued) on the deployment; bridged deployments only.
`metrics_asset_tokens.redemptions_daily`	`redemptions`	Value redeemed (burned) on the deployment, native or bridged.
`metrics_asset_tokens.redemptions_native_daily`	`redemptions_native`	Value redeemed (burned) on the deployment; natively-issued deployments only.
`metrics_asset_tokens.redemptions_bridged_daily`	`redemptions_bridged`	Value redeemed (burned) on the deployment; bridged deployments only.
`metrics_asset_tokens.transfer_count_daily`	`transfer_count`	Transfers on the deployment, native or bridged.
`metrics_asset_tokens.transfer_count_native_daily`	`transfer_count_native`	Transfers on the deployment; natively-issued deployments only.
`metrics_asset_tokens.transfer_count_bridged_daily`	`transfer_count_bridged`	Transfers on the deployment; bridged deployments only.
`metrics_asset_tokens.transfer_volume_daily`	`transfer_volume`	Value transferred on the deployment, native or bridged.
`metrics_asset_tokens.transfer_volume_native_daily`	`transfer_volume_native`	Value transferred on the deployment; natively-issued deployments only.
`metrics_asset_tokens.transfer_volume_bridged_daily`	`transfer_volume_bridged`	Value transferred on the deployment; bridged deployments only.
`metrics_asset_tokens.daily_active_users_native_daily`	`daily_active_users_native`	Distinct addresses sending the deployment’s token on the day; natively-issued deployments only.
`metrics_asset_tokens.daily_active_users_bridged_daily`	`daily_active_users_bridged`	Distinct addresses sending the deployment’s token on the day; bridged deployments only.
`metrics_asset_tokens.weekly_active_users_native_daily`	`weekly_active_users_native`	Distinct addresses sending the deployment’s token in the trailing 7 days; natively-issued deployments only.
`metrics_asset_tokens.weekly_active_users_bridged_daily`	`weekly_active_users_bridged`	Distinct addresses sending the deployment’s token in the trailing 7 days; bridged deployments only.
`metrics_asset_tokens.monthly_active_users_native_daily`	`monthly_active_users_native`	Distinct addresses sending the deployment’s token in the trailing 30 days; natively-issued deployments only.
`metrics_asset_tokens.monthly_active_users_bridged_daily`	`monthly_active_users_bridged`	Distinct addresses sending the deployment’s token in the trailing 30 days; bridged deployments only.

Sample queries

Each measure is its own table, so a row with both is a join on asset_id and timestamp, bounded on each side. off_peg reads as a decimal fraction of the peg measured against the peg currency’s end-of-day rate, so -0.02 is two percent below.

with supply as (
    select timestamp, market_cap_circulating_native
    from `metrics_assets.market_cap_circulating_native_daily`
    where asset_id = 'usdt'
      and timestamp >= timestamp('2026-06-01')
),

peg as (
    select timestamp, off_peg
    from `metrics_assets.off_peg_daily`
    where asset_id = 'usdt'
      and timestamp >= timestamp('2026-06-01')
)

select
    timestamp,
    supply.market_cap_circulating_native,
    peg.off_peg
from supply
full join peg
    using (timestamp)
order by timestamp

dimensions.assets has asset_type, so the stablecoin filter is a join to it.

select
    assets.symbol,
    daily.market_cap_circulating_native
from `metrics_assets.market_cap_circulating_native_daily` as daily
join `dimensions.assets` as assets
    using (asset_id)
where daily.timestamp = timestamp('2026-08-01')
  and assets.asset_type = 'stablecoin'
order by daily.market_cap_circulating_native desc
limit 25

The deployment tables key on asset_token_id, and dimensions.asset_tokens has the chain and the issuance status behind that key.

select
    deployments.chain_id,
    deployments.bridged_status,
    daily.market_cap_circulating
from `metrics_asset_tokens.market_cap_circulating_daily` as daily
join `dimensions.asset_tokens` as deployments
    using (asset_token_id)
where daily.timestamp = timestamp('2026-08-01')
  and deployments.asset_id = 'usdc'
order by daily.market_cap_circulating desc

Native and bridged supply are separate measures in separate tables, and the product total is the native column added up. A bridged row has supply with an empty mints, because a wrapper arrives by bridge.

with deployments as (
    select asset_token_id, chain_id, token_address, bridged_status
    from `dimensions.asset_tokens`
    where asset_id = 'eurc'
),

native as (
    select asset_token_id, market_cap_circulating_native
    from `metrics_asset_tokens.market_cap_circulating_native_daily`
    where timestamp = timestamp('2026-08-01')
),

bridged as (
    select asset_token_id, market_cap_circulating_bridged
    from `metrics_asset_tokens.market_cap_circulating_bridged_daily`
    where timestamp = timestamp('2026-08-01')
),

mints as (
    select asset_token_id, mints
    from `metrics_asset_tokens.mints_daily`
    where timestamp = timestamp('2026-08-01')
),

redemptions as (
    select asset_token_id, redemptions
    from `metrics_asset_tokens.redemptions_daily`
    where timestamp = timestamp('2026-08-01')
)

select
    deployments.chain_id,
    deployments.token_address,
    deployments.bridged_status,
    native.market_cap_circulating_native,
    bridged.market_cap_circulating_bridged,
    mints.mints,
    redemptions.redemptions
from deployments
left join native
    using (asset_token_id)
left join bridged
    using (asset_token_id)
left join mints
    using (asset_token_id)
left join redemptions
    using (asset_token_id)
order by native.market_cap_circulating_native desc

Circulating supply is the one measure where the two grains can differ. Supply an issuer reports off-chain sits in the stablecoin row and in metrics_assets.market_cap_circulating_offchain_daily, and accounts for the difference.

with deployment_sum as (
    select
        tokens.asset_id,
        daily.timestamp,
        sum(daily.market_cap_circulating_native) as summed
    from `metrics_asset_tokens.market_cap_circulating_native_daily` as daily
    join `dimensions.asset_tokens` as tokens
        using (asset_token_id)
    where tokens.asset_id = 'usdt'
      and daily.timestamp >= timestamp('2026-08-01')
    group by tokens.asset_id, daily.timestamp
),

asset_level as (
    select asset_id, timestamp, market_cap_circulating_native
    from `metrics_assets.market_cap_circulating_native_daily`
    where asset_id = 'usdt'
      and timestamp >= timestamp('2026-08-01')
)

select
    timestamp,
    asset_level.market_cap_circulating_native as stablecoin_grain,
    deployment_sum.summed as deployment_grain
from asset_level
left join deployment_sum
    using (asset_id, timestamp)
order by timestamp

Some stablecoins take their price from the peg rate itself, marked price_source = 'peg' on metrics_assets.price_daily, and their off_peg is zero by construction. Joining that table filters them out of a ranking by tightest peg.

select
    assets.symbol,
    assets.peg_currency,
    peg.off_peg
from `metrics_assets.off_peg_daily` as peg
join `metrics_assets.price_daily` as prices
    using (asset_id, timestamp)
join `dimensions.assets` as assets
    using (asset_id)
where peg.timestamp = timestamp('2026-08-01')
  and assets.asset_type = 'stablecoin'
  and prices.price_source != 'peg'
order by abs(peg.off_peg) desc
limit 25

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Tables

Sample queries

​Tables

​Sample queries

Tables

Sample queries