flipside

    il insurance
    boomer77il insurance
    Updated 2022-04-12
    with raw as (select *
    from thorchain.liquidity_actions
    where lp_action = 'remove_liquidity')

    select pool_name, count(distinct tx_id)
    from raw
    group by 1