select BLOCK_TIMESTAMP, TRANSFER_TYPE, SENDER, RECEIVER, CURRENCY, AMOUNT as RAW_AMOUNT, DECIMAL, RAW_AMOUNT/pow(10,DECIMAL) as amount,

case

when SENDER ilike 'agoric%' then 'Agoric'

when SENDER ilike 'axelar%' then 'Axelar'

when SENDER ilike 'bcna%' then 'BitCanna'

when SENDER ilike 'comdex%' then 'Comdex'

when SENDER ilike 'cosmos%' then 'Cosmos'

when SENDER ilike 'cre%' then 'Crescent'

when SENDER ilike 'emoney%' then 'e-Money'

when SENDER ilike 'evmos%' then 'Evmos'

when SENDER ilike 'inj%' then 'Injective'

when SENDER ilike 'juno%' then 'Juno'

when SENDER ilike 'ki%' then 'Ki'

when SENDER ilike 'kujir%' then 'Kujir'

when SENDER ilike 'mantl%' then 'AssetMantle'

when SENDER ilike 'osmo%' then 'Osmosis'

when SENDER ilike 'persi%' then 'Persistence'

when SENDER ilike 'regen%' then 'Regen'

when SENDER ilike 'rizon%' then 'Rizon'

when SENDER ilike 'secre%' then 'Secret'

when SENDER ilike 'stars%' then 'Stargaze'

when SENDER ilike 'swth1%' then 'Carbon'

when SENDER ilike 'terra%' then 'Terra'

when SENDER ilike 'umee1%' then 'Umee'

when SENDER ilike 'fetch%' then 'Fetch'

when SENDER ilike 'kava1%' then 'Kava'

when SENDER ilike 'ex%' then 'ixo-Cosmos'

when SENDER ilike '0x%' then 'Ethereum'

else 'Others' end as chain_in,

case

when RECEIVER ilike 'agoric%' then 'Agoric'

when RECEIVER ilike 'axelar%' then 'Axelar'

when RECEIVER ilike 'bcna%' then 'BitCanna'

when RECEIVER ilike 'comdex%' then 'Comdex'

when RECEIVER ilike 'cosmos%' then 'Cosmos'