t1 as (

select

trunc(x.block_timestamp,'day') as date,

case when block_timestamp<'2022-09-15' then 'Before merge'

else 'After merge'end as period,

count(distinct tx_hash) as adds,

count(distinct origin_from_address) as wallets,

sum(amount_usd) as volume,

sum(volume) over (order by date) as cum_volume

from ethereum.core.ez_token_transfers x

join ethereum.core.dim_dex_liquidity_pools y on x.to_address = y.pool_address

where origin_function_signature in ('0xf305d719','0xe8e33700') and y.platform = 'sushiswap'

and block_timestamp between '2022-09-01' and '2022-09-30'

group by 1,2

order by 1 asc

),

t2 as (

select

trunc(x.block_timestamp,'day') as date,

case when block_timestamp<'2022-09-15' then 'Before merge'

else 'After merge'end as period,

count(distinct tx_hash) as adds,

count(distinct origin_from_address) as wallets,

sum(amount_usd) as volume,

sum(volume) over (order by date) as cum_volume

from ethereum.core.ez_token_transfers x

join ethereum.core.dim_dex_liquidity_pools y on x.from_address = y.pool_address

where origin_function_signature in ('0xbaa2abde','0x02751cec','0x02751cec','0xded9382a','0x5b0d5984') and y.platform = 'sushiswap'

and block_timestamp between '2022-09-01' and '2022-09-30'

group by 1,2

order by 1 asc

select

t1.date,

t1.cum_volume as total_volume_added_usd,