select date_trunc('day',BLOCK_TIMESTAMP) as day

,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('0xa5977fbb','0xcdd1b25d')

group by 1),

tab2 as (

select date_trunc('week',BLOCK_TIMESTAMP) as week

,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('0xa5977fbb','0xcdd1b25d')

group by 1),

tab3 as (

select date_trunc('month',BLOCK_TIMESTAMP) as month

,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('0xa5977fbb','0xcdd1b25d')

group by 1)

select 'DAY' as time

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

,max("BRIDGE VOLUME IN") as "MAX IN"

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

,min("BRIDGE VOLUME IN") as "MIN IN"

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

,-max("BRIDGE VOLUME OUT") as "MAX OUT"

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

,-min("BRIDGE VOLUME OUT") as "MIN OUT"

from tab1

group by 1

union all