date_trunc('month',block_timestamp) as date,

case when sender ilike 'axelar%' then 'Axelar'

when sender ilike 'cosmos%' then 'Cosmos'

when sender ilike 'terra%' then 'Terra'

when sender ilike 'evmos%' then 'Evmos'

when sender ilike 'juno%' then 'Juno'

when sender ilike 'stars%' then 'Stargaze'

when sender ilike 'stride%' then 'Stride'

when sender ilike 'rebus%' then 'Rebus'

when sender ilike 'gravit%' then 'Graviton'

when sender ilike 'bostrom%' then 'Bostrom'

when sender ilike 'ki%' then 'KI'

when sender ilike 'kujira%' then 'Kujira'

when sender ilike 'emoney%' then 'E-Money'

when sender ilike 'mantle%' then 'Mantle'

when sender ilike 'inj%' then 'Injective'

when sender ilike 'comdex%' then 'Comdex'

when sender ilike 'regen%' then 'Regen'

when sender ilike 'umee%' then 'Umee'

when sender ilike 'chihuahua%' then 'Chihuahua'

when sender ilike 'secret%' then 'Secret'

when sender ilike 'cro%' then 'Cronos'

when sender ilike 'sif%' then 'Sifchain'

when sender ilike 'persistence%' then 'Persistence'

when sender ilike 'cerberus%' then 'Cerberus'

when sender ilike 'tori%' then 'Teritori'

when sender ilike 'akash%' then 'Akash'

when sender ilike 'fetch%' then 'Fetch'

when sender ilike 'agoric%' then 'Agoric'

when sender ilike 'kava%' then 'Kava'

else 'Elsewhere' end as source_chain,

count (distinct tx_id) as txs,

count (distinct receiver) as users,

sum (txs) over (partition by source_chain order by date) as cum_txs

from osmosis.core.fact_transfers