A as ( select date, protocol,

sum(fees) over (partition by protocol order by date) as "Total Fees",

sum(revenue) over (partition by protocol order by date) as "Total Revenue"

from external.defillama.fact_protocol_fees_revenue

where protocol = 'Optimism')

select * from A