flipside

    Try Quests to earn SOLTry Quests to earn SOL
    Share

    Average Solana Portfolio

    Q91. What does the average Solana user's portfolio look like and how has that changed over time? What % of a user's activity (in SOL terms) is staked, unstaked, in liquidity pools/farms, in NFTs? How has this trend changed since the start of 2022?

    Intro and Method

    The portfolio of average Solana users is investigated in this bounty. The estimation of portfolio is done based on the number of transactions on Solana in 2022.

    Method

    • The used table--> count(tx_id) as no_txn

    • The NFT transactions--> solana.core.fact_nft_sales and solana.core.fact_nft_mints

    • The Add or remove liquidity--> solana.core.fact_events

      • add liquidity--> EVENT_TYPE='mintTo'
      • Remove liquidity--> EVENT_TYPE='burn'

    • Stake or unstake--> solana.core.fact_events

      • Stake--> EVENT_TYPE='delegate'
      • Unstake--> EVENT_TYPE='withdraw'

    Outcomes

    Loading...
    Loading...

    The summary of the outcomes of this bounty is:

    1. The adding liquidity to pools and farms is about 77.5% of transactions.
    2. The second most used platform is NFT with 20% of transactions.
    3. The daily roadmap of average Solana portfolio over time shown in the second figure. This figure shows the dominance of Adding liquidity but since start of May the application of NFTs increased.
    4. The trend of NFT usage by average Solana users is increased over time in 2022.
    5. The daily number of transactions for actions shown in the last figure. On June 25th the application of NFT is passed the adding liquidity to pools and farms.
    Loading...