banbannard
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?
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?
$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).
Active Daily Wallets
Mar 2, 2022 - Let's look at daily active addresses on Algorand. -Compare the number of active daily wallets for the month of January 2022 to December 2021 and January 2021. What day had the most active number of wallets in January 2022? Was there an event on Algorand associated with this date?
Katana wLUNA Pool
Feb 20, 2022 - Create a chart showing the amount of Katana WLUNA Covered Call Vault Shares claimed since February 4th and the number of unique wallets that have claimed shares. What is the average size claim? Does it seem that the wLUNA vault is mainly used by "whales"?
Moonbirds Crossovers
May 3, 2022 - Are there any notable cross overs between the Moon Birds community and other communities? How many holders also have BAYC, Doodles, etc
Price Status Quo
Jan 31, 2022 - Does the price of the Sushi token tend to follow the trend of the rest of the market? Does the price follow the trend of the rest of the DEXs? Why or why not might this be?
Algorand Blockchain Block Performance
Jan 17, 2022 - Let's take a deeper dive into Algorand's blockchain performance! First, let's look at block times: What’s the average time between block and how has this changed over time What’s the max recorded time between two blocks? What’s the minimum recorded time between blocks? Next, let's look at block size: How many transactions did the biggest block have? And what was the make up of this block(i.e. what type of transactions did it contain?)? Has the number of transactions per block increased as network adoption increased(Chart the number of transactions per block over time)?"
Al Goannas
May 26, 2022 - Al Goanna is Algorand’s premier bluechip NFT with a collection of 489 original NFTs. Let’s take a look at the collection. Show the number of Al Goanna’s each wallet holds. Show the amount of fees Al Goanna sales have generated for the DAO over time. Show Al Goanna sales and ALGO volume over time. Show the distribution of ALGO balances of Al Goanna holders
Flipside's World Cup of Bounties Side Quest: Fifa+ Collect Collection Scorecard
Nov 15, 2022
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?
Sushi and Uni Gas
Jan 31, 2022 - Compare the daily ETH gas fees on Sushiswap over the past 2 months to those on Uniswap. Show the average gas fee per transaction as well as total gas fees collected.
Looking For Swap Arbitrage
Mar 31, 2022 - Let’s see if we can find any wallets profiting from arbitrage on the Algorand DEXes. We specifically want to see if anyone is conducting arbitrage with USDT or USDC, Asset ID 31566704 or 312769. The period we will want to look at is From January 1st 2022 to current. We will want to grab wallets swapping USDC or USDT to another asset then their next swap being back out of that other asset(with the same amount of it) back to USDT or USDC in their next transaction. If we find a wallets conducting this behavior, let’s look if they end up with more USDT or USDC they started with in the initial swap. If we find users doing this, let's look at the top 10 wallets successfully earning more USDT or USDC. What assets do we see them swapping for when they commit this arbitrage? Show and explain your methodology if we don't see this arbitrage occurring.
Unique Programs
Feb 12, 2022 - One way to track developer growth in an ecosystem is through the number of unique contracts used. Create a visualization of the number of unique programs used per day since the beginning of January. What are the 5 most commonly used programs over that timeframe? What do those programs do and why do you think they are so popular?
34. - Gaming Tokens
Feb 2, 2022 - Find the 5 largest crypto gaming tokens on Sushiswap. How did volume on Sushiswap get impacted when each of these tokens got added to the protocol? What tokens are most often used to exchange into new gaming crypto tokens?
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?
New Users on Algorand vs. Ethereum vs. Solana vs. Terra
May 4, 2022 - Algorand, Ethereum, Solana and Terra What trends do you see?
UST Competitive Advantages
May 3, 2022 - Why would a user choose to transact using UST over DAI (and vice versa)?
Total Metamask Users
Jun 24, 2022 - How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher order activity, like staking?
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?
Tinyman Pool Health Score Card
Jun 9, 2022 - Create a dashboard/table that lists the Tinyman pools and a composite score illustrating the health of each active Tinyman pool. This score should help the public understand the health composition of the pool and whether or not its safe to create an LP for. Possible factors to be included in the score number of wallets holding Pool LP tokens, the number of mints/burns for the pool, the percentage of LP tokens held by wallets, the percentage of tokens involved in the LP held by the wallets, etc. Detail the methodology you used and the factors that go into your score. The table should include the overall score and metrics that attributed to the score so the public can understand how each pool score is calculated!
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.
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?
Folks Finance TVL
Jun 30, 2022 - Calculate the TVL on Folks Finance- broken out by deposited and borrowed. Use their markets/total deposited page(https://app.folks.finance/markets), their homepage(https://folks.finance/), and contracts(https://docs.folks.finance/developer/contracts) to guide your analysis. Note any interesting findings about major TVL shifts or anything else you find/
LP-er Retention
Apr 24, 2022 - Take a look at thorchain addresses that have ever added liquidity. Group them by the month of their first date of adding liquidity. What % are still providing liquidity in the THORChain ecosystem? How does it look if you filter those that provided at least $10,000 in liquidity?
Proof-of-Work on Ethereum
Sep 9, 2022 - We will explore Ethereum miners and their transaction count per mined block in this dashboard
THOR-versary!
Apr 19, 2022 - THORChain Chaosnet just hit its 1-year anniversary. Calculate the following metrics, comparing THORChain in its first 30 days vs the last 30 days: total number of swaps, volume of swaps (in USD), TVL, # of pools, # of chains. Feel free to add any other metrics you feel would be interesting / relevant.
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?
Synth Utilization
Apr 13, 2022 - Calculate the synth_utilisation of each pool and chart over time.
Staking Yield, Mvmt 1: The Basics
Jan 16, 2022 - Explain in your own words (i.e. don't copy the documentations) how Terra's staking yield is calculated. Provide a graph that compares LUNA staking yield to LUNA price over a time period that you define.