Ali3N
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
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.
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.
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.
Solana | Governing the Underworld
Mar 4, 2023 - Hadeswap governance voting analysis and the behavior of voters.
DEXs Season
Dec 1, 2022 - With the collapse of FTX, do users want to remove their crypto from centralized exchanges and use decentralized options for trading?
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?
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?
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?
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.
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.
FTX, Alameda and the Solana ecosystem
Nov 10, 2022 - How has the recent tumult surrounding FTX and Alameda impacted SOL and the Solana ecosystem?
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?
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
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.
Flipside's World Cup Kick Off: Gas Guzzlers
Nov 12, 2022 - Welcome to Flipside's World Cup of Bounties. To celebrate the arrival of the FIFA World Cup, we'll be holding a tournament to determine the top bounty hunters in the world across several blockchains, projects, and more. This year's theme is cross-chain comparisons. To qualify for this tournament, create a gas tracking dashboard that looks at gas usage by a chain over the last couple of months. Include Ethereum, Solana, Algorand, Flow, NEAR, Optimism and Osmosis, and add any other chain you think is worth noting. Breakout the following metrics by a chain in the dashboard Total amount USD of gas spent on the chain in the last 30 days. Average cost of gas in USD per $1,000,000 of liquidity transferred on each chain 30 days Average block gas price hourly and daily The top 10 addresses on each chain that spend the most on gas in the past month Daily amount spent on gas by chain tracked over the last 30 days Chart gas spend to network token price
Cats vs Sharks vs Squirrels!
Dec 12, 2022 - an in-depth comparison of Degen Fat Cats, Sharx & The Sinister Squirrel Syndicate NFT projects on Solana on the occasion of their recent hype during nowadays !
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?
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?
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.
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.
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.
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?
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.
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.
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.
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?
New Year New Activity
Jan 6, 2023 - The holidays and New Year are often chaotic in the crypto and DEFI space, as users make a spree of new transactions and wallets as they receive (and give) some cash and coins as holiday gifts. How has this activity impacted the crypto and DEFI ecosystems? Are users creating new wallets or buying tokens with their newfound holiday wealth? Are they staking all those new tokens once they get them? Or are they selling tokens to pay for their own gifts and holiday travel?
OpenBook
Nov 17, 2022 - One of the aftereffects of the FTX meltdown for Solana was the need to fork (replace) Serum, the OG order book on Solana due to key control risk. The Solana defi community worked together to create OpenBook https://twitter.com/openbookdex How has Solana defi responded to the risks that Serum suddenly presented and has there been any traction on Openbook so far? How has liquidity flowed through Solana defi? What programs seemed to be most affected by the replacement of Serum? Does it seem like defi on Solana is becoming more decentralized?
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 NFT Championship
Oct 8, 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
Flow Decentralization Progress
Nov 13, 2023 - The path for Flow has always been progressive decentralization over time. In the last year, various upgrades have enabled network participants to stake Flow, run nodes & validators, and more to drive the chain toward decentralization. Visualize that progress; how many nodes or validators are run on the network, & how does that compare with other chains? How much FLOW is staked, and by how many users? What else can you add to visualize the progress?
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?
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.
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?
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.
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.
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.
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?
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!