barbod147 / Swing and a Miss Count Over Time
    Updated 2022-02-17
    SELECT COUNT(tx_id) AS tx_num, tx_status, CASE WHEN msg_value:execute_msg:initiate_transfer:recipient_chain != 3 THEN 'Terra' END AS sender_name,
    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'
    WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 6 THEN 'Avax'
    WHEN msg_value:execute_msg:initiate_transfer:recipient_chain = 7 THEN 'Oasis'
    END AS recipient_name
    FROM terra.msgs AS msg
    WHERE msg.chain_id = 'columbus-5'
    AND msg.msg_value:contract = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'
    AND msg.msg_value:contract IS NOT NULL
    AND msg.msg_value:execute_msg:initiate_transfer:recipient_chain IS NOT NULL
    GROUP BY 2, 3, 4
    ORDER By tx_num DESC
    Run a query to Download Data