tornado_eth as (

select

address,

address_name

from crosschain.address_labels

where project_name = 'tornado cash'

and blockchain = 'ethereum' --arbitrum, avalanche, polygon

and label_subtype = 'general_contract'

and address_name like '%eth%' -- usdt,wbtc,dai,usdc,cdai,cusdc [eth,avax,matic]

),

tornado_out as (

select

block_timestamp,

tx_hash,

'out' as direction,

t.eth_from_address as tornado_contract,

e.address_name as contract_name,

t.eth_to_address as user,

amount

from ethereum.core.ez_eth_transfers t join tornado_eth e on t.eth_from_address = e.address

),

tornado_in as (

select

block_timestamp,

tx_hash,

'in' as direction,

t.eth_to_address as tornado_contract,

e.address_name as contract_name,

t.eth_from_address as user,

amount

from ethereum.core.ez_eth_transfers t join tornado_eth e on t.eth_to_address = e.address

),

data as (

select * from tornado_in

union all