Projects

The top of the catalog breaks activity down by who ran it. A project is the entity behind a protocol, such as Uniswap. An app is one deployed version that project runs, such as uniswap-v3.

metrics.apps_chains_daily: one row per app per chain per day.
metrics.projects_chains_daily: one row per project per chain per day.

Every column is documented at Projects ▸ Metrics.

Sample queries

Apps on ZKsync Era
One project's series
ZKsync Era's share

Rank the apps active on ZKsync Era by fees over one week.

select
    apps.name,
    sum(daily.fees) as fees,
    sum(daily.revenue) as revenue
from `metrics.apps_chains_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 = 'zksyncera'
group by apps.name
order by fees desc

Read one project’s daily ZKsync Era fees.

select
    daily.timestamp,
    daily.fees,
    daily.revenue
from `metrics.projects_chains_daily` as daily
where daily.timestamp >= timestamp('2026-08-16')
  and daily.timestamp < timestamp('2026-08-23')
  and daily.chain_id = 'zksyncera'
  and daily.project_id = 'uniswap'
order by daily.timestamp

Work out how much of a project runs on ZKsync Era. Dropping the chain filter and grouping by chain turns the same table into a comparison across every chain the project operates on.

with by_chain as (
    select
        chain_id,
        sum(fees) as fees
    from `metrics.projects_chains_daily`
    where timestamp >= timestamp('2026-08-16')
      and timestamp < timestamp('2026-08-23')
      and project_id = 'uniswap'
    group by chain_id
)

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

Notes

The two tables hold the same measures at two levels. A project figure for one chain and one day is the sum of its apps on that chain and day, worked out once and served at both levels. The same holds across chains: a project’s chain rows for one day sum to what metrics.projects_daily serves without the chain breakout, so use the chain tables when the chain breakdown is the question. Each 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

Market verticals

Chain verticals

Sample queries

Notes

​Sample queries

​Notes

Sample queries

Notes