mattkstew
Solana Fees
Feb 5, 2022 - One of the main advantages for a user of Solana is the extremely low fees relative to other blockchains. Create a visualization showing transaction fees per day accumulated since the beginning of January. Also create a visualization that shows transaction fees per transaction on each day. Do fees ever seem to spike or is it consistent.
Stablecoin Dominance
Jun 24, 2022 - Compare the transaction volume for USDC, USDT, and DAI on Osmosis. Is there a stable coin that Osmosis users prefer?
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?
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.
Active Wallet Growth
Jan 28, 2022 - What is the number of unique active wallets (signers) over the past 7 days? Create a visualization showing the number of active wallets per day since the start of 2022. What trends do you see?
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.
Cross-chain Anchor
Mar 30, 2022 - Q7. Compare the Earn sides of Anchor protocol on Terra vs. Avalanche. What does the Earn side look like on Avalanche? In the last week, are people using it more? Is there more volume?
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.
NFL AllDay NFT Traders
May 14, 2023 - In this dashboard we are going to be looking at NFL AllDay 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.
Genopets Staking
Jun 1, 2022 - Create a visualization showing the amount of staked GENE over time. How many unique wallets have staked $GENE since its inception on May 18th? What percentage of those stakers have previously purchased a Genopets NFT? What trends are you seeing with the Genopets NFT collection?
User Behavior
Jun 16, 2022 - What are users swapping for? What activities are the most common for users on Flow right now? Create a visualization on what’s causing spikes in swapping behavior.
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.
Terradash Part 3: Development
Dec 19, 2022 - Construct a dashboard that displays the number of new contracts deployed and the total number of contracts deployed each week over the past several months. Your dashboard should also chart the development of stablecoins, including any supply trends.
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?
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.
SUSHI Noobs II
Jun 17, 2022 - What is the first thing new users do when they acquire SUSHI?
Dimension X Activity
Mar 30, 2023 - Dimension X is one of Flow's hottest NFT games where you can create a team of heroes to go on quests and battle enemies. Each quest is a competition with other hero teams. Analyze Dimension X activity by showing Month over Month (MoM) active users, monthly user growth, new users over time, average transactions per user, and MoM fees paid (if any). Explore Dimension X yourself and see if you can uncover other useful metrics to compare Dimension X to other popular NFT games (you can compare to games on other chains if you'd like).
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.
Pooly NFTs
Jun 21, 2022 - How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
AAVE and stAAVE movements
Aug 9, 2022 - Create visualizations showing daily AAVE supplied and withdrawn on Aave protocol and daily AAVE staked and unstaked.
Terra LP-ers: Aftermath
Jun 19, 2022 - What did people that were LP-ing in the Terra pools do? Are they just holding onto their $RUNE now or are they back in the arena LP-ing somewhere? Or did they sell their $RUNE and leave the ecosystem completely.
Optimistic Bears
Aug 8, 2022 - Analyze Optimism during the month of July as markets were get turbulent, showing whatever metrics you care to unearth.
OSMO on Coinbase
Jun 1, 2023 - Measure the impact that OSMO’s listing on Coinbase had on token price, trading on DEXs and overall liquidity on Osmosis.
Gainers and Losers
Jan 13, 2022 - Sort all of the liquidity pairs in terms of each of the following categories: fees in USD gained over the past 24 hours, volume in USD gained over the past 24 hours, and liquidity in USD gained in the past 24 hours. Repeat this process for the top 10 losers for each of the same categories.
Welcome to the City
Jul 15, 2022 - Once you’ve bridged to NEAR, what is a user’s first activity? Chart the protocols that users are leveraging after porting tokens through the Rainbow Bridge specifically
Bubblegoose Ballers Mint
Jun 15, 2022 - How many unique wallets minted a Bubblegoose Baller NFT and how many NFTs did these wallets purchase on average? How many NFTs were purchased with ETH using Crossmint? Identify any notable trends in minting activity and secondary market sales in the days following the launch. Which group(s) was most likely to "diamond fin" their NFTs?
Historical APY Search Tool
Aug 11, 2022 - Create a tool that shows historical APY earned/paid on loans over a user-specified data range.
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?
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.
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?
Impermanent Loss
Jul 30, 2021 - Calculate the IL vs HODL of the top 10 most active LPs on the top 10 pools
Most Recent Transactions
Jan 22, 2022 - Find the top 10 tokens in terms of liquidity in USD on Sushiswap. Show the 10 most recent transactions on Sushiswap for each of those tokens.
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.
New User Onboarding
Jun 26, 2022 - When a new wallet gets created, where are they first getting their $RUNE? Is it from a direct transfer? Or from a centralized exchange? From a $RUNE upgrade from BNB.RUNE or ETH.RUNE? Or from a swap from another chain's asset to $RUNE? If it's a swap, which chain / asset are they coming from? Are there any trends over time you can see?
Velodrome Locks
Jul 17, 2022 - Analyze new locks created on Velodrome Finance. What durations are most common? Which wallets have locked the most in the last 4 weeks? Which pools are wallets voting for with their locked tokens most often?
Ethereum Gas Fee Surge: Analyzing the Impact on Users and DApps
May 16, 2023 - This deep dive dashboard aims to investigate the recent surge in Ethereum gas fees since the beginning of April, with a focus on the top decentralized applications (DApps) and use cases that have contributed to this increase. Additionally, we will explore the amount of ETH burned as a result of these top apps in terms of gas fees and determine if the increased gas fees have discouraged users from interacting with Ethereum. Lastly, we will examine the use cases that have diminished due to high gas fees and those that persist, as well as the adoption of Layer 2 solutions as a result of elevated fees on Layer 1.
Comparative Analysis of Governance Voting and Staking Metrics on NEAR
Jun 15, 2023 - We are seeking a comprehensive analysis comparing the governance voting and staking metrics of the NEAR blockchain with two other prominent blockchains. The analysis should cover a period of the last two years and provide a breakdown of key metrics to determine the level of participation in governance activities and staking on each network.