project_name as project,

count (distinct tx_hash) as TX_Count,

count (distinct origin_from_address) as Users_Count,

sum (AMOUNT) as Total_Volume

from avalanche.core.ez_token_transfers t1

join avalanche.core.dim_labels t2 on t1.to_address = t2.address

where contract_address = '0xb97ef9ef8734c71904d8002f8b6bc66dd9c48a6e'

AND BLOCK_TIMESTAMP >= current_date - interval '{{Past_Months}} MONTH'

group by 1

order by 2 DESC

limit 10