mattkstew
Distribution of Swaps in $RUNE and USD Values
Sep 4, 2022 - Show the distribution of swap sizes in both $RUNE and USD, both for all pools as well as broken down by pool.
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?
Optimism NFT Traders and Strategies
Apr 11, 2023 - In this dashboard I am going to be looking at NFT traders on Optimism 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 Optimism 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.
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.
Defi and the Bear
May 4, 2022 - When crypto prices drop, TVL decreases across most pools on Uniswap. When crypto prices drop, are LP's exiting pools or are they staying put? Visualize the price of ETH against net liquidity flows on Uniswap over time.
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.
Free Square Question
Nov 15, 2021 - In this dashboard I will look at the donations to Levana
NEAR Gas Guzzlers
Jul 23, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month?
Top Providers
Jan 23, 2022 - Find the top 3 pools in terms of liquidity in USD on Sushiswap. Show the following for the top 10 liquidity providers in each of these pools: LP address, pool share (as a percentage), liquidity tokens staked, and liquidity tokens in USD
Celsius and Sushi
Jul 11, 2022 - Find out what Celsius platform has done on sushi (swaps, lending, LP'ing, farming). Make sure to use cross-chain tables as much as possible to capture data on all chains. currently, we have swaps, lending, and borrowing data cross-chain.
Impact of Adding New Chains/Tokens
Jan 19, 2022 - THORChain is planning on adding support for Dogecoin soon. Traditionally, what has been the impact of adding another chain (or token) on THORChain? Does swapping activity or THORChain wallet creation spike up?
Avalanche Centralized Exchange(CEX) Flows
Apr 16, 2023 - Using the labels table create a dashboard that illustrates the inflows and outflows of assets from Avalanche. Look at items such as number of users and volume by CEX. Another thing to look at is which CEXes brings in the most active users to the ecosystem?
Social Dashboard
Mar 2, 2023 - Create a dashboard using the new NEAR.social schema. Break out and document the activity happening on NEAR.social. Some suggested topics to look at in your dashboard: Profile creations, edits, Post creations, responses, Follows and unfollows, and Widget creation, usage and reusability. Don't be limited by the items above. Feel free to dive into any of the other meaningful actions being recorded on-chain and can help map growth and adoption of NEAR social.
Active Addresses
Jun 8, 2022 - How many addresses on the MATIC network are active? What’s the daily evolution of active addresses? Is the activeness related some how to the price?
User Activity
Jun 12, 2022 - Analyze user activity providing and removing liquidity from NFTX vaults. Which three vaults have seen the most activity over the past 60 days? Are there any similarities between these vaults or NFT projects? Explain and visualize your findings.
Smart Money NFT Traders
Jun 8, 2022 - Which wallets have made the most SOL off NFT mints and NFT trades since the start of the new year? What types of actions have led to being a profitable NFT trader on SOL? Is there a pattern behind their NFT trading strategy and can you define some of these traders as "smart money"? Do you think you need to be a "whale" to do well trading SOL NFTs, or can anyone have success in this market?
A Surge of Optimism
Dec 20, 2022 - Analyze the network and diagnose some of the possible reasons for the sudden drop, and slow climb, of OP price in recent weeks. Are there any notable trends in users, transactions, or any other metrics that could explain these events? Note any patterns or outliers you see.
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?
Active LP-ers
Jan 13, 2022 - Which RUNE wallet addresses are the most active in updating their LP positions? Are they typically chasing the pools with the highest returns or is there something else that seems to be dictating their behavior?
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
Transaction Failure
Mar 22, 2022 - Establish the failed transaction rate for Terra over a time period of your choosing. Is this analysis correct? Additionally, make a case for what is causing the failure transaction rate you assess, and provide recommendations to mitigate it.
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?
Trending NFT Projects
Jun 11, 2022 - Create a visualization showing NFT sales volume on Flow since May 9th. Which NFT projects are trending on Flow right now and what is the general trend of NFT sales over the last month? Do the projects that are trending seem to have common wallets or is there not much crossover between buyers/sellers?
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?
Voting Power Within the Arbitrum DAO
Mar 31, 2023 - Track the consolidation of voting power within the Arbitrum DAO. How many unique wallets have delegated their ARB tokens? How many unique delegates received tokens? Create a dashboard that monitors the total voting power and number of unique delegators for the top 50 delegates. Identify the top 10 delegators (by total ARB) for each delegate in the top 50. Also examine the on chain activities of wallets that have chosen to delegate their voting power and note any patterns. Based on transaction histories, is it possible to identify which user segments are more likely to delegate tokens?
Avalanche Gas Fees
Mar 24, 2023 - Create a dashboard to analyze gas usage on the Avalanche network. The dashboard should have two tabs: one for contracts and one for dApps. Each tab should show which ones generate the most network fees and use the most gas over a user-selectable time period. Include any other metrics or charts that reveal contracts and dApps with growing usage based on data such as network fees, number of unique users, or other relevant metric.
DimensionX NFT Traders and Strategies
May 25, 2023 - In this dashboard we are going to be looking at DimensionX NFT Traders. We are going to start by looking at general trading metrics across all traders. Next we are going to focus on the top 10 traders and their trading activity. Finally we are going to look at the trading strategies of the top 100 traders in order to see what the optimal timing and assets to trade are.
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?
Activity with NEAR Blockchain Projects and NEAR Horizon
Jun 22, 2023 - We are looking for analysts to identify and analyze active projects on the NEAR blockchain. The intention being to gain insights into the current project ecosystem, smart contract interactions and overall recent activity. Determine the total number of active projects on NEAR and specifically identify those on NEAR Horizon, the developer-friendly interface. Define active projects by your own terms and explain your thought process.
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.