with tornado_address as ( select address, address_name
from ethereum.core.dim_labels
where label = 'tornado cash')
,
receive as ( select date(block_timestamp) as date, tx_hash , ETH_TO_ADDRESS as wallet, 'ETH' as symbol , amount_usd
from ethereum.core.ez_eth_transfers
where eth_to_address in ( select address from tornado_address) and block_timestamp::date >= CURRENT_DATE - 365
UNION
select date(block_timestamp) as date, tx_hash , TO_ADDRESS as wallet , symbol , amount_usd
from ethereum.core.ez_token_transfers
where TO_ADDRESS in ( select address from tornado_address) and block_timestamp::date >= CURRENT_DATE - 365
)
select wallet , sum(amount_usd) as volume , count(DISTINCT(tx_hash)) as total
from receive
where symbol is not null
group by 1
order by 2 desc
limit 10