t1 as (select

distinct tx_id,sender

from osmosis.core.fact_transfers where currency ilike '%ibc/AB589511ED0DD5FA56171A39978AFBF1371DB986EC1C3526CE138A16377E39BB%'

and transfer_type ='IBC_TRANSFER_IN' and tx_succeeded='TRUE'

select

trunc(block_timestamp,'day') as date,

--transfer_type,

foreign_chain,

currency,

count(distinct x.tx_id) as counts

from axelar.core.fact_transfers x

join t1 y on x.sender=y.sender where tx_succeeded='TRUE'

group by 1,2,3 order by 1 asc

--from axelar.core.fact_transfers where currency ilike '%wmatic-wei%'

--and transfer_type ='IBC_TRANSFER_OUT' and tx_succeeded='TRUE' and receiver like '%osmo%'