Documentation Index
Fetch the complete documentation index at: /docs/llms.txt
Use this file to discover all available pages before exploring further.
Every curated asset issued on X Layer, with daily supply, holders and transfer activity.
dimensions.asset_tokens: one row per deployment.metrics_asset_tokens: one table per measure, one row per deployment per day.select
assets.symbol,
assets.asset_type,
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)
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 = 'xlayer'
order by daily.market_cap_circulating_total desc
limit 20
select
assets.asset_type,
count(*) as deployments,
countif(deployments.bridged_status = 'native') as native
from `dimensions.asset_tokens` as deployments
join `dimensions.assets` as assets
using (asset_id)
where deployments.chain_id = 'xlayer'
group by assets.asset_type
order by deployments desc
asset_token_id is the asset, the token address and the chain with dashes. Each measure is its own table, so reading two means a join on asset_token_id and timestamp. Both tables here read the native side of the deployment. A bridged deployment reads the _bridged pair instead.with supply as (
select
timestamp,
market_cap_circulating_native
from `metrics_asset_tokens.market_cap_circulating_native_daily`
where asset_token_id = 'usdc-0x74b7f16337b8972027f6196a17a631ac6de26d22-xlayer'
and timestamp >= timestamp('2026-08-16')
and timestamp < timestamp('2026-08-23')
),
holders as (
select
timestamp,
holders_native
from `metrics_asset_tokens.holders_native_daily`
where asset_token_id = 'usdc-0x74b7f16337b8972027f6196a17a631ac6de26d22-xlayer'
and timestamp >= timestamp('2026-08-16')
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