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

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

from (select distinct tx_from as user,

min(block_timestamp) as debut

from solana.core.fact_transfers x

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

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

and label_type = 'dex'

and label_subtype = 'pool'

and label ='orca'

and address_name not like '%aquafarm%'

group by 1) x

left join (select distinct address_name as pool,

min(block_timestamp) as debut

from solana.core.fact_transfers x

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

where block_timestamp>='2022-03-23'

and label_type = 'dex'

and label_subtype = 'pool'

and label ='orca'

and address_name not like '%aquafarm%'

group by 1) y on trunc(x.debut,'day')=trunc(y.debut,'day')

group by 1