sarathLP size distribution
    Updated 2022-05-02
    WITH add_liq AS (SELECT pool_name as pool_add, sum(asset_amount_usd) as liq_added
    FROM thorchain.liquidity_actions
    WHERE lp_action = 'add_liquidity'
    GROUP BY pool_name),

    remove_liq AS (SELECT pool_name as pool_remove, sum(asset_amount_usd) as liq_removed
    FROM thorchain.liquidity_actions
    WHERE lp_action = 'remove_liquidity'
    GROUP BY pool_name),

    data1 AS (SELECT * FROM add_liq LEFT JOIN remove_liq ON pool_add = pool_remove),

    pool_data AS (SELECT pool_add AS pool_name, liq_added, zeroifnull(liq_removed) as liq_removed FROM data1)

    SELECT pool_name, liq_added - liq_removed as lp_size
    FROM pool_data
    ORDER BY lp_size DESC
    Run a query to Download Data