Question:

Q2. Every city has its monuments, as well as its transit systems.

In the City of NEAR, the legendary Rainbow Bridge is an object of great importance to the people: a wondrous object that enables passage to and from other cities.

Visualize the Bridge’s activity over the past 90 days, using an activity metric of your choice (in your Methodology section, clearly define your chosen metric). As well, analyze the Bridge usage via at least 3 clearly defined metrics of your choosing (examples: volume, TVL, change in TVL over time, number of repeated trips vs. one-time users, origin and destination).

Overview of dashboard:

The aim of this bounty is investigating on performance of Rainbow Bridge on Near blockchain. For this analysis various metrics have been selected as:

• Count of bridge usage
• Paid fee to blockchain for bridging
• Count of unique senders via bridge
• Bridge from Ethereum to Near

Approach:

The assumptions and used tables have been clarified in this section as below:

• Bridge in NEAR

  from flipside_prod_db.mdao_near.actions_events_function_call where method_name ='ft_transfer_call' and (parse_json(args)):receiver_id = 'aurora'

• Obtaining fee and sender

  left outer join flipside_prod_db.mdao_near.transactions y on x.TXN_HASH=y.TXN_HASH -- joining transaction table by TXN_HASH

• Sending from Ethereum to NEAR\

  from ethereum.core.ez_token_transfers

  where CONTRACT_ADDRESS='0x85f17cf997934a597031b2e18a9ab6ebd4b9f6a4'

  and ORIGIN_TO_ADDRESS='0x85f17cf997934a597031b2e18a9ab6ebd4b9f6a4'

• Time period

  BLOCK_TIMESTAMP>=CURRENT_DATE-90

Key findings 1:

The results related to the chosen metrics for usage of Rainbow Bridge have been presented as below:

1. The highest usage of this bridge occurred on May 1 with 2855 count of usage.
2. The usage of Rainbow Bridge has been reduced since May 12 and the main reason of this reduction is because of the harsh market condition on Crypto universe.
3. The grow rate of application of Rainbow Bridge reveals via cumulative figure and based on this graph, since middle of May the gradient of line decreased accordingly.
4. The number of unique senders via Rainbow Bridge has been decreased over time and the highest count of participants occurred on April 22 with 876 unique users.
5. About 6.85 NEAR has been paid as fee for bridging on May 1 and its the highest paid fee in the past 90 days.

Key findings 2:

The amount of Near token sent from Ethereum blockchain to NEAR presented in the bar graph and according to that graph, the highest sent occurred on May 1 with more than 71.4k Near tokens.

Also, the second graph reveals that the total number of 8 unique users bridged Near token from Ethereum to NEAR in 11 transactions.