![Transaction Failure Transaction Failure](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Transaction Failure
Mar 22, 2022 - Establish the failed transaction rate for Terra over a time period of your choosing. Is this analysis correct? Additionally, make a case for what is causing the failure transaction rate you assess, and provide recommendations to mitigate it.
![Are NFT Creators Minting Money? Are NFT Creators Minting Money?](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Are NFT Creators Minting Money?
Jun 19, 2022 - What is the average and median return on investment for candy machine NFT creators? As in how much revenue are NFT creators making off mint and then off royalties? How has that trended over time and how do you see this shaping the NFT landscape on Solana?
Crossover with NBA Top Shot
Jun 11, 2022 - Which Flow NFT projects appear to have the most crossover of buyers with NBA Top Shot addresses? Is NBA Top Shot an effective onboarding tool in getting users interested into other Flow collections? Does this crossover tend to come from Top Shot "whales", or does the crossover come from average to smaller players? How can Flow projects better attract liquidity from Top Shot players?
![The Whales of NEAR The Whales of NEAR](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
The Whales of NEAR
Feb 12, 2023 - Where in the ocean of NEAR do the whales hang out? Examine the top 20 addresses by amount of NEAR held - excluding any custodial or exchange addresses that you can. Can you identify any “power players” or wallets of interest? What behaviors do these whales exhibit?
Tracking MarketingDAO Grants
Jan 30, 2023 - The NEAR MarketingDAO is in need of a grants tracking dashboard to better monitor the outcome of grant requests from their treasury. Discussion around these requests happen on the NEAR forum, but the formal decision is a vote on AstroDAO, codifying the results on chain.
![Gas as a proxy of activity Gas as a proxy of activity](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Gas as a proxy of activity
Jun 8, 2022 - How much did sushi users pay for gas in 2022? Is there a correlation with the price of ETH? Can you comment on the spikes in the chart?
AAVE and stAAVE movements
Aug 9, 2022 - Create visualizations showing daily AAVE supplied and withdrawn on Aave protocol and daily AAVE staked and unstaked.
![Celsius Swaps Celsius Swaps](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Celsius Swaps
Jun 17, 2022 - Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. From which one of their wallets did they conduct most of the swaps?
Metrics on True Freeze
Jul 28, 2022 - Produce a dashboard showing metrics on True Freeze. At a minimum, visualize: the daily volume of ETH frozen, the daily number of transactions to freeze ETH, and daily early redemptions.
Uniswap - CEX to DEX and DEX to CEX
May 18, 2023 - Examine the flow of UNI tokens between Centralized Exchanges (CEX) and Decentralized Exchanges (DEX). Identify the volume of UNI tokens being transferred from CEX to DEX and vice versa. Determine which exchanges have the highest volume in terms of USD and analyze whether more UNI tokens are flowing into or out of these exchanges.
Top TOKE Holders
Jun 21, 2022 - Identify the top holders of the TOKE token in January 2022, have they kept their position today?
![Solana Fees Solana Fees](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Solana Fees
Feb 5, 2022 - One of the main advantages for a user of Solana is the extremely low fees relative to other blockchains. Create a visualization showing transaction fees per day accumulated since the beginning of January. Also create a visualization that shows transaction fees per transaction on each day. Do fees ever seem to spike or is it consistent.
![Active Wallet Growth Active Wallet Growth](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Active Wallet Growth
Jan 28, 2022 - What is the number of unique active wallets (signers) over the past 7 days? Create a visualization showing the number of active wallets per day since the start of 2022. What trends do you see?
![Monthly Swap Volume Monthly Swap Volume](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Monthly Swap Volume
May 11, 2022 - Q2. Show the total monthly swap volume on ParaSwap over the past year. How has the swap volume changed over time? Which DEX’s is most of the swap volume coming from?
TopShot during the NBA Playoffs
May 8, 2023 - Analyze the TopShot sales and marketplace activity during the first few rounds of the NBA Playoffs. Visualize the impact that the playoffs are having on TopShot. Has there been an impact on TopShot transaction volume, sales, redemptions, etc? What about Flow transaction activity more generally? Is the trend surprising or expected from your point of view? Why?
Governing the Cosmos
Jan 11, 2023 - How active and engaged are users? How many unique voters are there on each chain? How is voting power distributed? What chain has been the most active in proposals? Include any other relevant metrics as you paint a "heat map" of the cosmos.
![Tracking USDC & USDT on Solana Tracking USDC & USDT on Solana](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Tracking USDC & USDT on Solana
Jun 15, 2022 - What's the current market share for USDC and USDT on Solana relative to other stablecoins in the ecosystem (look into USDC, USDT, UXD, USDH, PAI, NIRV, UST, DAI, FRAX)? Create a visualization showing the amount of transaction volume for USDC vs. USDT etc. do display popularity within Solana. For USDC and USDT specifically, breakdown the transaction activity by contract and exchange flows (i.e. which dapps and addresses hold the majority of USDC and USDT and what do cumulative flows to and from exchanges look like over time)?
Aurora Contract Users
Apr 24, 2023 - Let's dig into users that have interacted with the Aurora contract on NEAR. Let's look at how many distinct users have interacted with the contract. Additionally, break out contract interactions, user interactions, and unique user interactions by day. Include any additional insights about the usage of the Aurora contract on NEAR.
Terradash Part 3: Development
Dec 19, 2022 - Construct a dashboard that displays the number of new contracts deployed and the total number of contracts deployed each week over the past several months. Your dashboard should also chart the development of stablecoins, including any supply trends.
Aave Delegates' Gas Usage
Mar 19, 2023 - How much gas was used by delegates voting in Aave in the past 90 days? In the past 180? How much gas on average is spent by voters in a single vote
NEAR partners with AlibabaCloud
Jun 30, 2023 - In the article above you can read about NEAR’s upcoming collaboration with Alibaba Cloud. This collab is going to boost the visibility of NEAR in APAC and make it easier for Alicloud users to spin up NEAR validators, hosted on there. Please research some insights into validators on NEAR: Number of validators, Seat price, Validators using poolv1.near vs pool.near, the new updateable pool factory, NEAR staked per validator in the active set, NEAR staked total, Effects of liquid staking solutions, and Yield on NEAR staking.
Terra LP-ers: Aftermath
Jun 19, 2022 - What did people that were LP-ing in the Terra pools do? Are they just holding onto their $RUNE now or are they back in the arena LP-ing somewhere? Or did they sell their $RUNE and leave the ecosystem completely.
![Most Recent Transactions Most Recent Transactions](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Most Recent Transactions
Jan 22, 2022 - Find the top 10 tokens in terms of liquidity in USD on Sushiswap. Show the 10 most recent transactions on Sushiswap for each of those tokens.
NEAR Centralized Exchange(CEX) Flows
May 2, 2023 - Using the labels table create a dashboard that illustrates the inflows and outflows of assets from NEAR to CEX and vice-versa. Look at items such as number of users and volume by CEX. Another thing to look at is which CEXes bring in the most active users to the ecosystem? Lastly what dApps in the ecosystem are users who onboarded funds from CEXes are using?
New and Improved NEAR Labels
May 13, 2023 - A plethora of new labels have been added to Flipside's NEAR labels table. Using the labels, dive into which specific projects and project types (defi, nfts, etc) generate the most gas fees, have the most users, and have the highest number of transactions per user. Next, dig a little deeper and see if you can find which project types and which projects have the stickiest(repeat) users!
NEAR Performance
Jul 15, 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.
Liquidity pools & providers
Jul 13, 2022 - For this bounty, analyse liquidity providers on Uniswap and the pools they provide liquidity to. Analysis can be done (but not limited to) the top and fastest growing pools, the biggest liquidity providers and what kind of pools they provide liquidity to, differences between v2 and v3 (such as TVL, total providers), etc.
![Bubblegoose Ballers Mint Bubblegoose Ballers Mint](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Bubblegoose Ballers Mint
Jun 15, 2022 - How many unique wallets minted a Bubblegoose Baller NFT and how many NFTs did these wallets purchase on average? How many NFTs were purchased with ETH using Crossmint? Identify any notable trends in minting activity and secondary market sales in the days following the launch. Which group(s) was most likely to "diamond fin" their NFTs?
Distribution of Swaps in $RUNE and USD Values
Sep 4, 2022 - Show the distribution of swap sizes in both $RUNE and USD, both for all pools as well as broken down by pool.
The Solana Smart Money
Jan 31, 2023 - Create a dashboard that tracks the most profitable traders on Solana (both in terms of token swaps and with NFTs). Use parameters to help define who falls under the category of most profitable and over what timeframe.
NBA Topshot NFT Traders
May 19, 2023 - In this dashboard we are going to be looking at NBA Topshot NFT Traders. We are going to start by looking at general trading metrics across all traders. Next we are going to focus on the top 10 traders and their trading activity. Finally we are going to look at the trading strategies of the top 100 traders in order to see what the optimal timing and assets to trade are.
Looking for the Elixir
May 28, 2023 - Elixir is a platform where you can buy and sell floor NFTs using the Elixir fAMM, a fast and efficient automated market maker on Solana blockchain. We need your help to create a new dashboard on Flipside that shows how Elixir is performing. Some of the metrics we want to see are: Sales volume: how much money is spent on buying NFTs on Elixir. Transaction volume: how many NFTs are bought and sold on Elixir. Users: how many unique wallets are using Elixir. Tokens: how many different types of NFTs are available on Elixir. Wallets per token: how many wallets own each type of NFT on Elixir
![Back to Basics I: Deposits and Borrows Back to Basics I: Deposits and Borrows](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Back to Basics I: Deposits and Borrows
Jan 14, 2022 - Select a time period (minimum 1 month). Using visuals, compare borrow volume and deposit volume over that time period.
Voting Power Within the Arbitrum DAO
Mar 31, 2023 - Track the consolidation of voting power within the Arbitrum DAO. How many unique wallets have delegated their ARB tokens? How many unique delegates received tokens? Create a dashboard that monitors the total voting power and number of unique delegators for the top 50 delegates. Identify the top 10 delegators (by total ARB) for each delegate in the top 50. Also examine the on chain activities of wallets that have chosen to delegate their voting power and note any patterns. Based on transaction histories, is it possible to identify which user segments are more likely to delegate tokens?
User Segmentation Analysis
Dec 26, 2022 - Let's analyze a typical user journey through Osmosis.
Velodrome Locks
Jul 17, 2022 - Analyze new locks created on Velodrome Finance. What durations are most common? Which wallets have locked the most in the last 4 weeks? Which pools are wallets voting for with their locked tokens most often?
Solana NFT Project Feature
Jul 16, 2022 - Choose a NFT project from the following list and create a dashboard with the new Flipside dashboard layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the project. Note any noticeable trends or current events for the project. Highlight how liquidity is flowing in and out of the project and what types of buyers and sellers are interacting with the project.
![Gainers and Losers Gainers and Losers](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Gainers and Losers
Jan 13, 2022 - Sort all of the liquidity pairs in terms of each of the following categories: fees in USD gained over the past 24 hours, volume in USD gained over the past 24 hours, and liquidity in USD gained in the past 24 hours. Repeat this process for the top 10 losers for each of the same categories.