SELECT FROM_ADDRESS, SUM(RUNE_AMOUNT) as sent_RUNE, SUM(RUNE_AMOUNT_USD) as sent_RUNE_USD

FROM thorchain.transfers

GROUP BY 1

, received as (

SELECT TO_ADDRESS, SUM(RUNE_AMOUNT) as received_RUNE, SUM(RUNE_AMOUNT_USD) as received_RUNE_USD

FROM thorchain.transfers

GROUP BY 1

SELECT FROM_ADDRESS, sent_RUNE, received_RUNE, received_RUNE - sent_RUNE as net_RUNE

FROM sent s INNER JOIN received r ON FROM_ADDRESS = TO_ADDRESS

WHERE FROM_Address NOT IN ('thor1g98cy3n9mmjrpn0sxmn63lztelera37n8n67c0', 'thor1dheycdevq39qlkxs2a6wuuzyn4aqxhve4qxtxt',

'thor17gw75axcnr8747pkanye45pnrwk7p9c3cqncsv', 'thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6')

ORDER BY net_rune DESC NULLS LAST

LIMIT 10