with eth_to_op as (select
'ETH' as currency,
count(distinct tx_hash) as bridges,
count(distinct origin_from_address) as users,
sum(amount_usd) as usd_vol
from ethereum.core.ez_eth_transfers
where origin_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
union all
select
symbol as currency,
count(distinct tx_hash) as bridges,
count(distinct origin_from_address) as users,
sum(amount) as usd_vol
from ethereum.core.ez_token_transfers
where origin_to_address = '0x99c9fc46f92e8a1c0dec1b1747d010903e884be1'
group by 1)
select currency, bridges
from eth_to_op
where currency is not null
order by 2 desc
limit 10