with excluded_protocols(protocols) as (SELECT * FROM values(

'chainlink'), ('uniswap'), ('balancer'), ('traderjoe')

, ('kyberswap'), ('aave'), ('dodo'), ('curve'), ('sushiswap'))

,

fees_one_month as (

SELECT sum(fees) as monthly_fees, sum(52 * fees) as annualized_fees, protocol FROM external.defillama.fact_protocol_fees_revenue

where chain = 'arbitrum'

and date > sysdate() - interval '7 days'

and protocol not in (SELECT protocols FROM excluded_protocols)

and fees > 0

GROUP BY 3)

,

fees_two_month as (

SELECT sum(fees) as monthly_fees, sum(52 * fees) as annualized_fees, protocol FROM external.defillama.fact_protocol_fees_revenue

where chain = 'arbitrum'

and date > sysdate() - interval '14 days' and date < sysdate() - interval '7 days'

and protocol not in (SELECT protocols FROM excluded_protocols)

and fees > 0

GROUP BY 3)

SELECT a.annualized_fees as annualized_weekly_fees,

a.monthly_fees as current_week_fees,

b.monthly_fees as last_week_fees,

case when b.monthly_fees > 0 then 100 * (a.monthly_fees - b.monthly_fees) / b.monthly_fees else null end as weekly_change

,

a.protocol