Q7.

Provide your best assessment of the number of smart contracts deployed on NEAR and clearly outline your methodology (after all, contract lawyers love clearly specified terms).

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

Info

NEAR Protocol uses a native token called NEAR, which allows users to pay fees for transactions, run applications, and pay for storage. Applications on NEAR must pay storage fees to the NEAR Protocol for any data that they store on the network and for performing computations.

Method

Tables: from near.core.fact_transactions , from near.core.fact_actions_events

Number of used: count(DISTINCT TX_HASH)

Number of contracts: count(DISTINCT tx_receiver)

where action_name = 'DeployContract'

Top 5 contracts period of timewhere day::date >= CURRENT_DATE - 120

Daily

\

• The highest number of interact with contracts on Near was on June 7th. On this contracts used 1323 times.
• The second day that the number of used that had noticeable number was July 21st with 1306.
• The number of used contracts had some spikes over time.
• The first noticeable growth was on September 16th, 2021 when contracts were used 1123 times. The previous day, the number of used contracts was 423.

• The highest number of contracts that were used was on June 7th. On this day, 1260 contracts had been used.

• The number of contracts started at 12 on September 1st, 2021, and ended at 30.8k on August 2nd, 2022.

Weekly

New contracts

• The highest number of contracts that were created newly was on September 16th, 2021.

  On this day, 643 new contracts were added to the Near protocol.

• The second day that had a noticeable number of new contracts was on November 25th, 2021.

  On this day the number of new contracts was 293.

• In the year 2022, The highest number of new contracts was on April 19th.

• On this day, 229 new contracts had been created.

\

• The first new contract that had the most interaction over the 120 days was Boobs.zudwa.near. This new contract was used 71 times.

• The second contract was f3d.near that used 68 times.

• Zomland.near had been used 66 times.

• Alpari91525.near contract had been used 50 times.

• Ans the last contract of the top 5 had been used

Total