transfers as (

select

to_address as address,

sum(amount) as volume

from

avalanche.core.ez_token_transfers

where

contract_address = '0x152b9d0fdc40c096757f570a51e494bd4b943e50'

group by

address

union all

select

from_address as address,

-sum(amount) as volume

from

avalanche.core.ez_token_transfers

where

contract_address = '0x152b9d0fdc40c096757f570a51e494bd4b943e50'

group by

address

)

transfers.address as "Address",

labels.project_name as "Label",

sum(transfers.volume) as "Balance"

transfers

left join avalanche.core.dim_labels labels on transfers.address = labels.address

transfers.address != '0x0000000000000000000000000000000000000000'

group by

"Address",

"Label"

"Balance" > 0