Introduction

NEAR Protocol is a layer-1 blockchain that uses Nightshade, a unique sharding technology, to achieve scalability. It was launched in 2020 as a decentralized cloud infrastructure to host decentralized applications (DApps).

NEAR offers cross-chain interoperability through the Rainbow Bridge and a layer-2 solution called Aurora. Users can bridge ERC-20 tokens and assets from the Ethereum blockchain to the NEAR Protocol network, which gives them access to higher throughput and lower transaction fees.

In this dashboard we are going to make an assessment about the number of contracts deployed on NEAR.

Summary

Let’s summarized our research in a few sentences.

• Since 2022, almost 9920 contracts has been deployed on NEAR chain.
• There is a meaningful correlation between daily number of new contract deployments with the price of NEAR.
• Since 2022, the Aurora contract, with more than 50% of user interaction is in the first place.
• Since 2022, 0xfluxs.near had the most number of upgrades, more than 400 times, a very large number!

Top Contracts by Number of Upgrades

As mentioned earlier, the NEAR ecosystem allows contract upgrades by redeploying it with the required changes.

Since 2022, 0xfluxs.near had the most number of upgrades, more than 400 times, a very large number!

Top 5 Contracts by User Interaction

By looking at the charts below, the top 5 contracts by user interaction can be seen. User interaction simply means the number of distinct transaction each contract had.

Since 2022, the Aurora contract, with more than 50% of user interaction is in the first place, followed by Nearcrowd with 27% of the interactions.

Daily Number of Deployment

The chart below shows the daily amount of contracts being deployed each day. These number are only related to first time deployment and not upgrades. Contract upgrades are discussed in next sections.

The NEAR/USD price chart is also present, to find any correlation between contract creation and NEAR’s price.

It can be seen that:

• During the first half of January, as price increased, the number of new contracts deployed each day also increased.

• Since Jan 20 to March 20, almost for a month, there is a decline in number of contracts deployed each day, during this period the price of NEAR is also stagnant.

• During April as the price soars, the number of contracts are also increased.

• Since Apr 22, as the price of NEAR declines, the number of contracts deployed declines too.

• There is a meaningful correlation between daily number of new contract deployments with the price of NEAR.

  \

Total Number of Contracts

The total number of contracts can be seen in this section.

• Since 2022, almost 9920 contracts has been deployed on NEAR chain.

Approach

Tables

The following table are used in this study:

• near.core.fact_actions_events → This table is mainly used to find ==contract deployment== transactions.
• near.core.fact_transactions → This table is used to ==access transactions== and also get transactions related to contract deployer.

Studied Period

We are studying NEAR contract deployments since 2022, The results are all from this time period. It is possible to change the StartDate parameter and see the charts for different periods.

Contract Deployment

To find all transactions related to contract deployment, we will query near.core.fact_actions_events table, by looking at the transactions of some of well known contracts on NEAR, such as aurora etc., ==DeployContract== is a very common ACTION amongst these contracts, this type of action is used when a contract is to be deployed. NEAR also allows contract upgrades, which uses the same ACTION as deployment.

In order to find all deployment transactions following piece of code is use:

WHERE ACTION_NAME ilike 'DeployContract'