pools as (

select

distinct address_name as pool,

min(block_timestamp) as debut

-- signers[0] as users

from solana.core.fact_transfers x

join solana.core.dim_labels y on x.tx_to=y.address

where block_timestamp>='2022-03-23' -- orca whirlpools launch

and label_type = 'dex' and label_subtype = 'pool' and label ='orca' and address_name not like '%aquafarm%'

--and x.index like '%4%'

group by 1

),

users as (

select

distinct tx_from as user,

min(block_timestamp) as debut

-- signers[0] as users

from solana.core.fact_transfers x

join solana.core.dim_labels y on x.tx_to=y.address

where block_timestamp>='2022-03-23' -- orca whirlpools launch

and label_type = 'dex' and label_subtype = 'pool' and label ='orca' and address_name not like '%aquafarm%'

--and x.index like '%4%'

group by 1

)

select

ifnull(count(distinct user),0) as new_users,

ifnull(count(distinct pool),0) as new_pools

from users x

join pools y