isam-NuSprf
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.
ERC20 Tokens (zkSync)
Jun 16, 2022 - Q2. 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. Users can also deposit ERC20 tokens into ZkSync. Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days? Visualize and explain both findings.
RUNE bonded + slashed amounts
Jun 10, 2022 - Q103. How much RUNE is bonded, how much RUNE has been slashed from those bonds (total and or over time)?
Polygon Block Performance
Jul 26, 2022 - What is the average time between blocks on Polygon? What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
Flow vs Other L1s Pt (II)
Jul 11, 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.
Tokemak Popularity
Mar 3, 2022 - Tracer Q3: Tokemak is a protocol that allows tracer governance token holders (TCR) to seek further ROI by way of yield farming. What is the popularity of Tokemak among tracer users?
Top TOKE Holders
Jun 22, 2022 - Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
New Wallets In May
Jun 11, 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? What other ASAs do these new wallets from May hold? How many of these wallets have performed a swap? Finally, note anything else interesting about these wallets! Why are these wallets being created and what are they doing on Algorand?"
Marinade's Non-Fungible Chefs (Part II)
May 4, 2022 - Marinade Finance Non-fungible Chef NFTs began minting on April 4, 2022. How many unique holders of the NFTs are there? Create a chart showing trading activity and SOL volumes on Magic Eden. Aside from Marinade Finance, what other Solana DeFi protocols are most used by holders of the Non-fungible Chef NFTs? Highlight any trends in protocol usage. What other NFTs have these holders purchased and sold previously? Are holders active NFT traders on Solana, or are they first-time NFT users?
Prizes
Jun 22, 2022 - Q3. In the past 60 days, how many PoolTogether prizes have been awarded and claimed? What’s the USD value of these prices?
Friktion's Crab Strategy
Apr 28, 2022 - Friktion recently launched a new product offering, Volt #03 - a volatility yield strategy for stablecoins in crab markets. For more information. reference this twitter thread https://twitter.com/friktion_labs/status/1516835223576719376 And Friktion's helpful medium article: https://medium.com/friktion-research/harvest-volatility-yield-with-friktion-volt-03-2ba2c9df028b And a link to the Volt: https://app.friktion.fi/crab Track the deposit activity into the Crab Volt. How many unique wallets have used the strategy since April 11th? What other Friktion Volts have these wallets used since March 1st? What is the crossover between the Volt #1 Bitcoin strategy and the Crab Volt? Why would a wallet prefer to use this Crab Volt instead of the other products? Stay
Orca + Jupiter Volumes
Mar 11, 2022 - Compare the 5 most popular swaps SOL -> coin swaps (SOL swapped for another coin) on Orca and on Jupiter since January 1st. Create a visualization showing the total volume per day on Orca and Jupiter since January 1st for SOL to another coin swaps. What has been the historical swap success rate since January 1st on Orca and on Jupiter?
Song That Own Itself(STOI) Airdrop #3
Apr 7, 2022 - Let's look at how many wallets have claimed the STOI Song #3 “Million Scars” Airdrop.
Standardized TVL over time (all pools)
Apr 15, 2022 - Traditional TVL metrics are imperfect because they are influenced by both the quantity and price of the tokens over time. We would like to see a version of this metric that abstracts out the price influence on this metric.
Celsius Swaps
Jun 17, 2022 - Q95. 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?
Getting Started with Terra Bounties
Mar 2, 2022 - In response to: find all transactions delegating LUNA to Flipside on the day you completed the Terra Scavenger Hunt, make a chart that visualizes those transactions, and highlights your delegation transaction in a different color.
Solana Outages
Jun 5, 2022 - Q82. Solana experienced another outage on 6/1 where validators were forced to restart the network. The network experienced a similar problem back on 5/1. After the restart happens during these outages, how do users on the network generally respond? Does the price of SOL drop because users lose confidence in the network? Is there more swapping behavior and more stablecoin activity? What protocols seem to have more activity after these types of events that on the average day in the Solana ecosystem? Is there more fear from defi Solana users than NFT enjoyers?
Bridger Destinations
Jun 17, 2022 - Q5. Where do people go when they bridge to Polygon from Ethereum? What are the 10 most popular first destinations for Polygon addresses that have just bridged from Ethereum?
The Rise of DeGods
Mar 26, 2022 - DeGods have risen to become one of the most valuable NFT collections on Solana with an extremely devoted community.
Impact of Terra integration on new wallets created
Apr 22, 2022 - Q67. Show the daily number of new Thorchain wallets created in the 10 days prior to and after the integration of LUNA and UST.
USDC, USDT, UST on Jupiter
Mar 6, 2022 - Question 31: Create a visualization comparing USDC, USDT, and UST (wormhole) popularity in swaps on Jupiter since December 1st (both in terms of count and amount - swaps from and swaps to). Is there a dominant stablecoin in swaps on Jupiter? What percentage of all Jupiter swaps are stablecoin swaps (as in a swap between USDC, USDT, and UST)? Have we seen more instances of users swapping USDC or USDT for UST over time? Why or why not based on your knowledge of Terra's cross-chain efforts?
Marinade's Non-fungible Chefs
Apr 22, 2022 - Q55. Marinade Finance officially launched their protocol governance system on April 4, 2022. In order to participate in governance, holders of the protocol's native MNDE token lock their tokens in exchange for an NFT. This NFT, which varies in size based on the total amount of MNDE locked, represents total voting power and is used to vote on proposals. Governance NFT holders will soon have direct control over a portion of the protocol's validator delegation strategy too. There are 5 levels of Non-fungible Chefs, each representing an increasing amount of MNDE locked: Level 1: 1000–4999 MNDE Level 2: 5000–24999 MNDE Level 3: 25000–99999 MNDE Level 4: 100,000–249,999 MNDE Level 5: 250,000 MNDE or greater Create a bar chart illustrating the pace of minting activity since the launch on April 4, 2022. Create a pie chart showing the distribution of Chef NFTs by Level (as outlined above). How many whales (L5) are out there, ready to participate in governance?
Unique Programs
Feb 12, 2022 - One way to track developer growth in an ecosystem is through the number of unique contracts used. Create a visualization of the number of unique programs used per day since the beginning of January. What are the 5 most commonly used programs over that timeframe? What do those programs do and why do you think they are so popular?
Swap Fees
Jun 25, 2022 - 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?
Moonbirds Mint Distribution
Apr 22, 2022 - Q5. What was the mint distribution of the Dutch Auction? Plot the distribution at various price points and/or the mints over time with the cost. Use the Ethereum_core schema. Hint: https://etherscan.io/address/0x23581767a106ae21c074b2276d25e5c3e136a68b
Trident
May 4, 2022 - Describe using a visual document how Sushi's Trident works and compare, if possible, with other similar products in Defi.
Tinyman Farming Pool Incentives
May 20, 2022 - Q71. Tinyman is currently offering incentivized LP farming on USDt/ALGO USDC/ALGO and USDC/USDt pairs(https://app.tinyman.org/#/staking) Show how these rewards impact the number of mints and burns of these pools compared to some of the other large pools on Tinyman. Also show how these rewards impact the number of mints and burns of these pools(before rewards and during). How much of an increase in liquidity do we see being provided to these pools compared to when these incentives were not being offered? Are these staking pools on Tinyman a good way to increase the number of wallets and liquidity participating in defi? Tips https://app.tinyman.org/#/staking TRY_BASE64_DECODE_STRING( tx_message :txn :apaa [0] :: STRING) = ‘mint’ and app_id = 552635992 OR AND try_base64_decode_string(tx_message:txn:apaa[0]::string) IN ('mint', ‘burn') AND app_id IN (552635992) https://tinymanorg.medium.com/tinyman-staking-program-fd205b219eaf Example Mint Transaction: https://algoexplorer.io/tx/5DLPLLEGDJP3BZGYTZOMBKW2AYB5LJKY6AR774ZOBGYIMDXAMHUQ"
Staking SOL on Marinade
Mar 8, 2022 - Marinade Finance is the first non-custodial liquid staking protocol built on Solana. By staking SOL with Marinade, users receive mSOL tokens in return that can be used to explore other DeFi protocols and earn additional yield. mSOL can also be swapped for other tokens on decentralized exchanges like Jupiter and Orca.
Luart Trends
Feb 11, 2022 - What projects currently exist on Luart, and what have been their respective volumes? Create a visualization showing Luart trading volumes since its launch. What have been the 10 largest NFT purchases on Luart?
Sushi Reward Program for Farmers
May 4, 2022 - How much in total has been distributed so far? How much is left to distribute? What percentage of eligible addresses have not claimed anything so far? What percentage have totally claimed their rewards? What percentage have partially claimed their rewards? What percentage of the eligible addresses are dead addresses (A dead wallet is a wallet that has not executed any transaction in the last 3 months) Hints: Distributors address: 0x1026cbed7b7E851426b959BC69dcC1bf5876512d The table that shows the list of eligible addresses with their total vested rewards as at Oct 22 2021 at 5:47 PM EDT can be found under ethereum_sushi as “distributor_rewards_schedule_Farmers” The reward program started on Sep 24th 2021 the merkle_root for this merkle distributor is '0x015e6c2cd1a4d6fa77aa1884c436b2435aae4beab5c9a091f18fd0c00dc7e577'