banbannard
Collateral Impact (May 13)
May 14, 2022 - How does the volume on MakerDAO (in terms of DAI minting) change as more collateral tokens are added to the platform? Which tokens have impacted volume the most?
New to the Menu
Apr 10, 2022 - What are the 10 most recent assets (coins) supported by sushi?
Seedclub: CLUB Liquidity
Mar 15, 2022 - What’s the liquidity of the CLUB token on decentralized exchanges? Analyze the trade volume on Uniswap, what is the largest trade? Did that trade affect the balance of tokens in the pool significantly?
The Octorand Universe
May 26, 2022 - Octorand is a virtual world of opportunity built on top of the Algorand blockchain. Octo Primes are the only form of life existing in the world of Octorand. You can collect these Octo Primes, transform them to increase their value and trade them through the inbuilt marketplace. Show the number of Octo Primes Gen1 and Octo Primes Gen2 each wallet holds. How many unique holders are there for Gen1 and Gen2? How many Gen2 holders hold an Oct Prime Gen1? Show Octo Primes Gen1 and Octo Primes Gen2 sales and ALGO volume over time.
Flipside Algorand Wallet Behavior
Apr 7, 2022 - Let's take a look on Flipside Algorand Wallet Behaviour!
Privacy Coins + Politics
Jun 11, 2022 - Do major news events result in more people swapping to SCRT? :Look at the volume of swaps to SCRT over the past three months. Do periods of high volume swaps into SCRT line up with major international news events? Or is there a pattern in SCRT swap volume?
Stablecoin Pegs
May 13, 2022 - How have USD-pegged stablecoins across different chains, and with different backing mechanisms, fared through the last 5 days? Compare volume, peg stability, and any other metrics you think are relevant, and present a dashboard the summarizes your findings and conclusions.
How Relevant is Justin Sun?
May 3, 2022 - Justin Sun has recently announced an algorithmic stablecoin, USDD, with 30% yield. Sun has announced plans to backstop USDD with $10B of crypto as collateral, matching the Luna Foundation Guard (LFG). Do a deep dive, conduct research, and provide a well-researched conclusion to the burning questions: is Justin Sun for real? Is USDD likely to accrue significant backing? How will its 30% offering fare over time?
Active Addresses
Jun 6, 2022 - How many addresses on the MATIC network are active? What’s the daily evolution of active addresses? Is the activeness related some how to the price? Hint: Active address is an address that has done at least one transaction or has received at least once a token in the past 3 months. medium
Do the DOGE
Jan 22, 2022 - How many unique users have made a swap using the $DOGE-$RUNE pool?
New Addresses
May 30, 2022 - 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.
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. How many users have claimed the airdrop? Chart the STOI Song #3 airdrop token distribution by day.
Cosmic Champs Token Launch
Apr 30, 2022 - 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?
Governance Period 2 Payouts
Apr 14, 2022 - How many reward payments were sent? And what was the total amount of ALGO rewards paid out? How much time elapsed from the first to the last rewards payment? What wallet had the largest rewards payout and how much did they receive? Create a plot to show the distribution of rewards payouts.
Folks Finance: Minting gALGO3 For Governance
Apr 22, 2022 - 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?
Trending NFT Projects
Jun 12, 2022 - 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?
When Do Transactions Fail?
Jan 18, 2022 - Do times of high transaction volume lead to more transaction failures? Create a visualization that shows the relationship between transaction volume and success rate of transactions throughout the month of December. Are there any noticeable patterns to when transactions are more likely to fail?
Sablier Top 10 Users
Apr 21, 2022 - List 10 users who received the most funds and 10 users who sent the most funds through cash streams.
Tracking USDC & USDT on Solana
Jun 16, 2022 - What's the current market share for USDC and USDT on Solana relative to other stablecoins in the ecosystem (look into USDC, USDT, UXD, USDH, PAI, NIRV, UST, DAI, FRAX)? Create a visualization showing the amount of transaction volume for USDC vs. USDT etc. do display popularity within Solana. For USDC and USDT specifically, breakdown the transaction activity by contract and exchange flows (i.e. which dapps and addresses hold the majority of USDC and USDT and what do cumulative flows to and from exchanges look like over time)?
Rand Gallery NFT Sales
May 4, 2022 - Rand Gallery is one of the largest NFT marketplaces on Algorand. Let’s take a deeper look into rand gallery’s history and the performance of the marketplace. Show Daily NFT sale volume in # of sales, ALGOs, and USD over time. Show how much Rand Gallery has earned in fees daily and accumulated over time. -How many NFTs have been sold through Rand Gallery and what is the total -volume in ALGOs of NFT sales. What was the biggest NFT sale in both ALGOs and USD. What was the NFT?
Fuse Pool USDC Allocation
Mar 21, 2022 - How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
200K ALGO Donated Toward Tree Planting
Mar 9, 2022 - Show the donations to the wallet over time. Has the donation wallet sent any of the ALGOs anywhere? If so, what addresses have most of the ALGOs been sent to? Have any of the ALGOs been sent to a centralized exchange(CEX)? If so, how much?
"Small" LP Actions
Apr 12, 2022 - What percent of LP adds to each pool are small (<$1k USD)? Is there a relationship between the chain and the proportion of “small” LPs?
Stablecoin Popularity for Swaps
Apr 7, 2022 - Which stablecoin is more popular for a wallet to use in swaps(use algorand.swaps table): USDT, USDC, STBL? Compare volumes and number of swaps for each over the month of March 2022.
Hot Ball of Money (Solana NFTs)
Jun 15, 2022 - Compare Solana NFT sales activity on "new" collections to the activity on more established collections within the ecosystem. Has the trend been to buy into the hype or invest in builders for the long term? What do whales seem to be doing? Has it been more profitable to mint/buy these new hyped collections and flip them, or to invest long term into NFT collections?
Sushi rewards distribution
Apr 27, 2022 - How much in total has been distributed so far? (A daily chart could help too) How much is left to distribute today? What percentage of eligible addresses have not claimed anything so far? How many eligible addresses have not claimed anything so far? 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)
Let it burn!
Apr 24, 2022 - Find the week that the most volume of Luna burning happened. What caused this event? Show some effects of this burning had on Terra ecosystem by your opinion.
Algorand Unique Users(Addresses) Growth
Feb 6, 2022 - Chart how many unique wallets are added each day(Tip: Use the Account Table) Do we see an increase in wallets created during the governance commitment periods compared to non governance commitment times?
ALGO Transaction Payment Size
Mar 31, 2022 - Let’s look at the quantities of ALGOs being sent in transactions since January 1st 2022 to see if we see any upwards or downwards trends. Group the transactions(algorand.payment_transactions) by size 0-10ALGOs, 10-100ALGOs,100-1000ALGOS, 1,000-10,000ALGOs and 10,000+ ALGOs. Count the number of transaction in each size and chart them by day from January 1st 2022 to current. Do we see any trends of increasing or decreasing payment sizes? What might this indicate for the Algorand network?
Folks Finance Scavenger Hunt
May 19, 2022 - I have completed this Folks Finance Scavenger Hunt on May 18th 2022 and I enjoyed it!
MonkeDAO Vote
Apr 6, 2022 - Track the wallets that voted yes and no for the SMB proposal. What were people's voting preferences based on the number of SMBs that they owned? What have these wallets done with their SMBs since the voting? Was the nearly unanimous voting a bullish event? Have wallets that voted yes bought more monkes? Were those who voted no more likely to sell after the fact and on which marketplace? What percentage of all monke sales involved a selling wallet that voted at all?
DOGE-RUNE LP-ers
Feb 2, 2022 - How many of the THORChain wallets that added liquidity to the $DOGE-$RUNE pool were new (created on or after Jan 15th)? Of the existing wallets (created before Jan 15) that added liquidity to the $DOGE-$RUNE pool, how many of them withdrew liquidity from other pools before adding to the $DOGE-$RUNE pool?