contract_address,

symbol,

name,

sum(Distinct TX_hash) as num_transactions

FROM polygon.core.fact_token_transfers t1 JOIN polygon.core.dim_contracts t2 ON

t1.contract_address = t2.address

Where block_timestamp::Date > '2022-01-01'

Group By 1,2,3

Order by num_transactions DESC