from ethereum.core.ez_dex_swaps

where platform in ('balancer','uniswap-v2')

and amount_in_usd < 10000000

group by 2,3)

,

optimism as ( select min(block_timestamp::date) as date, origin_from_address, platform

from optimism.velodrome.ez_swaps

where amount_in_usd < 10000000

group by 2,3

select min(block_timestamp::date) as date, origin_from_address, platform

from optimism.sushi.ez_swaps

where amount_in_usd < 10000000

group by 2,3)

,

raydium as ( select min(block_timestamp::date) as date, swapper , swap_program as platform

from solana.core.fact_swaps

where (SWAP_PROGRAM ilike '%raydium%' or SWAP_PROGRAM ilike '%jupiter%' )

group by 2,3)

,

final as ( select date, platform, count(DISTINCT(origin_from_address)) as total_user,

sum(total_user) over (order by date asc) as cum_user

from ethereum

where date >= '2022-10-01'

group by 1,2

select date, platform, count(DISTINCT(origin_from_address)) as total_user,

sum(total_user) over (order by date asc) as cum_user

from optimism

where date >= '2022-10-01'

group by 1,2

select date, platform, count(DISTINCT(swapper)) as total_user,

sum(total_user) over (order by date asc) as cum_user

from raydium