LIQUIDITY_PROVIDER_ADDRESS,

'deposited' as action,

sum(amount / pow(10,6)) as "volume"

from osmosis.core.fact_liquidity_provider_actions

where pool_id = 812

and currency != 'uosmo'

and action ='pool_joined'

and block_timestamp >= '2022-09-27 16:31:00'

and tx_status = 'SUCCEEDED'

group by 1,2

order by 3 desc

limit 10