-- 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