sum(rune_amount) as rune_inflow

from thorchain.transfers

where asset = 'THOR.RUNE'

group by 1),

outflow6 as (select from_address,

sum(rune_amount) as rune_outflow

from thorchain.transfers

where asset = 'THOR.RUNE'

group by 1),

holdings6 as (select from_address,

rune_inflow - ifnull(rune_outflow, 0) as holding_rune

from inflow6 a

left join outflow6 b

on a.to_address = b.from_address

where holding_rune > 1),

adding6 as (select

from_address,

sum(stake_units) as add_liq

from thorchain.liquidity_actions

where lp_action = 'add_liquidity'

group by 1),

removing6 as (select

from_address,

sum(stake_units) as remove_liq

from thorchain.liquidity_actions

where lp_action = 'remove_liquidity'

group by 1),