select

date_trunc('month',date) as monthly,

protocol,

sum(FEES) as collected_fees,

sum(collected_fees) over (order by monthly) as cumulative_collected_fees,

sum(REVENUE) as daily_revenue,

sum(daily_revenue) over (order by monthly) as cumulative_revenue

external.defillama.fact_protocol_fees_revenue

where protocol in ('SushiSwap','Velodrome')

and date> '2022-06-01' and date <='2023-06-12'

group by 1,2

order by 1 asc