select

tx_id,

LIQUIDITY_PROVIDER_ADDRESS as User,

amount / pow(10, decimal) as volume2

from

osmosis.core.fact_liquidity_provider_actions

where

currency = 'uosmo'

and tx_status = 'SUCCEEDED'

and block_timestamp >= CURRENT_DATE - 10

),

osmoswap as (

select

tx_id,

trader as user,

from_amount / pow(10, from_decimal) as volume2

from

osmosis.core.fact_swaps

where

from_currency = 'uosmo'

and tx_status = 'SUCCEEDED'

and block_timestamp >= CURRENT_DATE -10

)

SELECT

'Only LPing' as type,

count (distinct tx_id) as TX_Count,

count (distinct user) as Users_Count,

sum (volume2) as Volume1

from

osmolp

where

user not in (

select

user

from