select pool_name, count(distinct from_address) as LP_provider, sum(rune_amount) as Rune_supplied, sum(asset_amount) as asset_supplied,
sum(rune_amount_usd) as Rune_supplied_usd, sum(asset_amount_usd) as asset_supplied_usd
from thorchain.liquidity_actions
where lp_action = 'add_liquidity'
group by 1
order by 2 desc