Saleh
Marinade's Non-fungible Chefs
Apr 22, 2022 - 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.
Ecosystem Anchor
Mar 12, 2022 - Create a graph to show either a) the token price (over a time period of your choosing)
Gas Prices and Deposit/Borrow Amounts
Nov 10, 2021 - the following table shows the relation of GasPrices and average of Borrowed USD. the table Grouped by GAS Range. Note : GAS RANGE is ethereum.transactions.gas_price/1000000000 Meaning Gwei
The Nightmare Scenario
Apr 22, 2022 - Recently, attacks have been leveled against Terra, suggesting that it is doomed to collapse as UST reaches unsustainable levels. Specifically, concerns have been raised that at a low enough LUNA price, users will no longer be able to redeem $1 of UST for $1 of LUNA. In what circumstances would the price and supply of LUNA and the supply of UST constitute a serious threat to UST redemption, i.e. create an imbalance wherein the UST-LUNA exchange mechanism would no longer function properly? What is the likelihood of such a scenario, and how might it be mitigated?
Untitled BoardSushi vs Uni on L2
Oct 15, 2022 - Sushi vs Uni on L2 Compare the market share of Sushiswap and Uniswap on the following L2 chains.
Untitled BoardLiquidity Pools - Wallet Composition
Oct 25, 2022 - Liquidity Pools - Wallet Composition What type of wallets provide liquidity on Osmosis?
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. Track the volume and the number of wallets that are buying and selling goETH and goBTC on DEXs. Are more users acquiring goETH and goBTC or are they selling it? How does each DEX compare? Are wallets swapping goBTC and goETH for just ALGO? If not, what other ASAs are wallets swapping goETH and goBTC for? Did the price crash in May impact the number or volume of goBTC and goETH trades? Are there any notable days of trade for goBTC or goETH? What may have caused this? Note anything else interesting you find in your analysis on goBTC and goETH swaps!
Pleasure to Burn
Feb 27, 2022 - Terra Q152: How much LUNA has been burned over the past 30 days? How has the supply of UST changed over the same time period? Display both of these, using visualizations.
Trend Analysis
Apr 2, 2022 - Q63. Analyze the trend of active users and number of swaps for sushiswap and draw a comparison with Uniswap. Describe the trends that you see
18. [Hard] Stalking Whales
Dec 26, 2021 - Find the 10 wallets with the highest value locked in liquidity pools on Sushi. Show the activities of these addresses in terms of pools used, duration stayed in pools, gas fees paid, and profits earned.
Bots and success rate
Apr 27, 2022 - Compare the success rate of transactions executed by bots in the past 60 days with average users' transactions in the same time period. Is there any difference and any trends identifiable?
Who's That Going Across My Bridge (Redux)
Apr 22, 2022 - Pick one bridge from Terra and a destination of your choice. (e.g. Shuttle bridge Terra <-> Ethereum or Wormhole Terra <-> Solana).
BendDAO Metrics
Sep 5, 2022 - Q1. Analyze deposits and withdrawals into BendDAO over the past month. Provide metrics such as total ETH volume and unique wallets, and explain any interesting findings
Bot Activity
May 16, 2022 - Q86. Create a way of identifying bots within THORChain (could be something like a certain number of swaps / day made). What % of the swaps and swap volume are made by bots? Are there certain strategies you can see them employing (most of them are likely arbitrage bots)? Are there many bots or mainly just a few that conduct a high % of bot activity?
Wildlife Warriors NFT Drop
Jun 20, 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?
Let's look into stablecoin data on Algorand
Jun 1, 2022 - Q96. Chart some metrics on the total supply of stablecoins on Algorand. What is the total monthly transaction volume for stablecoins on Algorand? What are the most popular stablecoins monthly? How much of the total stablecoin supply on Algorand is being lent or borrowed? How has the impact of UST’s depeg affected the flow of funds in and out of various stablecoins on Algorand?
Activity after re-enabling pools
Jun 6, 2022 - Q98. There is currently a proposal on THORChain to keep trading on Terra assets disabled and use the remaining RUNE in the pools to support actors within the THORChain ecosystem that have been impacted by the Terra collapse. The idea behind this proposal is that if trading were re-enabled on Terra assets, most of the RUNE would be scooped up by bots and sold for other assets. We are curious in exploring that hypothesis. Take a look back at when THORChain was halted from November 11, 2021 to November 18, 2021. When trading was re-enabled, what did it look like? How quickly did prices on THORChain reflect the true values? (Since trading was halted, prices were stuck at the values they were at before the chain was halted). Did it seem like mostly bot activity? Did those bots then sell off any $RUNE they got from their swaps?
Seasonal Analysis
Feb 20, 2022 - Question 45: Conduct a seasonal analysis on sushi swap activity. Is there a particular month or day where there is more activity?
Market Volatility
May 25, 2022 - Q82. The second week of May saw some huge volatility in the market and prompted many to sell their volatile assets and take a flight to safety. What did the volume look like in decentralized exchanges on ethereum during that period? Which assets were being sold/bought the most?
Most Recent Pools
Jan 16, 2022 - Show the 100 most recently added liquidity pools. How much liquidity is in these pools? What is the volume of these pools?
Untitled BoardInflows and Outflows (redux)
Nov 2, 2022 - What is the volume of ETH and three stablecoins of your choice that's moved between the Optimism network and the Ethereum network across the bridge?
Lido Rocket Pool Comparison
Apr 27, 2022 - Q13. Use the ethereum_core tables to compare deposits to Lido and Rocket Pool
Wherefore Art Thou, Rewards?
Feb 7, 2022 - Question 145: What are users doing with their Anchor rewards? Quantify and visualize the differences between how users deploy rewards earned from each of the following: borrowing, staking, liquidity pooling.
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.
What Are Users Swapping gALGO3 For?
Apr 30, 2022 - gALGO3 is an asset that is pegged to ALGO. Users can lock their ALGO up on Folks.finance for governance and while their ALGO is locked they receive gALGO3 and you can use it for other defi activities. Read more about it here: https://docs.folks.finance/protocol-architecture/algo-liquid-governance Let’s look what users are swapping their gALGO3 for while their ALGO is locked in governance.
Untitled Board
Sep 21, 2022 - How many $MATIC have been staked since July 1, 2022? What is the staking ratio of $MATIC (amount of $MATIC staked vs circulating $MATIC) during the same time frame?
Untitled BoardWhat's All The Hubbub for Hubble Protocol?
Oct 10, 2022 - Hubble Protocol is a financial platform building sustainable Decentralized Finance services on Solana. Hubble's core service centers around a low-interest, stablecoin borrowing mechanism. Hubble's US Dollar-pegged stablecoin, USDH, can be borrowed against a variety of assets, including ETH, BTC, and SOL
Staking SOL on Marinade
Mar 7, 2022 - Question 32: Marinade Finance is the first non-custodial liquid staking protocol built on Solana.
Solana Staking Madness
Nov 13, 2022 - How has staking pool behavior on Solana responded to recent events?
Price + Circulating Supply
Jun 8, 2022 - Q3. Draw a chart showing MATIC’s circulating supply from the start till today. Compare it with MATIC’s price.
Staking STBL on AlgoFi
Mar 10, 2022 - Question 33: Let's look at how much STBL, Algorand's First Stablecoin, has been staked on AlgoFi.