banbannard
Miso's Competitive Advantage
Apr 18, 2022 - Create a visual document outlining the below facts about Miso, the new addition to the Sushi menu
Solana NFT Growth
Apr 27, 2022 - -Total mints and growth rates of mints over time -Total NFT sales and growth rates of sales over time -Total unique wallets that have minted or purchased a Solana NFT and growth rates over time -Total Unique Signers of Metaplex programs -Total minters of NFTs using Candy Machine V1 and total minters of NFTs using Candy Machine V2 -Total users of Metaplex's Auction House program Compare these metrics with NFT activity on Ethereum. How do the two chains compare and how are they trending?
IL Insurance
Apr 12, 2022 - What % of users that are removing liquidity are receiving IL insurance?
Pact.fi LP Pool Actions
Apr 30, 2022 - Show us total mints and burns by day across all pools. What are the most popular pools wallets are minting LP for? Do we see an increase in mints in the ALGO/GOMint, ALGO/GoBTC, and ALGO/GoETH pools from the AlgoMint incentive? Folks Finance is offering incentive in the ALGO/GoETH starting on April 8th, do we see an increase in mints in this pool from the incentive? Are there any notable days of for an increase of mints? What pool is causing that increase if there is and is there an event tied to the increase?
Bot Activity by Aff
Aug 29, 2022 - [UPDATED DAILY] This dashboard shows the bot activity on Thorchain affiliates
Transactions on Wormhole
Jan 9, 2022 - Assess transaction size & volume of transactions on Wormhole. Define a number of buckets, e.g. Minnow, Fish, Whale, and group the transactions into them. How many transactions are in each bucket?
AlgoFi's AlgoVault Governance Period 3
Apr 23, 2022 - What is the current total amount of ALGOs in AlgoFis AlgoVault?(Look at all the wallets that are created via the AlgoVault then use the algorand.account table to calculate total balance) What percent of the AlgoVault Wallets have committed to governance? What percent of the ALGOs in the AlgoVault have been committed to the How much have they committed? Show the algoVault wallets governance commitment by number of wallets and amount of ALGOs over time.
Let's Learn Arbitrum!
Aug 17, 2022 - Let's learn Arbitrum from bridging and how it compares to its competitor!
Do Whales Have Diamond Hands?
Jun 19, 2022 - Does the swap behavior of OSMO whales differ from everyday users? How does it differ? Create visuals showing what whales swap to and from compared to a normal Osmosis user.
Discovering Polygon
Jul 31, 2022 - Let's learn about Polygon together by looking at some Polygon data and statistics!
In The Stars
May 30, 2022 - Stargaze Zone is an IBC NFT launchpad and marketplace, and new launchpad projects drop on mint every Friday at 4:00 PM EST. Does the volume of swaps involving Stars change around this time? Analyze the volume of swaps involving STARS from March 20th until present.
Sablier Cash Streams
Apr 21, 2022 - Out of all streams of cash created on Sablier, how many have been cancelled before their stop time?
Stablecoin Popularity
Feb 2, 2022 - Create a visualization comparing USDC, USDT, and UST (wormhole) usage in transactions throughout the month of January. Has UST seen more adoption in the Solana ecosystem this month? How do you expect this trend to continue? Why?
SOL Staker Activity
Apr 11, 2022 - How frequently are SOL stakers interacting with DeFi protocols over the past month? Which protocols are they interacting most with? Which actions are they mostly taking? Staking? Farming? Swapping? Mining?
Block Rewards vs Swap Fees
Apr 24, 2022 - Breakdown the yield from block rewards vs swap fees, both total and by pool. Show how the proportions have changed over time since the network started.
Fault Tolerant Staking
Apr 10, 2022 - Define Fault Tolerant Staking (FTS). What are the advantages of FTS? What are the disadvantages? Explain what problems FTS might help solve.
Lockdrops Keep Fallin' On My Head
Jan 23, 2022 - Explain, in your own words, what a “lockdrop” is. Choose a metric for ASTRO tokens (price, circulating supply, amount sold vs. HODL) and display it visually over a time period of your choosing.
Algorand Governance Period 2 Voting
Mar 9, 2022 - Show wallet votes over time Which had more individual wallet votes, A or B? Show the voting result(A vs B) based on the ALGOs committed by wallets for this governance period.
Acquiring goBTC and goETH
Apr 7, 2022 - Where are users acquiring goBTC and goETH? Are they acquiring the assets by swapping or by minting? Has this changed over time? Explain the insights you find.
Most Popular Jupiter Swaps
Feb 26, 2022 - Since February 1st, what have been the 10 most popular tokens to swap away? Over that same timeframe, what have been the 10 most popular tokens to swap for? What are the 10 most popular swapping pairs (combination of swap away to swap for)? Define 'popular' as the number of swaps and create a visualization showing total number of swaps over that time frame, highlighting these most popular tokens.
Collateral Impact
Jan 15, 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?
Algorand Assets Using Account Asset Table
Feb 3, 2022 - Lets explore the Account Asset Table and look at popular ASAs(assets) being held in the Algorand ecosystem: Using the Account Assets Table what are currently the top 10 most popular assets to hold outside of Algos?(Do not include any assets that include Pending Props in the name) For these top 10 assets lets map when they were added to users wallets over time? Create wallet holding distribution charts for 3 of the biggest projects in the Algorand Ecosystem: Yieldly, Opulus, SmileCoin.
IL Protection By Pool
May 14, 2022 - Which pools have paid out the most IL protection in the last week? Month?
Sushiswap DEX Loyal Users
May 9, 2022 - Rank wallets that used SushiSwap based on the number of trades and number of days they used the DEX. How many users keep coming back to the platform ? Use different frequencies for the ranking : Last month, Year to date and since inception
MonkeDAO Whale Voters
Apr 13, 2022 - Break down the voting behavior for the first three proposals by the following number of monkes per wallet (1 SMB, 2-3 SMBs, 4+ SMBs). Are there any patterns that you see based on number of SMBs used to vote in a wallet? Why do you think ""whales"" voted the way that they did?
Magic Eden Whales
Apr 12, 2022 - Track the top 20 wallets in terms of buying volume on Magic Eden since March 1st. What have these wallets been buying the most over that time period? As in, which collections seem to have their attention? Do these wallets tend to ""sweep"" (buy a lot of the same collection at once) or patiently buy collections? How often are these wallets buying NFTs and what does their profit look like?
AlgoMint goMint Token Release
May 4, 2022 - Show us the volume of ALGOs swapped for goMint by day on each DEX since the token release Show us the number of swaps and the number of wallets by day by DEX for goMINT/algo swaps in the first week of the token release. In the first 24 hours of the token release- chart the average swap price in ALGOs for goMint across each DEX(AlgoFi Tinyman Pact). Do we see a higher average price for goMint on any of the DEXes? Note any other interesting findings between the DEXes related to the release of the goMint and the goMint/algopools, such as volume, number of swaps, or number of wallets swapping.
Smart Money NFT Traders
Jun 7, 2022 - Which wallets have made the most SOL off NFT mints and NFT trades since the start of the new year? What types of actions have led to being a profitable NFT trader on SOL? Is there a pattern behind their NFT trading strategy and can you define some of these traders as "smart money"? Do you think you need to be a "whale" to do well trading SOL NFTs, or can anyone have success in this market?
Sablier TVL
Apr 21, 2022 - What is the total value locked in Sablier and by how many users?
Most Popular ASA To Swap From ALGOs
Apr 14, 2022 - Create a bar chart visualization of the top 10 ASAs by total ALGO swap volume. (Tip: This means we want to look at swaps where the wallet is sending in ALGOs(asset ID: 0) and receiving another asset in return. The volume would in ALGOs would be the sum of all the ALGOs wallets sent in to receiver the asset). Create a table for the top 10 ASAs found in part 1. In this table, list the ALGO swap volume and the average amount of ALGOs involved in a swap. Create a time series chart to look at the number of swaps (from ALGOs) to each of these 10 ASAs over time by day since the beginning of 2022. Note any trends on the increasing or decreasing popularity of any of the ASAs.