Ramahar
Sushi and Uni Gas
Feb 3, 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.
How Impactful is NEAR contract to the ecosystem?
Mar 20, 2023 - NEAR is a dynamic ecosystem where new protocols are introduced on a regular basis. Which of the new contracts that were introduced at the end of 2022 and in 2023 are gaining more users and expanding the NEAR ecosystem.
Where’s The Pot of Gold?
Mar 20, 2022 - What % of the bAsset market cap for bLUNA and bETH is locked as collateral on Anchor? Show where else bLUNA/bETH is being held, and explain why you think this is.
$THOR Staking Reward + APY
May 22, 2022 - Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards. Show the daily / weekly staking rewards and calculate the daily / weekly APR for $THOR stakers. How has it progressed since staking was introduced?
Holder Behaviors
Jun 1, 2022 - Explore the behavior of top 5 LDO holders. Include: LDO balances and history Typical actions with LDO
Osmosis - 20. OSMO on Coinbase
Jun 3, 2023 - Measure the impact that OSMO’s listing on Coinbase had on token price, trading on DEXs and overall liquidity on Osmosis.
Ethereum USDC-WETH pools on Uniswap-v3
Apr 26, 2023 - This dashboard showcases the generic analysis of USDC-WETH pools in Uniswap-v3. It includes several important metrics: such as users, transactions, and $USD volume. It provides the flexibility to view other USDC-WETH pools using similar metrics. The reader is able to grab the relationship between the $ETH token price and activity on USDC-WETH pools.
Liquid Staking ETH Platforms Analysis
Sep 3, 2022 - Consider all possible liquid staking ETH platforms. Then, find out the following: How much ETH was staked over time?
Transaction Fees
May 24, 2022 - How many transaction fees are being paid out each day for the past 30 days? Does a certain type of transaction result in a greater amount of fees being collected?
Metamask vs. Other Platforms
Jun 25, 2022 - Q3. How many users are swapping via MetaMask vs other platforms? How much volume have these users done? Chart a comparison between the two, and show the following metrics over a time period of your choosing: transaction volume, average amount swapped, and a comparison of fees.
It's Raining $RUNE!
Jan 15, 2022 - This dashboard is showing which node operators receiving the most rewards.
Deposit rate from L1s
Jun 12, 2022 - Q105. Look at users swapping from native L1 assets to $RUNE. Are there any trends by chain or over time?
stETH vs ETH
Jun 7, 2022 - Q2. How has the price of stETH compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
Solend SOL Lending/Borrowing
Feb 15, 2022 - Solend is the leading lending and borrowing protocol on Solana. Since February 5th, how much SOL has been supplied by lenders? How much SOL has been borrowed? Are there any noticeable trends in the net flows during this time? Provide insights and a visualization on the day-to-day trends of SOL and lending vs borrowing. How many SOL withdrawals and repayments happened during that timeframe on Solend? (Hint do small txs on Solend to identify the accounts you need)
Market Module
Apr 4, 2022 - Explain in your own words what Terra’s “market module” is, and how it functions. Define at least two key metrics for the market module, and demonstrate how it’s performing in its stated goals based on these metrics.
Velodrome Health
Aug 14, 2022 - Create at least 5 metrics on Velodrome with a description for each that showcase traction and success in a data-driven manner.
39. ETH.RUNE upgrades vs BNB.RUNE upgrades
Jan 8, 2022 - This dashboard is showing the overall ratio between ETH.RUNE upgrades vs BNB.RUNE upgrades. It also shows the daily ETH.RUNE upgrades vs BNB.RUNE upgrades over the time.
Redemption Arc
Apr 6, 2022 - Explore the limitations of redemption on Terra, i.e. the burn and mint mechanism. In what scenarios would the ability to burn & mint be insufficient for demand? Using data, illustrate occasions where these scenarios have occurred or come close to occuring. There are a number of ways to do this; one approach is to quantify a “Redemption Utilization”, i.e. a performance metric that encapsulates the extent to which demand for redemptions outstrips or comes close to the programmed caps, and then to explore the number of days over a specified time period that this metric has crossed a concerning threshold.
Bot Activity
May 14, 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?
Osmosis Governance: 362 and Beyond
Nov 23, 2022 - Governance in the Cosmos ecosystem has been a hot topic of late - first with Cosmos Hub 82 and now in Osmosis. Osmosis Prop 362 is a vote to decide the fate of the Osmosis Grants Program (OGP). Contention aside, there have been many points and counterpoints, AND a ton of vote switching.
RUNE Distribution
Apr 25, 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). In terms of charts, feel free to create a histogram or whichever visual you think works best!
Solana Protocol Feature
Jul 12, 2022 - Q97. Choose a defi protocol from the following list and create a dashboard with the new Flipside layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the protocol and what is happening on it.
Squid Axelar : New Kid On The Block
Feb 22, 2023 - Axelar’s General Message Passing primitive has been live for a long time; however, the launch of Squid Protocol has brought GMP into the spotlight. Now, users can swap any token on their source chain for any token on their desired destination chain, with on-click of a button. How has this frictionless experience impacted Axelar’s token transfer volume via their native bridge Satellite? Analyze user growth for Squid vs. Satellite since Squid’s launch on Flipside supported chains (Ethereum, Avalanche, Binance, Polygon). Have Satellite’s DAUs remained loyal, or are they transitioning to Squid for their cross-chain transfers? Or are the users different? Provide a user segmentation analysis of Squid.
Outbound Traffic
Mar 15, 2022 - The Terra Bridge has expanded its capabilities: https://twitter.com/Speicherx/status/1501883479457288193 Create a dashboard to track the outflows of LUNA and UST to Osmosis, Secret, Axelar, and Injective. What conclusions can you draw from the outflows thus far?
ETH Down Bad
Nov 24, 2022 - The price of Ethereum has sank in recent days - how does it compare to other tokens amid a general market downturn?
Bridge Transactions (Across)
Jun 22, 2022 - Q1. Analyze bridge transactions via the Across bridge over the last two weeks. What assets are users bridging from Ethereum, and to what chains?
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!
Polygon Block Performance
Jul 23, 2022 - What is the average time between blocks on Polygon? What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
Whale Dependency Index
Jan 25, 2022 - This dashboard displaying DEX pool vs total liquidity on Loop with the number of total wallets holding LP tokens typed on each bar. Showing which pools are highly dependent on whales determined by the lower number of wallets associated with the highest liquidity pools will tell us this for each pool. The percentage of user/liquidity is illustrated as the “whale dependency” index.
Getting Your Feet Wet, Part 2
Mar 6, 2022 - Assess the extent to which new users interact with each of the following projects. For Definition, clearly define what “interact with” means, e.g. “at least 1 transaction”, “at least 5 transactions”, etc. Anchor, Mirror, Pylon, Astroport, Terraswap, Prism, Mars Bonus: to be eligible for the grand prize, complete at least one of the following: Display at least one visualization to demonstrate project participation, e.g.. “total # of users who have used each project”, “total # of transactions by project”, “TVL by project”. Include Randomearth, Knowhere and your analysis
Arbs, Arbs Everywhere!
Jul 18, 2022 - Q.112 One of the core actors in the THORChain ecosystem are the “Traders” (https://docs.thorchain.org/roles/trading). These traders swap at a high frequency to make a profit and are a key cog to helping balance prices on THORChain 1) Identify the Ethereum arb bots and show their activity over time. How many are there? What is their average swap frequency and volume? Which tokens are they swapping? Are they interacting with synths or non-synths? How much profit are they making?
Top LDO Holders
Jun 1, 2022 - Who are the top LDO holders on ethereum and where have their LDO come from? Did they buy it or was it an airdrop?
Free Square
Jun 13, 2022 - How's native L1 Integration helps Thorchain to grow stronger as a Decentralized Exchange.
33. [Hard] THORChain Wallet Address Growth by Time Segment
Dec 18, 2021 - This dashboard is showing the creation of new RUNE address wallet in daily basis and find the relation of it with the THORChain growth rate. Using number of new RUNE address created per day as a metric to analyzed the event happened for 1. Pre-hack (before July 16, 2021) 2. Pre-Network Halt (Sep 24 - Nov 11) 3. Post-Network Halt (Nov 18 - present)
THOR-versary!
Apr 16, 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.
Head to Head
Mar 29, 2022 - Excluding the respective foundations, what are the top 10 addresses by amount of UST held? What are the top 10 addresses by amount of DAI held? Do you have any guesses to whom those addresses belong?
How's recent Polygon Hard Fork affect Gas Fee?
Feb 19, 2023 - ETH-scaling project Polygon completed a hard fork last month in hopes of reducing gas fees, as well as disruptive chain reorganizations known as "reorgs,” according to Coindesk. Let’s dive into the network’s health and performance leading up to and since the hard fork. Has the software upgrade led to lower gas fees as hoped? Have these changes affected any meaningful user metrics, such as volume, activity, monthly active users, or others?
Polygon NFT
Jul 16, 2022 - Q3. How popular are NFTs on Polygon? Track daily volume over the past month/year/etc. How many Polygon users started off with NFTs? Who made the most profit?
Optimism NFT Purchasing Behavior
Oct 17, 2022 - Show the distribution of all NFT sales on Optimism by price. What percentage of all sales have been above .01 ETH? Above .1 ETH? 1 ETH? Do you think that there is a limit to how high a floor for a NFT collection on Optimism can reach compared to on Ethereum?