with acquired_eth_users AS

select 'ethereum' as chain , from_address, sum(1) as "yes" from ethereum.core.fact_transactions

where 1=1

and nonce =1

and block_timestamp::date >= '2023-01-01' and block_timestamp::date < '2024-01-01'

group by 1,2 )

select distinct from_address,'ethereum' as chain, 1 as "yes" from acquired_eth_users nu inner join ethereum.defi.ez_dex_swaps sw

on nu.from_address=sw.origin_from_address

),

acquired_poly_users_swap as

with acquired_poly_users AS

select 'polygon' as chain , from_address, sum(1) as "yes" from polygon.core.fact_transactions

where 1=1

and nonce =1

and block_timestamp::date >= '2023-01-01' and block_timestamp::date < '2024-01-01'

group by 1,2 )

select distinct from_address,'polygon' as chain, 1 as "yes" from acquired_poly_users nu inner join polygon.defi.ez_dex_swaps sw

on nu.from_address=sw.origin_from_address

),

acquired_opti_users_swap as

with acquired_opti_users AS

select 'optimism' as chain , from_address, sum(1) as "yes" from optimism.core.fact_transactions