banbannard
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?
xSushi vs Meowshi
Feb 28, 2022 - How many/what percentage of xSushi holders have interacted with the Bentobox to obtain Meowshi and further improve their gain? What is the total volume?
Solana TPS
Feb 22, 2022 - One of Solana's main features is its speed compared to other blockchains. Blockchain performance is usually measured in Transactions per Second (TPS). Measure the TPS of Solana in February (non votes) and 'Successful TPS' per day and create a chart showing how TPS has fluctuated during that time period.
ETH Staked
Apr 4, 2022 - What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
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!
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?
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?
Kashi TVL
Apr 11, 2022 - What is the Total Value Locked (TVL) by liquidity pool on Kashi? draw a weekly chart for 2022. what are the top 10 pools?
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?
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?
Astroport Rewards Analysis
Apr 15, 2022 - How much ASTRO is allocated for rewards? What percent is currently being used and how is this changing over time?
Swap Volume vs. LP Rewards
May 1, 2022 - Chart the weekly swap volume and LP rewards on the same chart. What is the relationship between the two?
Facts_Lending
Mar 12, 2022 - Build a query for a fact table about sushi's lending activity on Polygon. What questions does your table answer(At least Two questions)? What other dimensions could potentially be extracted from sushi contracts and added to this table to make it more valuable?
Active Wallet Addresses
Jun 19, 2022 - We are interested in knowing how many users are currently in the ecosystem. In this case, how many are holding $RUNE in their wallet or have an open LP position. What is this number currently, and how has it trended over time?
Content Bounty: Terra -> Osmosis
May 23, 2022 - Are Terra projects interested in migrating over to Osmosis? What is most important to Terra developers when looking for a chain to migrate to and why might Osmosis be a good choice?
P2P NFT Lending with Yawww
May 10, 2022 - Which wallets have been most active in Yawww in terms of lending and in borrowing? Which NFTs have been the most involved in these lending agreements since Yawww has launched? What percentage of these loans have been paid back so far?
Impact of Terra integration on new wallets created
Apr 16, 2022 - Show the daily number of new Thorchain wallets created in the 10 days prior to and after the integration of LUNA and UST.
Proof-of-Work on Ethereum
Sep 9, 2022 - We will explore Ethereum miners and their transaction count per mined block in this dashboard
Impact of Adding New Chains/Tokens
Jan 15, 2022 - THORChain is planning on adding support for Dogecoin soon. Traditionally, what has been the impact of adding another chain (or token) on THORChain? Does swapping activity or THORChain wallet creation spike up?
Stability Fee
May 15, 2022 - How impactful is the stability fee (the interest rate) on DAI loans in terms of the impact on volume and dollar amount of loans taken out? How does activity with DAI tokens change when the stability fee is different?
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)
Solana Competitive Advantages
May 1, 2022 - Why would a developer and / or a user choose Solana over Ethereum (and vice versa)?
Seasonality
Mar 13, 2022 - Is it true that the average gas fee paid by users is lower during festive seasons? Choose two festive seasons in 2021 to put this claim to the test! What else can we say about the festive seasons?
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.
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.