from ethereum.transactions

where to_address_name = 'sushiswap' and block_timestamp >= '2021-01-01'

group by 1),

uni as (select date_trunc('week', block_timestamp) as dt, count(distinct from_address) as uni_users

from ethereum.transactions

where to_address_name = 'uniswap' and block_timestamp >= '2021-01-01'

group by 1)

select a.dt, a.sushi_users, b.uni_users, (a.sushi_users + b.uni_users) as total, (a.sushi_users/total)*100 as sushi_percentage, (b.uni_users/total)*100 as uni_percentage

from sushi a

join uni b on a.dt=b.dt