with tab1 as (select from_address as address, - amount as amount

from ethereum.core.ez_token_transfers

where contract_address = lower('0x0a6e7ba5042b38349e437ec6db6214aec7b35676')

union all

select to_address as address, amount as amount

from ethereum.core.ez_token_transfers

where contract_address = lower('0x0a6e7ba5042b38349e437ec6db6214aec7b35676'))

select address, sum(amount) as net_amount

from tab1

group by 1)

select address as "Holder", net_amount as "Balance"

from tab2

where net_amount>0),

supply_table as (with tab2 as (

with tab1 as (select from_address as address, - amount as amount

from ethereum.core.ez_token_transfers

where contract_address = lower('0x0a6e7ba5042b38349e437ec6db6214aec7b35676')

union all

select to_address as address, amount as amount

from ethereum.core.ez_token_transfers

where contract_address = lower('0x0a6e7ba5042b38349e437ec6db6214aec7b35676'))

select address, sum(amount) as net_amount

from tab1

group by 1)

select sum(net_amount) as "Supply"

from tab2