Q92. One way to track developer growth in an ecosystem is through the number of unique contracts used. Create a visualization of the number of unique programs used per day since the beginning of January.

What type of programs are the most popular, and what programs seem to be gaining in popularity over that timeframe? Does it appear that development is still ongoing in the bear market?

Introduction

In this dashboard we will be using Solana database to look at most popular programs on Solana and analyze these programs in terms of number of transactions and number of unique users from the January 2022.

Then we will find the most popular type of programs on Solana and programs growth over that timeframe.

The opposite chart shows number of user interactions with Solana programs since the beginning of January 2022.

We can see number of interactions was higher on May and Jun and it reaches to about 7.49M on May 14, 2022.

The opposite chart shows number of unique users who interacted with Solana programs since the beginning of January 2022.

We can see number of users has increased in Apr and May and it reaches to 200.142K on May 26, 2022.

But it has sharp drops in Jun and reaches to lowest number from January 2022 by 25.609K users on

Jul 4,2022.

The opposite chart shows number of users who interacted with various type of Solana programs per day.

We can see Orca is the most interacted with program.

The opposite chart shows number of user interactions with various type of Solana programs per day.

It is clear that Jupiter Aggregator v2 is the most interacted with program.

The following chart shows most interacted with type of programs in first 6 month of 2022.

It shows that swap programs are most popular programs based on number of interactions.

The following chart shows most popular type of programs in first 6 month of 2022 based on the number of unique users.

It shows that swap programs are most popular programs and next is NFT marketplaces.

The following chart shows most popular programs on Solana based on number of unique users.

We can see Orca is the most popular, Raydium v4 is in second place and

Magic Eden v2 is in third place.

The following chart shows most popular programs on Solana based on number of transactions.

We can see Jupiter aggregator v2 is the most popular, Orca is in the second place and

Raydium v4 is in third place.

The opposite chart shows growth of Solana programs based on the number of unique users since January 2022.

We can see Orca has highest most number of users by about 8.61M in total.

The opposite chart shows growth of Solana programs based on the number of transactions since January 2022.

We can see Jupiter Aggregator v2 has highest number of transactions by about 338.17M in total.