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.

Every column is documented at Apps ▸ Metrics.

Sample queries

Apps on Optimism
Optimism's share

Rank the apps active on Optimism 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 = 'optimism'
group by apps.name
order by trading_volume desc

Work out how much of one app runs on Optimism. 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

Notes

An app’s figure on Optimism 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 this table 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.

Overview

Core entities

Core datasets

Market verticals

Chain verticals

Sample queries

Notes

​Sample queries

​Notes

Sample queries

Notes