Documentation Index
Fetch the complete documentation index at: /docs/llms.txt
Use this file to discover all available pages before exploring further.
Every stablecoin issued on Avalanche: supply, holders and transfers.
asset_type = 'stablecoin': the registry rows describe each coin’s deployments and metrics_asset_tokens has their daily supply, holders and transfer activity in one table per measure.
Every column is documented at Stablecoins.
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 = 'avalanche'
and assets.asset_type = 'stablecoin'
order by daily.market_cap_circulating_native desc
limit 20
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-0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e-avalanche'
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-0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e-avalanche'
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