with tab1 as (

select TX_HASH

,sum(AMOUNT_USD) as volume

from ethereum.defi.ez_bridge_activity

where BLOCK_TIMESTAMP::date>='2023-01-01'

and PLATFORM='across'

group by 1)

select 'TX' as tx

,avg(volume) as volume

from tab1

group by 1