Try Quests to earn NEARNEAR Tournament Round IV: The Journeymen
Introduction
“At NEAR, we believe in a world where people can control their assets, their data, and their power of governance,” said Marieke Flament, NEAR Foundation’s CEO. “We believe that is key to creating an Open Web world. A world where everyone can engage and participate; a world where new business models can be created, and where creators, developers, and users can be better rewarded.”
Method :monocle_face:
Join me on this comprehensive dashboard. We are able to see the actions of a bridger men on the Near protocol after he or she has bridged from other chains to the Near protocol. It was my intention to trace the following Bridger activities:
> Using queries in The Rainbow Bridge Grand Prizes, I first determine which tables to query in order to obtain the Bridger addresses. These tables are ethereum.core.fact event logs and flipside prod db.mdao near.transactions. > > After that, I added up all the cashflow sent to the near ecosystem by means of these bridgers. Then, you may keep tabs on these bridgers' stake activities over time by transaction count, holder count, and stake volume in Ⓝ and US $ using the near.core.fact actions events function call table. > > Next, I examined the evolution of the Arts district's NFT marketplaces by filtering the near.core.fact receipts table using the receiver Id in ('marketplace.paras.near," "market.mintbase1.near').
It's been too long, right? Hold on, I'm just getting started on this journey. :sweat_smile:
> Tables 1 and 2 provide my taxonomy of whales and fishes from the Bridger to the Near region. We needed to know the wallet balances of the whales and fishes in order to do this, but there is ==NO== simple way to do so within Flipside's Near database. Instead, I used the amount of money that entered and left each address to determine the balance of each wallet, labelling the top 1000 wallets with the highest balances as whales and the first 1000 wallets with more than 1000 Ⓝ as fishes. > > Knowing the Whales and Fishes in this way allowed me to monitor their exchanges and stakes in the financial district and their transactions on the NFT marketplaces in the Arts District in terms of sales and bought volume as well as the number of days they spent on the NFT marketplaces after bridging.
In order to follow the bridgers as they move through the NEAR ecosystem, I used the date of the bridge transactions as a starting point and tracked all transactions from that point on.
Now, I realise that this is a rather lengthy journey, but I hope that you enjoy it as much as I did. :clown_face:
Conclusion
- Bridge from Ethereum => Near
> Total Volume= 3,33B $ > > Total Tx count= 31,356 > > Total Receiver= 14,633
- Bridge from Aurora => Near
> Total Volume= 1,45B $ > > Total Tx count= 190,016 > > Total Receiver= 29,816
- Staking by Bridgers ==Vis 7=> 19
> On Staking, there were several bridgers, but not many. Huge. Market volatility undoubtedly played a factor. The 2022 volume rise happened from October through November. After staking, transaction volume fell. > November and March make up 23-22% of Staked volume and 26-20% of transactions. > > advocado.near, minhtamtamminh.near & sentry.near are in the top 3 place in Staking volume with more than 30% of Staked volume.
- Activities on NFTs Marketplaces ==Vis 20 => 30
> Average and median NFT costs are above. > NFTs have risen in price from 0.1 N to 6-9 Ⓝ. > 125 Ⓝ cost more on September 18. > Median prices were 0.1 Ⓝ before the recession and are now 4.5 Ⓝ.
- Staking Activities by Whales & Fishes Bridgers after ridge ==Vis 31 => 50
> The whales have the most Staking transactions and Ⓝ volume. Both Whales and Fishes had high Staking volumes in January, but only Whales did so in February, March, and early May. Fish weren't active. > 1,434 Whales Staked N$17.7M. > In over 750 trades, Fishes Staked over 7.5m Ⓝ. This shows that fishes were half as active as whales during the same time period and with the same number of Bridgers.
- NFTs Marketplaces Activities by Whales & Fishes Bridgers after ridge ==Vis 51 => 70
> The quantity and value of NFTs sold on NEAR are shown in the graph. > > Since August 2021, 1666 Whale and 1850 Fish sales have been registered in NEAR. January through March 2022 drove this rise.
- Swapping Activities by Whales & Fishes Bridgers after ridge ==Vis 71 => 92
> Whales bought 20.8% (5.3 Ⓝ) of all NFT on NEAR from the Antisocial Ape Club (ASAC) collection. Whales' nearnautnft.near collection sold 43% (637k Ⓝ) of all NFTs. Fishes purchased 19.1% (3.2 Ⓝ) of NEAR's NFT volume from the secretskelliessociety.near collection. Nearnautnft.near accounted for 21.8% (80k Ⓝ) of Fishes' NFT purchases on NEAR. > > On that occasion, Whales traded the most. Over 30,000 whale transactions have converted $10 million to USDT. With over 62k traded to USDT across 353 transactions, DAI is more popular with Fishes than Whales. > > On May 10, 2022.2, most swappers exchanged Stablecoins for NEAR, which is worth more USDT. > > Fishes' moves to NEAR from stablecoins weren't uniform, and they haven't followed any trends. > > Whales have made over 30,000 USDT exchanges for over $12 million.
***At the End of this Book, the Journey Remains… ***:end:
About:
-
Author: HaM☰d
\
-
Discord: 0xHaM☰d#8391
\
-
Twitter: @arjmandi_hamed
\
-
Email: h_arjmandi2012@yahoo.com
The foundations of a great city are built by its citizens; where they’ve been, where they’ll go, what they do along the way.
Analyze the journey of active NEAR users. After bridging to NEAR, where do they head first?
How many users are day trading in the financial district, and how many are buyers and sellers on the NFT marketplaces of the Arts district?
Who are the whales, and is their activity any different from that of smaller fish?
Top submissions should provide an in-depth analysis of the typical NEAR user journey, from small fish to the biggest whales.
Image \n
Hey there 👋!
Firstly, I appreciate you sticking with it until the conclusion.
I’m Hamed, Ph.D. In Civil Engineering and interested in data science.
I've made many similar dashboards and visualizations since I started at Flipside in January.
Please have a look at my various contact information and let me know what you think.
Alright, alright, alright… 🤔
> In this PIE chart (==Vis 4==) we can see that, in amongst of all 43.1k bridgers, nearly 28k of them previously were citizen of NEAR and 6.87k of them are Newcomers.
NOTE: Previously citizen of Near are who that have had at least one transactions before bridge from other chains to near, and called as newcomer, if that has after bridging or with that.
So, we know how many are old citizen or newcomer, from those who bridged from other chains.
Vis 5 & 6:
- Now we can see that where is destinations of these bridgers in Vis 5 & 6.
> I filtered Method_Name on near.core.fact_actions_events_function_call table by Having tx_signer > 1000, that means count all functions that have had more that 1000 users amongst forename bridgers. > > As of these charts can observed that ft_transfer_call, storage_deposit, near_wirthraw, near_deposit & deposit_and_stake are the functions with most user interactions.
- Our mission would be started from here. We would like to look at exactly what is happening in these functions. Hence, I will deep dive into some of these functions to track bridger activities on those.
Ok, Now we know that 33k people from 43k initial bridgers Staked 267.6m Ⓝ over time after bridge from Ethereum & Aurora.
> Hmmm, A significant number of bridgers were active on Staking, but NOT in volume. It’s so meaningful 🥶. I think that was because of market volatile on few month ago, as we can see From middle of Oct, 2022 till late of Nov, most amount of volume has Staked. and after that we observed a downward trend on volume and transaction count to Staking. > > November & March has the most share of Staked volume and transactions count, by 23 & 22% on Volume, and 26 & 20% on transactions count, respectively.
🏆 Who, In Your Opinion, are the Top 10 Stakers after bridging?!
Let’s Go to See Who are Top 10 Stakers Over Time by Weekly & All the Time. (==oh, Wait, I Identified them by Their Staked Ⓝ Volume not any Else==) :woozy_face:
🏙️ Vis 16 => 19
- In this Section Top 10 Stakers was known, and understood that advocado.near, minhtamtamminh.near & sentry.near are in the top 3 place in Staking volume with more than 30% of Staked volume.
Bridgers are so intrested in NFTs marketplasec.
Overall view of activities of bridgers are shown in the single numbers.
In middle of Jan till early of May have had most volatile on marketplaces in Ⓝ & $ volume(Vis 20).
In Vis 21 & 22, we classified bridgers based on their activities on Near ecosystem by their transactions count.
Most activities of bridgers took placed on Oct till early of Feb.
Findings:
In the Vis 23, since September 2021, we have seen an increase in the number of bridgers who have interacted with NFTs, but a decline in the percentage of bridgers who have purchased NFTs.
The Vis 23, shows us the days of bridgers on NFTs marketplaces. we can see that most of bridgers spent most their days without transactions on NFTs after bridging.
Cumulative number of sales count and sales volume in Ⓝ are shown In the Vis 25, more than 310k Ⓝ sold in more than 23k sales transactions, in total.
As of Vis 26, there has been a rising pattern in the selling price of NFTs on NEAR.
The average and median prices of NFTs on Ⓝ are displayed above.
For the most part, the average selling price of NFTs on Ⓝ has risen from 0.1 Ⓝ to the present range of 6-9 Ⓝ.
There was an increase in average price of 125 Ⓝ on September 18th.
When compared to where they were before the recession, median prices are up from below 0.1 Ⓝ to where they are now, at 4.5 Ⓝ.
As a result, half of all NFTs sold recently had a value of 4.5 Ⓝ or less.
This core idea of this part is credited to Pinehearst’s Dashboard. I used and chaged it to ==bridgers== activities on NFTs marketplaces.
:1st_place_medal: This section shows the total volume and shares of ==top 10== NFT collections bought and sold by birdgers on NEAR
- Collectively, the top 10 collections contributed to ~60% of all sales volume
- The top collection was the NEARNAUTNFT.NEAR, taking 24% of all NFT bought and 31% of sales volume by bridgers on NEAR.
Findings:
-
Similar to how user growth affects NFT volume, NEAR's NFT volume has been progressively falling since January 2022.
-
Each day, the Vis 51=>60 displays the total number of NFTs sold on Ⓝ and the volume of sales.
-
It wasn't until 2022 that NFT sales volume began to rise. Before 2022, whales sold an average of 10 NEAR each day while fish sold an average of 5 Ⓝ.
-
As of right now, the daily amount of NFT sales on Ⓝ is down to ten Ⓝ, just as it was before 2022.
-
The increase in new NFT buyers is reflected in a rise in the volume and number of NFTs sold on Ⓝ, as indicated previously.
\
The NFT bull season for NEAR was January 2022 - March 2022.
The preceding graph details the total number and amount of NFTs sold on NEAR.
Since August of 2021, sales have totaled 28k by Whales and 29k by Fishes(in NEAR), with 1666 & 1850 individual transactions, rexpectively.
The months of January through March of 2022 accounted for the vast majority of this expansion.
- Whales and Fishes tends on choosing validates are similar, but different in percentage shares of transactions count and Staked volume.
- Share of transactions count and Staked volume are shown in the following PIE charts.
Vis 35 & 36:
- Cumulative amount of Staked volume in Ⓝ and transactions count are increasingly by Whale and Fishes after bridging.
- More than 17.7m volume in Ⓝ was Staked by 1434 transactions by Whales in total.
- More than 7.5m volume in Ⓝ was Staked by 750 transactions by Fishes in total.
- This shows that, in the same period time, and equal number of Bridgers on Whales and Fishes, the activities by Fishes were half of whales.
I haven't been able to find a more accurate technique to determine the value of a near wallet than the one provided by . However, this method finally satisfied my craving for whale and fish discovery. I could only use this way on the dashboard.
> The way to defined Whales and Fishes are explained on Methodology.
Part III-I: Whales & Fishes bridger on Stake activities.
> All of following metrics are assessed after bridging from other chains to NEAR
Findings:
The Vis 63 => 70, shows the total volume of sales and bought by the top 10 NFT collections by Whales and Fishes on NEAR
- Collectively, the top 10 collections contributed to ~60% of all sales volume
> The top bought collection by Whales was the Antisocial **Ape Club (**ASAC), taking 20.8% (5.3 Ⓝ) of all NFT bought volume on NEAR. > > The top sold collection by Whales was the nearnautnft.near, taking 43% (637k Ⓝ) of all NFT sales volume on NEAR. > > The top bought collection by Fishes was the secretskelliessociety.near, taking 19.1% (3.2 Ⓝ) of all NFT bought volume on NEAR. > > The top sold collection by Fishes was the nearnautnft.near, taking 21.8% (80k Ⓝ) of all NFT sales volume on NEAR.
The core Idea is credited to previouse Link. I edited it to Whales and Fishes bridger after bridge.
Findings:
- The first high point in the volume of transactions occurred on June 13th by Whales, However, beginning in late of Mars and continuing until late June, daily transaction volume fell to below 50 by Whales. The most purchases were made with each stablecoin on May 11th. Initially, we knew that this date is the start of Luna crash and market volatile.
- This pattern were followed by Fishes but in more low scale.
- That date also saw the highest volume of volume swaps by Whales.
- More than ==10m swapped to USDT== by Whales by 30k transactions count.
- More than ==62k swapped to USDT== in volume by 353 transactions count by Fishes.
- DAI is more popular amongst the Fishes than Whales.
Findings:
- The number of swaps reached its highest point on May 10th, 2022 by Whales, marking the peak of the trading activity. But after that, the number of transactions per day fell below 50, beginning in Mars and continuing until late of June of 2022. On May 10th, there was a rise in the total number of transactions that took place across all stablecoins. The first token to be used as a switching source was USDT, which had a transaction count of more over 1300 by Whales and 10 by Fishes.
- On May 10th, 2022, the vast majority of one-of-a-kind swappers traded their Stablecoins for NEAR, which is equivalent to more USDT.
- Swapping to NEAR from stablecoins by Fishes weren’t on a steady trend and fishes haven’t had follow any trends.
- More than ==12m swapped From USDT== by Whales by more than 30k transactions count.