SELECT to_address,sum(rune_amount) as added_rune1 from thorchain.transfers

group by 1

),

debit as (

SELECT from_address,sum(rune_amount) added_rune2 from thorchain.transfers

group by 1

),

final as(

select to_address,added_rune1,added_rune2,added_rune1-added_rune2 as balance

from credit join debit on credit.to_address=debit.from_address

),

ten_k as(

select final.balance,final.to_address from final where final.balance>10000 ),

liquidity as(

select from_address ,pool_name from thorchain.liquidity_actions

)

select to_address,pool_name,balance from liquidity join ten_k on liquidity.from_address=to_address