with tab1 as (

select tx_from as user, -amount/pow(10,5) as amount

from eclipse.core.fact_transfers

where mint='HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL'

and succeeded='TRUE'

union all

select tx_to as user, amount/pow(10,5) as amount

from eclipse.core.fact_transfers

where mint='HgD4Dc6qYCj3UanMDiuC4qANheeTsAvk6DY91B3F8gnL'

and succeeded='TRUE')

select user as "Holder", round(sum(amount),1) as "Balance"

from tab1

group by 1)

select "Holder", "Balance"

from tab2

where "Balance">0

order by 2 desc

limit 10