'swapping' as action_type,

count (distinct osmosis.core.fact_swaps.TX_ID) as number_of_transactions

FROM osmosis.core.fact_swaps, osmosis.core.fact_transactions

where trader = tx_from

and tx_from is not NULL)

union ALL

(SELECT --date(osmosis.core.fact_staking.block_timestamp) as date,

'staking' as action_type,

count (distinct osmosis.core.fact_staking.TX_ID) as number_of_transactions

FROM osmosis.core.fact_staking, osmosis.core.fact_transactions

where TX_CALLER_ADDRESS = tx_from

and tx_from is not NULL)

union ALL

(SELECT --date(osmosis.core.fact_liquidity_provider_actions.block_timestamp) as date,

'liquidity providing' as action_type,

count (distinct osmosis.core.fact_liquidity_provider_actions.TX_ID) as number_of_transactions

FROM osmosis.core.fact_liquidity_provider_actions, osmosis.core.fact_transactions

where LIQUIDITY_PROVIDER_ADDRESS = tx_from

and tx_from is not NULL)

union ALL

(SELECT --date(osmosis.core.fact_transfers.block_timestamp) as date,

'transfering' as action_type,

count (distinct osmosis.core.fact_transfers.TX_ID) as number_of_transactions

FROM osmosis.core.fact_transfers, osmosis.core.fact_transactions

where SENDER = tx_from

and tx_from is not NULL)