with ETHTable as (
select count (distinct tx_hash) as TX_Count,
count (distinct origin_from_address) as Users_Count,
sum (amount_usd) as USD_Volume,
sum (amount) as Volume
from ethereum.core.ez_eth_transfers
where origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'),
TokenTable as (
select count (distinct tx_hash) as TX_Count,
count (distinct origin_from_address) as Users_Count,
sum (amount_usd) as USD_Volume,
sum (amount) as Volume
from ethereum.core.ez_token_transfers
where origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'
and contract_address = lower('0xA0b86991c6218b36c1d19D4a2e9Eb0cE3606eB48'))
select 'ETH' as type, *
from ethtable
union all
select 'USDC' as type, *
from tokentable