b 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 = 'Near'

select * from b

order by 1 desc