Crazy_Kid Small LP Actions
    Updated 2022-04-13
    WITH total AS (SELECT pool_name, COUNT(block_timestamp) as total_lps
    FROM thorchain.liquidity_actions
    WHERE lp_action = 'add_liquidity'
    GROUP BY pool_name),

    small_lp AS (SELECT pool_name, COUNT(block_timestamp) as small_lps
    FROM thorchain.liquidity_actions
    WHERE asset_amount_usd < 1000 AND lp_action = 'add_liquidity'
    GROUP BY pool_name)

    SELECT total.pool_name, total_lps, small_lps, (small_lps/total_lps)*100 as percentage_of_small_lps
    FROM total JOIN small_lp ON total.pool_name = small_lp.pool_name
    Run a query to Download Data