date(block_timestamp) as date,

platform,

from ethereum.core.ez_dex_swaps

where amount_in_usd < 1000000 )

,

sushi as ( select min(date) as min_date, origin_from_address

from swaps

where platform = 'sushiswap'

group by 2)

,

uni_v2 as (select min(date) as min_date, origin_from_address

from swaps

where platform = 'uniswap-v2'

group by 2 )

,

balancer as ( select min(date) as min_date, origin_from_address

from swaps

where platform = 'balancer'

group by 2)

,

uni_v3 as ( select min(date) as min_date, origin_from_address

from swaps

where platform = 'uniswap-v3'

group by 2)

,

curve as ( select min(date) as min_date, origin_from_address

from swaps

where platform = 'curve'

group by 2)

select 'curve' as plat, trunc(min_date,'week') as weekly, count(DISTINCT(origin_from_address)) as new_user, sum(new_user) over (order by weekly) as cum_new

from curve

where min_date >= '2022-01-01'

group by 1,2