Question:

 What tokens and blockchains are users interacting with when bridging to and from Flow?

An analysis could include what protocols users are leveraging after bridging TO Flow from another chain, as well as what chains contribute to the most bridge volume. Or you could do the reverse, where are users going from Flow to another chain going? What were they interacting with on Flow before bridging out?

Methodology:

• We would be using the flow .core.bridge_transactions table for viewing the transactions and making an analysis of it. We would segregate our analysis into 2 parts-
• One for inbound where the direction would be set as inbound and other variables like blockchain and token contract would be looked into
• And the other would be outbound where the same variables would be compared and finally a conclusion would be made

Query 1:

SELECT date(block_timestamp) as day, blockchain, token_contract, count(DISTINCT tx_id) as total_txs, sum(total_txs) over (partition by blockchain, token_contract order by day ) as cumulative_txs from flow.core.fact_bridge_transactions where direction != 'inbound' GROUP by 1,2 , 3

Query 2:

SELECT date(block_timestamp) as day, blockchain, token_contract, count(DISTINCT tx_id) as total_txs, sum(total_txs) over (partition by blockchain, token_contract order by day ) as cumulative_txs from flow.core.fact_bridge_transactions where direction = 'inbound' GROUP by 1,2 , 3

Summary:

• Total Transactions by Token Inbound and chain
• Which token for Inbound
• Blockchain by Inbound direction
• Cumulative Transactions by Chain (for Inbound)
• Total Transactions by Token Outbound and chain
• Which token for Outbound
• Blockchain by outbound direction
• Cumulative Transactions by Chain (for outbound)

Some Explanation & Insights:

• Blockto was the most transferred token to the flow chain followed by Tether, Starly, REVV & FLOW with a dominance of 40%, 24%, 11%, 9% and 6%
• Most inbound was from Ethereum followed by Solana, BSC and Polygon with a dominance of 44%, 30%, 23% and 2% respectively
• In all across chains 400+ transactions have been made inbound to the bridges
• The transactions for Blockt Token have taken place in a heap as can be seen towards the end

Some Explanation & Insights:

• Blockto was the most transferred token from the flow chain followed by Tether, RLY , FLOW & Starly with a dominance of 34%, 27%, 25%, 6% and 3%
• Most outbound was from Ethereum followed by Solana, BSC and Polygon with a dominance of 64%, 28%, 10% and 0.2% respectively
• In all across chains 1400+ transactions have been made outbound to the bridges
• The transactions for RLY Token have taken place in a heap as can be seen towards the end

Next, let’s view some stats on amounts:

Explanation & Insights:

• Outbound have more amount (in $) than inbounds (in the ratio of about 3:1)
• 1.8M inbounds vs 300k inbouns in $ since April
• Blockto bridge has almost 9x more transaction by amount than cbridge
• About 1M$ has been transferred in a single day alone!
• TeleportedTetherToken is the most popular fro transfers followed by FLOW and BLT with dominances -50%,24% and 19% respectively. These 3 alone account for 95% of all transactions by amount
• FLOW had the most transactions on 10th May, the day of LUNA’s crash where the market volatility was very high implying that FLOW generally reacts more during highly volatile times at the bridges.

Conclusions:

• The users tend to leave more (in smaller amounts) than enter as the number of transactions outgoing is at 1400+ while incoming is at 400+ which is about a 3x difference

• The dominance of Blockto is seen within the Chain as most transactions were linked to it and most inbound transactions were related to Blockto

• Ethereum is a much more favourite chain to exit than to enter for users while BSC is a favourite spot for entry than exit. So, one can say users enter from BSC to Ethereum via FLOW

• For outbound RLY token was the most popular one than for inbound

• After Ethereum, the popular chains in order are Solana, BSC & polygon

• Blockto & Tether are more popular for both inbound & outbound than flow

• Outbounds are popular than inbounds

• BlockTo > Cbridge

• TeleportedTether, FLOW & BLT are the most popular tokens

  \