DISTINCT MESSAGE_VALUE['sender'] as user,

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'

else null

end as "blockchain",

count(TX_ID) as "bridge count",

sum(AMOUNT/1e6) as "bridge volume"

from terra.core.ez_transfers

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

and CURRENCY='uluna'

and "blockchain" is not null

group by 1,2

order by 3 desc

limit 10