select CONTRACT_ADDRESS, contracts.name, TO_ADDRESS, COUNT(TX_HASH) from ethereum.core.ez_token_transfers as transactions
JOIN ethereum.core.dim_contracts as contracts
ON
transactions.contract_address = contracts.address
GROUP BY CONTRACT_ADDRESS, contracts.name, TO_ADDRESS
ORDER BY COUNT(TX_HASH) DESC
--where TX_HASH = '0xc281511f64f2321b14ba5161167ff1475e41d5081b726fe2dbf1ca2e69396fb3'
limit 1000