Ali3N
The People like the Clay Dinos !
Mar 20, 2023 - A dashboard that covers all things Claynosaurz highlighting key NFT kpi metrics.What has been the relationship between sales activity between Claynosaurz, Claymakers, and Clay? What percent of holders have flipped/sold their Clay vs held or accumulated more Clay? Are there users that have used Claymakers as an entry point into the project instead of Claynosaurz themselves? What is happening with the special Sardinhas and how has that sales premium trended over time? What type of holders have been purchasing Claynosaurz? Does it appear that the project is bringing in any outside liquidity, such as from Ethereum? What other NFT projects on Solana do the holders also hold? Are holders still buying new Claynosaurz or is it predominantly new wallets?
City Amidst the Storm
Nov 15, 2022 - Provide a thoughtful analysis of how NEAR is weathering the market turbulence that occurred as a result of FTX’ insolvency.
Exchange Flows in the Bear (Ethereum)
Aug 13, 2022 - Let's understand whether the bear market and recent issues with CeFi products have changed centralized exchange users' behavior. Explore trends in exchange withdrawal (specifically, moving money from CEX addresses onto the chain) patterns over the last 6 months. Have those withdrawals increased? Has the typical size of them changed? Most important: are people creating new wallets to take custody of their CeFi deposits?Also have a look at what people do after a withdrawal: are they holding their withdrawn tokens? Or are they fiat-on-ramping so they can swap, provide liquidity, buy NFTs, etc.hint: find centralized exchange addresses in [chainname].core.dim_labels where label_type = 'cex' and label_subtype = 'hot_wallet' other hint: feel free to include a couple of major chains for this analysis, but certainly at least include Ethereum
ETH Positive Price Action
Jan 19, 2023 - Let’s examine ETH's positive price action this year: Looking at Ethereum Mainnet activity from block: 16310000 (Jan 1, 2023) to block 16420000 (Jan 16, 2023) what on-chain activity could correspond to the recent increases in ETH's price? What major dapps, tokens, or similar have risen with or more than ETH over that time span? How has user activity, including in specific protocols, changed over the time period?
Quix vs Magic Eden vs OpenSea
Sep 24, 2022 - Create a dashboard highlighting at least 3 metrics comparing marketplace performance and adoption between Quix (formerly Quixotic) on Optimism, Magic Eden on Solana, and OpenSea on Ethereum, since July of this year. What has been the rate of change of these metrics since the start of the new year and are there any signs of growth of a certain marketplace or ecosystem of NFTs? Highlight the 5 most popular NFT collections for each marketplace over that timeframe in terms of sales volume. Is the turnover rate (number of transactions) for collections on Quix noticeably higher than on OpenSea and Magic Eden? Provide some insights on these findings.
Impact of FTX & Alameda on Solana Ecosystem and FTX,Alameda-Invested Tokens
Nov 19, 2022 - How has the recent tumult surrounding FTX and Alameda impacted SOL and the Solana ecosystem?
Waiting for Aurory (Solana Bounty)
Jul 16, 2022 - Aurory is one of the most highly anticipated games to come out on any chain. Create a dashboard highlighting wallet trends around both the tokens and NFTs. Does the price of Aurory token has positive correlation with volume of nft sales? How have token staking and nft expedition patterns changed in the bear market? What have wallets been doing with their airdropped NFTs?
Everyone Needs a 1-of-1
Jan 21, 2023 - Exchange Art is the leading digital art marketplace on Solana for 1-of-1 art and fine digital art. This category has been rising on Solana as more artists have realized the ease and low costs of launching digital art on Solana. Create a dashboard diving into the key growth metrics of Exchange Art over time. How has the marketplace grown over time and how does that compare to the general NFT growth on Solana? Does it appear that 1-of-1 art is popular among many users on Solana, or is it primarily collected by select individuals? Are most users on Exchange Art whales or art lovers or both? Are there any unique purchasing behavior patterns that you see out of wallets that buy art on Exchange Art? What does the average price look like on Exchange Art and is there more of an appetite for high end pieces? How does the holding period of NFTs bought on Exchange Art compare to that of Magic Eden? Are users truly collecting or are they still interested in short term flipping? What wallets have been most profitable on Exchange Art and what has their strategy been so far?
ETH Down Bad
Nov 23, 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?
Solana Hack on August 2022
Aug 5, 2022 - Starting on August 1st, a total of over 8,000 users were hacked on Solana mainly the Slope and Phantom wallets. The users' private keys were compromised and their wallets were drained. Four Solana addresses are suspected of having committed the attack. reveal some information about this hack attack!
USDC Declining on Solana?
Oct 3, 2022 - It looks like over the last few weeks the market cap of USDC on Solana has been declining. 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?
NFT crosschain showdown: y00ts vs Art Gobblers
Nov 23, 2022 - Two freshly launched NFT projects are going viral: the Art Globbers (on Ethereum) and yOOts (on Solana). Create a dashboard that compares the two projects.
Quixotic NFT Dashboard (Optimism Bounty)
Jul 30, 2022 - Q7. Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism! Include any data you think is relevant in our Optimism tables and tell us the most interesting trends you can find with the secondary NFT market.
The Rise of Tensor on Solana
Mar 13, 2023 - Tensorswap is an NFT marketplace built for traders (think Blur on Solana). Recently, the first season of rewards for their airdrop was released with similar reward mechanics as Blur along with the start of season 2. Since then, activity on the marketplace has started to heat up and Tensor has risen to being the 2nd largest marketplace on Solana only behind Magic Eden and climbing. In this dashboard and using Flipside's newly curated Tensor NFT sales data, you are gonna see an in-depth analysis of this marketplace since its debut.
USDC 2023 Journey in Solana vs Ethereum
Dec 29, 2023 - This analysis offers a concise exploration of the trends and activities surrounding the USDC stablecoin on Solana and Ethereum throughout the year 2023.
Ailing Alameda
Nov 8, 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?
Realms vs Snapshot
Aug 27, 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?
Pool Props: Decentralized Sports Exchange
Nov 25, 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 all-time leaderboard show both the biggest winners and losers, how many they’ve taken and how much they’ve won or lost.
Who's Escaping FTX?
Nov 16, 2022 - Who's managing to escape from the FTX debacle mostly unscathed? Create a single chart showing trading volume on dydx, gmx, and gns to show how people are exiting ftx and entering margin trading dapps. Are they off-boarding through any other methods? Are any particular exchanges, chains, or dapps seeing large increases in new users or trading volume? Note any trends or outliers you see.
Tracking Realms DAOs
Aug 15, 2022 - Q104. 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 16, 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?
The Battle of The Federation Foxes !
Dec 2, 2022 - A Comparison of Famous & Transdimensional Foxes Federation, Two NFT projects by Famous Fox Federation, On The Occasion of Their Recent Hype.
Solana | Governing the Underworld
Mar 4, 2023 - Hadeswap governance voting analysis and the behavior of voters.
Polygon Block Performance
Jul 23, 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?
A Surge of Optimism
Dec 16, 2022 - The price of Optimism (OP) fell sharply in early November, dropping from highs above $1.30 on November 6 to as low as $0.79 on November 9. In the weeks since, prices have been on the rise, with OP hit $1.19 on December 14. Analyze the network and diagnose some of the possible reasons for the sudden drop, and slow climb, of OP price in recent weeks. Are there any notable trends in users, transactions, or any other metrics that could explain these events? Note any patterns or outliers you see.
Hadeswap Wash Trading
Oct 20, 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. 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?
Solana Surpasses Ethereum in NFTs (December 2023)
Jan 3, 2024 - Solana NFT Sales Skyrocket, Topping Ethereum in Monthly Volume for First Time!
Flow Down Bad Really?
May 3, 2023 - Recently, an article published by The Block has raised concerns about the success of Dapper Labs' projects such as NFL All Day and NBA TopShot. However, we believe that some of the data presented in the article might be misleading. To provide a comprehensive comparison and clear any confusion, we suggest conducting a thorough analysis of the top NFT collections on FLOW, Ethereum, and Solana.
Solana Phantom/Slope Hack (August 2022)
Feb 24, 2023 - One of my closest friends was a victim of Solana Phantom hack and as a result, he lost more than $1000 money.
FTX, Alameda and the Solana ecosystem
Nov 10, 2022 - How has the recent tumult surrounding FTX and Alameda impacted SOL and the Solana ecosystem?
What's All The Hubbub for Hubble Protocol?
Oct 6, 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?
Solana Staking Madness
Nov 11, 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.
Solana's Flash Trade Protocol
Feb 13, 2024 - Welcome to the Flash Trade Protocol Analysis Dashboard, your gateway to a comprehensive exploration of Flash Trade's recent endeavors on the Solana blockchain.
Tensor NFT Marketplace on Solana
Aug 28, 2023 - Explore the Tensorswap NFT Analytics Dashboard—a data-driven journey into the world of Solana's second-largest NFT marketplace. Uncover trading insights, user behavior shifts, and the impact of key announcements shaping Tensorswap's dynamic evolution.
LUNA Price Run Investigation (Terra)
Jan 12, 2023 - Beginning in the wee hours of Monday, January 9 (ET), the price of LUNA skyrocketed, from $1.37 to a high of nearly $2 before settling down at roughly $1.60. Identify some of the major reasons for this recent upshot in price, and back up your assertions with data. Why did the price jump so suddenly on Monday night? Will prices remain at, or above, current marks in the coming weeks or will it return to at or near $1? Why?
NEAR City Layout
Oct 29, 2022 - How centralized or decentralized is NEAR, really? Choose at least two distinct measures of decentralization that can be explored with on-chain data; clearly define those metrics; and outline how NEAR performs based on those metrics. In your view, is NEAR becoming more centralized or decentralized over time? You are welcome to draw on any past submissions in your work, but ensure you credit and link to the original creator (bonus points if you shout them out on Twitter). Grand Prize submissions will also explore these metrics for at least one other blockchain.
NFT Wallet Behavior Comparison (Flow Bounty)
Jul 15, 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?
The Battle of the Solana NFT Aggregator
Oct 27, 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?