hesam
Tracking Realms DAOs
Aug 16, 2022 - We now have Solana Realms governace data! Their team would love to be able to see a list of DAOs / multisigs built on SPL Governance, and understand their: - Number of Members (assuming unique voters is what he means here) - Total Votes - Number of Proposals - Date of Last Proposal - Date of Creation Track these metrics and any other metrics that you find interesting for the following DAOs: Mango-Grape-Psy Finance-Solend-MonkeDAO-Metaplex-Jet-Serum-The Imperium of Rain-Synthetify
FLOW User Retention vs Other Chains
Dec 19, 2022 - How sticky are the users on Flow? Create a detailed analysis comparing user retention on Flow vs. other L1 chains like Ethereum and Solana. How often do users who make a transaction come back and make another transaction one month later? How do monthly active users compare between chains? Bonus: add a section of your analysis comparing retention specifically with regard to NFT purchases. How often do users who purchase an NFT come back and make another purchase one month later? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
DUST is in the Air
Sep 8, 2022 - $Dust is the utility token behind the most popular NFT project on Solana - Degods. The team and the community have been building with $DUST. How is $DUST being used in the Solana ecosystem? What are its most popular use cases and where are buyers of $DUST coming from? Highlight at least 3 metrics showing $DUST trends in Solana.
ETH Down Bad
Nov 24, 2022 - The price of Ethereum has sank in recent days - how does it compare to other tokens amid a general market downturn? Can you find evidence of any potential causes for ETH's struggle? Are there any other indicators that could help us predict whether/when it could recover? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Solana Staking Madness
Nov 14, 2022 - How has staking pool behavior on Solana responded to recent events? Analyze Flipside's new staking pools data to analyze staking behavior in the Solana ecosystem over the past week. How are stakers responding to recent events? Have there been any notable inflows or outflows to staking pools? What staking pools have seen the most notable behavior? Can you link any staking behavior to other defi activity or other accounts on Solana? Note any trends or outliers you see.
Realms vs Snapshot
Aug 31, 2022 - Building off previous recent bounties on Realms and Snapshot, create a dashboard that shows how Realms and Snapshot are growing and used in comparison to one another. Feel free to build off previous bounty work on these platforms. What trends do you see between governance behavior between the two chains? Does a platform seem to capture more market share of its users on their respective chain than the other? What seems to influence voting behavior on each platform? Does one platform have more proposals and voting opportunities than the other? Are whales more powerful on Realms or on Snapshot? How can each platform become more decentralized?
Ailing Alameda
Nov 9, 2022 - Analyze what Alameda is experiencing. Rumors over the weekend began swirling that alameda research is on the brink of insolvency. Observe net in and outflows of USD tokens from known Alameda or FTX accounts throughout different chains. Are they going somewhere specifically? Are there any signs of potential insolvency? Note any other interesting trends or events you see. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and anywallets
Average Solana Portfolio
Jun 30, 2022 - 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?
City Amidst the Storm
Nov 16, 2022 - Provide a thoughtful analysis of how NEAR is weathering the market turbulence that occurred as a result of FTX’ insolvency. You can include baseline measures, e.g. token price, transaction volume - but go beyond that and apply your analysis skills. Choose and define at least 2 measures of ecosystem health, and assess how NEAR is performing on those metrics between the week of 11/7 and 11/14. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
The Great Solana Royalty Debate
Nov 7, 2022 - The most controversial topic on Solana over the past month has been NFT royalties. After platforms like Yawww and Solanart moved to 0% creator royalties, and eventually Magic Eden followed, the market has been in a chaotic state. Magic Eden had cited that almost all funds for a project are coming from the mint, not royalties: https://twitter.com/MagicEden/status/1580367439824826368 Is this accurate, or a misrepresentation of how successful NFT projects have been operating? What projects have been more reliant on NFT royalties than others? What collections were wallets pivoting towards using 0% royalties more frequently? Higher royalty percentages? Higher floor volumes? Are flowing royalties a sign of project health and sustainability? How much volume from 0% royalty sales can be accounted for by wash trading rather than actual user interest? Was this actual user demand, or were decisions made based on inflated data? Compare the rise of 0% royalty market behavior on Solana to on Ethereum. Are users less likely to pay royalties on Solana?
Solana Since The Mango Hack
Oct 16, 2022 - What has been happening in the Solana defi ecosystem since the Mango Markets Hack? Has activity increased? Decreased? Are users flocking to any particular defi apps? Are they leaving the ecosystem? Chart flows in and out of centralized exchanges from the Solana ecosystem. Has staking behavior changed on Solana since the hack? Note any trends or outliers you see in Solana defi. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Hadeswap Wash Trading
Oct 23, 2022 - A new sector of NFT marketplaces have begun to gain popularity on Solana, the NFT AMM. One of the most notable NFT AMMs on Solana so far is Hadeswap. Documentation: https://docs.hadeswap.com/ . Note, the founder is one of the biggest "whales" in the NFT space: https://twitter.com/HGESOL . It's clear that this new type of marketplace is gaining popularity in the ecosystem. But how much of it is real trading and how much is 'wash trading' to drive up volume numbers? Note there are no fees in the marketplace so it can be easy to swap back and forth. Create a definition for 'wash trading 'and use that to track sales activity on Hadeswap with our newly curated models in the NFT sales table. How much of the volume seems "legit"? Are there certain accounts that seem to be creating the majority of the volume? What collections have had the most activity on Hadeswap, and how much of that was from 'wash trading'? Now that Magic Eden has moved to 0% royalties, compare Hadeswap 'wash trading' to wash trading on Magic Eden. Does an AMM create more wash trading?
What's All The Hubbub for Hubble Protocol?
Oct 11, 2022 - Hubble Protocol is a financial platform building sustainable Decentralized Finance services on Solana. Hubble's core service centers around a low-interest, stablecoin borrowing mechanism. Hubble's US Dollar-pegged stablecoin, USDH, can be borrowed against a variety of assets, including ETH, BTC, and SOL. Create a KPI dashboard that shows Hubble metrics such as: daily active users, new users, mint/burn rates, different rates of instructions etc. (anything you find relevant). Show the flows of USDH, where it is being used in the Solana ecosystem, is it gaining adoption, and if so how? Hubble also recently launched Kamino Finance: https://blog.hubbleprotocol.io/multicoin-raise-kamino-launch/ Provide metrics on its growth rate and adoption so far. How is it being used?
Pool Props: Decentralized Sports Exchange
Nov 30, 2022 - Pool Props just surpassed $1M USD in volume on their decentralized sports exchange where players can purchase and trade assets based on game and player odds and receive payouts based on the results. Let’s create a parameterized dashboard(based on wallet address) to help players understand their activity on pool props: How many pools they’ve traded in. how many positions they’ve taken. How much they’ve won or lost, in USD and native currency. At the top of your dash create a top 10 all-time leaderboard show both the biggest winners and losers, how many they’ve taken and how much they’ve won or lost. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Algorand Price Correlation
Jul 1, 2022 - Is the price of Algorand more closely correlated with the crypto market, and assets such as BTC or ETH, or is it more correlated with network usage such as number of transactions or ALGO transfers? How does this compare to other networks such as Solana? Note your findings and anything else that may be interesting in relation to Algorand's price movement!
Solana NFT Championship
Oct 10, 2022 - There’s no shortage of sports-related NFTs on Solana, from Collectorz Club and Suites to Laidback Lions and Aaron Jones’ Showtime collection — but who can lay claim to the title of Solana sports NFT champion? Create a dashboard that shows off the top collections. Include at least these metrics, along with any others you find notable or interesting: - Sales volume (daily/weekly/monthly) - Total Sales Volume - Daily Average Sales Price and 7-day moving average - Total Unique Buyers - Average Buyers/Day
Just Keep Swimming
Jul 27, 2022 - Swim Protocol provides a simple way to transfer tokens across chains via multi-token liquidity pools. It is built on top of one of the most infamous bridges, Wormhole, which allows users to more seamlessly transfer assets across multiple blockchains. Create a dashboard for Swim on Solana including at least the following metrics (add anything else you find interesting): - Total Volumes - Total unique users - Most popular destinations from Solana - Most popular stablecoins and non-stablecoins traded over time
The Battle of the Solana NFT Aggregator
Oct 30, 2022 - Hyperspace and Coral Cube are the two most popular NFT aggregators on Solana. This means that they list all NFTs across different marketplaces along with allowing listings on their own marketplace. Create a dashboard comparing KPIs between Hyperspace and Coral Cube. Which marketplace has done more volume? Which collections are popular on each marketplace? Why would I use one marketplace over the other? Are there any noticeable market trends between the marketplaces, especially after Solana marketplaces moved to a 0% creator royalty?
NEAR Performance
Jul 21, 2022 - How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.
Solana Protocol Feature
Jul 14, 2022 - Choose a defi protocol from the following list and create a dashboard with the new Flipside layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the protocol and what is happening on it. Note any noticeable trends or current events for the protocol. Highlight how liquidity is flowing in and out of the protocol and which pools are popular. (The Orca protocol was selected)
Solend Demographics
Aug 4, 2022 - Solend is the leading lending protocol on Solana. What are the demographics of the Solend userbase? What is the user distribution by size of account? (How many have between $1-1,000, 1,000 - 100k, etc). Is the protocol largely influenced by whales, or by average Solana users?
NFT Wallet Behavior Comparison
Jul 19, 2022 - Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to Ethereum and Solana. Is there more or less "whale" activity on Flow compared to each of the other chains? What do "whales" tend to focus on in Flow? How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? Are wallets more interested in new projects, or already existing projects on Flow?
Flow vs Other L1s Pt (II)
Jul 19, 2022 - How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum.
Polygon Block Performance
Jul 27, 2022 - What is the average time between blocks on Polygon? What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
Merry $BONK-ing Christmas
Jan 4, 2023 - It's still Christmas for Solana's dog coin $BONK — people all over crypto twitter are giving away billions of $BONK tokens, and its price has risen over 40% in the last day (NFA). Bring the world up to speed on Bonk Inu, with all of our favorite metrics: Total # of holders. % of holders that are active wallets. Average amount $bonk in holder wallets. Average time holding bonk. Any other notable trends or outliers you see. Then, give us context! What kinds of Solana users are $bonk holders? How active are they, what other tokens do they tend to hold, etc. Has Solana activity as a whole risen in conjunction with recent $bonk activity, and how much Solana activity does Bonk Inu account for?And as always, don't forget to tweet about your dashboard and $bonk, to share your insights with others!
USDC Declining on Solana?
Oct 7, 2022 - It looks like over the last few weeks the market cap of USDC on Solana has been declining. Source: https://defillama.com/stablecoins/Solana - What appears to be the cause of this? Where is USDC being removed from the ecosystem and where is it being sent to? - Does this trend seem to be driven by a few big whales, or does it seem more broad-based throughout the ecosystem? - Are other stablecoins also dropping in market cap on Solana?