Documentation Index
Fetch the complete documentation index at: /docs/llms.txt
Use this file to discover all available pages before exploring further.
Daily Fees and Revenue for each tracked project, broken out to Ethereum.
metrics_project_chains: one table per measure, one row per project per chain per day.metrics_projects serves without the chain breakout, so use these tables when the chain breakdown is the question.
Every column is documented at Projects ▸ Metrics.
select
daily.timestamp,
daily.fees
from `metrics_project_chains.fees_daily` as daily
where daily.timestamp >= timestamp('2026-08-16')
and daily.timestamp < timestamp('2026-08-23')
and daily.chain_id = 'ethereum'
and daily.project_id = 'uniswap'
order by daily.timestamp
with by_chain as (
select
chain_id,
sum(fees) as fees
from `metrics_project_chains.fees_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