BlockTrackerrevenue
Updated 2025-01-20
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select
date_trunc('week', date) as week,
chain,
sum(REVENUE) as revenue
from external.defillama.fact_protocol_fees_revenue
where date >= current_date -90
group by 1 , 2
order by week desc
-- where revenue is not null
-- qualify row_number () over (partition by week order by revenue desc) <= 20
QueryRunArchived: QueryRun has been archived