with receivet as (

select to_address as Receiver,

sum (amount) as Received_Volume

from arbitrum.core.ez_token_transfers

where contract_address = lower('0x580e933d90091b9ce380740e3a4a39c67eb85b4c')

group by 1),

sendt as (

select from_address as sender,

sum (amount) as sent_volume

from arbitrum.core.ez_token_transfers

where contract_address = lower('0x580e933d90091b9ce380740e3a4a39c67eb85b4c')

group by 1),

balancetable as (

select coalesce (t1.Receiver,t2.sender) as Holder,

coalesce (Received_Volume, 0) - coalesce (sent_volume, 0) as Balance

from receivet t1 full outer join sendt t2 on t1.receiver = t2.sender)

select count (distinct holder) as Holders_Count,

avg (balance) as Average_Balance,

median (balance) as Median_Balance,

max (balance) as Maximum_Balance

from balancetable

where holder not in (select address from avalanche.core.dim_labels)

and balance > 0