Metrics

Circulating market cap, price, yield, holders, mints, redemptions and transfer activity. One row per thing per day, at two grains: asset and deployment.

Tables

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

Asset
Deployment

One row per asset per day. Price and yield belong to the asset itself; every other measure is the asset’s deployments added together.

Table	Value column	What it holds
`metrics_assets.price_daily`	`price`	Asset price in USD (canonical across sources).
`metrics_assets.app_tvl_daily`	`app_tvl`	Value of the asset deposited into onchain apps — lending markets, DEX pools and vaults
`metrics_assets.apy_daily`	`apy`	Annualized yield, native-market-cap-weighted across deployments.
`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_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.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.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_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.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.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.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.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_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_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.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.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. Each deployment is either natively issued or bridged in, and its rows sit in the matching _native or _bridged tables.

Table	Value column	What it holds
`metrics_asset_tokens.apy_daily`	`apy`	Annualized yield of the deployment.
`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.market_cap_circulating_total_daily`	`market_cap_circulating_total`	Circulating market cap 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_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.mints_total_daily`	`mints_total`	Value minted (issued) 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.redemptions_total_daily`	`redemptions_total`	Value redeemed (burned) 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_count_total_daily`	`transfer_count_total`	Transfers 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.transfer_volume_total_daily`	`transfer_volume_total`	Value transferred on the deployment, native or bridged.
`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 all three is a join on asset_id and timestamp, bounded on each side. Join with full join: a fund can publish a price on a day no supply figure landed.

with supply as (
    select timestamp, market_cap_circulating_total
    from `metrics_assets.market_cap_circulating_total_daily`
    where asset_id = 'buidl'
      and timestamp >= timestamp('2026-06-01')
),

price as (
    select timestamp, price
    from `metrics_assets.price_daily`
    where asset_id = 'buidl'
      and timestamp >= timestamp('2026-06-01')
),

yield as (
    select timestamp, apy
    from `metrics_assets.apy_daily`
    where asset_id = 'buidl'
      and timestamp >= timestamp('2026-06-01')
)

select
    timestamp,
    supply.market_cap_circulating_total,
    price.price,
    yield.apy
from supply
full join price
    using (timestamp)
full join yield
    using (timestamp)
order by timestamp

The metric tables hold every asset type, so the type filter comes from dimensions.assets on the join. market_cap_circulating_native counts the supply the issuer minted, the figure for how much of the instrument exists.

select
    assets.asset_id,
    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 = 'tokenized-stocks'
order by daily.market_cap_circulating_native desc
limit 25

issuer_project_id is the project holding the issuer relation, and it is the column the coverage matrix groups on. The supply side is a left join: an asset enters the registry on the day it is listed, ahead of its first daily figure.

select
    assets.asset_id,
    assets.symbol,
    assets.asset_type,
    daily.market_cap_circulating_total
from `dimensions.assets` as assets
left join `metrics_assets.market_cap_circulating_total_daily` as daily
    on daily.asset_id = assets.asset_id
   and daily.timestamp = timestamp('2026-08-01')
where assets.issuer_project_id = 'securitize'
  and assets.asset_type in (
      'tokenized-stocks', 'tokenized-funds',
      'tokenized-commodities'
  )
order by daily.market_cap_circulating_total desc

asset_token_id is the deployment key, and dimensions.asset_tokens has the chain and the bridged_status behind it. The deployment rows of an additive measure add back up to the asset row.

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 = 'buidl'
order by daily.market_cap_circulating_total desc

Summing the native table across deployments counts each unit of supply once, because a bridged wrapper stands for supply already minted somewhere else. The type filter needs both dimension tables: the chain sits on the deployment, the type on the asset.

select
    deployments.chain_id,
    count(distinct deployments.asset_id) as instruments,
    sum(daily.market_cap_circulating_native) as native_supply
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-01')
  and assets.asset_type in (
      'tokenized-stocks', 'tokenized-funds',
      'tokenized-commodities'
  )
group by deployments.chain_id
order by native_supply desc

A rate needs a weight before it reads across assets. Circulating supply is that weight, and it is also how apy rolls up onto the asset from its deployments.

select
    daily.timestamp,
    sum(daily.apy * supply.market_cap_circulating_total)
        / sum(supply.market_cap_circulating_total) as weighted_apy
from `metrics_assets.apy_daily` as daily
join `metrics_assets.market_cap_circulating_total_daily` as supply
    using (asset_id, timestamp)
join `dimensions.assets` as assets
    on assets.asset_id = daily.asset_id
where assets.asset_type = 'tokenized-funds'
  and daily.timestamp >= timestamp('2026-08-01')
group by daily.timestamp
order by daily.timestamp

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Tables

Sample queries

​Tables

​Sample queries

Tables

Sample queries