case

when SUBSTR(MESSAGE_VALUE['receiver'], 0, 4) = 'osmo' then 'osmo'

when SUBSTR(MESSAGE_VALUE['receiver'], 0, 4) = 'kuji' then 'kujira'

when SUBSTR(MESSAGE_VALUE['receiver'], 0, 4) = 'cosm' then 'cosmos'

when SUBSTR(MESSAGE_VALUE['receiver'], 0, 4) = 'evmo' then 'evmos'

when SUBSTR(MESSAGE_VALUE['receiver'], 0, 4) = 'stri' then 'STRI'

when SUBSTR(MESSAGE_VALUE['receiver'], 0, 4) = 'axel' then 'axelar'

when SUBSTR(MESSAGE_VALUE['receiver'], 0, 4) = 'grav' then 'GRAV'

when SUBSTR(MESSAGE_VALUE['receiver'], 0, 4) = 'secr' then 'secret'

when SUBSTR(MESSAGE_VALUE['receiver'], 0, 4) = 'terr' then 'terra'

when SUBSTR(MESSAGE_VALUE['receiver'], 0, 4) = 'juno' then 'juno'

when SUBSTR(MESSAGE_VALUE['receiver'], 0, 3) = 'cre' then 'CRE'

when SUBSTR(MESSAGE_VALUE['receiver'], 0, 3) = 'sif' then 'SIF'

end as blockchain,

count(TX_ID) as bridge_count,

count(DISTINCT MESSAGE_VALUE['sender']) as bridger_count,

sum(AMOUNT/1e6) as bridge_volume

from terra.core.ez_transfers

where MESSAGE_TYPE='/ibc.applications.transfer.v1.MsgTransfer'

and BLOCK_TIMESTAMP >= '2023-01-01'

and CURRENCY='uluna'

and blockchain is not null

group by 1