select * from flipside_prod_db.crosschain.address_labels

where address_name ilike '%tornado%'),

tokens_volume as (

select to_address, address_name as token_address, count(tx_hash) as frequency, sum(amount_usd) as token_vol

from ethereum.core.ez_token_transfers l

inner join tornado_addresses t on t.address = l.to_address

where origin_to_address = '0xd90e2f925da726b50c4ed8d0fb90ad053324f31b'

and block_timestamp >= '2022-07-01'

and block_timestamp <= '2022-07-30'

and to_address != '0xd90e2f925da726b50c4ed8d0fb90ad053324f31b'

group by to_address, token_address

order by 3 DESC),

eth_volume as (

select eth_to_address, address_name as eth_address, count(distinct tx_hash) as frequency,

sum(amount_usd) as eth_vol

from ethereum.core.ez_eth_transfers l

inner join tornado_addresses t on t.address = l.eth_to_address

where origin_to_address = '0xd90e2f925da726b50c4ed8d0fb90ad053324f31b'

and block_timestamp >= '2022-07-30'

and block_timestamp <= CURRENT_DATE

and eth_to_address in (

'0x47ce0c6ed5b0ce3d3a51fdb1c52dc66a7c3c2936',

'0x910cbd523d972eb0a6f4cae4618ad62622b39dbf',

'0x12d66f87a04a9e220743712ce6d9bb1b5616b8fc',

'0xa160cdab225685da1d56aa342ad8841c3b53f291')

group by eth_to_address, eth_address

order by 3 DESC

select token_address, token_vol, frequency, 'Non-ETH' as label

from tokens_volume

union

select eth_address, eth_vol, frequency, 'ETH' as label