dariustay_0512c. Wormhole Transactions - Fish / Whale
    Updated 2022-01-12
    WITH
    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'
    Run a query to Download Data