![Alexay | Flipside Analyst Alexay | Flipside Analyst](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/backgrounds/analyst-bg.png)
Alexay
Solend TVL Tracking
Aug 25, 2022 - - How has this influenced user behavior on Solend so far compared to prior user activity? How many users have used a permissionless pool? - What is the % of TVL contributed from isolated and permissionless pools, against the main pool over time? - What is the amount/% of TVL that comes from PDAs/integrations or DAOs/Realm addresses, instead of normal signers? - Overall how healthy does Solend appear as a protocol and is it gaining traction in the Solana ecosystem? Date Created: 26/8/2022
Aave - How does BTC funding affect rates?
Aug 12, 2022 - Show: Supply and lending rates for at least five tokens in Aave V2, and Total amount of Wrapped BTC supplied over time. Provide analysis on the volatility of rates. Measure the correlation between USDC borrow rates and total wBTC supplied. Date Created: 12/8/2022
Aave - AAVE and stAAVE movements
Aug 8, 2022 - - Daily AAVE supplied and withdrawn on Aave protocol. - Daily AAVE staked and unstaked.
Tourist Journeys
Oct 26, 2022 - Select one of the key Districts from the NEAR tournament, and compare it to a similar district in another “city” (that is, another Layer 1 blockchain). Look at the past 90 days and visualize the relative progress of these two L1s, using at least 3 metrics of your definition. Date Created: 27/10/2022
Sushi pairs on Avalanche and BSC
Aug 5, 2022 - Let's dive deep into Sushi pairs on Avalanche and BSC
ETH Derivatives
Sep 12, 2022 - Consider the liquid staking ETH derivates from ankr, rocketpool and lido(aETH , rETH and stETH ). What are some trends around the price volatility for these tokens? Swap activity? Date Created: 13/9/2022
![curve curve](https://res.cloudinary.com/dsr37ut2z/image/upload/assets/project-icons/curve.png)
District Deep Dive: Contracts Deployed
Sep 29, 2022 - Building on work from The Law Offices of NEAR , provide an updated view of contracts deployed over time on NEAR. What factors do you think might influence the number of contracts deployed? How might NEAR boost the number of developers and deployments within its ecosystem? You can rely on earlier work - yours and that of others - but clearly reference anyone whose work you use. Date Created: 29/9/2022
Flipside's World Cup of Bounties Side Quest: Fifa+ Collect Collection Scorecard
Nov 16, 2022 - Use the parameter feature on Flipside to allow users to put in their Fifa+ Collect Wallet address. Show the users collection and the breakdown of the users score Add a cool visualization that provides additional context
Avalanche Swaps vs Transfers (Redux)
Dec 8, 2022 - Lets look at volume of USDC swaps vs transfer by hour since 7/1. What is the average amount of USDC transferred vs swapped? Show number of unique swapper addresses vs transfer addresses by day for USDC Next lets look at mints and burns of pairs involving Lets look at the volume of USDC mints and burns by hour since 7/1 How many unique wallets are minting and burning USDC by day What is the average mint vs burn for USDC by day Note anything else interesting about USDC transactions
New NEAR Users
Sep 7, 2022 - What actions does a user take when they deposit money into the NEAR ecosystem? Show the most common actions taken by users on NEAR (new users using NEAR for the first time) over the past 3 months. Date Created: 7/9/2022
Untitled Board
Sep 3, 2022 - Choose 1 liquid staking provider and answer the following question: How much ETH was staked? How many unique depositors are there? What is the avg/median/max/min/distribution of ETH deposits? Date Created: 9/4/2022
The Law Offices of NEAR
Aug 3, 2022 - Provide your best assessment of the number of smart contracts deployed on NEAR and clearly outline your methodology (after all, contract lawyers love clearly specified terms). Visualize the number of new smart contracts deployed over time over a time period of your choosing. What are the top 5 new smart contracts interacted in that period of your choosing? Date Created: 3/8/2022
Untitled Board
Oct 5, 2022 - Do a deep dive into another project on NEAR and analyze its impact, defining metrics for “impact” and displaying them with data. What contributions is your chosen project making to NEAR? You don’t need to choose one of the biggest or most impactful projects - and your research can include qualitative assessment as well. Date Created: 6/10/2022
Opensea Fees
Aug 1, 2022 - Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions. Date created: 1/8/2022
FLOW Usage During the NBA Playoffs - Alexay
Jul 12, 2022 - Here we analyze TopShot sales in the 12 day period of the NBA playoffs and rank each team sales.
Flipside's World Cup of Bounties Side Quest: Sorare Compete With Collectibles
Nov 22, 2022 - Sorare is a digital, playables and collectibles platform where users can compete across football, NBA, and MLB in a fantasy sport setting. Build a dashboard that covers the Sorare project: - Statistics on Sorare NFTs being sold on Opensea such as buyers, volume, number of NFTs etc - Transfers and mints over time - Statistics on contract events such as players and clubs added - Provide additional insight into the players and clubs added in from the event inputs.
Overtime Markets - Volume
Aug 22, 2022 - Analyze the total volume on Overtime Markets over the past two weeks. Which games received the most activity, both in total users and total $ volume? Which sports are receiving the most bets in total dollar volume on a daily basis? Explain your findings. Date Created: 24/08/2022
City Amidst the Storm
Nov 17, 2022 - Provide a thoughtful analysis of how NEAR is weathering the market turbulence that occurred as a result of FTX’ insolvency. 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.
Tornado Cash Addresses
Aug 10, 2022 - Using the Tornado Cash blacklisted addresses find out: Which of the Tornado Cash addresses received the most # of transactions in the last month, quarter, year Which addresses received the most transaction volume (worth) in the last month, quarter, year Over all the addresses, group the transactions into buckets by value. Date Created: 10 August 2022
True Freeze - 7. FRZ Airdrop Activity After Claim
Aug 26, 2022 - Approximately 230,000 addresses are eligible to claim FRZ. What percentage of all eligible addresses have claimed the airdrop? After claiming their allotment in the FRZ airdrop, what do participants do with their FRZ tokens? Date Created: 26/8/2022
ETH Removed
Sep 17, 2022 - Examine user behavior in recent weeks leading up to the merge on at least 3 major protocols. Have there been any changes in the amount of ETH removed from protocols like Uniswap and Aave? Note any trends or outliers you find.
Osmosis Governance: 362 and Beyond
Nov 23, 2022 - Governance in the Cosmos ecosystem has been a hot topic of late - first with Cosmos Hub 82 and now in Osmosis. Osmosis Prop 362 is a vote to decide the fate of the Osmosis Grants Program (OGP). Contention aside, there have been many points and counterpoints, AND a ton of vote switching. Let's take a look at the governance behavior surrounding Proposal 362. On the outside, it seems that a ton of voters have been switching their votes - is this actually true, or is it just big whales/validators causing these swings? What is the average wallet size (in OSMO) of the people voting? Of the people who have changed their vote more than once? Compare and contrast voting behavior of validators and average users in this context. Further, is Prop 362 significantly different than other proposals from an engagement perspective? Analyze voting for 362 vs. other recent governance proposals.
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. Date Created: 11/10/2022
![Tracking Realms DAOs Tracking Realms DAOs](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Tracking Realms DAOs
Aug 16, 2022 - Use Solana Realms governance data to track a list of DAOs / multisigs built on SPL Governance, and understand their: Number of Members / 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 Date created: 16/8/2022
DEX Change
Nov 16, 2022 - This week has highlighted the need for transparency & decentralization in crypto markets. Let's see how users have reacted to this wild week in Web3. Have behaviors changed? Analyze growth in Osmosis Volumes & User Count this week. Has more money flowed into Osmosis this week compared to the past few weeks/months? Where is this money coming from? Centralized Exchanges? Have wallets moved more into stables?
Solana Since The Mango Hack
Oct 15, 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. Date Created: 17/10/2022
Sushi vs Uni on L2
Oct 15, 2022 - Compare the market share of Sushiswap and Uniswap on the following L2 chains. Polygon, Arbitrum, Optimism. Use measures such as number of trade or number of swaps, etc. Date Created: 17/10/2022
![Velodrome Health Velodrome Health](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Velodrome Health
Aug 17, 2022 - Create at least 3 metrics on Velodrome with a description for each that showcase traction and success in a data-driven manner. Try to find the insights that help our readers answer the question "How healthy is this project?" Date Created: 18/8/2022
RaceDay NFTs
Oct 23, 2022 - How does Speedway Motorsports RaceDay NFTs stack up to sports NFT collections in the FLOW ecosystem? What other projects are RaceDay fans buying? Date Created: 24/10/2022
![Realms vs Snapshot Realms vs Snapshot](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Realms vs Snapshot
Aug 29, 2022 - 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? Date Created: 31/8/2022
The Battle of the Solana NFT Aggregator
Oct 30, 2022 - 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? Date Created: 31/10/2022
![Bots Success Rate Bots Success Rate](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Bots Success Rate
Apr 27, 2022 - In this bounty our task is to analyze and compare the success rate of transactions executed by bots with user transactions in the past 2 months. Our query will retrieve the four following columns: Bots_Success, Bots_Failed, User_Success, Users_Failed for each day. First we want to look at a bar chart for both users and bots successful/failed trades.
OP Price vs Swapper Activity
Oct 5, 2022 - Is there a relationship between OP price and trade volume? Date Created: 5/10/2022
BendDAO Metrics
Sep 7, 2022 - Analyze deposits and withdrawals into BendDAO over the past month. Provide metrics such as total ETH volume and unique wallets, and explain any interesting findings. Date Created: 8/9/2022
![Solend Demographics Solend Demographics](https://res.cloudinary.com/dsr37ut2z/image/upload/f_auto,q_auto/assets/backgrounds/dashboard_default.png)
Solend Demographics
Aug 2, 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? Date created: 3/8/2022
NEAR City Layout
Nov 9, 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?
OpenBook
Nov 22, 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?