LTirrell20. Liquidity
    Updated 2021-11-16
    -- Of the wallets that have supplied liquidity in THORChain pools, what percentage have removed at least some of the liquidity?

    select
    count(
    distinct (
    case
    when lp_action = 'add_liquidity' then from_address
    end
    )
    ) as adders,
    count(
    distinct (
    case
    when lp_action = 'remove_liquidity' then from_address
    end
    )
    ) as removers,
    removers / adders as removal_ratio
    from
    thorchain.liquidity_actions
    where
    TX_ID is not null AND block_timestamp::date>current_date-30


    Run a query to Download Data