auserlist1 as (

(

select

sender

from

avalanche.core.ez_dex_swaps

where

token_in = lower('0x68327a91E79f87F501bC8522fc333FB7A72393cb') --AUX

or token_out = lower('0x68327a91E79f87F501bC8522fc333FB7A72393cb')

group by

1

)

union

(

select

sender

from

avalanche.core.ez_dex_swaps

where

token_in = lower('0x13E7bceFddE72492E656f3fa58baE6029708e673') --AgX

or token_out = lower('0x13E7bceFddE72492E656f3fa58baE6029708e673')

group by

1

)

),

raw as (select ft.*, sender ,project_name from avalanche.core.fact_token_transfers ft

inner join auserlist1 on auserlist1.sender=ft.from_address

inner join avalanche.core.dim_labels l on ft.to_address=l.address)

select project_name, count(distinct sender) as n_wallet_address,

count(distinct tx_hash) as n_txn

from raw

group by 1