with transactions as (
select
sender,
-asset_amount as amount
from flipside_prod_db.algorand.asset_transfer_transaction
where asset_transferred = 684649988
and asset_amount > 0
and tx_group_id is not null
union all
select
asset_receiver as sender,
asset_amount as amount
from flipside_prod_db.algorand.asset_transfer_transaction
where asset_transferred = 684649988
and asset_amount > 0
and tx_group_id is not null
)
select
sender,
sum(amount)/1e6
from transactions
group by 1
order by 2 desc