with eth_data as (select origin_function_signature, count(distinct eth_from_address) as depositors_count, count(distinct tx_hash) as txs_count, sum(amount_usd) as all_amount_usd

from ethereum.core.ez_eth_transfers

where eth_to_address = lower('0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d')

and origin_function_signature = '0xf6326fb3'

and eth_from_address <> '0x0000000000000000000000000000000000000000'

group by 1),

other_coins_data as (select origin_function_signature, count(distinct from_address) as depositors_count, count(distinct tx_hash) as txs_count, sum(amount_usd) as all_amount_usd

from ethereum.core.ez_token_transfers

where to_address = lower('0x5f6ae08b8aeb7078cf2f96afb089d7c9f51da47d')

and origin_function_signature in ('0x0a553dcb','0x3265aead','0xf688bcfb','0x365833e1')

and from_address <> '0x0000000000000000000000000000000000000000'

group by 1)

select case

when origin_function_signature = '0xf6326fb3' then 'ETH'

when origin_function_signature = '0x0a553dcb' then 'USDT'

when origin_function_signature = '0x3265aead' then 'stETH'

when origin_function_signature = '0xf688bcfb' then 'USDC'

when origin_function_signature = '0x365833e1' then 'DAI'

else null end as token_name, sum(depositors_count) as total_depositors_count, sum(txs_count) as total_txs_count, CONCAT('$', CAST(sum(all_amount_usd) as DECIMAL(18,2))) as total_amount_usd

from

(select *

from eth_data

union

select *

from other_coins_data)