Question:

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.

\n 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?

Approach:

• Solana programs

  count(distinct instructions[0]:programId) as usages,

  sum(usages) over (order by day) as grow_rate

  from solana.core.fact_transactions

• popularity by unique users

  count(distinct signers[0]) as unique_users,

  sum(unique_users) over (partition by LABEL_TYPE order by day) as grow_rate

  from solana.core.fact_transactions t join solana.core.dim_labels l on t.instructions[0]:programId = l.address

  
  \

Results:

Key findings 1

1. The share of each program type per day reveals the most used types as DEX, NFT and DeFi type of programs.
2. In grow rate analysis, the gradian of DEX, NFT and DeFi are the three sharpest in the mentioned order.
3. About half of the programs application on Solana belongs to the DEXs of blockchian.

Popularity by count of participants (unique users):

Key findings 2

1. The popularity of various programs by count of unique participants displays the highest participation on DEXs and its normal.
2. The NFT participation decreased from start of March in comparison with January and February.
3. Largest group of unique participants belongs to the January 24, 2022 and on that date all of the program types reached their maximum level.
4. The grow rate of unique participants validate the consequences related to the daily graphs.