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>=5),

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 hour,count(distinct CURRENCY)as cur_count,count(distinct TX_ID)as tx_count

,case

when hour like '%00:00:00.000' then '00:00:00.000'

when hour like '%01:00:00.000' then '01:00:00.000'

when hour like '%02:00:00.000' then '02:00:00.000'

when hour like '%03:00:00.000' then '03:00:00.000'

when hour like '%04:00:00.000' then '04:00:00.000'

when hour like '%05:00:00.000' then '05:00:00.000'

when hour like '%06:00:00.000' then '06:00:00.000'

when hour like '%07:00:00.000' then '07:00:00.000'

when hour like '%08:00:00.000' then '08:00:00.000'

when hour like '%09:00:00.000' then '09:00:00.000'

when hour like '%10:00:00.000' then '10:00:00.000'

when hour like '%11:00:00.000' then '11:00:00.000'

when hour like '%12:00:00.000' then '12:00:00.000'

when hour like '%13:00:00.000' then '13:00:00.000'

when hour like '%14:00:00.000' then '14:00:00.000'

when hour like '%15:00:00.000' then '15:00:00.000'

when hour like '%16:00:00.000' then '16:00:00.000'

when hour like '%17:00:00.000' then '17:00:00.000'

when hour like '%18:00:00.000' then '18:00:00.000'

when hour like '%19:00:00.000' then '19:00:00.000'

when hour like '%20:00:00.000' then '20:00:00.000'