with tornado_addresses as (
select * from flipside_prod_db.crosschain.address_labels
where project_name = 'tornado cash'
),
token_transfers as (
select
from_address,
sum(amount_usd) as usd_volume,
count(distinct tx_hash) as number_of_transactions
from ethereum.core.ez_token_transfers
inner join tornado_addresses on address = to_address
where to_address in (select address from tornado_addresses)
and block_timestamp::date >= '2022-08-01'
and from_address not in (select address from tornado_addresses)
and amount_usd is not null
group by from_address
order by number_of_transactions DESC)
select from_address, usd_volume, number_of_transactions
from token_transfers
order by usd_volume DESC
limit 10