Apps

An app is one deployed version of a protocol that a project runs, such as uniswap-v3. The project level sits on Projects.

metrics_app_chains: one table per measure, one row per app per chain per day.

An app’s figure on Ethereum for one day rolls into its project’s figure on the Projects page, worked out once and served at both levels. An app’s chain rows for one day sum to what metrics_apps serves without the chain breakout, so use these tables when the chain breakdown is the question. An app’s activity has a finer table beneath it: a DEX’s volume breaks down pool by pool on DEX, and bridge volume breaks down transfer by transfer on Bridges. Start with the daily figures and drop down when the question needs the detail. Every column is documented at Apps ▸ Metrics.

Sample queries

Apps on Ethereum
Ethereum's share

Rank the apps active on Ethereum by trading volume over one week.

select
    apps.name,
    sum(daily.trading_volume) as trading_volume
from `metrics_app_chains.trading_volume_daily` as daily
join `dimensions.apps` as apps
    using (app_id)
where daily.timestamp >= timestamp('2026-08-16')
  and daily.timestamp < timestamp('2026-08-23')
  and daily.chain_id = 'ethereum'
group by apps.name
order by trading_volume desc

Work out how much of one app runs on Ethereum. Dropping the chain filter and grouping by chain turns the same table into a comparison across every chain the app runs on.

with by_chain as (
    select
        chain_id,
        sum(trading_volume) as trading_volume
    from `metrics_app_chains.trading_volume_daily`
    where timestamp >= timestamp('2026-08-16')
      and timestamp < timestamp('2026-08-23')
      and app_id = 'uniswap-v3'
    group by chain_id
)

select
    chain_id,
    trading_volume,
    trading_volume / sum(trading_volume) over () as share
from by_chain
order by trading_volume desc
limit 20

Overview

Popular datasets

Market verticals

Chain ecosystems

Core entities

Sample queries

​Sample queries

Sample queries