A as( select date, protocol, revenue,

sum(revenue) over(partition by protocol order by date) as revenue_growth

from external.defillama.fact_protocol_fees_revenue

where PROTOCOL in ('Unibot','Banana Gun')

)

select * from A

order by date desc