mattkstew
Optimism NFT Purchasing Behavior
Oct 18, 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?
Layer 2 Blocks
Jun 30, 2022 - How many layer2 StarkNet blocks have been accepted on Ethereum (L1) chain so far? How much fees have been paid(generated) to Ethereum network? Has StarkNet contributed to saving in transaction fees for its users?
NFT Buying Behavior on Flow
Jun 11, 2022 - Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to on Ethereum and Solana. Is there more or less "whale" activity on Flow compared to each of the other chains? What do "whales" tend to focus on in Flow? How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? Are wallets more interested in new projects, or already existing projects on Flow?
Uniswap On Avalanche
Jul 21, 2023 - In this dashboard I am going to be covering Uniswap Activity on Avalanche. For this Analysis I am going to be looking at Uniswap Overall on the platform, Uniswap compared to other DEX's on Avalanche, as well as Uniswaps activity on Avalanche compared to Uniswaps Activity on other Platforms.
HODL or Sell?
Jun 10, 2022 - Identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. Have they held or sold their stETH?
Early Redemptions
Jul 29, 2022 - True Freeze users can pay a fee to unlock their ETH early. What is the sum of fees paid for early unlocks? So far, what percentage of locked ETH was unlocked early?
Open Analytics Bounty: Snapshot
Aug 12, 2022 - In this dashboard I am going to be looking at a handful of different metrics relating to Snapshot. I will be deep diving into proposal authors, popular proposals, voters, proposal time and many other interesting metrics. I also have created a tool to find proposals and look at how users voted on them. I will be discussing all of these metrics an analytics and looking for any interesting insights and conclusions for the reader.
Stablecoin Landscape on DEX
Jun 9, 2022 - Q87. Analyse the stablecoin landscape on Sushiswap, identifying the various tokens available and their main metrics (volume, number of swaps, TVL, and other relevant for you). Which one is the most successful? Is it the same at Uniswap?
Celsius Swaps
Jun 17, 2022 - Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. From which one of their wallets did they conduct most of the swaps?
stETH/ETH Fluctuation
Jun 13, 2022 - Analyze the price of stETH in ETH denomination and find meaningful correlations that explain its fluctuation. Possible correlations could be with ETH’s price in USD, ETH’s gas price, volume in the curve pool, Curve stETH/ETH pool composition, etc.
Aave Delegates' Gas Usage
Mar 19, 2023 - How much gas was used by delegates voting in Aave in the past 90 days? In the past 180? How much gas on average is spent by voters in a single vote
Gas as a proxy of activity
Jun 8, 2022 - How much did sushi users pay for gas in 2022? Is there a correlation with the price of ETH? Can you comment on the spikes in the chart?
Total Metamask Users
Jun 23, 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?
AAVE and stAAVE movements
Aug 9, 2022 - Create visualizations showing daily AAVE supplied and withdrawn on Aave protocol and daily AAVE staked and unstaked.
Token Reactor Rankings
Jun 22, 2022 - Rank the token reactors by their TVL, analyze the pattern of liquidity (withdrawals, deposits) on the top ones. Is there a reason why some reactors have more liquidity than others?
My Next Purchase
Jul 28, 2022 - What is the most common transaction (any transaction) users make after minting frETH?
Arbs, Arbs Everywhere!
Jul 14, 2022 - 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?
SUSHI Noobs II
Jun 17, 2022 - What is the first thing new users do when they acquire SUSHI?
Prizes
Jun 22, 2022 - In the past 60 days, how many PoolTogether prizes have been awarded and claimed? What’s the USD value of these prizes?
Bridge Users (Hop Protocol)
Jun 17, 2022 - How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
Avalanche Lido stETH Redemption Analysis
May 20, 2023 - Lido Finance, a decentralized finance protocol, recently enabled withdrawals of Ethereum (ETH) in the form of staked Ethereum 2.0 tokens (StETH). This feature attracted significant attention and led to an impressive rush of StETH redemptions, with $500,000 worth of StETH redeemed in just three hours. Make a comprehensive analytical report on the Lido StETH redemption rush, focusing on the key factors, implications, and trends observed during the event.
Flow vs Other L1s
Jun 16, 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
Ethereum NFT Traders and Strategies
Apr 4, 2023 - In this dashboard I am going to be looking at NFT traders on Ethereum over the last 90 days. I will start by looking at all NFT traders on the platform across a handful of different metrics and then focus my outlook to the top 10 NFT traders on Ethereum to see how they differ from the rest of the traders. Finally I will look at the top 500 traders and focus on what projects they are trading and at what times they tend to trade in order to get insights into potential trading strategies of these users.
Opensea Fees
Aug 1, 2022 - Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
2022 Retrospective
Dec 21, 2022 - Let’s explore some key indicators of the health of the Web3 industry. Project ETH supply growth for 2023 by using various average gas prices. What is the highest value DEX swap, by protocol? Where was there the most DEX swaps by protocol? Which were the highest gas consuming NFT mints?
NEAR Performance
Jul 15, 2022 - How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.
Groundhog Day
Jan 13, 2023 - let’s turn to our friend the groundhog for an early crypto-winter prediction: are we nearly through to spring, or will winter’s cold snap continue on even longer? Back your assertion by creating a dashboard with on-chain data that supports your arguments in favor of either a continued downturn in the space or a soon-to-come rally.
Metrics on True Freeze
Jul 28, 2022 - Produce a dashboard showing metrics on True Freeze. At a minimum, visualize: the daily volume of ETH frozen, the daily number of transactions to freeze ETH, and daily early redemptions.
Tornado Cash Addresses
Aug 9, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online.
Bridge Volume (Optimism Bridge)
Jun 15, 2022 - Compare user bridge volume on the Optimism Native Token Bridge vs. another Mainnet <-> Optimism Bridge of your choosing (e.g. Hop). Can we conclude if there are differences in the types of users or transactions using the native bridge vs. the non-native bridge?
Memecoins and the market
May 15, 2023 - How long does a meme last? Recently, memecoin activity and prices have spiked and crashed. Where did the liquidity come from, and where has it gone? Are markets returning to a risk-off mentality?Compare recent memecoin price action and activity with historical trends for memecoins of prior fame. Among today's notable choices are $pepe, $bonk, $chad, (etc), whereas older coins include $doge, $shib, etc.
Whale Watching With Deebs
May 30, 2023 - Deebs Defi recently won Flipside's analytics tournament. Find at least 15 Avalanche whales using Deebs Whale Finder tool. Then, analyze the balance sheet of these whales across chains. How much is each wallet worth in total, and what are the proportions of their assets across different Ethereum compatible chains? Which chains have the most assets from these whales? Finally, explore the Defi activity of these whales on Avalanche. Are they lending, borrowing, staking, farming, LP'ing or trading?