Introduction

The Rainbow Bridge connects the Ethereum, NEAR, and Aurora networks with each other. Aurora, the NEAR-based scalability solution for Ethereum, is responsible for creating the bridge.

The bridge can be used to transfer tokens between any of the three networks that it connects to. Bridging can include as little as one transaction, or as many as two, depending on the chosen direction. Transfers to NEAR and Aurora can take up to 10 minutes and require a single transaction. Ethereum transfers require two separate transactions and can take up to 12 hours to complete. Transfers between NEAR and Aurora are fast, need only one transaction, and cost only a few cents.

Method

In tis dashboard I tried to calculate the volume bridged from NEAR to Aurora and from Ethereum to NEAR and for this I used ***flipside_prod_db.mdao_near.actions_events_function_call ***table, but when tried to do this I got a problem with decimal for volume bridged amount, so to escape from this issue I applied a politic in such a way that calculate the length of amount in *ARGS *column, and categorized that in three class as when

when length_amt BETWEEN 9 and 13 then amt/1e6 when length_amt BETWEEN 14 and 21 then amt/1e18 when length_amt >= 22 then amt/1e24

but after that I got a new problem by this error: ***OperationFailedError: Failed to cast variant value "{amount}" to REAL ***and to fix this I run those three classes of transactions in separate queries as below.

And also to calculate the amount of bridged volume from Ethereum to NEAR I used **ethereum.core.fact_event_logs by this filter: WHERE EVENT_NAME = 'TransferToNearInitiated'

> So let’s look at the results as below.

Analysis

Conclusion

In this dashboard I tried to calculate The amount of bridged volume from NEAR to Aurora and from Ethereum to NEAR.
so as of shown above charts, the highest count of tx was took placed on May 11th with more than 1350 tx per day, and most bridged volume transferred on June 7th, with more than 16.5m $NEAR to Aurora, and 35k tx & 78m volume in total.

\
In contract this metrics for transferred to USDC & USDT from NEAR to Aurora: the highest count of tx was took placed on May 1th with more than 1566 tx per day, and most bridged volume transferred on April 19th, with more than 204m $NEAR to Aurora, and 10k tx & 1.3B volume in total.

\
In the other hand same metrics for transferred to WETH & WBTC from NEAR to Aurora: the highest count of tx was took placed on May 17th with more than 818 tx per day, and most bridged volume transferred on May17th, with more than 102k $NEAR to Aurora, and 12k tx & 1m volume in total.

\
On May 1th, 0.015 $ETH was paid as fees and more than 147 $NEAR in total.

\
The same metrics for transferred from Ethereum to NEAR : the highest count of tx was took placed on April 22th with more than 7 tx per day, and most bridged volume transferred on June 9th, with more than 52k transferred volume, and 67 tx & 66 volume in total.

\
On May 1th, 6.8 $NEAR was paid as fees and more than 0.11 $ETH in total.

About:

Author: HaM☰d
Discord: 0xHaM☰d#8391

\
Twitter: @arjmandi_hamed

\
Email: h_arjmandi2012@yahoo.com

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. \n

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).