miguelperspective
Distinct Wallets (zkSync)
Jun 18, 2022 - How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day?
Swapping goBTC and goETH on DEXs
May 21, 2022 - Q72. goETH and goBTC are wrapped forms of ETH and BTC minted by algoMint. Let's look at goBTC and goETH swaps across the DEXs since the beginning of April and get a better understanding of how wallets are swapping goETH and goBTC - especially during the price crash in May.
NBA Playoff Usage
Jun 28, 2022 - Analyze the start of the NBA playoffs (mid-April) and determine whether it had an impact on Flow transaction volume. What about NBA Top Shots?
User Activity
Jun 14, 2022 - Q2. 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. Hint: fact_event_logs is probably the best table to use here.
Highest Sales Volume
Jun 12, 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.
RUNE Upgrades
Jun 28, 2022 - Q.107 There has been a big push for users to upgrade their ETH.RUNE + BNB.RUNE -> native RUNE, as the wrapped versions will be depreciated.
Algorand NFT Shuffle Hunt
Jun 29, 2022 - I completed this hunt by following the structure.
ETH Staked
Jun 16, 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?
Hot Ball of Money (Solana NFTs)
Jun 15, 2022 - Compare Solana NFT sales activity on "new" collections to the activity on more established collections within the ecosystem. Has the trend been to buy into the hype or invest in builders for the long term? What do whales seem to be doing? Has it been more profitable to mint/buy these new hyped collections and flip them, or to invest long term into NFT collections?
User Behavior
Jun 20, 2022 - Q11. What are users swapping for? What activities are the most common for users on Flow right now? Create a visualization on what’s causing spikes in swapping behavior.
New Wallets In May
Jun 17, 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? How many new wallets were created in May? What % of total wallets with more than 1 ALGO is this? Additionally, show the distribution of ALGO holdings for these new wallets. What is the average ALGO holding of these new wallets?
Daily Transactions and Unique Addresses
Jul 13, 2022 - Q1. Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022.
Swap Increase on May 11 + 12
Jun 9, 2022 - Heads up! Any changes made to your dashboard after the bounty ends may result in your submission being marked as ineligible. Please confirm that your dashboard is ready to be graded before you press submit! Q98. On May 11th and 12th we saw a spike in number of swaps and volume across the DEXs. Breakdown what happened? What were users swapping from and to? Were users swapping from ALGO to stables? Was the average swap size bigger than normal? Is this tied to the price of ALGO? Help us understand what took place and why the volume and number swaps increased!
Flow vs Other L1s Pt (II)
Jul 19, 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.
Trending NFT Projects
Jun 14, 2022 - Create a visualization showing NFT sales volume on Flow since May 9th. Which NFT projects are trending on Flow right now and what is the general trend of NFT sales over the last month?
NEAR Scavenger Hunt
Jul 12, 2022 - I received some NEAR and swapped them to wNEAR and then swapped my wNEAR tokens to USN.
$RUNE Movement from Crypto.com
Jun 21, 2022 - Q104. Show the in + outflow from cryto.com to native wallets over time. Are there any trends?
Distinct Wallets (Optimism Bridge)
Jun 18, 2022 - 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.
Do Whales Have Diamond Hands?
Jun 21, 2022 - Q12. Does the swap behavior of OSMO whales differ from everyday users? How does it differ? Create visuals showing what whales swap to and from compared to a normal Osmosis user.
Transaction Fees
May 24, 2022 - How many transaction fees are being paid out each day for the past 30 days? Does a certain type of transaction result in a greater amount of fees being collected?
