with plus as (select to_address, sum(rune_amount) as total_received from thorchain.transfers group by to_address), min as (select from_address, sum(rune_amount) as total_sent from thorchain.transfers group by from_address), net_balance as ( select p.to_address as address, p.total_received - m.total_sent as transfer_balance from plus p, min m where p.to_address = m.from_address ), liquidity_add as (select from_address, sum(rune_amount) as total_rune_added from thorchain.liquidity_actions where lp_action = 'add_liquidity' and from_address is not null group by from_address ), liquidity_remove as ( select from_address, sum(rune_amount) as total_rune_withdrawn from thorchain.liquidity_actions where lp_action = 'remove_liquidity' and from_address is not null group by from_address ), net_liquidity_balance as (select a.from_address as address, a.total_rune_added - r.total_rune_withdrawn as lp_balance, iff(lp_balance < 0, 0, lp_balance ) as real_lp_balance from liquidity_add a, liquidity_remove r where a.from_address = r.from_address ), balances as (select b.address, b.transfer_balance, l.real_lp_balance, b.transfer_balance + l.real_lp_balance as total_rune_balance, iff(total_rune_balance < 0.001, 0, total_rune_balance) as final_total_rune_balance from net_balance b, net_liquidity_balance l where b.address = l.address), final_values as (select count(case when final_total_rune_balance <= 10 then 1 end) as "0 - 10 RUNE", count(case when final_total_rune_balance > 10 and final_total_rune_balance <= 50 then 1 end) as "10 - 50 RUNE", count(case when final_total_rune_balance > 50 and final_total_rune_balance <= 100 then 1 end) as "50 - 100 RUNE", count(case when final_total_rune_balance > 100 and final_total_rune_balance <= 200 then 1 end) as "100 - 200 RUNE", count(case when final_total_rune_balance > 200 and final_total_rune_balance <= 500 then 1 end) as "200 - 500 RUNE", count(case when final_total_rune_balance > 500 and final_total_rune_balance <= 1000 then 1 end) as "500 - 1k RUNE", count(case when final_total_rune_balance > 1000 and final_total_rune_balance <= 2000 then 1 end) as "1k - 2k RUNE", count(case when final_total_rune_balance > 2000 and final_total_rune_balance <= 5000 then 1 end) as "2k - 5k RUNE", count(case when final_total_rune_balance > 5000 and final_total_rune_balance <= 10000 then 1 end) as "5k - 10k RUNE", count(case when final_total_rune_balance > 10000 and final_total_rune_balance <= 50000 then 1 end) as "10k - 50k RUNE", count(case when final_total_rune_balance > 50000 and final_total_rune_balance <= 1000000 then 1 end) as "50k - 100k RUNE", count(case when final_total_rune_balance > 1000000 then 1 end) as "100k+ RUNE" from balances) select bin, n from final_values unpivot( n for bin in ( "0 - 10 RUNE", "10 - 50 RUNE", "50 - 100 RUNE", "100 - 200 RUNE", "200 - 500 RUNE", "500 - 1k RUNE", "1k - 2k RUNE", "2k - 5k RUNE", "5k - 10k RUNE", "10k - 50k RUNE", "50k - 100k RUNE", "100k+ RUNE") )u --add_liquidity --remove_liquidity

$RUNE Distribution