Metrics

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

Tables

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

Stablecoin
Deployment

One row per stablecoin per day.

Table	Value column	What it holds
`metrics_assets.market_cap_circulating_total_daily`	`market_cap_circulating_total`	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.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_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_total_daily`	`mints_total`	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_total_daily`	`redemptions_total`	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_total_daily`	`transfer_count_total`	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_total_daily`	`transfer_volume_total`	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.user_dau_daily`	`user_dau`	Distinct addresses sending the asset on the day, across every deployment.
`metrics_assets.user_wau_daily`	`user_wau`	Distinct addresses sending the asset in the trailing 7 days, across every deployment.
`metrics_assets.user_mau_daily`	`user_mau`	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.market_cap_circulating_total_daily`	`market_cap_circulating_total`	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_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_total_daily`	`mints_total`	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_total_daily`	`redemptions_total`	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_total_daily`	`transfer_count_total`	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_total_daily`	`transfer_volume_total`	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.user_dau_native_daily`	`user_dau_native`	Distinct addresses sending the deployment’s token on the day; natively-issued deployments only.
`metrics_asset_tokens.user_dau_bridged_daily`	`user_dau_bridged`	Distinct addresses sending the deployment’s token on the day; bridged deployments only.
`metrics_asset_tokens.user_wau_native_daily`	`user_wau_native`	Distinct addresses sending the deployment’s token in the trailing 7 days; natively-issued deployments only.
`metrics_asset_tokens.user_wau_bridged_daily`	`user_wau_bridged`	Distinct addresses sending the deployment’s token in the trailing 7 days; bridged deployments only.
`metrics_asset_tokens.user_mau_native_daily`	`user_mau_native`	Distinct addresses sending the deployment’s token in the trailing 30 days; natively-issued deployments only.
`metrics_asset_tokens.user_mau_bridged_daily`	`user_mau_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_total
from `metrics_asset_tokens.market_cap_circulating_total_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_total 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_total, 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_total
    from `metrics_asset_tokens.mints_total_daily`
    where timestamp = timestamp('2026-08-01')
),

redemptions as (
    select asset_token_id, redemptions_total
    from `metrics_asset_tokens.redemptions_total_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_total,
    redemptions.redemptions_total
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