with acquired_eth_users_chain as

with acquired_eth_users AS

(select

'ethereum' as chain,

from_address,

sum(1) as "yes"

from ethereum.core.fact_transactions

where 1=1

-- and from_address in (lower('0x2c3C48dcFA3875b5D181033A5ffFe1584270462a'),lower('0x4838B106FCe9647Bdf1E7877BF73cE8B0BAD5f97'))

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

),

acquired_poly_users_chain 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

),

acquired_opti_users_chain as

with acquired_opti_users AS