Goal:

How many smart contracts are deployed on NEAR protocol per day? Let’s find it.

\n Questions:

• Visualize the number of new smart contracts deployed over time over a time period of your choosing.
• What are the top 5 new smart contracts interacted in that period of your choosing?

Solutions:

To answer this question, I used near.core.fact_actions_events table. The time frame I choose for counting the number of new smart contracts deployed is since the beginning of 2022.

I’m looking for some transactions that have the following condition:

action_name = 'DeployContract'

Also, I found the addresses of them from near.core.fact_transactions and tx_receiver column. `

This chart shows the number of smart contracts that are deployed per day.

the blue line shows the cumulative number of new deployed smart contracts.

There are some spikes on the daily chart. The average number is around 80 but some days reached more than 1000.

Since the beginning of 2022, around 26K smart contracts are deployed on the NEAR protocol.

The right chart shows the top 10 smart contracts based on user interactions.

As you can see:

:1st_place_medal:0xfluxs.near (40.9%)

:2nd_place_medal:nearbiez.near (10.7%) is related to Nearbiez NFT collection.

:3rd_place_medal:marssooh.near (7.18%) is one of the verified creators on Paras.

These charts show the overview of interaction users by each of smarts contract.

Conclusion:

• Deployed more than 26K smart contracts since the beginning of 2022.
• The top 3 new smart contracts interacted with are:
  • :1st_place_medal:0xfluxs.near (40.9%)
  • :2nd_place_medal:nearbiez.near (10.7%)
  • :3rd_place_medal:marssooh.near (7.18%)