Sniper
Bentobox Stats II
May 8, 2022 - Answer the following questions about user behaviour on Bentobox. Ideally choose both Ethereum and Polygon. What's the average holding period of each user? from initial deposit to bento until withdrawal of at least half of the total deposit? What percentage of users who supply stable coins to bento, also supply other coins? what percentage stick to stable coins? For this question you can ignore deposits of less than $50 USD.
Folks Finance Liquidation
Jul 14, 2022 - Q118. Dig into liquidations on Folks Finance to help us better understand liquidations that have happened on the platform!
Farming USDC and USDT Yield on Folks Finance
Jun 16, 2022 - Q102. Folks Finance has launched an alternative to their Lock and Learn. You can now stake fUSDC and fUSDT and farm a yieldwithout locking your assets. This is essentially a yield on your staked USDC and USDC! Let's look at wallets staking and using these farm pools.
Holders of the Headline NFTs & Token
Jun 16, 2022 - Headline(https://www.headline-inc.com/) is Algorand’s premier communities on Algorand with that is incubating multiple defi tools, a token, and two separate NFT collections: Astros and Pixel Astros
Stablecoin Dominance
Jun 27, 2022 - Q20. Compare the transaction volume for USDC, USDT, and DAI on Osmosis. Is there a stable coin that Osmosis users prefer?
Going Down The Wormhole
Aug 11, 2022 - Q103. Create a dashboard that can refresh daily with metrics that provide a detailed picture of Wormhole activity both from Ethereum to Solana and from Solana to Ethereum.
Velodrome Health (Redux)
Nov 16, 2022 - Create at least 5 metrics on Velodrome with a description for each that showcase traction and success in a data-driven manner.
Overtime Markets - Profitable Traders
Aug 24, 2022 - Identify the 5 most profitable traders on Overtime Markets in the last two weeks. How much has each wallet won by sport?
Exchange Flows in the Bear
Aug 13, 2022 - Let's understand whether the bear market and recent issues with CeFi products have changed centralized exchange users' behavior.
DOT DOT, Who's There?
Dec 13, 2022 - Like most assets in the last two years, DOT saw a meteoric rise in 2021 followed by a crater in 2022. However, DOT there still remains a little bit of DOT liquidity and volume flowing through Osmosis. Is the trading activity of DOT on Osmosis real user activity, or is this just arbitrageurs? How many users are active in Pool 773 every day, week, month?
Rand Gallery NFT Sales
May 4, 2022 - In this analysis, You will read about Rand Gallery NFT Sales in Algorand blockchain. I went through Rand gallery and analyze these metrics: Daily NFT sale volume in # of sales, ALGOs, and USD over time. How much Rand Gallery has earned in fees daily and accumulated over time How many NFTs have been sold through Rand Gallery and what is the total -volume in ALGOs of NFT sales What was the biggest NFT sale in both ALGOs and USD. What was the NFT?
User Activity
Jun 11, 2022 - Analyze user activity providing and removing liquidity from NFTX vaults. Which three vaults have seen the most activity over the past 60 days? Are there any similarities between these vaults or NFT projects? Explain and visualize your findings.
NEAR Performance
Jul 21, 2022 - Q5. 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.
HODL or Sell?
Jun 13, 2022 - Q11. Identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. Have they held or sold their stETH?
Waiting for Aurory
Jul 21, 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.
Quixotic NFT Dashboard
Aug 3, 2022 - Q7. Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism!
Assets Removed from Osmosis
Jun 10, 2022 - On June 8th, a critical bug was found on Osmosis that led to the theft of several million dollars from liquidity pools. In an effort to help provide the Osmosis team with important data, we’ve curated these flash bounties to surface metrics that the team has requested. The upgrade that contained the exploited bug occurred at block height 4707300, and the chain was halted at block 4713064. What was the total dollar amount of assets that was improperly removed from pools due to the bug, and what is the list of addresses that had joined a pool since the upgrade? What is the dollar value deposited of those addresses joining pools? What is the cumulative value of funds that joined and exited?
New Wallets In May
Jun 16, 2022 - Q101. How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May?