banbannard
aUST Analysis
Dec 20, 2021 - Provide an analysis of aUST usage in the past 80 days. Employ at least two metrics of your choice and at least one data visualization. What opportunities do you see for aUST to add value to the Terra ecosystem?
$RUNE Distribution
Apr 24, 2022 - Calculate the distribution of $RUNE holdings by address. Include RUNE that is in liquidity pools. (e.g. if I have 100 $RUNE in my wallet and LP 50, I should still be considered to be holding 100).
Transaction Fees
Feb 3, 2022 - All transactions on Algorand have a transaction fee of .001 but lets dive a little deeper into fees generated on Algorand. What is the total amount of fees generated on Algorand since the first block? Plot fees generated over time by day on Algorand since the beginning of 2021. Create a table of the top 10 wallets that have generated the most amount of fees in 2022. List both number of transactions and fees of the wallets. Using the asset transfers table, what are the top 10 assets besides Algos that have generate the most fees?
Friktion Bitcoin Volt
Mar 19, 2022 - Provide some insight on how this type of strategy works. For users that have deposited BTC into the Friktion BTC Covered Call Volt since January 28th (Epoch 6), what other DeFi protocols have those wallets interacted with? How many unique wallets have deposited into this BTC Volt and list the top 10 wallets in terms of amount deposited since Epoch 6. Has the Volt become more popular over time for "whales" or the average Solana wallet?
Flipside Crypto: Nouns DAO
Jun 8, 2022 - Part 1: Analyze the mint and secondary NFT marketplace activity for Nouns DAO. Can we conclude if there are certain types of traits (body, accessory, etc.) that are causing some Nouns to sell or mint for more than others? Part 2: Who is typically settling Nouns auctions? Does the winner settle the auction, or does an eager new bidder settle the current auction to begin the next auction?
MIM + Anchor
Feb 9, 2022 - How much of the current deposits to Anchor Protocol’s Earn product are from the MIM Degenbox Strategy? How has this changed over the past 30 days ? What would be the implications of Disabling MIM Degenbox Strategy? Could Anchor limit the MIM Degenbox Strategy to a certain percentage of deposits?
Top Pool Analytics
Jan 10, 2022 - For the top 10 Sushi liquidity pairs (by liquidity) show the following: liquidity, 24 hour volume, 7 day volume, 24 hour fees, 7 day fees, and one year fees as a percentage.
Onboarding with Solana NFTs
Jun 15, 2022 - It has been said that Solana NFTs have become a powerful onboarding tool into the Solana ecosystem. Is this narrative true? Which NFTs have captured the most first time users of the Solana blockchain? What kinds of activities do these wallets tend to do after buying their first NFT? Do you think the NFT growth on Solana will spill over into Defi?
Contractually Obligated
Mar 8, 2022 - Based on your analysis for #161, provide the top 20 smart contract addresses that users interact with or the top 2 smart contract addresses per each of the protocols that you previously analyzed. Grand prize-winning submissions will assess both!
What Happens After A Withdrawal?
Feb 7, 2022 - Create a visualization showing net deposits vs withdraws into Ribbon pools over time. When a wallet withdraws their liquidity from an option strategy, what do they do with that liquidity? How often does a wallet deposit their liquidity into a different Ribbon pool after withdrawing from a vault (as their next transaction)? Which vault has seen the greatest inflow of deposits from another vault?
StepN Growth
Feb 26, 2022 - Create a visualization showing the number of unique wallets that have transacted with GST by day since January 1st. How much total GST has been transacted per day since January 1st? Provide some insights over the adoption of GST and how long it can accommodate its limitless supply as an in-game token.
GMT Airdrop
Mar 20, 2022 - Create a graphic showing the wallets that received the GMT airdrop and highlight the top recipients of the airdrop. What have recipients done with the airdrop? Are these "trailblazers" holding their airdrop or are they selling? Have the top recipients been more or less likely to hold onto their tokens?
Solana Outages
Jun 7, 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?
Mango Market Flows
May 10, 2022 - Track Exchange wallet flows and volume in and out of Mango Markets. Generate a daily aggregate of how the following venues exchange value with Mango Markets and also between each other on the Solana blockchain. Is FTX a central source of capital flowing into Mango? From what protocols does capital seem to be flowing into Mango programs? Where do users send assets to after using Mango Markets? Limit the analysis since the month of March.
Is 2 Really Better than 1? (A Comparison Between Optimism and Ethereum)
Aug 4, 2022 - Lets compare the differences between Layer 1 (Ethereum) and Layer 2 (Optimism)!
Bridger Destinations
Aug 1, 2022 - Lets explore what protocols and actions users interact with and perform after bridging from Ethereum to Polygon!
Osmo Staking
May 29, 2022 - Over the past 30/60/90 days and since June 2021, how much OSMO has been staked per day? What is the staking percentage (OSMO staked vs. circulating supply) and how has it changed over time?
Sushi Reward Program for Farmers
May 4, 2022 - How much in total has been distributed so far? How much is left to distribute? What percentage of eligible addresses have not claimed anything so far? What percentage have totally claimed their rewards? What percentage have partially claimed their rewards? 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)
Fuse Pool Analysis
May 23, 2022 - Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? What differences can you identify?
Top Kashi Pairs III
May 25, 2022 - Find the top 5 kashi pairs based on: A- The number of loans they have generated B- The total available for lending (in USD) C- Total collateral deposited (in USD)
Bridgesplit and MonkeDAO's DAOJONES
Feb 21, 2022 - Create a chart showing daily transaction volume and the number of distinct wallets that transacted with DAOJONES. When was the peak amount of trading volume and seemingly ""hype"" around DAOJONES? What was the most amount of distinct wallets that made a transaction with DAOJONES in a day? Provides some insights around why these numbers peaked when they did.
Common LP Pairs
Jan 8, 2022 - Of Rune wallet addresses providing liquidity in 2+ pools, what are the most common combinations?
Fun Facts of Tensor! 🎉
Jul 13, 2023 - All Tensor data in this dashboard is as of July 16th, 2023. If you find this dashboard helpful, please leave a ❤️ to show your support!
Top Kashi Pairs
May 16, 2022 - Find the top 5 Kashi pairs on Ethereum based on TVL. Choose one that you like and describe the following information: How many people are borrowing on this pair at the moment ? How much collateral has each user added to the pair? How many users have already partially paid their loans?
GMT and SOL into StepN
May 5, 2022 - GMT is the governance token for StepN that will provide holders with a share of all fees earned within the app. However, recently StepN has made some changes to require using GMT in the game mechanics itself to give it additional utility and incentivize burning of the supply. Currently, the only way acquire GMT is by trading for it (you can not currently earn it in the game, this will change soon). Track the flow of GMT into the app. How are users acquiring GMT? Is by swapping using a DEX like Jupiter, or do flows seem to be coming from centralized exchanges? How often is GST (the token earned in the game) swapped for GMT? What other actions are wallets that are sending GMT into the app doing? Additionally, where do SOL inflows into the app seem to be coming from? Does it seem like most StepN users were already active within the Solana ecosystem, or is there a lot of activity that originated from inflows from centralized exchanges? Essentially, is StepN onboarding users into Solana? Create visualizations showing these inflows of GMT and SOL into the StepN app and if the announcement of Coinbase adding StepN to their list of tokens sparked additional interest from sources outside of the Solana ecosystem."
Transaction Failure
Mar 20, 2022 - Establish the failed transaction rate for Terra over a time period of your choosing. Is this analysis correct? Additionally, make a case for what is causing the failure transaction rate you assess, and provide recommendations to mitigate it.
DEX Performance Dashboard
Nov 5, 2023 - This dashboard helps in the understanding of the DEX landscape, allowing for more informed decision-making and a deeper understanding of decentralised finance trends and opportunities.
Weigh Anchor (Users)
Jan 9, 2022 - Who are the top users (by address) of Anchor Protocol? Are they retail investors or protocol/enterprise users? Whales or small fry?
Solana Flash Bounty: Saga
Jun 24, 2022 - How many wallets have pre ordered Saga (the new solana phone) so far? Note: the preorder is a NFT purchase on-chain. Who is preordering the phone? Provide a breakdown of the type of wallets ordering so far. Example metrics to investigate: what other programs are these wallets interacting with, how active have these wallets been on Solana, are they average users or whales?
Who's That Going Across My Bridge (Redux)
Apr 19, 2022 - Pick one bridge from Terra and a destination of your choice. (e.g. Shuttle bridge Terra <-> Ethereum or Wormhole Terra <-> Solana). Assess the daily and cumulative amount of UST that goes through that bridge, both inflow and outflow. How many users are using the bridge on a daily basis? How many transactions take place on a daily basis?
New NFT Mints
May 16, 2022 - How many total new NFT projects have appeared on Magic Eden per day since the start of the new year (as in new projects that have minted that day)? Compare that to the total number of new NFT projects that were minted/created on Ethereum? Create a dashboard comparing the growth rates of the number of new NFT projects on Solana and Ethereum and understanding the amount of sales activity on ""new projects"" for each chain.