Screener

One row per asset in screeners.assets, per asset per chain in screeners.assets_by_chain and per asset token in screeners.asset_tokens, every figure as of as_of, the last complete day. Each measure has a column per window and aggregation, named <measure>_<window>_<aggregation>: market_cap_circulating_max_latest is the latest circulating market cap, and mints_30d_sum the value minted over the 30 days ending on as_of.

Columns

Keys
Aggregations
Asset measures
Asset chain measures
Asset token measures

Each table has as_of and its key, then one FLOAT64 column per measure, window and aggregation. Every row is an asset in dimensions.assets, an asset chain in dimensions.assets_by_chain or an asset token in dimensions.asset_tokens, so the join on the key always matches.

Column	Type	Description
`as_of`	TIMESTAMP	The last complete day, the same on every row of every table. Every window ends on it.
`asset_id`	STRING	Asset the row belongs to in `screeners.assets`, such as `usdc`; joins `dimensions.assets`.
`asset_chain_id`	STRING	Asset chain the row belongs to in `screeners.assets_by_chain`: one asset’s deployments on one chain, formatted `{asset_id}-{chain_id}`. Joins `dimensions.assets_by_chain`.
`asset_token_id`	STRING	Asset token the row belongs to in `screeners.asset_tokens`: one asset’s token contract on one chain, formatted `{asset_id}-{token_address}-{chain_id}`. Joins `dimensions.asset_tokens`.

A window is 1d, 7d, 30d, 90d, 180d or 365d, and spans that many days ending on as_of, while the max_ columns read the whole history. Which aggregations a measure has follows its over_time in Metric definitions: only a measure whose over_time is sum has sum.

Column	What it holds
`<measure>_<window>_avg`	Mean of the daily values over the window.
`<measure>_<window>_sum`	Total of the daily values over the window. Flows only: the measures ticked under Sum.
`<measure>_<window>_change`	A comparison of two aggregations: the value on `as_of` against the value one window earlier, as `(now - then) / abs(then)`. Null when either value is missing or the earlier one is 0.
`<measure>_<window>_trend`	A comparison of two aggregations: the window’s average against the average of the window before it, as `(avg - prior) / abs(prior)`. Null unless the window before has a value on every one of its days, and null when its average is 0.
`<measure>_max_latest`	The value on `as_of`. Null when there is none.
`<measure>_max_ath`	The highest daily value over the whole history.
`<measure>_max_atl`	The lowest daily value over the whole history.

One row per asset, in screeners.assets. Every measure has the avg, change, trend and max_ columns, and the flows also have sum.

Measure	Sum	What it holds
`daily_active_users_agentic`	✗	Distinct addresses making agentic (x402) payments in the asset on the day, across every deployment.
`monthly_active_users_agentic`	✗	Distinct addresses making agentic (x402) payments in the asset over the trailing month, across every deployment.
`weekly_active_users_agentic`	✗	Distinct addresses making agentic (x402) payments in the asset over the trailing week, across every deployment.
`app_trading_volume`	✓	DEX trading volume: value of spot trades involving the asset on onchain venues (DEX pools and onchain order books), USD, summed across them and across chains. Every trade counts on both of its tokens, so this does not add up across assets. The app tabs split the same figure by app and by deployment.
`app_tvl`	✗	DeFi TVL: value of the asset deposited into the apps we cover, USD, summed across them and across chains. The app tabs split the same figure by app and by deployment.
`apy`	✗	The asset’s yield over the past year, written as a fraction: `0.05` means five percent. Measured once per asset per day, and never added up.
`holders`	✗	Addresses holding a non-zero balance, summed across every deployment of the asset. A sum of per-deployment counts, so an address holding the asset on two chains counts twice.
`holders_bridged`	✗	Addresses holding a non-zero balance, summed across the asset’s bridged deployments.
`holders_native`	✗	Addresses holding a non-zero balance, summed across the asset’s natively-issued deployments.
`market_cap_circulating`	✗	Circulating market cap across every form of the asset, USD: native issuance plus bridged wrappers. Counts tokens outstanding rather than economic value, because a bridged wrapper stands in for native supply that the same figure already counts.
`market_cap_circulating_bridged`	✗	Circulating market cap of the asset’s bridged deployments, USD. A bridged deployment is a wrapper standing in for supply issued natively on another chain.
`market_cap_circulating_native`	✗	Circulating market cap of the asset’s natively-issued supply, USD. This is the measure that answers how much of the asset exists. It includes anything the issuer reports as held off-chain, which is why the asset figure runs above its deployment rows added together, by exactly that amount.
`mints`	✓	Value minted on the day, USD, summed across every deployment. A genuine total: minting on a bridged deployment is its own event, not a second view of a native one.
`mints_bridged`	✓	Value minted on the day, USD, summed across the asset’s bridged deployments.
`mints_native`	✓	Value minted on the day, USD, summed across the asset’s natively-issued deployments.
`off_peg`	✗	How far the asset’s price sits from its peg, as a fraction: `(price - reference) / reference`. `-0.02` means two percent below peg. The peg is the asset’s `reference_asset_id`: the dollar’s rate is 1 and every other currency takes its end-of-day FX rate, listed on Stablecoins ▸ Metrics.
`price`	✗	The asset’s price in USD, one figure per asset per day. Where more than one source has a price, we take them in a fixed order of preference. The label of the source is on `metrics_assets.price_daily`, not in the screener.
`redemptions`	✓	Value redeemed on the day, USD, summed across every deployment. A genuine total.
`redemptions_bridged`	✓	Value redeemed on the day, USD, summed across the asset’s bridged deployments.
`redemptions_native`	✓	Value redeemed on the day, USD, summed across the asset’s natively-issued deployments.
`transfer_count`	✓	Number of transfers on the day, summed across every deployment. A genuine total.
`transfer_count_agentic`	✓	Number of agentic (x402) transfers on the day, summed across every deployment. A genuine total.
`transfer_count_agentic_bridged`	✓	Number of agentic (x402) transfers on the day, summed across the asset’s bridged deployments.
`transfer_count_agentic_native`	✓	Number of agentic (x402) transfers on the day, summed across the asset’s natively-issued deployments.
`transfer_count_bridged`	✓	Number of transfers on the day, summed across the asset’s bridged deployments.
`transfer_count_native`	✓	Number of transfers on the day, summed across the asset’s natively-issued deployments.
`transfer_volume`	✓	Value transferred on the day, USD, summed across every deployment. A genuine total.
`transfer_volume_agentic`	✓	Value transferred by agentic (x402) flows on the day, USD, summed across every deployment. A genuine total.
`transfer_volume_agentic_bridged`	✓	Value transferred by agentic (x402) flows on the day, USD, summed across the asset’s bridged deployments.
`transfer_volume_agentic_native`	✓	Value transferred by agentic (x402) flows on the day, USD, summed across the asset’s natively-issued deployments.
`transfer_volume_bridged`	✓	Value transferred on the day, USD, summed across the asset’s bridged deployments.
`transfer_volume_native`	✓	Value transferred on the day, USD, summed across the asset’s natively-issued deployments.
`daily_active_users`	✗	Distinct addresses sending the asset on the day, counted across every deployment in one pass. The deployment tables split the same count native from bridged, and Senders holds the addresses themselves for any wider figure.
`monthly_active_users`	✗	Distinct addresses sending the asset over the trailing month, across every deployment.
`weekly_active_users`	✗	Distinct addresses sending the asset over the trailing week, across every deployment.

One row per asset per chain, in screeners.assets_by_chain. A flow’s sum adds up across an asset’s chains to the asset’s figure; a holder or user count, a change and a trend each describe one chain alone.

Measure	Sum	What it holds
`daily_active_users_agentic`	✗	Distinct addresses making agentic (x402) payments in the asset on the chain on the day, summed across its deployments there.
`monthly_active_users_agentic`	✗	Distinct addresses making agentic (x402) payments in the asset on the chain over the trailing month, summed across its deployments there.
`weekly_active_users_agentic`	✗	Distinct addresses making agentic (x402) payments in the asset on the chain over the trailing week, summed across its deployments there.
`app_trading_volume`	✓	DEX trading volume: value of spot trades involving the asset on the chain on onchain venues (DEX pools and onchain order books), USD, summed across them and across its deployments there. Every trade counts on both of its tokens, so this does not add up across assets.
`app_tvl`	✗	DeFi TVL: value of the asset on the chain deposited into the apps we cover, USD, summed across them and across its deployments there.
`apy`	✗	The asset’s yield over the past year on the chain, written as a fraction: `0.05` means five percent. Averaged across its deployments there, and never added up.
`holders`	✗	Addresses holding a non-zero balance, summed across the asset’s deployments on the chain. A sum of per-deployment counts: an address holding two of them counts twice, which only moves chains with more than one deployment of the asset.
`holders_bridged`	✗	Addresses holding a non-zero balance, summed across the asset’s bridged deployments on the chain.
`holders_native`	✗	Addresses holding a non-zero balance, summed across the asset’s natively-issued deployments on the chain.
`market_cap_circulating`	✗	Circulating market cap of the asset on the chain, USD, summed across every deployment there, native and bridged.
`market_cap_circulating_bridged`	✗	Circulating market cap of the asset’s bridged deployments on the chain, USD, summed across them.
`market_cap_circulating_native`	✗	Circulating market cap of the asset’s natively-issued deployments on the chain, USD, summed across them.
`mints`	✓	Value minted on the day, USD, summed across every deployment on the chain.
`mints_bridged`	✓	Value minted on the day, USD, summed across the asset’s bridged deployments on the chain.
`mints_native`	✓	Value minted on the day, USD, summed across the asset’s natively-issued deployments on the chain.
`redemptions`	✓	Value redeemed on the day, USD, summed across every deployment on the chain.
`redemptions_bridged`	✓	Value redeemed on the day, USD, summed across the asset’s bridged deployments on the chain.
`redemptions_native`	✓	Value redeemed on the day, USD, summed across the asset’s natively-issued deployments on the chain.
`transfer_count`	✓	Number of transfers on the day, summed across every deployment on the chain.
`transfer_count_agentic`	✓	Number of agentic (x402) transfers on the day, summed across every deployment on the chain.
`transfer_count_agentic_bridged`	✓	Number of agentic (x402) transfers on the day, summed across the asset’s bridged deployments on the chain.
`transfer_count_agentic_native`	✓	Number of agentic (x402) transfers on the day, summed across the asset’s natively-issued deployments on the chain.
`transfer_count_bridged`	✓	Number of transfers on the day, summed across the asset’s bridged deployments on the chain.
`transfer_count_native`	✓	Number of transfers on the day, summed across the asset’s natively-issued deployments on the chain.
`transfer_volume`	✓	Value transferred on the day, USD, summed across every deployment on the chain.
`transfer_volume_agentic`	✓	Value transferred by agentic (x402) flows on the day, USD, summed across every deployment on the chain.
`transfer_volume_agentic_bridged`	✓	Value transferred by agentic (x402) flows on the day, USD, summed across the asset’s bridged deployments on the chain.
`transfer_volume_agentic_native`	✓	Value transferred by agentic (x402) flows on the day, USD, summed across the asset’s natively-issued deployments on the chain.
`transfer_volume_bridged`	✓	Value transferred on the day, USD, summed across the asset’s bridged deployments on the chain.
`transfer_volume_native`	✓	Value transferred on the day, USD, summed across the asset’s natively-issued deployments on the chain.
`daily_active_users`	✗	Distinct addresses sending the asset on the chain on the day, summed across its deployments there. An address sending two of them counts twice, which only moves chains with more than one deployment of the asset.
`monthly_active_users`	✗	Distinct addresses sending the asset on the chain over the trailing month, summed across its deployments there.
`weekly_active_users`	✗	Distinct addresses sending the asset on the chain over the trailing week, summed across its deployments there.

One row per asset token, in screeners.asset_tokens. A flow’s sum adds up across an asset’s tokens to the asset’s figure; a holder or user count, a change and a trend each describe one token alone.

Measure	Sum	What it holds
`daily_active_users_agentic_bridged`	✗	Distinct addresses making agentic (x402) payments in the deployment on the day. Bridged deployments only.
`daily_active_users_agentic_native`	✗	Distinct addresses making agentic (x402) payments in the deployment on the day. Natively-issued deployments only.
`monthly_active_users_agentic_bridged`	✗	Distinct addresses making agentic (x402) payments in the deployment over the trailing month. Bridged deployments only.
`monthly_active_users_agentic_native`	✗	Distinct addresses making agentic (x402) payments in the deployment over the trailing month. Natively-issued deployments only.
`weekly_active_users_agentic_bridged`	✗	Distinct addresses making agentic (x402) payments in the deployment over the trailing week. Bridged deployments only.
`weekly_active_users_agentic_native`	✗	Distinct addresses making agentic (x402) payments in the deployment over the trailing week. Natively-issued deployments only.
`app_trading_volume`	✓	DEX trading volume: value of spot trades involving the deployment on onchain venues (DEX pools and onchain order books), USD, summed across them. Every trade counts on both of its tokens, so this does not add up across assets.
`app_tvl`	✗	DeFi TVL: value of the deployment deposited into the apps we cover, USD, summed across them.
`apy`	✗	Yield over the past year, written as a fraction and kept within `(0, 0.50]`. Measured once per asset, on the deployment with the largest circulating market cap, then copied onto the asset’s other deployments. Every deployment row for an asset holds the same value, so adding them multiplies the rate.
`holders`	✗	Addresses holding a non-zero balance of the deployment, whichever side it sits on.
`holders_bridged`	✗	Addresses holding a non-zero balance of the deployment. Bridged deployments only.
`holders_native`	✗	Addresses holding a non-zero balance of the deployment. Natively-issued deployments only.
`market_cap_circulating`	✗	Circulating market cap of the deployment, USD, whichever side it sits on. Not a sum: a deployment is one or the other, so this is simply its value.
`market_cap_circulating_bridged`	✗	Circulating market cap of the deployment, USD. Bridged deployments only.
`market_cap_circulating_native`	✗	Circulating market cap of the deployment, USD. Natively-issued deployments only.
`mints`	✓	Value minted on the deployment on the day, USD, whichever side it sits on.
`mints_bridged`	✓	Value minted on the deployment on the day, USD. Bridged deployments only.
`mints_native`	✓	Value minted on the deployment on the day, USD. Natively-issued deployments only.
`redemptions`	✓	Value redeemed on the deployment on the day, USD, whichever side it sits on.
`redemptions_bridged`	✓	Value redeemed on the deployment on the day, USD. Bridged deployments only.
`redemptions_native`	✓	Value redeemed on the deployment on the day, USD. Natively-issued deployments only.
`transfer_count`	✓	Number of transfers on the deployment on the day, whichever side it sits on.
`transfer_count_agentic`	✓	Number of agentic (x402) transfers on the deployment on the day, whichever side it sits on.
`transfer_count_agentic_bridged`	✓	Number of agentic (x402) transfers on the deployment on the day. Bridged deployments only.
`transfer_count_agentic_native`	✓	Number of agentic (x402) transfers on the deployment on the day. Natively-issued deployments only.
`transfer_count_bridged`	✓	Number of transfers on the deployment on the day. Bridged deployments only.
`transfer_count_native`	✓	Number of transfers on the deployment on the day. Natively-issued deployments only.
`transfer_volume`	✓	Value transferred on the deployment on the day, USD, whichever side it sits on.
`transfer_volume_agentic`	✓	Value transferred by agentic (x402) flows on the deployment on the day, USD, whichever side it sits on.
`transfer_volume_agentic_bridged`	✓	Value transferred by agentic (x402) flows on the deployment on the day, USD. Bridged deployments only.
`transfer_volume_agentic_native`	✓	Value transferred by agentic (x402) flows on the deployment on the day, USD. Natively-issued deployments only.
`transfer_volume_bridged`	✓	Value transferred on the deployment on the day, USD. Bridged deployments only.
`transfer_volume_native`	✓	Value transferred on the deployment on the day, USD. Natively-issued deployments only.
`daily_active_users_bridged`	✗	Distinct addresses sending the deployment on the day. Bridged deployments only.
`daily_active_users_native`	✗	Distinct addresses sending the deployment on the day. Natively-issued deployments only.
`monthly_active_users_bridged`	✗	Distinct addresses sending the deployment over the trailing month. Bridged deployments only.
`monthly_active_users_native`	✗	Distinct addresses sending the deployment over the trailing month. Natively-issued deployments only.
`weekly_active_users_bridged`	✗	Distinct addresses sending the deployment over the trailing week. Bridged deployments only.
`weekly_active_users_native`	✗	Distinct addresses sending the deployment over the trailing week. Natively-issued deployments only.

Sample queries

One asset
Top 25 by market cap
One chain's assets by market cap
One asset's tokens by holders

Every column of one row shares the same as_of, so the figures read together. market_cap_circulating_30d_change compares the market cap on as_of with 30 days earlier.

select
    as_of,
    market_cap_circulating_max_latest,
    market_cap_circulating_30d_change,
    holders_max_latest,
    mints_30d_sum,
    redemptions_30d_sum
from `screeners.assets`
where asset_id = 'usdc'

market_cap_circulating_max_latest is each asset’s latest circulating market cap, and mints_30d_sum the value minted over the 30 days ending on as_of. The join to dimensions.assets on asset_id adds the name and symbol.

select
    assets.name,
    assets.symbol,
    screener.market_cap_circulating_max_latest,
    screener.mints_30d_sum,
    screener.redemptions_30d_sum
from `screeners.assets` as screener
join `dimensions.assets` as assets
    using (asset_id)
where screener.market_cap_circulating_max_latest is not null
order by screener.market_cap_circulating_max_latest desc
limit 25

dimensions.assets_by_chain gives each row’s asset and chain, so the filter on chain_id picks one chain’s assets. market_cap_circulating_max_latest is the asset’s circulating market cap on that chain on as_of, and mints_30d_sum the value minted there over the 30 days ending on it.

select
    chains.asset_id,
    chains.bridged_status,
    screener.market_cap_circulating_max_latest,
    screener.mints_30d_sum
from `screeners.assets_by_chain` as screener
join `dimensions.assets_by_chain` as chains
    using (asset_chain_id)
where chains.chain_id = 'base'
  and screener.market_cap_circulating_max_latest is not null
order by screener.market_cap_circulating_max_latest desc
limit 25

dimensions.asset_tokens gives each token’s asset, chain and address, so the filter on asset_id picks one asset’s tokens. Holder counts describe one token each, which makes them a ranking key across an asset’s tokens.

select
    tokens.chain_id,
    tokens.token_address,
    screener.holders_max_latest,
    screener.market_cap_circulating_max_latest,
    screener.transfer_volume_30d_sum
from `screeners.asset_tokens` as screener
join `dimensions.asset_tokens` as tokens
    using (asset_token_id)
where tokens.asset_id = 'usdc'
order by screener.holders_max_latest desc

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Columns

Sample queries

​Columns

​Sample queries

Columns

Sample queries