The Wormhole is a bridge that facilitates the transfer of crypto assets between chains.

In this post I use a Sankey diagram to visualize Terra transactions sent to other chains through the Wormhole.

Methodology

Data gathering

I query Flipside’s terra.msg schema for transactions originating from Terra and sent to the Wormhole address. I group transactions by recipient chain and transaction status.

Only transactions from January 12 to February 13, 2022 are included.

Visualizations

The data is presented in a Sankey diagram and a collapsible tree. The Sankey is produced using the networkD3 package. The collapsibleTree package is used to make the tree.

Dataset

Resulting dataset:

##    starting_chain recipient_chain nb_tx tx_status
## 1           Terra           0asis     5    FAILED
## 2           Terra           0asis   153 SUCCEEDED
## 3           Terra            Avax  1451 SUCCEEDED
## 4           Terra            Avax    39    FAILED
## 5           Terra             BSC    30    FAILED
## 6           Terra             BSC  1125 SUCCEEDED
## 7           Terra        Ethereum   878 SUCCEEDED
## 8           Terra        Ethereum    19    FAILED
## 9           Terra         Polygon    39    FAILED
## 10          Terra         Polygon  1420 SUCCEEDED
## 11          Terra          Solana  7190 SUCCEEDED
## 12          Terra          Solana   245    FAILED

Link to the SQL code and query result on Flipside Crypto

Sankey Diagram

Hover over links to get the transaction count.

Click on nodes to move.

From Terra to Wormhole, Transaction Status, Jan 12 to Feb 13

Collapsible Tree

Click on the nodes to expand the tree.

Scroll to zoom.

From Terra to Wormhole, Transaction Status, Jan 12 to Feb 13

Observations

Sankey diagrams offer a lot of information at a glance.

Transactions from Terra to other chains were observed for a period of one-month. Only 3% of transactions failed (377). The destination chain with the highest rate of failed transactions was Solana. A total of 245 transactions destined for Solana failed, which is a rate of 3.4%. Solana is also the most popular destination chain.

 

Annex A: Failed Diagrams

This annex is my way to honor my failed diagrams. May these discarded projects pass through the wormhole and into the great beyond.

Alluvial Chart

Paralel Set Plot

The ggalluvial package produces a diagram that is similar to a Sankey. It is tempting to use alluvial plots because they can be created quickly. However, the resulting diagrams requires a lot of formatting. Sankeys offer more compelling visuals that also pack more information.

Sankey Diagram - Multiverse Edition

This Sankey shows transaction status at the final node. The advantage is that it shows the number of failed transaction per recipient chain. However, this Sankey can lead the viewer to believe that transactions fail after they have reached the destination chain. In reality, transactions fail on Terra before they make it through the wormhole.

 

Thank you for reading. I had fun building this project.