contract_address,

count(distinct tx_hash) as transactions,

count(distinct b.origin_from_address) as users

from avalanche.core.ez_decoded_event_logs b

left join avalanche.core.dim_labels c

on b.contract_address = c.address

where b.block_timestamp > current_date - 30

group by 1

order by 3 desc

limit 10