Terra - Wormhole
Wormhole
DECODE - Which Chain the TX comes from.
SELECT
block_timestamp, msg_value:sender::string as sender, tx_id,
HEX_ENCODE(BASE64_DECODE_BINARY(msg_value:execute_msg:submit_vaa:data::string)) as vaa_data,
CASE
WHEN vaa_data ILIKE '%0000000000000000000000000000000000000000000000000000000000000004%' THEN 'Solana Asset Meta'
WHEN vaa_data ILIKE '%0def15a24423e1edd1a5ab16f557b9060303ddbab8c803d2ee48f4b78a1cfd6b%' THEN 'Solana NFT'
WHEN vaa_data ILIKE '%ec7372995d5cc8732397fb0ad35c0121e0eaa90d26f828a534cab54391b3a4f5%' THEN 'Solana Token Bridge'
WHEN vaa_data ILIKE '%0000000000000000000000003ee18b2214aff97000d974cf647e7c347e8fa585%' THEN 'Ethereum Token Bridge'
WHEN vaa_data ILIKE '%0000000000000000000000006ffd7ede62328b3af38fcd61461bbfc52f5651fe%' THEN 'Ethereum NFT Bridge'
WHEN vaa_data ILIKE '%0000000000000000000000005a58505a96d1dbf8df91cb21b54419fc36e93fde%' THEN 'BSC NFT Bridge'
WHEN vaa_data ILIKE '%000000000000000000000000b6f6d86a8f9879a9c87f643768d9efc38c1da6e7%' THEN 'BSC Token Bridge'
WHEN vaa_data ILIKE '%000000000000000000000000465862772f9c2e9d71982627bcfdc721a47deb22%' THEN 'Polygon Contract Bridge'
WHEN vaa_data ILIKE '%0000000000000000000000005a58505a96d1dbf8df91cb21b54419fc36e93fde%' THEN 'Polygon Token Bridge'
WHEN vaa_data ILIKE '%00000000000000000000000090bbd86a6fe93d3bc3ed6335935447e75fab7fcf%' THEN 'Polygon NFT Bridge'
WHEN vaa_data ILIKE '%0000000000000000000000000e082f06ff657d94310cb8ce8b0d9a04541d8052%' THEN 'Avax 8052'
WHEN vaa_data ILIKE '%000000000000000000000000f7b6737ca9c4e08ae573f75a97b73d7a813f5de5%' THEN 'Avax 5de5'
WHEN vaa_data ILIKE '%00000000000000000000000004952d522ff217f40b5ef3cbf659eca7b952a6c1%' THEN 'Oasis a6c1'
WHEN vaa_data ILIKE '%0000000000000000000000005848c791e09901b40a9ef749f2a6735b418d7564%' THEN 'Oasis 7564'
ELSE 'Unknown Chain'
END as emitter_chain
FROM terra.msgs
WHERE 1=1
--and tx_id = '05A1DF7D5B88490E0652A47EE069092A3123FCF0B9F5EAF4D89FFF5C2C6C3ED4' -- sol test tx
--and tx_id = '21A301D0DD1E712E98309E66E928E7607EC1D861F6FD31A561BB6154AF65E49D' -- oasis test tx
and msg_value:execute_msg:submit_vaa:data is not null
--and vaa_data ILIKE '%0000000000000000000000005848c791e09901b40a9ef749f2a6735b418d7564%'
limit 2How to update above table
Use this website to figure out who are the contract emitters and add them to the list...
Bridges
Assets
Tokens
BEST SUBMISSIONS (To Be Sorted)
QUESTION 101
https://jp12.medium.com/terra-wormhole-bridge-data-analysis-4147e06c07aa
https://www.techdreams.org/crypto-currency/terra-blockchain-users-wormhole-adoption/11276-20211124
https://app.flipsidecrypto.com/dashboard/101-elite-crypto-cosmology-part-1-wormhole-KTaVPE
https://app.flipsidecrypto.com/dashboard/into-the-wormhole-Sqv35x
https://app.flipsidecrypto.com/dashboard/crypto-cosmology-part-1-0-ioEB
QUESTION 103
https://app.flipsidecrypto.com/dashboard/ust-wormhole-transfers-from-terra-DvStIo
https://colab.research.google.com/drive/12KCDeXeoYZFAD8dSdYxhy94hRAL_NcF5?usp=sharing
https://app.flipsidecrypto.com/dashboard/into-the-multichain-verse-yJ4igh
https://jp12.medium.com/wormhole-ust-analysis-740531efdd01
https://app.flipsidecrypto.com/dashboard/from-wormhole-to-terra-q2LzZF
https://app.flipsidecrypto.com/dashboard/from-terra-with-love-kYoQ8w
https://app.flipsidecrypto.com/dashboard/103-elite-from-wormhole-to-terra-3_utCM
https://app.flipsidecrypto.com/dashboard/analysis-of-ust-sent-from-terra-through-wormhole-bridge-gna286
https://colab.research.google.com/drive/1YAA8TKZ7FmGPMRubs0laNyzbbGQsvOJJ?usp=sharing
https://app.flipsidecrypto.com/dashboard/103-elite-from-terra-with-love-z_e8LY
https://www.techdreams.org/crypto-currency/wormhole-terra-usd-ust-dashboard/11350-20211128
https://scottincrypto.github.io/analytics/terra/wormhole/2021/12/01/UST-into-the-Wormhole.html
https://app.flipsidecrypto.com/dashboard/from-terra-with-love-ust-transactions-via-wormhole-out-of-terra-6FmD1f https://app.flipsidecrypto.com/dashboard/103-elite-from-terra-with-love-TfzilA
QUESTION 104
https://hexagonal-telescope-6b0.notion.site/Binance-Comparison-Analysis-ae865c30a9ad40f480cd32b61b2c4425 https://app.flipsidecrypto.com/dashboard/comparisons-of-transactions-from-terra-to-bsc-via-shuttle-and-wormhole-BGqEr_
https://app.flipsidecrypto.com/dashboard/104-elite-binance-comparison-3N9xy7
https://analytics.zoho.in/open-view/213608000000013488/05e261732c278cafb1b9c93ea635d102
https://app.flipsidecrypto.com/dashboard/104-elite-binance-comparison-terra-jCRVay
https://colab.research.google.com/drive/1iwrS_HZ5RPYWRlcvzElLG37RmLauUSI1?usp=sharing
https://app.flipsidecrypto.com/dashboard/binance-bridge-and-wormhole-comparison-qAU573
https://jp12.medium.com/bsc-terra-shuttle-bridge-vs-wormhole-a8533073295d
https://colab.research.google.com/drive/1ueT5KrdAynpJFaOEFqSSavD7pJVOGZyy?usp=sharing
https://app.flipsidecrypto.com/dashboard/terra-104-binance-shuttle-vs-wormhold-QQxReS
https://app.flipsidecrypto.com/dashboard/terra-bounty-binance-comparison-rI9vgn
https://app.flipsidecrypto.com/dashboard/comparison-of-bridges-terra-binance-smart-chain-TuoT8n
https://colab.research.google.com/gist/YusefAN/eacb1473029a216af6e85df12d0de7af/-104-binance-comparison-zefwow-submission.ipynb#scrollTo=PQTIWA-TSqZp
https://app.flipsidecrypto.com/dashboard/brads-bsc-comparison-terra-bridge-vs-wormhole-hkWgTG https://app.flipsidecrypto.com/dashboard/elite-binance-comparison-VJW0qN
Last updated