Saleh
Untitled BoardOptimistic Bears (Redux)
Nov 7, 2022 - Q9. Analyze Optimism during the month of July as markets were get turbulent, showing whatever metrics you care to unearth.
Tracking USDH
Apr 22, 2022 - Hubble is a decentralized finance protocol built on Solana. Hubble will offer multiple Hubble currently focuses on borrowing and minting USDH - a stable coin. Users can deposit multiple kinds of crypto assets like SOL, BTC, ETH, and others to borrow up to 90.9% LTV in USDH. While borrowing, users can earn yield on their deposits. Therefore you can take your USDH and invest it in other protocols.
NEAR Gas Guzzlers
Jul 26, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month?
CowSwap - Market Mover?
Apr 22, 2022 - Has CowSwap shifted the token exchange market? Show the number of swaps that are done on CowSwap compared to other DEXs over the past several months. What DEXs are the users of CowSwap coming from?
Saber Locked Over Time
Mar 28, 2022 - Q46. Review the scavenger hunt on veSBR for an explanation on the Saber Wars! Create a visualization showing the amount of SBR locked in governance over time since January 1st. Are there any notable trends on when SBR has been locked or wallets have exited from their locked positions? For example, have there been certain dates when we can expect there to be more locking activity than others? Provide some insight on locking behavior.
IL Protection Over Time
May 16, 2022 - Q88. With highly volatile prices recently, more IL protection has been paid out on THORChain. How do recent days or weeks compare to historical amounts?
Gain or Lose-Lido
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?
Bridger Destinations
Sep 14, 2022 - Where do people go when they bridge to Optimism from Ethereum?
Unique Users on Algorand
Apr 3, 2022 - Compare the number of unique wallets that have sent a transaction since February 1st on Algorand vs Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Algorand compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks?
Looking For Swap Arbitrage
Mar 30, 2022 - Q42. Let’s see if we can find any wallets profiting from arbitrage on the Algorand DEXes. We specifically want to see if anyone is conducting arbitrage with USDT or USDC, Asset ID 31566704 or 312769. The period we will want to look at is From January 1st 2022 to current.
Rand Gallery Wallets
May 25, 2022 - Q77. Let’s look at wallets that buy from Rand Gallery to get a better understanding of purchasing behavior. How many wallets are buying NFTs on rand gallery. What is the total number of unique wallets that have purchased from rand gallery? Create a distribution plot of how many NFTs each wallet has purchased from Rand Gallery Are we seeing new wallets purchasing on Rand Gallery or is it only wallets that have purchased from Rand Gallery before? Chart the first purchase on Rand Gallery by wallet over time. Create a table of the top 10 wallets that are purchasing from rand gallery by ALGOs and number of NFTs
11. [Easy] Claims vs Price
Jan 5, 2022 - The table below shows what percentage of users are active and what percentage is inactive. Our method for detecting user activity or inactivity is to find the difference between two user transactions. If a user has less than one minute of transaction during these 6 months, it is considered inactive.
DEX Popularity: Tinyman, Algofi, Pactfi
May 20, 2022 - Q70. Since the beginning of April, how has the growth of AlgoFi and Pact impacted swaps on Tinyman? Show us how the Algorand DEX ecosystem is changing as each DEX grows. Do we see a change in the number of wallets swapping on these DEXs? Do we see a change in the volume of ALGOs being swapped on Tinyman and the other DEXs? Are ALGO whales swapping on certain DEXs more than others? Have we seen has the recent price change in ALGO impact the number of swaps/wallets/volume on the DEXs? If so, how?
stETH Most Common Pools
Apr 27, 2022 - Use the ethereum_core tables to determine the pools most commonly used to swap in and out of stETH. What are the most common pairs? Which pools are most often used?
New Addresses
May 31, 2022 - Q2. Draw a chart showing the number of new addresses every day on polygon(matic) network. New addressses are unique addresses that appeared for the first time in a transaction of Matic.
125. [Easy] Anchor Users
Dec 25, 2021 - By calculating the total number of anchor users and subtracting them from the users of the last 3 months, it can be concluded that 61818 new users have been added to the anchor in the last 3 months.
Moonbirds Gas Fees
Apr 22, 2022 - How much gas was spent minting? Was any gas lost due to failed transactions? How does it compare to other recent launches?
NFL ALL (THANKSGIVING) DAY
Dec 3, 2022 - The NFL's annual Thanksgiving games recently drove record viewership in the U.S., with 42 million people tuning in to see the Giants take on the Cowboys. Did FLOW NFT project NFL ALL DAY see similar boosts in popularity?
Trending NFT Projects
Jun 11, 2022 - Q8. 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? Do the projects that are trending seem to have common wallets or is there not much crossover between buyers/sellers?
9. [Easy] Claimed Token Distribution
Dec 18, 2021 - the average amount of ENS claimed from the airdrop
Forefront Curators
Apr 22, 2022 - Forefront has token-permissioned governance and curation channels that require holders owning at least 1000 FF tokens. Create a visualization of the number of curator roles in Forefront over time. Are more curators being added over time? How could Forefront incentivize growth in curator roles?
SOL OpenSea vs Magic Eden
Apr 13, 2022 - OpenSea launched its SOL compatibility on 4/6 - giving the SOL NFT landscape access to the largest source of NFT liquidity. However, Magic Eden remains the top NFT marketplace on SOL. Compare sales volumes between OpenSea (for solana NFTs) and Magic Eden since OpenSea's Solana launch. How many unique users have bought a SOL NFT on OpenSea vs Magic Eden since 4/6. How do you expect this trend to develop over time?
140. Anchor Collateralization
Jan 28, 2022 - 1-How much of the collateral provided on Anchor is bLUNA vs. bETH? 2-How has this changed over the past 90 days?
Weighted-Average LP Duration
May 10, 2022 - What is the average duration of liquidity held in each pool, weighted by the size of the LP?
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).
Celsius and Sushi
Jul 13, 2022 - Q104. Find out what Celsius platform has done on sushi (swaps, lending, LP'ing, farming). Make sure to use cross-chain tables as much as possible to capture data on all chains. currently, we have swaps, lending, and borrowing data cross-chain.
NFDomains
Jun 23, 2022 - Q107. NFDomains are .ALGO domains NFTs that have launched on Algorand. Lets look how many domains NFDomains have sold
Untitled BoardAiling Alameda
Nov 8, 2022 - Analyze what Alameda is experiencing. Rumors over the weekend began swirling that alameda research is on the brink of insolvency.
Solana Outages
Jun 8, 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?
Swap Sizes
Feb 7, 2022 - Question 37: Show the daily average swap size over time for the 10 largest liquidity pools (in terms of value locked). How has this swap size changed over time? Why might this be?
128. Fees on Wormhole vs Others
Jan 8, 2022 - Above we have two graphs and a table, In the table, we have the columns of Wormhole sum, Harmony Bridge sum and Terra Bridge BSC sum on a weekly basis, respectively, and in the next three columns we have the ratio of Fee to Amount. And in the last chart, we compared the ratios and it can be concluded that in weeks 46 and 44, the highest Fee of existence was received.
Song That Own Itself(STOI) Airdrop #3
Apr 5, 2022 - Q44. Let's look at how many wallets have claimed the STOI Song #3 “Million Scars” Airdrop.
Total Metamask Users
Jun 25, 2022 - Q1. How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher order activity, like staking?
Algofi Decentralized Lending-Algo
Feb 16, 2022 - Algofi Decentralized Lending Algofi is a decentralized lending platform where you can provide collateral to take a loan on your asset.
Sushi Farming
Apr 6, 2022 - How many farms are there on Ethereum, Polygon and harmony. And what is the TVL per farm? which farms offer the most TVL? How has this changed over time?