Ecosystem or Project Analysis

    Pick your favorite ecosystem or project and tell us why it’s your favorite using data! Compare or analyze any standard metrics, like activity (developers, users, trading etc), volumes (TVL, trading, mint, etc), active users, projects and more. Demonstrate the value of your choice by sharing any standard metrics you find interesting. BONUS: 10 randomly selected analysts will receive a Flipside merch pack if you complete this bounty, share on Twitter that you used the new Flipside app and tag @flipsidecrypto

    Loading...
    Loading...

    Methodology
    Through this dashboard im going to show you some data about my favorite Ecosystem Solana ! In this dashboard im going to analyze Solana Ecosystem base on several metrics like Trades , Volume of trades , Transactions , Voting on Proposals and so much more ... I will use Flipsidecrypto database and tables for fetching data i need . Some of tables that im going to use is solana.core.fact_transactions , solana.core.fact_nft_sales , solana.core.fact_proposal_votes and more ... For this bounty im using new flipsidecrypto data app please excuse me if this dashboard is not prefect enough . So get started !

    db_img

    Introduction
    Solana is a highly functional open source project that banks on blockchain technology’s permissionless nature to provide decentralized finance (DeFi) solutions. While the idea and initial work on the project began in 2017, Solana was officially launched in March 2020 by the Solana Foundation with headquarters in Geneva, Switzerland.

    To learn more about this project, check out our deep dive of Solana.

    The Solana protocol is designed to facilitate decentralized app (DApp) creation. It aims to improve scalability by introducing a proof-of-history (PoH) consensus combined with the underlying proof-of-stake (PoS) consensus of the blockchain.

    Because of the innovative hybrid consensus model, Solana enjoys interest from small-time traders and institutional traders alike. A significant focus for the Solana Foundation is to make decentralized finance accessible on a larger scale.

    Transactions

    NFT sales & mints

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    Trades

    Loading...
    Loading...
    Loading...
    Loading...

    Top and active Solana Programs (Smart Contracts)

    Loading...
    Loading...
    Loading...

    Inflow & Outflow of CEXs ( queries didn't get executed i prepred queries but flipsidecrypto new data app was crashed)

    Stake & UnStake

    Votes & Voters on Proposals

    For some reasons some of queries didn't get executed i tried so hard to make them work but it didn't work ill add some screenshot at the bottom of this dashboard to prove it

    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...
    Loading...

    Summary and Conclusion
    According to all data texts , and visulazations we saw in this dashboard we come to these conclusions :
    According to charts about transactions and activity on Solana ecosystem we saw number of daily transactions and active users increased significantly at the start of 2023 and this is so good specially after FTX & Alameda collapse which had so bad effect and some people thought Solana will collapse too but this statistics shows Solana is still one the best blockchains out there and this is why i like Solana .
    According to charts about daily NFT sales on Solana ecosystem we saw number of daily NFT sales and NFT purchasers increased significantly at start of 2023 and these days .
    This shows us NFT on Solana is still popular and shows us how users trust ecosystem and like to trade NFT .
    We saw at start of 2023 USD volume of NFT sales increased to average almost 5M $ per day which increased more than 2x times compare to end of 2022 and also event these days seems so great .
    According to charts about NFT mints on Solana ecosystem we saw several spikes at start of 2023 which number of mint transaction spiked several times which at 10th of January 2023 total 12.3k NFT mints submitted by 6.67k active users .
    Also we saw $usd volume of NFT mints increased at start of 2023 and at 14th of Januray 2023 total 716k USDC spent on NFT minting .
    We saw USDC , USDT , raydium and scrap are most favorite tokens for minting NFTs on Solana ecosystem.
    According to charts about trades on Solana DEXs we saw number of swaps (trades) and swappers (traders) on DEXs increased significantly at start of 2023 which at 3rd day January 2023 total 863k trades submited by 52.9k unique traders which is so impresive because at end of 2022 number if trades was droped to average almost 100k trades and almost 10k traders but at start of 2023 Solana again shows us it's power and popularity .
    We saw also $USD volume of trades increased to more than 50M $USD at start of 2023 which is so great because at end of 2022 volume of trades was almost 7M $ And also saw average $USD volume of trades increased significantly from almost 60$ per trade to more than 120$ these days .
    According to charts about active programs ( smart contracts) on Solana ecosystem we saw pyth is most favorite program on Solana these days .
    Pyth Network is an oracle that publishes financial market data to multiple blockchains. Our market data is contributed by over 70 first-party publishers, including some of the biggest exchanges and market making firms in the world. We offer price feeds for a number of different asset classes, including US equities, commodities, and cryptocurrencies. Each price feed publishes a robust aggregate of publisher prices that updates multiple times per second.
    And second favorite program on Solana is switchboard and also switchboard is Permission-less, customizable, multi-chain oracle protocol for general-purpose data feeds & verifiable randomness!
    Another favorite program on Solana is magic eden , Magic Eden is the largest NFT marketplace on the Solana blockchain. It allows traders to buy, sell, mint and manage tokens, and it includes a thriving secondary market.

    Appendix
    For some reason flipsidecrypto data app was crashed and didn't run some of my queries i included empty chart for those parts to see queries and test it to find out why i didn't run .
    Discord : hosein-maleki#9555
    Twitter tweet of this dashboard :
    https://twitter.com/0xhosein/status/1624907825855234048

    db_img
    db_img
    Loading...

    Observations
    According to above charts about transactions and activity on Solana ecosystem we can see number of daily transactions and active users increased significantly at the start of 2023 and this is so good specially after FTX & Alameda collapse which had so bad effect and some people thought Solana will collapse too but this statistics shows Solana is still one the best blockchains out there and this is why i like Solana . But after all one the downsides is at the start of 2023 number of failed transactions also increased and almost more than 50% of daily transactions are failed .

    Observations
    According to above charts about daily NFT sales on Solana ecosystem we can see number of daily NFT sales and NFT purchasers increased significantly at start of 2023 and these days .
    This shows us NFT on Solana is still popular and shows us how users trust ecosystem and like to trade NFT .
    We can see at start of 2023 USD volume of NFT sales increased to average almost 5M $ per day which increased more than 2x times compare to end of 2022 and also event these days seems so great .

    Observations
    According to above charts about NFT mints on Solana ecosystem we can see several spikes at start of 2023 which number of mint transaction spiked several times which at 10th of January 2023 total 12.3k NFT mints submitted by 6.67k active users .
    Also we can see $usd volume of NFT mints increased at start of 2023 and at 14th of Januray 2023 total 716k USDC spent on NFT minting .
    We can see USDC , USDT , raydium and scrap are most favorite tokens for minting NFTs on Solana ecosystem.

    Observations
    According to above charts about trades on Solana DEXs we can see number of swaps (trades) and swappers (traders) on DEXs increased significantly at start of 2023 which at 3rd day January 2023 total 863k trades submited by 52.9k unique traders which is so impresive because at end of 2022 number if trades was droped to average almost 100k trades and almost 10k traders but at start of 2023 Solana again shows us it's power and popularity .
    We can see also $USD volume of trades increased to more than 50M $USD at start of 2023 which is so great because at end of 2022 volume of trades was almost 7M $ And also we can see average $USD volume of trades increased significantly from almost 60$ per trade to more than 120$ these days .

    Observations
    According to above charts about active programs ( smart contracts) on Solana ecosystem we can see pyth is most favorite program on Solana these days .
    Pyth Network is an oracle that publishes financial market data to multiple blockchains. Our market data is contributed by over 70 first-party publishers, including some of the biggest exchanges and market making firms in the world. We offer price feeds for a number of different asset classes, including US equities, commodities, and cryptocurrencies. Each price feed publishes a robust aggregate of publisher prices that updates multiple times per second.
    And second favorite program on Solana is switchboard and also switchboard is Permission-less, customizable, multi-chain oracle protocol for general-purpose data feeds & verifiable randomness!
    Another favorite program on Solana is magic eden , Magic Eden is the largest NFT marketplace on the Solana blockchain. It allows traders to buy, sell, mint and manage tokens, and it includes a thriving secondary market.

    Observations
    According to above charts about Stakes and UnStakes we don't see anythinf unusaul and everything seems normal and good .

    Observations
    According to above charts about votes and voters on governance platforms we can see realms is most favorite platform on Solana .
    According to realms documantion Realms provides a platform for builders on Solana to create a DAO, manage their members, vote on proposals, and allocate their treasury. Whether you are running a multisig, NFT community DAO, or community token DAO, Realms has the tools and integrations to help your community flourish. Realms serves as the frontend for SPL Governance, a DAO-type and asset-type agnostic standard for building and maintaining DAOs on Solana.
    We can see also governance on Solana seems good and normal and we don't see anything bad but little drop on daily votes these days which is note a big deal .