Methodology

First the question asked for finding number of smart contracts over a time period

For finding smart contracts we filter the same tx_hash in the near.core.fact_transactions and near.core.fact_actions_events tables.

Then we use ==action_name= ‘DeployContract'== so with this method we can have the smart contracts and finding that how much they use over a period.

For smart contract with most interaction we use above tables and near.core.fact_receipts table for finding RECEIVER_ID.

And then we find top 10 smart contract with most interaction.

Results

• Here we can see the number of unique smart contracts over a time period.
• We can see that In some days, more smart contracts are used.
• On july 21 we have about 1263 number of smart contracts that used.

According to the chart:

About 85% of smart contract with most interaction is for aurora and app.nearcrowd.near.

Other smarts have low percent.

Introduction

NEAR Protocol is a software that aims to incentivize a network of computers to operate a platform for developers to create and launch decentralized applications. 

Central to NEAR Protocol’s design is the concept of sharding, a process that aims to split the network’s infrastructure into several segments in order for computers, also known as nodes, to only have to handle a fraction of the network’s transactions .source

Smart contracts are simply programs stored on a blockchain that run when predetermined conditions are met. They typically are used to automate the execution of an agreement so that all participants can be immediately certain of the outcome, without any intermediary’s involvement or time loss. They can also automate a workflow, triggering the next action when conditions are met .source)