binhachon48. DOGE-RUNE LP-ers - Pools in Thorchain
    Updated 2022-01-29
    -- Find list of addresses that added liquidity to any pool
    with address_list as (
    select
    pool_name,
    count(distinct from_address) as liquidity_provider,
    row_number() over (order by liquidity_provider desc) as rank
    from thorchain.liquidity_actions
    where lp_action = 'add_liquidity'
    group by pool_name
    )
    select * from address_list
    Run a query to Download Data