with maintable as (

select *

from external.defillama.fact_protocol_fees_revenue

where protocol ilike '%thruster%'

union all

select *

from external.defillama.fact_protocol_fees_revenue

where protocol ilike '%joe%'

and chain ilike '%avalanche%'

order by date desc)

select date,

case when protocol ilike '%thruster%' then 'Thruster'

else 'Trader Joe' end as platform,

sum (fees) as Generated_Fees,

sum (Generated_Fees) over (partition by platform order by date) as Cumulative_Fees

from maintable

group by 1,2

order by 1 desc,platform asc