from osmosis.core.fact_transactions

where tx_id in ( select tx_id from osmosis.core.fact_msg_attributes

where attribute_key = 'amount' and msg_type = 'unbond' )

select 'LP' as type ,count(DISTINCT(tx_id)) as total_tx

from osmosis.core.fact_liquidity_provider_actions A join cte1 B on A.LIQUIDITY_PROVIDER_ADDRESS = B.tx_from

where date(block_timestamp) > date and action = 'pool_joined' and currency = 'uosmo'

select 'Stake' as type , count(DISTINCT(tx_id)) as total_tx

from osmosis.core.fact_staking A join cte1 B on A.TX_CALLER_ADDRESS = B.tx_from

where TX_STATUS = 'SUCCEEDED' and action = 'delegate' and CURRENCY = 'uosmo'

and date(block_timestamp) > date

select 'Swap' as type , count(DISTINCT(tx_id)) as total_tx

from osmosis.core.fact_swaps A join cte1 B on A.TRADER = B.tx_from

where date(block_timestamp) > date and TX_STATUS = 'SUCCEEDED' and from_currency = 'uosmo'