select * from flipside_prod_db.crosschain.address_labels

where project_name = 'tornado cash'

select

eth_to_address,

address_name,

sum(amount) as eth_volume,

sum(amount_usd) as usd_volume,

count(distinct tx_hash) as number_of_transactions,

count(distinct eth_from_address) as users,

date_trunc('day', block_timestamp::date) as TIME

from ethereum.core.ez_eth_transfers

inner join tornado_addresses on address = eth_to_address

where eth_to_address in (select address from tornado_addresses)

and eth_to_address in (

'0xd90e2f925da726b50c4ed8d0fb90ad053324f31b',

'0x47ce0c6ed5b0ce3d3a51fdb1c52dc66a7c3c2936',

'0x12d66f87a04a9e220743712ce6d9bb1b5616b8fc',

'0x910cbd523d972eb0a6f4cae4618ad62622b39dbf',

'0xca0840578f57fe71599d29375e16783424023357',

'0xa160cdab225685da1d56aa342ad8841c3b53f291'

)

and block_timestamp >= '2022-08-01'

group by eth_to_address, address_name, TIME

order by number_of_transactions DESC