inc-purple

Updated 2024-09-11

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 >= '2023-01-01'

and block_timestamp < '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 from_address in (lower('0x2c3C48dcFA3875b5D181033A5ffFe1584270462a'),lower('0x4838B106FCe9647Bdf1E7877BF73cE8B0BAD5f97'))

and nonce =1

and block_timestamp >= '2023-01-01'

and block_timestamp < '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

(

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

where 1=1

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

and nonce =1

and block_timestamp >= '2023-01-01'

Last run: 21 days ago

1KB

120s

flipside