strawbettypercentage of small LP adding to each pool
    Updated 2022-04-16
    with all_add_liqs as (
    select pool_name, tx_id, rune_amount_usd + asset_amount_usd as amount_usd
    from thorchain.liquidity_actions
    where lp_action = 'add_liquidity'
    ), count_add_liquidities as (
    SELECT
    pool_name,
    count( CASE WHEN amount_usd < 1000 THEN amount_usd END) as count_below_1000_usd,
    count( CASE WHEN amount_usd > 0 THEN amount_usd END) as count_all,
    (count_below_1000_usd / count_all)*100 as percent
    from all_add_liqs
    group by 1
    order by 2 desc
    )

    SELECT
    *
    from count_add_liquidities
    where count_all > 1
    order by count_below_1000_usd desc
    Run a query to Download Data