select

address,

address_name

from crosschain.address_labels

where project_name like 'tornado cash'

and blockchain like 'ethereum' )

select

case when amount between .01 and .1 then 'Between 0.01 to 0.1 Eth'

when amount between .1 and 1 then 'Between 0.1 to 1 Eth'

when amount between 1 and 10 then 'Between 1 to 10 Eth'

when amount between 10 and 100 then 'Between 10 to 100 Eth'

else 'More than 100 ETH'

end as catg,

count(distinct tx_hash) as num_transactions

from ethereum.core.ez_eth_transfers left outer join tor on ETH_to_address = address

where ETH_to_address in (select address from tor)

and block_timestamp > '2022-08-08'

group by 1

having catg is not null