mattkstew
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?
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.
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?
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?
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.
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.
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?
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.
AAVE and stAAVE movements
Aug 9, 2022 - Create visualizations showing daily AAVE supplied and withdrawn on Aave protocol and daily AAVE staked and unstaked.
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?
Aave and stAave Movements on Ethereum Mainnet
Jun 3, 2023 - Continuing with the set of easy questions for our newbie users, we are now asking for creating visualizations depicting the daily, weekly and/or monthly movements of AAVE tokens on the Aave protocol specifically occurring on the Ethereum Mainnet, including both supply and withdrawal activities, as well as the daily staking and unstaking of AAVE tokens.
Highest Sales Volume
Jun 12, 2022 - Which 3 NFT collections have the most total sales volume in the last 60 days on NFTX? These are transactions where someone redeems their NFTX tokens for a specific NFT
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?
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?
SUSHI Noobs II
Jun 17, 2022 - What is the first thing new users do when they acquire SUSHI?
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?
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?
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.
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
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.
Opensea Fees
Aug 1, 2022 - Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
Distinct Wallets (Optimism Bridge)
Jun 14, 2022 - How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
Multichain Backend Upgrade Delay
May 31, 2023 - The Multichain Token experienced a significant price plunge of 30% due to a backend upgrade delay. In order to gain valuable insights and understand the repercussions of this news, we are seeking skilled data analysts to conduct a comprehensive analysis of relevant data points. The goal is to provide a thorough understanding of the Multichain Token's current state and its potential impact on the market, with a specific focus on the repercussions of the backend upgrade delay.
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.
wETH Deposit Rate
Jun 13, 2022 - Calculate the deposit rate of wETH over time on Osmosis. How does this compare to SushiSwap and Thorchain now? How does the wETH deposit rate compare to when wETH was a relatively new asset (or the protocol was relatively new)? Is Osmosis growing at a faster rate than Thorchain and Sushiswap?
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.
Largest Tokemak DEX Pools
Jun 22, 2022 - What are the largest dex pools for TOKE (UNI, SUSHI, etc.)? What is the behavior of TOKE holders on these token pools currently?
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.
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?