liquidity_provider_address,

-- count(distinct tx_id) as number_of_txs

sum(amount/power(10, decimal)) as volume

from osmosis.core.fact_liquidity_provider_actions

where block_timestamp::date >= '2022-05-01'

and tx_status = 'SUCCEEDED'

and action = 'pool_joined'

and amount > 0 and amount is not null

group by 1

order by 2 desc

limit 10