select sender

from osmosis.core.fact_transfers

where currency = 'ibc/AB589511ED0DD5FA56171A39978AFBF1371DB986EC1C3526CE138A16377E39BB'

and transfer_type ='IBC_TRANSFER_IN'

select date_trunc('month',block_timestamp) as date,

FOREIGN_CHAIN,

count(distinct(tx_id)) as total_tx,

sum(amount/pow(10,decimal)) as volume

from axelar.core.fact_transfers

where sender in ( select sender from foreign_senders )

and FOREIGN_CHAIN is not null

and amount/pow(10,decimal) < 1e9

group by 1,2