shadil"Small" LP Actions - all
    Updated 2022-04-10
    with all_lp as (
    SELECT
    pool_name,
    count(DISTINCT tx_id) as count_trxs
    from thorchain.liquidity_actions
    where lp_action = 'add_liquidity'
    group by pool_name
    ),
    small_lp as (
    SELECT
    pool_name,
    count(DISTINCT tx_id) as count_trxs
    from thorchain.liquidity_actions
    where lp_action = 'add_liquidity'
    and rune_amount_usd <= 1000
    group by pool_name
    )

    SELECT al.pool_name,
    case when al.count_trxs = 0 then 0 else (sl.count_trxs/al.count_trxs) * 100 end as portion --divide zero error solved
    from all_lp al
    join small_lp sl on sl.pool_name = al.pool_name
    Run a query to Download Data