Overview :

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?

Method :

> timeframe : since 2022-02-01 (I had problems in running queries when I set the date to January 1st, so I changed the starting date to Feb 1st) > > using solana schema , specially the events table I identified program ids and could analyze them and by joining the events table to dim,labels , the label of programs were identified . here are the results :

Charts and Analyzes :

>
> \

As shown in the charts:

the number of daily using programs has an increasing trend and is growing day by day

interacting with dex has been the most popular activity among in Solana users and 88.2% of transactions were related to this type .

looking at the cumulative chart, Dex using trend is quite exponential and ranked first by far,othe types of transactions, like NFT,DEfi and Layer2, also were seem to be gaining in popularity among studeied time frame.iv

Breaking down the Transactions :

looking at the charts, the most popular program was Jupiter Aggregator v2 , with over 60% of all transactions.(sub platform of Dex sector )

Raydium Liquidity pool and Metaplex NFT candy machine are ranked the next places with 18.4% and 9.81% of all transactions respectively.

looking at the cumulative chart, the upward trends for more of programs is quite visible.for example, Adrin staking had several jumps on Feb. 27,Mar.27,April 29 and June 1 , and Saber Stabel stable,Jupiter Aggregator v2 , Metaplex nft candy machine and so many other programs had a jump in number of using on studied timeframe