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

union all

SELECT 'Only Swapping' as type, count (distinct tx_id) as TX_Count, count (distinct user) as Users_Count, sum (volume2) as Volume1 from osmoswap