Pmisha-llIHxU
NEAR Performance
Jul 20, 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.
Aave - 8. How does BTC funding affect rates?
Aug 12, 2022 - Create a dashboard that shows: 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.
Aave - 7. AAVE and stAAVE movements
Aug 12, 2022 - Create visualizations showing the following: Daily AAVE supplied and withdrawn on Aave protocol. Daily AAVE staked and unstaked.
Tornado Cash Sanctions
Aug 10, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online. (Hint: we also have them in our crosschain address labels table as well). What is Tornado Cash and why would it be targeted by the US government? Why might an address interact with the service?
Wildlife Warriors NFT Drop
Jun 23, 2022 - Q105. Wildlife Warriors was a project established by Steve Irwin in 2002 as a way to include and involve other caring people to support the protection of injured, threatened or endangered wildlife. They recently had an NFT drop(https://twitter.com/wildwarriors) on Algorand to support the project. Lets look at the wallets that own one of these NFTs: -Look at when the wallets were created(created_at) that own a wildlife warrior. Were wallets created recently for the drop or are they more established wallets? -Look at the ALGO balances of wallets that own a wildlife warrior and show the distribution balances -Look at how many Wildlife Warriors each wallet holds. -Is there a correlation between how many Wildlife Warriors a wallet holds and their ALGO balance?
Liquidity Providers Stats
Aug 24, 2022 - Q109. Liquidity providers stats 1. Evaluate the distribution of various target segments who provide liquidity (LP) 2. Evaluate the profitability of an LP Provider & Yield Farmer
Increasing Positions
Jun 27, 2022 - Q2. Compare users terminating vs increasing positions over the last 30 days. By how much are they increasing positions? How much are they receiving back after terminating?
Are NFT Creators Minting Money?
Jun 22, 2022 - Q87. 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?
Polygon Opensea Fees
Aug 1, 2022 - Q6. Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
Velodrome Health
Aug 17, 2022 - Q10. Create at least 3 metrics on Velodrome with a description for each that showcase traction and success in a data-driven manner. Most importantly, your insights should help our readers answer the question "How healthy is this project?"
Optimistic Bears
Aug 9, 2022 - Q9. Analyze Optimism during the month of July as markets were get turbulent, showing whatever metrics you care to unearth. You can choose any topic you’d like: How did the network perform? What about market performance? Were there significant inflows or outflows on bridges? Were there any notable patterns in user behavior?
Gain or Lose
Jun 15, 2022 - Q10. Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose depending on the peg of stETH to ETH at the time of the swap? Repeat the same analysis for stakers who have swapped stETH to ETH; how much ETH did they gain or lose?
Distinct Wallets (Optimism Bridge)
Jun 17, 2022 - Q1. Many blockchain bridges exist allowing users to move assets between different blockchains. One of the blockchains currently receiving a lot of bridge volume is Optimism. There are several bridges you can use to move tokens to Optimism, but for this bounty we are particularly interested in Optimism’s bridge. You can find more information on their native bridge here and here. How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
Hacks, Scandals and Scams - 3. Whales On Alert
Jul 30, 2022 - Identify active wallets with a high balance of ETH (whales). Visualize the ETH transaction history of these whales in May and June 2022.
Tornado Cash Addresses
Aug 9, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online. (Hint: we also have them in our crosschain address labels table as well).
Solana Protocol Feature
Jul 13, 2022 - Q97. 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.
Opening Positions
Jun 27, 2022 - Q1. Over the last month, what volume of assets are Mean Finance (Polygon) users opening positions with (selling)? What assets are they dollar-cost averaging into (withdrawing swapped assets)? Note any large positions that don’t make sense on Ethereum due to transaction fees.
Sushiswap- WETH/THOR Pool
Sep 13, 2022 - Q111. ThorSwap just recently partnered with Sushiswap to create an Onsen farm for ETH-THOR LP providers to stake their liquidity to earn extra rewards. Previously ThorSwap offered their own contract for the same purpose but this switch allows for higher rewards as well as lower slippage for the users.
Average Solana Portfolio
Jun 29, 2022 - Q91. 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?
Flow vs Other L1s Pt (II)
Jul 18, 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.
Velodrome Locks
Jul 15, 2022 - Analyze new locks created on Velodrome Finance. 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?
Realms vs Snapshot
Aug 30, 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.
Welcome to the City
Jul 21, 2022 - Once you’ve bridged to NEAR, what is a user’s first activity? Chart the protocols that users are leveraging after porting tokens through the Rainbow Bridge specifically
Highest Sales Volume
Jun 14, 2022 - Q1. Which 3 NFT collections have the most total sales volume in the last 60 days on NFTX? These are transactions where someone redeems their NFTX tokens for a specific NFT.
NEAR Gas Guzzlers
Jul 27, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month?
Tracking Realms DAOs
Aug 16, 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 features.
The Unstakeeeeers
Jul 18, 2022 - How frequently do users on Osmosis unstake their Osmosis? What do they do with the OSMO once unstaked? Do they re-delegate, enter a LP position, or swap into another token? Do they re-delegate to certain validators more frequently than others? Why might this be so?
Active Wallets
Jun 19, 2022 - Q12. What are active wallets doing more broadly? What type of activities are the most common on average, and what are the whales doing? Is there a way to identify real users and organic transaction activity?
FLOW Usage During the NBA Playoffs
Jul 13, 2022 - Q19. Analyze the NBA Conference Finals (May 17th- May 29th) and determine whether it had an impact on NBA Top Shot's volume. Did the Warriors, Celtics, Mavericks, or Heat see higher sales volume?
Stablecoins on Kashi
Jul 14, 2022 - Q102. Analyze the behavior of stablecoins on Kashi markets. Which ones are being deposited for lending? Which ones as collateral? Do this for both polygon and Ethereum. You can use the cross-chain sushi ez_lending and ez_borrowing.
True Freeze - 2. Distribution of Token Ownership
Jul 30, 2022 - How many addresses hold frETH? Exclude labelled addresses, liquidity pools and protocol-owned addresses from the count. Visualize the distribution of frETH tokens amongst non-institutional addresses.
ETH Staked
Jun 15, 2022 - Q9. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
Distinct Wallets (zkSync)
Jun 17, 2022 - Q1. ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. You can read more about ZkSync here. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
Swap Fees
Jun 27, 2022 - Q21. Do fees on Osmosis differ when users swap to or from different tokens? On average, which tokens have the highest and lowest swap fees on Osmosis?
Network Performance Dashboard
Jul 13, 2022 - Q95. Create a dashboard displaying Solana network performance over time. How has the network performed over the past month compared to the rest of the year? Has transaction per second and success rates of transactions gone up recently? Is this because of less botting or fewer users, or new improvements from the Solana engineers? What wallets and programs have paid the most in fees for failed transactions?