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 2

How to update above table

Use this website to figure out who are the contract emitters and add them to the list...

BUIDL | WormholeWormhole

https://wormholenetwork.com/en/explorer/?emitterChain=1

Bridges

wormhole/.env.sample at 14ba777cc179f0a5c5afb007c755a97cf921b261 · certusone/wormholeGitHub

Assets

analytics/wormhole_bridge_assets.csv at e0d187d2f5f86c879a88a5aac5a7f4d9387186ef · scottincrypto/analyticsGitHub

Tokens

flipside/wh_token_addresses.csv at main · forgxyz/flipsideGitHub

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