select date_trunc('week', block_timestamp) as week, count(distinct tx_hash) as txns,

sum(amount_usd) as usd_amount, count(distinct from_address) as users, 'USDC' as coin

from ethereum.core.ez_token_transfers

where origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'

and block_timestamp >= '2022-01-01' and symbol='USDC'

group by 1),

eth as (select date_trunc('week', block_timestamp) as week, count(distinct tx_hash) as txns,

sum(amount_usd) as usd_amount, count(distinct origin_from_address) as users, 'ETH' as coin

from ethereum.core.ez_eth_transfers

where origin_to_address = '0x25ace71c97b33cc4729cf772ae268934f7ab5fa1'

and block_timestamp >= '2022-01-01'

group by 1)

select * from usdc

union all

select * from eth