select

FROM_ADDRESS as withdrawer

,TO_ADDRESS as depositor

,sum(case when ORIGIN_FUNCTION_SIGNATURE='0xcdd1b25d' then AMOUNT_USD end) as "BRIDGE VOLUME IN"

,sum(case when ORIGIN_FUNCTION_SIGNATURE='0xa5977fbb' then AMOUNT_USD end) as "BRIDGE VOLUME OUT"

from polygon.core.ez_token_transfers

where ORIGIN_TO_ADDRESS='0x88dcdc47d2f83a99cf0000fdf667a468bb958a78'

and ORIGIN_FUNCTION_SIGNATURE in('0xcdd1b25d','0xa5977fbb')

group by 1,2)

select

'BRIDGER' as type

,avg("BRIDGE VOLUME IN") as "AVG IN"

,median("BRIDGE VOLUME IN") as "MED IN"

,-avg("BRIDGE VOLUME OUT") as "AVG OUT"

,-median("BRIDGE VOLUME OUT") as "MED OUT"

from tab1

group by 1