banbannard
Have staking rewards impacted the amount of $RUNE bonded or in LPs?
May 22, 2022 - Chart an analysis on Staking 2.0’s effect on the pendulum incentive. Have there been meaningful impacts?
Flow vs Other L1s
Jun 20, 2022 - How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum
Flipside's World Cup of Bounties Side Quest: Fifa+ Collect Collection Scorecard
Nov 15, 2022
Flipside GodMode NFT
Jun 8, 2022 - This dashboard will go through Ethereum profile of those who minted during the first hour after GodMode's launch
UST Competitive Advantages
May 3, 2022 - Why would a user choose to transact using UST over DAI (and vice versa)?
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?
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!
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
Algorand Stablecoin Popularity USDC vs USDT
Feb 8, 2022 - What’s the number of people who currently hold USDC vs USDT (Tip: Use the Account asset table) Create a time series chart counting the number of transactions a day for each stablecoin(Tip: Use the asset_transfer_transaction table) Create 1 chart for each stablecoin visualizing the current distribution of holders. 3a. Does one have a better distribution than the other? If so, explain why.
⚡ Streaming Swaps
Aug 11, 2023 - An Overview of Streaming Swaps on THORChain. If you find this dashboard helpful, please leave a ❤️ to show your support!
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?
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)!
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?
$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).
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?
Cross-chain Anchor
Mar 26, 2022 - Compare the Earn sides of Anchor protocol on Terra vs. Avalanche. What does the Earn side look like on Avalanche? In the last week, are people using it more? Is there more volume?
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?
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?
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?
Liquidity and Volume
Jan 16, 2022 - For the past 30 days show the following: daily liquidity on Sushiswap and daily volume on Sushiswap. Which pools are contributing the most to each of these metrics?
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.
Common LP Pairs
Jan 8, 2022 - Of Rune wallet addresses providing liquidity in 2+ pools, what are the most common combinations?
Aurory Expeditions
May 9, 2022 - Since Expeditions launched on April 17th, how many unique Aurorians have been staked? Do these expeditions seem to be more popular for ""fish"" or for ""whales""? Based on the rewards structures of the different expeditions, why do you think that is? How many Aurorians that were sent on an expedition were then sold after their return?