john600
The Rise of DeGods
Mar 29, 2022 - Q42. DeGods have risen to become one of the most valuable NFT collections on Solana with an extremely devoted community. Create visualizations showing sales volume and unique wallet purchases since January 1st on Magic Eden. Using the NFT metadata, are there certain traits that have become more popular over time in anticipation of DeadGods? $DUST is the token created by DeGods for NFT auctions and will be a necessity for modifying the DeGod art to a DeadGod. Who is swapping for $DUST on Jupiter? Is it correlated with the wallets that have purchased the most DeGods? What do you think will happen to the price of the DeGods collection and $DUST when DeadGods launches on March 31st?
Sushiswap Bentobox Scavenger Hunt
Mar 24, 2022 - tx1 : Create limit order tx2 : Approve limit orders and Deposit MATIC into BentoBox
Spectrum Scavenger Hunt
Jan 27, 2022 - 1_added luna /ust liquidity on spectrum 2_bought some spec 3_staked my spec for 30 days
Cosmic Champs Token Launch
Apr 26, 2022 - Algorand based NFT Game Cosmic Champs have launched their project token $COSG. Let’s look at what users are doing with it. Use the swaps table to look at $COSG and show daily swap to and swap from volume for the asset. Note any trends There is a Yieldly Staking Pool for $COSG (https://app.yieldly.finance/distribution?id=710543830). Show how many stake actions a day are occurring. Plot the staking amounts(the amount of $COGS staked) by day over time on a scatter plot. What types of trends do you see?
Folks Finance: Minting gALGO3 For Governance
Apr 18, 2022 - Q53. Folks Finance is a newly launched lending and borrowing protocol built on Algorand. They offer a unique liquid Algorand governance opportunity which allows you to still utilize your ALGOs in in the form of gALGO3 a token you mint when you deposit your ALGOs into their governance pool. An important note is ALGO and gALGO3 are one to one in terms of value. We want to look at the users who committed their ALGOs to this liquid governance pool and minted gALGO3. How much gALGO3 was minted during the governance commitment period? Show the total amount of gALGO3 minted during the governance commitment period over time? Show the total amount of gALGO3 minted over time by day including outside the governance commitment period. Has a lot of gALGO3 been minted outside the governance commitment period?
Solana Health in Bear Market
May 31, 2022 - Q80. Create a dashboard with at least 5 different metrics of your choosing showing Solana's health and adoption as a blockchain as market conditions have soured.
Weighted-Average LP Duration
May 1, 2022 - What is the average duration of liquidity held in each pool, weighted by the size of the LP?
Algorand Foundation New CEO Staci Warden
Mar 17, 2022 - Question 31: Algorand Foundation appointed a new CEO Staci Warden on February 10th 2022. How did this impact the Algorand ecosystem? The week following announcement did we see an increase of ALGOs being moved from CEXs(centralized exchanges) to wallets? Or did we see an increase of ALGOs being moved from wallets back to CEXs?