Description of Work

> One way to track developer growth in an ecosystem is through the number of unique contracts used

In this bounty, we want to review Solana Programs from the beginning of this year until now. To do this, we examine the following items:

• Total unique programs used since the beginning of January
• Total unique programs used since the beginning of January per day
• Check 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?

Note

To address these questions:

We use the solana.core schema, fact_events table for find Solana Programs (program_id) and dim_labels table for find program details

Conclusion of part 1

According to the results obtained from the total number of unique programs that were used, it is determined in overall and daily that:

• The total number of unique programs since the beginning of the year is 2940

• The number of unique programs used shows an upward trend from the beginning of the year until now

  \

2 → Most popular Program since the beginning of January

Conclusion of part 1

Of the ==2940 programs that have been used since the beginning of the year, only ==64 of them have information in the ==dim_labels== table. By checking the addresses of the rest of the programs on solscan, we did not get a complete result and we did not find any information about other programs, so we checked the same 64 programs.

• According to the obtained results, it is clear that the number of transactions to use the program is increasing every day from May 12 and after the start of the market decline and has an upward trend.
• The highest number of transactions for programs on a daily basis is related to serum dex v3, Mango Markets, Raydium Liquidity Pool V4, token program, memo program and zeta dex programs respectively.

Conclusion of part 3

> According to the daily transactions of the 10 most popular programs, it is clear that the number of transactions for these programs is increasing. > > and after May 12, the use of these programs is increasing.

Final Conclusion

According to the review and analysis of the unique programs used since the beginning of the year until now, it was found that the use of the programs is increasing on a daily basis, and also by examining the popular programs, it was found that the use of these programs from May 12 onwards It has been increasing since the fall of the market and has an upward trend