terra_wormhole_tx AS (

SELECT

block_timestamp,

tx_id,

msg_value,

msg_value:sender::string AS address,

msg_value:execute_msg:initiate_transfer:asset:amount / POW(10,6) as tx_amt,

CASE

WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 1 THEN 'SOLANA'

WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 2 THEN 'ETHEREUM'

WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 3 THEN 'TERRA'

WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 4 THEN 'BSC'

WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 5 THEN 'POLYGON'

ELSE 'TERRA'

END AS target_chain,

CASE

WHEN msg_value:execute_msg:initiate_transfer:asset:info:token IS NOT NULL THEN msg_value:execute_msg:initiate_transfer:asset:info:token:contract_addr::string

WHEN msg_value:execute_msg:initiate_transfer:asset:info:native_token IS NOT NULL THEN msg_value:execute_msg:initiate_transfer:asset:info:native_token:denom::string

ELSE 'NULL'

END AS token

FROM terra.msgs

WHERE tx_status = 'SUCCEEDED'

AND msg_value:contract::string = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'

AND msg_value:execute_msg:initiate_transfer IS NOT NULL),

tokens AS (

SELECT

token,

CASE

-- wormhole

WHEN token = 'terra19t8cxscre0jss7nejqy29c97fkg7els3v8zujg' THEN 'wh'

WHEN token = 'terra1hd9n65snaluvf7en0p4hqzse9eqecejz2k8rl5' THEN 'wh'

WHEN token = 'terra16q5pke2vueu23y8punvj70h0cp0s0rc7vrzl57' THEN 'wh'

WHEN token = 'terra1e6mq63y64zcxz8xyu5van4tgkhemj3r86yvgu4' THEN 'wh'

WHEN token = 'terra1k7tstwhf25wm45x329ny84xe4n2z2nnq9ekuv2' THEN 'wh'