(select *, cumulative_fees_in_K/POW(10,3) as cumulative_fees_in_M from (select *,

sum(fees_in_K) over ( PARTITION by pool_name order by week_no) as cumulative_fees_in_K

from (select *, case when fees> 10000 then fees/pow(10,18) else fees end as fees_in_K from (select week(block_timestamp) as week_no, pool_name, sum(amount_usd)/pow(10,6) as volume_in_M, sum(amount_usd)*0.04/pow(10,5) as fees,count(DISTINCT(from_address)) as unique_users from ethereum.dex_swaps

where platform = 'curve' and timestampdiff(SQL_TSI_DAY,block_timestamp,'2022-01-01')< 366

group by week_no, pool_name))))

order by weeK_no , fees_in_K desc