select
TO_ADDRESS as tornado_cash_address,
ADDRESS_NAME as tornado_cash_address_name,
count(distinct TX_HASH) as number_of_received_transactions
from
ethereum.core.fact_transactions join flipside_prod_db.crosschain.address_labels
on TO_ADDRESS = ADDRESS
where
lower(PROJECT_NAME) like '%tornado%' AND STATUS = 'SUCCESS' and date(BLOCK_TIMESTAMP) > CURRENT_DATE - 365
GROUP by
TO_ADDRESS, ADDRESS_NAME
ORDER by
number_of_received_transactions desc
limit 10