with tab1 as (

select date_trunc('week',BLOCK_TIMESTAMP)as week,TX_FROM as active_user

, count(distinct BLOCK_TIMESTAMP::date)as date

from osmosis.core.fact_transactions

group by 1,2

having date>=4),

tab2 as (

select date_trunc('hour',BLOCK_TIMESTAMP)as hour,CURRENCY,TX_ID,RECEIVER

from osmosis.core.fact_transfers

where TRANSFER_TYPE='IBC_TRANSFER_IN'

and TX_STATUS='SUCCEEDED'

group by 1,2,3,4)

select RECEIVER,count(distinct CURRENCY)as CURRENCY_count

from tab1

full outer join tab2

on tab1.active_user=tab2.RECEIVER

group by 1)

select CURRENCY_count,count(distinct RECEIVER) as RECEIVER_count

from act1

where CURRENCY_count>0

group by 1

order by 1