shahdadi-9ptm8Ylp holders
    Updated 2022-06-28
    with a as(select
    distinct from_address,
    sum(rune_amount) ADD_L
    from flipside_prod_db.thorchain.liquidity_actions
    where lp_action='add_liquidity'
    group by from_address
    ),b as(select
    distinct from_address,
    sum(rune_amount) REM_L
    from flipside_prod_db.thorchain.liquidity_actions
    where lp_action='remove_liquidity'
    group by from_address
    ),c as(select
    a.from_address address,
    (ADD_L - REM_L) amount
    from a join b on a.from_address=b.from_address
    )
    select count(address)
    from c where amount >0

    Run a query to Download Data