select block_timestamp::date as fecha,

case

when sender ilike 'osmo%' then 'OSMOSIS'

when sender ilike 'cosmos%' then 'COSMOS'

when sender ilike 'terra%' then 'TERRA'

when sender ilike 'cre%' then 'CRESCENT'

when sender ilike 'stars%' then 'STARGAZE'

when sender ilike 'evmos%' then 'EVMOS'

when sender ilike 'umee%' then 'UMEE'

when sender ilike 'kujira%' then 'KUJIRA'

when sender ilike 'juno%' then 'JUNO'

when sender ilike 'agoric%' then 'AGORIC'

when sender ilike 'bcna%' then 'BCNA'

when sender ilike 'comdex%' then 'COMDEX'

when sender ilike 'ki%' then 'KI'

when sender ilike 'mantle%' then 'ASSETMANTLE'

when sender ilike 'emoney%' then 'EMONEY'

when sender ilike 'secret%' then 'SECRET'

when sender ilike 'ex%' then 'EX'

when sender ilike 'swth%' then 'SWTH'

when sender ilike 'fetch%' then 'FETCH.AI'

when sender ilike 'regen%' then 'REGEN'

when sender ilike 'inj%' then 'INJECTIVE'

when sender ilike 'rizon%' then 'RIZON'

when sender ilike 'persistence%' then 'PERSISTENCE'

else sender

end as COSMOS_CHAINS,

count(tx_id) as transactions

from axelar.core.fact_transfers

where transfer_type = 'IBC_TRANSFER_IN'

group by fecha, COSMOS_CHAINS

),

bridge_out_axelar as (

select block_timestamp::date as fecha,