with tab1 as (select tx_from as sender, sum(amount) as volume_out

from solana.core.fact_transfers

where mint in ('poLisWXnNRwC6oBu1vHiuKQzFjGL4XDSu4g9qjz9qVk')

group by 1),

tab2 as (select tx_to as receiver, sum(amount) as volume_in

from solana.core.fact_transfers

where mint in ('poLisWXnNRwC6oBu1vHiuKQzFjGL4XDSu4g9qjz9qVk')

group by 1)

select sender as "Holder", volume_in, volume_out, case

when volume_in is null then 0

else volume_in

end as vol_in, case

when volume_out is null then 0

else volume_out

end as vol_out

from tab1 left join tab2 on tab1.sender=tab2.receiver

order by 2 desc)

select "Holder", vol_in as "Volume in", vol_out as "Volume out", vol_in-vol_out as "Balance"

from tab3

order by 4 desc

limit 10