jackguy
Solana Outages
Jun 6, 2022 - 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?
New Wallets from NFTs
Jun 7, 2022 - Let’s look at the month of May and June to understand if the Algorand NFT scene is onboarding new wallets. For this we want to focus on wallets that have >1 ALGO and look at two different groups all wallets >1 ALGO and wallets created in May and June with >1 ALGO. Also note we only want to look at arc69 NFTs.
Tinyman Dex Popularity
Mar 24, 2022 - Tinyman was Algorand’s first DEX(decentralized exchange) and in 2022 we’ve seen the launch of three other DEXes: pactFi, algoFi, and Wagmiswap. Let’s look at the launch of these other DEXes and see how they have impacted the number of swaps on Tinyman.
Creating an NFT on Polygon
Aug 20, 2021 - Create a step-by-step guide to creating your own NFT on Polygon.
Staking Yield, Mvmt. II: Anchor
Jan 31, 2022 - Imagine it is February 20 and the Anchor yield reserve has reached 0. Using data to support your answer, assess what the APY on Anchor Earn would be, based on LUNA staking yield and ANC incentives. How might this compare to stablecoin yields that are currently available from other protocols (not limited to Terra)?
Full Cost of Swap
Dec 23, 2021 - What is the full cost of swaps (fee + gas) as a percentage of the amount received? How does it vary by pool or chain, and how does that cost compare to the cost of swapping through a CEX?
Monthly Swap Volume
Nov 12, 2021 - Show the total monthly swap volume on Sushiswap over the past year. How has the swap volume changed over time? Do the same for Uniswap. How do the changes in swap volume over time compare in the two DEX’s?
Liquidity and Volume
Jan 17, 2022 - For the past 30 days show the following: daily liquidity on Sushiswap and daily volume on Sushiswap. Which pools are contributing the most to each of these metrics?
Brace for (Meteor) Impact
Dec 16, 2021 - -How many meteors are there? -What is the breakdown/count of Legendary, Ancient, Rare, and Common? -How many have been cracked, and how many remain uncracked?
RUNE price vs Swapper activity
Oct 28, 2021 - Is there a relationship between rune price and trade volume?
LBP Analysis, Part 2
Dec 27, 2021 - Provide a full list of the participants in the Star Terra Halo sale, the Apollo farming event, and the LBP. Determine whether participants from the Star Terra Halo sale and Apollo farming event participated in the HALO LBP. Which group of participants had the highest level of involvement in the LBP (STT users, Apollo farmers or users of both)?
Claims vs Price
Dec 24, 2021 - Is ENS just for cred? Or do people actually use their ENS-addresses? Look at all addresses with an ENS registration in the last 6 months, what percent of those addresses have done transactions?
Synth Activity
May 6, 2022 - What are users doing with their synths? Are they swapping them for other assets? Are there any patterns in terms of actions / chains?
Fee Choice Analysis
Sep 11, 2021 - which fee choice/tier is getting the most bang for their buck? Does the answer to this seem to be stable or fairly dynamic?
Solport vs. Magic Eden
Apr 3, 2022 - a NFT marketplace on Solana - launched a V2 on March 12th that includes various new features for marketplaces. Beginning on March 12th, compare the NFT sales volume on Solport to Magic Eden's sales volume. How many unique wallets have used Solport over that timeframe compared to Magic Eden?
Terra Builders
Feb 26, 2022 - Describe at least 2 pain points that make building on Terra more difficult (these can be technical but non-technical pain points are also acceptable). Describe at least two (2) services/tools/capabilities that would address these pain points. Provide a concise explanation for each of them and the value they would unlock.
From Wormhole to Terra
Nov 22, 2021 - Chart the volume of UST being sent to other chains from Terra using Wormhole. Which chains have seen the most volume of UST sent since the Columbus 5 upgrade? How many unique wallets have sent UST to another chain? What is the growth rate? What is the average amount of UST sent per transaction to each chain? Are there any patterns behind UST being sent to Solana using Wormhole?
Most Popular Jupiter Swaps
Feb 25, 2022 - Jupiter is the best swap aggregator on Solana, meaning that it optimizes the best token swap rate across all decentralized exchanges for users.
Terra Transactional Nature
Mar 29, 2022 - In your own words, briefly explain how transaction volume relates to fees paid to stakers. Then, create a graph to show the fees derived from transactions and native swaps.
Top Delegator Overlap
Aug 13, 2021 - Which validators do the top 25 delegators (by volume) delegate to? Do they tend to delegate to the same validators, or to different ones?
Means of Repayment
Nov 6, 2021 - When people repay their loans, do they liquidate themselves and use collateral growth to do so, or are they paying off their loan with external (to Aave) funding? How does this relate to the collateral's price?
Rand Gallery Wallets
May 24, 2022 - Let’s look at wallets that buy from Rand Gallery to get a better understanding of purchasing behavior.
Tinyman 1.1 Launch Pools
Jan 26, 2022 - Tinyman 1.1 has relaunched. Let's check out what's going on in the pools for Algorand Tinyman. How many pools have been created?(Tip: Look for TX_GROUP_IDs that contain both an application call to APP_ID 552635992 and an asset configuration transaction. What are the most popular pairs to provide liquidity to by number of wallets? Now, let's build a table to show current total liquidity provided to each pool.
Flash Loan Prevalence on Aave
Aug 20, 2021 - Build a dashboard or tool to analyze flash loan use on Aave: how they are used (what protocols are the funds used with), how often, and how much (volume).
Weekly Fees
Nov 21, 2021 - Show the total weekly fees collected each week over the past year. How has the total amount changed over time?
Failed or not
Mar 12, 2022 - Create a visualization about the total transaction daily on harmony blockchain and show the success rate for transactions and compare it with others networks
Song That Own Itself(STOI) Airdrop #3
Apr 8, 2022 - Let's look at how many wallets have claimed the STOI Song #3 “Million Scars” Airdrop: How many users have claimed the airdrop? Chart the STOI Song #3 airdrop token distribution by day.
Miso's Competitive Advantage
Apr 20, 2022 - Create a visual document outlining the below facts about Miso, the new addition to the Sushi menu
Galactic Punks Lottery
Nov 3, 2021 - How much UST has been deposited into the lottery since it’s inception? What has been the average UST deposit amount?
Top Kashi Pairs (II)
May 18, 2022 - Find the top 5 Kashi pairs on Ethereum based on the number of loans they have given out so far. Choose one that you like, and describe the following information: How many people are lending on this pair at the moment ? How much each user is lending at the moment?
Gas Prices and Deposit/Borrow Amounts
Nov 6, 2021 - As gas prices have continued to rise, how have average deposit and borrow amounts changed in response?
January 2022 New Wallets Created
Feb 13, 2022 - Question 20: In January 2022, we see a surge in new wallets created. Were these new wallets interacting with any assets in particular? Were there any patterns in the amount of Algos these wallets held?
Algorand Governance Period 2 Initial Commitments
Feb 9, 2022 - The 2nd governance commitment period has ended and the voting has begun. Let's take a look at the number of wallets and ALGOs that were committed during the second commitment period.