mattkstew
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.
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?
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?
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
Whales On Alert
Jul 29, 2022 - Identify active wallets with a high balance of ETH (whales). Visualize the ETH transaction history of these whales in May and June 2022.
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?
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?
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?
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.
Gain or Lose
Jun 10, 2022 - Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose depending on the peg of stETH to ETH at the time of the swap? Repeat the same analysis for stakers who have swapped stETH to ETH; how much ETH did they gain or lose?
Uniswap - CEX to DEX and DEX to CEX
May 18, 2023 - Examine the flow of UNI tokens between Centralized Exchanges (CEX) and Decentralized Exchanges (DEX). Identify the volume of UNI tokens being transferred from CEX to DEX and vice versa. Determine which exchanges have the highest volume in terms of USD and analyze whether more UNI tokens are flowing into or out of these exchanges.
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?
SUSHI Noobs II
Jun 17, 2022 - What is the first thing new users do when they acquire SUSHI?
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?
My Next Purchase
Jul 28, 2022 - What is the most common transaction (any transaction) users make after minting frETH?
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?
FLOW User Retention vs Other Chains
Dec 19, 2022 - Create a detailed analysis comparing user retention on Flow vs. other L1 chains like Ethereum and Solana. How often do users who make a transaction come back and make another transaction one month later? How do monthly active users compare between chains?
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.
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?
AAVE and stAAVE movements
Aug 9, 2022 - Create visualizations showing daily AAVE supplied and withdrawn on Aave protocol and daily AAVE staked and unstaked.
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?
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.
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?
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.
ETH Deposited or Withdrawn
Jun 27, 2022 - StarkNet is a layer 2 chain, that ensures interoperability with the Ethereum mainnet. People are using it to move real ETH to StarkNet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors?
Axelar - Prime Protocol Launch
May 22, 2023 - Prime Protocol is web3’s first cross-chain native prime brokerage, allowing users to borrow assets on any chain backed by their complete portfolio of assets, powered by Axelar. Earlier this month, Prime launched across Arbitrum, Avalanche and Ethereum Mainnet, with Moonbeam as its home chain. This means that users are able to deposit tokens into their portfolio and borrow tokens based on their portfolio value, across any of these four chains.
Sushi Activity on Ethereum
Jun 25, 2022 - How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
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?
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.
SUSHI Noobs
Jun 18, 2022 - From which address do users acquire their first $SUSHI token ? is it CEX ? DEX ? Dual LP Staking Rewards ? Airdrop ?
Voting Activity
Jun 18, 2022 - The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.
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.
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.
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