address,

address_name

from flipside_prod_db.crosschain.address_labels

where project_name ilike '%tornado%'

and label_type = 'dapp')

case

when amount >= 0.01 and amount <= 0.1 then '0.01 to 0.1 ETH'

when amount > 0.1 and amount <= 1 then '0.1 to 1 ETH'

when amount > 1 and amount <= 10 then '1 to 10 ETH'

when amount > 10 and amount < 100 then '10 to 100 ETH'

when amount = 100 then '100 ETH'

when amount > 100 and amount <= 1000 then '100 to 1000 ETH'

when amount > 1000 then 'More than 1000 ETH'

else null

end as range,

count(distinct tx_hash) as number_of_tx

from ethereum.core.ez_eth_transfers

where eth_to_address in (select address from tornado)

group by 1

having range is not null