Opening Positions
Jun 27, 2022 - Over the last month, what volume of assets are Mean Finance (Polygon) users opening positions with (selling)? What assets are they dollar-cost averaging into (withdrawing swapped assets)? Note any large positions that don’t make sense on Ethereum due to transaction fees.
Daily stETH Metrics
Oct 8, 2021 - Lido’s staked ETH (stETH) metrics questions: Daily volume of stETH? Average stake size? Number of stakers over time? Average time staked? Percentage of stETH converted to bETH and bridged to Terra?
Curve.fi Stablecoin Pools
Mar 16, 2023 - Navigating the USDC Crisis through Curve Pool Analysis
Whale Transaction Volume
Feb 4, 2022 - Question 35: Show the daily swap volume of wallets with over 1 million Sushi tokens. How has this volume changed over time? How has the number of ‘whales’ changed over time?
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?
Saga
Jun 23, 2022 - How many wallets have pre ordered Saga (the new solana phone) so far? Note: the preorder is a NFT purchase on-chain. Who is preordering the phone? Provide a breakdown of the type of wallets ordering so far. Example metrics to investigate: what other programs are these wallets interacting with, how active have these wallets been on Solana, are they average users or whales
Yet Another Acme Question
Apr 22, 2022 - Refer to submissions for #175 - your own, or those of others. Pick your favorite Terra metric or visualization and recreate your own version.
ETH.RUNE upgrades vs BNB.RUNE upgrades
Jan 8, 2022 - What is the ratio of the number of ETH.RUNE upgrades vs BNB.RUNE upgrades? How has that ratio changed over time? Hint: use thorchain.upgrades
% of Solana Staked
Feb 12, 2022 - Using the "Events" table, what percentage of Solana that has been transacted is staked? How has that percentage changed throughout the month of January? Create a visualization showing % SOL staked over time. What is the average amount of Solana staked during a staking transaction?
Aave Staking Reward Flows
Oct 13, 2021 - Analyze how Aave rewards (staking) are spent on mainnet -- are they reinvested into positions? Used to pay down loans? Simply liquidated/swapped for ETH?
Calls vs. Puts
Feb 5, 2022 - Ribbon offers both covered call and put-selling automated strategies. Between its four main pools (ETH and BTC covered calls, yvUSDC-ETH, USDC-ETH puts) what is the most popular strategy by TVL? Are put-selling strategies or covered calls currently more popular? Has that trend always been the case? Create a visualization showing this trend. Why do you think that is?
Algorand NFTs Overview
Jan 22, 2022 - Let's get a better understanding of the Algorand NFT scene! How many total, non-closed NFTs are on the algorand network? How many NFTs use the ARC3 vs ARC69 standard? Additionally, show the minting of the NFTs with these standards over time. Finally, show the daily total volume of total NFT sales, ARC3 NFT sales and ARC69 NFT sales over time (Tip: Here is an example of an NFT sale tx_group_id: lLa5DLImBy1PrQEWvcHR9HRZnpS/QPVQFvQPTaMvt74= )
Flow Activty Comparison Dashboard
Apr 8, 2023 - Comparing User Activity, NFT Trends, and Network Growth on Ethereum, Solana, and Flow Blockchains
Bot Swappers
Apr 24, 2022 - Define bot swappers. How does the behaviour of bots differ from average swappers? For instance in terms of number of swaps, or in terms of distribution of swaps over a day. What percentage of swaps were executed by bots in the past 30 days? What pools and what pairs were most popular among bot swappers in the past 30 days.
