Josh956
Weighted-Average LP Duration
May 9, 2022 - What is the average duration of liquidity held in each pool, weighted by the size of the LP?
Most Popular Gaming Tokens On Sushiswap
Jan 28, 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?
LUNA Staking and Trends
May 9, 2022 - Q203. Over the past 30/60/90 days and the past year, how much LUNA has been staked per day? What is the staking percentage (LUNA staked/Circulating Supply), and how has it changed over time?
Governance Reaction to Terra
May 25, 2022 - The period between May 8th - May 13th was a busy week for Osmosis governance. What was the community response like to these proposals? How quickly did these proposals hit quorum compared to the last two months of proposals? What was the voter turnout for these proposals vs the last two months of proposals?
AB2 Gallery Wallets
May 25, 2022 - Q78. Let’s look at wallets that buy from AB2 Gallery! How many wallets are buying NFTs on AB2 gallery. What is the total number of unique wallets that have purchased from AB2? Create a distribution plot of how many NFTs each wallet has purchased from AB2. Are we seeing new wallets purchasing on AB2 or is it only wallets that have purchased from AB2 before? Chart the first purchase on AB2 by wallet over time. Create a table of the top 10 wallets that are purchasing from AB2 by ALGOs and number of NFTs
Impacts of UST on STBL
May 19, 2022 - This week we saw the depeg of UST(a stablecoin built on Terra) and it sent shockwaves through all blockchain ecosystems causing the crypto market to crash. STBL is a 100% fully collateralized stablecoin created by the AlgoFi protocol. Let’s look at how the circulating supply of STBL was impacted by the events from May 8th to May 14th.
Standardized TVL Over Time (1 Pool)
Apr 24, 2022 - Select one pool of your choice and show the total number of asset tokens (non-RUNE tokens) in that pool over time.
Aave Arc Analysis
Sep 1, 2021 - This paper describes the features and outlook of Aave's Arc protocol
Sushiswap Sizes
Feb 6, 2022 - Show the daily average swap size over time for the 10 largest liquidity pools (in terms of value locked). How has this swap size changed over time? Why might this be?
Binance Bonanza
Nov 2, 2022 - On October 28th, 2022 Binance became the first CEX to list spot trading for $OSMO. Abruptly, OSMO price shot up around 32%. How did this news impact trading on Osmosis. Analyze OSMO trading activity on October 28th and this past week vs. daily & weekly averages. This analysis should occur against two time periods: the 60-day averages & the 60-days prior to the May Terra collapse. Did any other tokens see a spike in trading on Osmosis?
Social Trends in NEAR- why the limited activity?
Mar 2, 2023 - Near Social appears to have fairly limited activity- this dashboard will explain why
L1 Unique users
Mar 12, 2022 - Question 37: Compare the number of unique wallets that have sent a transaction since February 1st on Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Solana compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks?
Bot Activity
May 16, 2022 - Create a way of identifying bots within THORChain (could be something like a certain number of swaps / day made). What % of the swaps and swap volume are made by bots? Are there certain strategies you can see them employing (most of them are likely arbitrage bots)? Are there many bots or mainly just a few that conduct a high % of bot activity?
Flipside's World Cup of Bounties Side Quest: LaLiga Golazos
Dec 6, 2022 - For this round, create an analysis looking at LaLiga’s first few weeks of action, comparing against the first few weeks of other Flow darlings like NBA TopShot & NFL All Day, as well as Algorand’s FIFA Collect+.
stETH Most Common Pools
Apr 22, 2022 - Use the ethereum_core tables to determine the pools most commonly used to swap in and out of stETH. What are the most common pairs? Which pools are most often used?
Market Volatility
May 25, 2022 - The second week of May saw some huge volatility in the market and prompted many to sell their volatile assets and take a flight to safety. What did the volume look like in decentralized exchanges on ethereum during that period? Which assets were being sold/bought the most?
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.
Forefront Curators
Apr 15, 2022 - Q2. Forefront has token-permissioned governance and curation channels that require holders owning at least 1000 FF tokens. Create a visualization of the number of curator roles in Forefront over time. Are more curators being added over time? In your own words, how could Forefront incentivize growth in curator roles?
Trend Analysis
Apr 5, 2022 - Q63. Analyze the trend of active users and number of swaps for sushiswap and draw a comparison with Uniswap. Describe the trends that you see
$RUNE Price vs Swapping Volume
Jan 21, 2022 - How does the transaction volume of Rune correlate to it's price?
More Mints
Apr 18, 2022 - Q56. Metaplex is an open source protocol that allows for the creation and minting of NFTs using a standardized format across wallets and applications. It is essentially the backbone architecture for Solana NFTs. How many NFTs have been minted over the past week? Since the beginning December, how many NFTs have been minted per week? Chart the growth of unique purchasers over time. What percentage of all mints have been via Metaplex's Candy Machine?
The Flippining
Jan 15, 2023 - It finally happened. The great Flip everyone’s been waiting for — Optimism and Arbitrum have officially surpassed Ethereum in combined transaction volume. (What, you were expecting some other flippening?) Use this historic event to compare and contrast these two major L2 chains. Include metrics such as total and average transaction volume, average transaction size, active users, new users added, and anything else you find relevant to this comparison.
Realized APY
May 16, 2022 - Visualize the realized APY of LP-ers that have removed liquidity from THORChain. What was their actual APY vs HODL (accounting for impermanent loss) when you pro-rate it for how long they were LP-ing for? Are certain pools out-performing others?
Sushibar Servings
Apr 18, 2022 - Q66. Draw charts showing sushi tokens transferred to the Sushibar. Do it at different frequencies and describe the trends if any.
Contractually Obligated
Mar 9, 2022 - 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!
SOL Swaps on Jupiter
Feb 17, 2022 - Since January 1st, how much SOL has been swapped for other tokens using Jupiter per day? Over the same time period, how much SOL has added from swaps using Jupiter per day? Create a visualization showing the flow of SOL from swaps on Jupiter since January 1st per day and provide insights around any spikes you see.
NEAR - 7. Weekly Report - Redux
Jan 16, 2023 - Each week, the NEAR Foundation publishes data to help the NEAR community understand the ecosystem's health as part of their Transparency Report. We want your help in making the NEAR ecosystem even more transparent. How can you improve on the existing NEAR Transparency report? Explain which metrics should be taken into consideration and why. Then, analyze those metrics over the last several weeks and draw your own conclusions on the health of the NEAR ecosystem.