Provide and explore key health metrics, as well as detailed data on at least 1 key project.

In your analysis, provide visualizations of USN, USDC and USDT breakdowns (i.e. which dapps and addresses hold the majority of USDC and USDT, and what cumulative flows to & from exchanges look like over time)

1 - Project :

Pumpopoly is a virtual real estate simulator game. It can be played on all devices and is designed in pixel art on an animated HTML5 canvas.

The gameplay is simple. Players collect a salary from the treasury when moving on the map (Drive&Claim). Players who park on land owned by other players pay rent to the landlord (owner of the land). Parking is free at all city properties.

Its native token is $PUMPOPOLY.

Currently, the game offers 5 types of unique properties - minted on the NEAR blockchain, and unlocked as your credit score increases (which increases when you invite new players). There are 256 pixel art variations for each property type, with 1024 variations each, improving rental income as well.

The bulk of the community chats on Discord and giveaways are being made on Twitter.

Project 1 : Review of the Pumpopoly project

Project 2 :Paras

Paras, an NFT marketplace for digital art cards, is one of the most active communities within the NEAR ecosystem. What began as a decentralized social media platform is now a vibrant mecca for crypto art. Everything from one-off artworks to themed series can be found on Paras. 

Late last year, the Jakarta-headquartered team released a new product, Paras Comic. As the first home for digital comics on NEAR, writers and illustrators can upload their digital comics as collectible NFTs. Now, comics and crypto art fans alike can interact, engage, and support creators by buying NFTs, and even tipping the artists. 

The Paras team isn’t stopping with NFT artworks and comics. As co-founder Rahmat “Riqi” Albariqi tells NEAR Foundation, Paras plans to release a few other features in the coming months. It’s all part of the plan to be a broad cultural hub for NFTs. 

In the diagram below For the Paras project The number and growth of NFT purchases weekly checked

• The largest purchase was in the third week of February 2022

In the diagram below In the Paras project The number of offers and the growth of offers on a weekly basis checked

• The highest offer was in the second week of January 2022

ref-finance.near-Tasks

In the diagram below For the Paras project Top 10 tasks Based on the number of do checked

Transfers ranks first with about 1 million transactions

In the diagram below For the Paras project Top 10 tasks Based on the number of do checked

• Transfers ranks first with about 33%

ref-finance.near-Swaps To

ref-finance.near-Swaps From

Deposit To ref-finance.near

Withdraw From ref-finance.near

Add liquidity To ref-finance.near

Add liquidity To ref-finance.near→pairs

Dapps-Holding→USDC

Dapps-Holding→USN

Dapps-Holding→USDT

In the diagram below Dollar volume and its growth Based on dapps weekly checked

• The highest was on May 2, 2022

In the diagram below Dollar volume and number of transactions Based on dapps checked

• The most is for the burrow.near project

In the diagram below volume and number of transactions Based on dapps checked

• The most is for the burrow.near project

In the table below Based on the USDT token By grouping dapps Number and volume and dollar volume of transfers to dapps checked

• The largest volume was for the burrow.near project

In the diagram below as a percentage volume of USD checked

• The highest is for burrow.near with about 57%

In the diagram below Dollar volume and number of transactions Based on dapps checked

• The most is for the ref-finance.near project

In the diagram below volume and number of transactions Based on dapps checked

• The most is for the ref-finance.near project

In the diagram below Dollar volume and its growth Based on dapps weekly checked

• The highest was on May 9, 2022

In the table below Based on the USN token By grouping dapps Number and volume and dollar volume of transfers to dapps checked

• The largest volume was for the ref-finance.near project

In the diagram below as a percentage volume checked

• The highest is for ref-finance.near with about 66%

In the diagram below Dollar volume and its growth Based on dapps weekly checked

• The highest was on April 18, 2022

In the diagram below Dollar volume and number of transactions Based on dapps checked

• The most is for the burrow.near project

In the diagram below volume and number of transactions Based on dapps checked

• The most is for the burrow.near project

In the table below Based on the USDC token By grouping dapps Number and volume and dollar volume of transfers to dapps checked

• The largest volume was for the burrow.near project

In the diagram below as a percentage of dollar volume checked

• The highest is for burrow.near with about 68%

In the diagram below The number of unique users and its growth Based on pairs weekly checked

• The highest add liquidity was on October 4, 2021

In the diagram below volume and its growth Based on pairs weekly checked

• The largest volume of add liquidity was on April 25, 2022

In the diagram below Dollar volume and its growth Based on pairs weekly checked

• The largest volume of add liquidity was on May 9

In the percentage charts below add liquidity Volume and dollar volume and number of users and number of transactions Checked based on pairs

• The highest volume for USDT<=>NEAR with about 32 percent
• The largest dollar volume for USDT<=>NEAR with about 17%
• Most users for USDT<=>NEAR with about 22%
• Most transaction for USDT<=>NEAR with about 22%

In the percentage charts below Volume and dollar volume and number of users and number of transactions Checked based on tokens

• The largest volume for NEAR with about 26%
• The largest dollar volume for NEAR with about 53%
• The most users for NEAR with about 45%
• The most transaction for NEAR with about 70%

In the diagram below Add liquidity dollar volume Checked based on tokens

• The largest volume was for NEAR

In the diagram below Add liquidity volume Checked based on tokens

• The largest volume was for NEAR

In the diagram below The number of add liquidity users Checked based on tokens

• The highest number was for NEAR

In the diagram below The number of add liquidity Checked based on tokens

• The highest number was for NEAR

In the diagram below Dollar volume and growth based on tokens weekly checked

• The highest volume was on May 9, 2022

In the diagram below Volume and growth based on tokens weekly checked

• The highest volume was on May 9, 2022

In the diagram below The number of withdrawer and its growth based on tokens weekly checked

• The highest was on October 25 , 2022

In the diagram below Volume Checked based on tokens

• The largest volume is for USDT with about 52%

In the diagram below Dollar volume Checked based on tokens

• The largest volume is for NEAR with about 53%

In the diagram below The number of depositors and its growth based on tokens weekly checked

• The highest was on April 18, 2022

In the diagram below Dollar volume and growth based on tokens weekly checked

• The highest volume was on May 9, 2022

In the diagram below Volume and growth based on tokens weekly checked

• The highest volume was on May 9, 2022

In the diagram below Volume Checked based on tokens

• The largest volume is for USDT with about 54%

In the diagram below Dollar volume Checked based on tokens

• The largest volume is for NEAR with about 40%

In the diagram below Number of swaps and growth weekly checked

• The largest swap was on October 4, 2021

In the diagram below Dollar volume and growth weekly checked

• The largest swap was on June 13, 2022

In the diagram below volume and growth weekly checked

• The largest swap was on June 13, 2022

In the diagram below Dollar volume of swaps checked

• NEAR token has the largest volume with about 57%

In the diagram below The volume of swaps as a percentage checked

• USDT token with about 51%

In the diagram below Swaps for top 10 tokens in ref.finance checked(Volume)

• The USDT token has the largest volume
• NEAR token is in the second place

In the diagram below Number of swaps and growth weekly checked

• The largest swap was on October 4, 2021

In the diagram below Dollar volume and growth weekly checked

• The largest swap was on June 13, 2022

In the diagram below volume and growth weekly checked

• The largest swap was on June 13, 2022

In the diagram below Dollar volume of swaps checked

• NEAR token has the largest volume with about 57%

In the diagram below The volume of swaps as a percentage checked

• USDT token with about 50%

In the diagram below Swaps for top 10 tokens in ref.finance checked(Volume)

• The USDT token has the largest volume
• NEAR token is in the second place

In the diagram below For the Paras project Top 10 tasks Based on the growth of the number of do weekly checked

• The highest growth has been for transfer

In the diagram below For the Paras project Top 10 tasks Based on the number of do weekly checked

• The highest number of tasks was on October 4, 2021

In the diagram below For the Paras project The number and growth of new wallets created Checked weekly

• The most wallets were created in the second week of January 2022

In the diagram below For the Paras project Distribution of the number of NFT seller users It has been reviewed in 4 categories

• Number 1 to 10 had the largest share with 47%

In the diagram below For the Paras project Distribution of the number of NFT seller users It has been reviewed in 4 categories

• Number 1 to 10 with about 11 thousand had the largest share

In the diagram below For the Paras project The number of NFT purchases and its growth weekly checked

• The highest number was in the third week of February 2022

In the diagram below For the Paras project The volume and growth of NFT purchases weekly checked

• The highest volume was in the last week of January 2022

In the diagram below For the Paras project The number and growth of NFT purchases based on the number of users weekly checked

• The most users were in the third week of February 2022

under General statistics of the Paras project It is presented in 8 categories Also, the number of 8 popular NFTs of this project is given in the form of a picture

In the diagram below In the Paras project The number of unique wallets offered and their growth Checked weekly checked

• The highest offer was in the second week of February 2022

In the diagram below In the Paras project The volume of offers and their growth Checked weekly checked

• The highest volume was in the third week of February 2022

In the diagram below In the Paras project Number of NFTs Checked weekly checked

• The highest NFT was in the second week of February 2022

In the diagram below Growing the number of tasks in the Pumpopoly project Based on the number of users Checked daily

• It seems that the move_player task has grown the most

In the diagram below The number of tasks in the Pumpopoly project Based on the number of users Checked daily

In the diagram below Growing the number of tasks in the Pumpopoly project Checked daily

In the diagram below Pumpopoly project tasks Checked daily

• On March 20, 2022, the most task occurred

In the charts below General statistics of the Pumpopoly project it has been shown which has been played about 5640 times

In the diagram below, pumpopoly.near tasks are checked based on the number and percentage.

• move_player about 87 percent

In the diagram below, pumpopoly.near tasks are checked by number.

• The most task: move_player

Conclusion:

In this dashboard, we examined The Financial District, based on this →

1- Pumpopoly project:

• The most performed task is for move_player with about 87 percent
• The number of land purchases is about 456
• The number of game executions is 5640
• Mint number NFT 52

2- Paras project:

• The number of collections is about 102 thousand
• The number of new wallets is about 78 thousand
• The number of NFTs is about 475 thousand
• Purchase volume of about 2 million NEAR
• The number of offers is about 101 thousand
• The number of purchases is about 165 thousand

1-3- ref.finance project Tasks:

• The highest task for transfer with about 33%
• The second rank is for swap with about 28 percent

3-2 - ref.finance project - Swaps To:

• The largest volume for USDT with about 50%
• The largest dollar volume for NEAR with about 57%
• The largest swap volume on June 13, 2022
• The largest number of swaps on October 4, 2021

3-3 - ref.finance project - Swaps From:

• The highest volume for USDT with about 51%
• The largest dollar volume for NEAR with about 57%
• The largest swap volume on June 13, 2022
• The largest number of swaps on October 4, 2021

Discord ID: Sal☰h#1747

twitter : @saleh03188287

email : saleh.mz@gmail.com

In the table below Add liquidity in the ref.finance project Based on the top 10 tokens

• The highest liquidity is for the NEAR token

In the table below Complete withdraw statistics for the ref.finance project Based on the top 7 tokens

• The USDT token has the largest volume in the project

In the table below Complete deposit statistics for the ref.finance project Based on the top 7 tokens

• The USDT token has the largest volume in the project

In the table below Overall statistics of swaps from top 10 tokens in ref.finance checked

• The USDT token has the largest volume
• NEAR token is in the second place

In the table below Overall statistics of swaps for top 10 tokens in ref.finance checked

• The USDT token has the largest volume
• NEAR token is in the second place

In the table below, the number of fields and playing times and the number of field constructions based on The top users are grouped

• Accordingly, pumpopoly.near has the largest number of land

3-4 - ref.finance-Deposit project:

• The largest deposit volume for USDT with around 54
• The largest deposit on May 9, 2022
• The highest depositor on April 18, 2022

3-5 - ref.finance-withdrawal project:

• The largest withdraw volume for USDC with about 52%
• The maximum withdrawal on October 25, 2021
• The largest withdraw volume on May 9, 2022

3-6 - ref.finance-Add liquidity project:

• The largest volume for NEAR with about 26%

• The largest dollar volume for NEAR with about 53%

• The most users for NEAR with about 45%

• The most transaction for NEAR with about 70%

7-3- ref.finance project - Add liquidity (pairs):

• The highest volume for USDT<=>NEAR with about 32 percent

• The largest dollar volume for USDT<=>NEAR with about 17%

• Most users for USDT<=>NEAR with about 22%

• Most transaction for USDT<=>NEAR with about 22%

4-1- Dapps-Holding→USDC:

• The largest volume was for the burrow. near project with about 68 percent
• The highest volume on April 18, 2022

4-2- Dapps-Holding→USN:

• The highest is for ref-finance. near with about 66%

• The highest volume on May 9, 2022

4-3- Dapps-Holding→USDT:

• The highest is for burrow. near with about 57%
• The highest volume on May 2, 2022

Methodology: In this review, three projects ==1- pumpopoly 2- Paras Superficially and statistically 3- The ref.finance project== was examined in depth: In the review of the ref.finance project:

• Swaps were checked by the method of separating the top tokens to detect the number of decimals also

  case when SYMBOL='USN' then 18 
  when SYMBOL='LiNEAR' then 24
   when SYMBOL='stNEAR' then 24
   when SYMBOL='NEAR' then 24
   when SYMBOL='USDC' then 6
   when SYMBOL='DAI' then 18
   when SYMBOL='USDT' then 6
   when SYMBOL='AURORA' then 18
   when SYMBOL='wETH' then 18
   when SYMBOL='wBTC' then 8
   else 1 end as decimal
  
  
  

And also near.core.fact_receipts was used to extract swaps and only successful transactions were desired with the method status_value like '%Success%' From the table above

• Deposit and Withdrawal for the ref.finance project: The same method as above was used to separate the decimals of the tokens and the tokens USDT and NEAR and wETH and wBTC and AURORA and USDC and DAI It was examined and used to extract deposit data from the logs field in the near.core.fact_receipts table.

Add liquidity for the ref.finance project: To extract tokens from the method

regexp_replace(split_part( array_to_string(logs,','),' ',4) , '(",)') as token1

used And the near.core.fact_prices table was also used for their dollar prices And for pairs too Using join

join lst_token_price p1 on p1.TOKEN_CONTRACT = regexp_replace(split_part( array_to_string(logs,','),' ',4) , '(",)')
join lst_token_price p2 on p2.TOKEN_CONTRACT = regexp_replace(split_part( array_to_string(logs,','),' ',6) , '("],)')
join lst_price lp1 on lp1.TOKEN_CONTRACT = regexp_replace(split_part( array_to_string(logs,','),' ',4) , '(",)')
join lst_price lp2 on lp2.TOKEN_CONTRACT = regexp_replace(split_part( array_to_string(logs,','),' ',6) , '("],)')

Names and prices of tokens were extracted

To extract the holders of USN, USDT and USDC tokens, the 'ft_transfer_call' method was used in the near.core.fact_actions_events_function_call table, and then we were able to extract the transfer of the desired tokens from the near.core.fact_receipts table with the split_part functions.