select date_trunc('day',BLOCK_TIMESTAMP) as day

,count(distinct case when ORIGIN_FUNCTION_SIGNATURE='0xa5977fbb'then FROM_ADDRESS end) as withdrawers

,count(distinct case when ORIGIN_FUNCTION_SIGNATURE='0xcdd1b25d'then TO_ADDRESS end) as depositors

,count(distinct case when ORIGIN_FUNCTION_SIGNATURE='0xa5977fbb'then TX_HASH end) as "WITHDRAW COUNT"

,count(distinct case when ORIGIN_FUNCTION_SIGNATURE='0xcdd1b25d'then TX_HASH end) as "DEPOSIT COUNT"

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

,count(distinct case when ORIGIN_FUNCTION_SIGNATURE='0xa5977fbb'then FROM_ADDRESS end) as withdrawers

,count(distinct case when ORIGIN_FUNCTION_SIGNATURE='0xcdd1b25d'then TO_ADDRESS end) as depositors

,count(distinct case when ORIGIN_FUNCTION_SIGNATURE='0xa5977fbb'then TX_HASH end) as "WITHDRAW COUNT"

,count(distinct case when ORIGIN_FUNCTION_SIGNATURE='0xcdd1b25d'then TX_HASH end) as "DEPOSIT COUNT"

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

,count(distinct case when ORIGIN_FUNCTION_SIGNATURE='0xa5977fbb'then FROM_ADDRESS end) as withdrawers

,count(distinct case when ORIGIN_FUNCTION_SIGNATURE='0xcdd1b25d'then TO_ADDRESS end) as depositors

,count(distinct case when ORIGIN_FUNCTION_SIGNATURE='0xa5977fbb'then TX_HASH end) as "WITHDRAW COUNT"

,count(distinct case when ORIGIN_FUNCTION_SIGNATURE='0xcdd1b25d'then TX_HASH end) as "DEPOSIT COUNT"

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

,max(withdrawers) as "MAX WITHDRAWERS"

,min(withdrawers) as "MIN WITHDRAWERS"

,avg(withdrawers) as "AVG WITHDRAWERS"

,median(withdrawers) as "MED WITHDRAWERS"

,max("WITHDRAW COUNT") as "MAX WITH COUNT"