2844RUBNE BALANCE
    Updated 2022-06-27
    with transfers as (
    select sum(rune_amount) as total_receive, to_address as wallet
    from thorchain.transfers
    where asset = 'THOR.RUNE'
    group by 2
    union
    select sum(rune_amount * -1) as total_receive, from_address as wallet
    from thorchain.transfers
    where asset = 'THOR.RUNE'
    group by 2
    ),

    all_holders as (
    select sum(total_receive) as total_rune_holdings, wallet
    from transfers
    group by 2
    ),

    lp as (
    select sum(rune_amount) as total_add, from_address as lp_address
    from thorchain.liquidity_actions
    where lp_action = 'add_liquidity'
    group by 2
    union
    select sum(rune_amount * -1) as total_withdraw, from_address as lp_address
    from thorchain.liquidity_actions
    where lp_action = 'remove_liquidity'
    group by 2
    ),

    total_in_pool as (
    select sum(total_add) as total_rune_pool, lp_address
    from lp
    group by 2
    ),

    Run a query to Download Data