select wallet, round(sum(amount/pow(10,6)),2) as amount from
(select
SENDER as wallet, sum(AMOUNT) as AMOUNT
from terra.core.ez_transfers
where CURRENCY='uluna'
group by 1
union all
select
RECEIVER as wallet,
sum(AMOUNT)*-1 as AMOUNT
from terra.core.ez_transfers
where CURRENCY='uluna'
group by 1
) group by 1 order by 2 desc limit 100