At first, the number of smart contracts was checked daily in the last three months. According to the graph, you can see that we had the largest number of smart contracts on June 7. But on other days of this period, the number of contracts is much lower than June 7, so that the second rank based on the number of contracts is May 3rd with 87 contracts, but on June 7, 1232 smart contracts were established in NEAR.

On July 16, the number of contracts has reached a minimum of 12 smart contracts. Except for June 7, when the number of contracts is 1232, the other days of this period fluctuate between 12 and 87 contracts. And according to the whole period of 3 months, it is clear that we have had a decreasing trend in smart contracts.

Introduction

what is a Smart Contract? A “Smart Contract” is simply a program that runs on the NEAR blockchain. It is a collection of code (its functions) and data (its state) that resides at a specific address on the NEAR blockchain. You can think of a smart contract as an account on the NEAR network, which runs as a program(LINK).

We want to examine the following two questions in this dashboard: 1-Visualize the number of new smart contracts deployed over time over a time period of your choosing. 2-What are the top 5 new smart contracts interacted in that period of your choosing?

The time period considered for this dashboard is from 1/5/2022 to 31/7/2022.(last three months)

Method

• Used tables: near.core.fact_actions_events | near.core.fact_receipts | near.core.fact_transactions
• Where clause to find new contracts: action_name ilike '%DEPLOYCONTRACT%'
• Method to find top 5 contracts: top 5 tx_receiver by the largest number of txs
• Analysis date range: Last 3 months (May, June, July)

The number of new smart contracts established in NEAR in the last three months is 4380 contracts.From May 1 to May 31, the total number of contracts is 1395. And at the end of June, the number of contracts has reached 3495, which shows that 2100 contracts have been added to the cumulative number in this one month. Also, at the end of July, the total number of contracts is cumulative. It has reached the number of 4380, which is approximately the share of July of this number of 885 contracts. Therefore, July has the lowest number of contracts in the last three months.

Conclusion:

This dashboard showed that the number of smart contracts in the last three months is 4380. It also showed the top 5 smart contracts in the last three months, which is ranked first by aurora with almost 22 million transactions. Also, the lowest number of contracts was in July and the highest number of contracts was in June. Also, on June 7, approximately 28.1 percent of the contracts, i.e. 1232 contracts, were registered in the data.

Top 5 contracts in order of rank: 1) aurora, 2) client.bridge.near , 3) zomland.near , 4) pixeltoken.near and 5) v1.orderbook.near

The donut chart above shows the top 5 smart contracts in the last three months. And in the bar graph, we have checked the share of transactions of the top 5 contracts on a daily basis in the last three months.

The donut chart shows that 91.2% of the transactions belong to the aurora contract, which ranks first among the top 5 contracts. The number of aurora contract transactions is approximately 22 million.

The second top smart contract based on the number of transactions is client.bridge.near, and looking at the donut chart you can see that 255,745 transactions have been recorded for this contract in the last three months.

The second top smart contract based on the number of transactions is client.bridge.near, and looking at the donut chart you can see that 255,745 transactions have been recorded for this contract in the last three months. The third, fourth and fifth ranks belong to the projects zomland.near(247679), pixeltoken.near(156899) and v1.orderbook.near(140105) respectively, the total transactions of these three contracts are 544683 transactions.

Other smart contracts have a total of 1,318,207 transactions registered for them in the last three months.

According to the above bar chart, the highest daily transaction for aurora contract was on May 10 with 981530 transactions recorded.

Most daily transaction for contract client.bridge.near On July 31, almost 3000 transactions were recorded.

> Thanks to my friends: camp#4286 and SGH#8588