mattkstew
Chain Swaps
Apr 27, 2023 - Since February 23rd, you have been able to swap into 13 different Cosmos Chains via Squid. What chain has had the most activity?
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.
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.
NFL ALL DAY Tournament Round 2
Sep 19, 2022 - there a type of play that is more valuable, or do valuable players sell at higher prices regardless of play type?
AAVE and stAAVE movements
Aug 9, 2022 - Create visualizations showing daily AAVE supplied and withdrawn on Aave protocol and daily AAVE staked and unstaked.
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
Pendle Finance Activity
Jun 12, 2023 - In our upcoming exploration, we'll be diving deep into the world of Pendle Finance, focusing on the activity surrounding the PENDLE token. We'll be examining the intricacies of its transfers, diving into the diversity of its holder base, and assessing the broader activity in its ecosystem. Furthermore, we're going to study the dynamics of yield token activity on Pendle, an innovative feature that separates this protocol from others. I hope you enjoy
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?
My Next Purchase
Jul 28, 2022 - What is the most common transaction (any transaction) users make after minting frETH?
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?
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?
SUSHI Noobs II
Jun 17, 2022 - What is the first thing new users do when they acquire SUSHI?
How does BTC Funding Affect Rates
Aug 11, 2022 - Create a dashboard that shows the supply and lending rates for at least five tokens in Aave V2 and total amount of Wrapped BTC supplied over time.
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.
Gas Efficiency
Jun 9, 2022 - Which one of the sushi services consumes the most gas per transaction? The services to include in your comparison are : -Adding liquidity -Removing liquidity -Adding an asset for lending -Borrowing -Removing an asset from lending -Repaying a loan -Swapping
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?
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.
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?
Active Wallet Addresses
Jun 16, 2022 - . We are interested in knowing how many users are currently in the ecosystem. In this case, how many are holding $RUNE in their wallet or have an open LP position. What is this number currently, and how has it trended over time?
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.
$RUNE Upgrades
Jun 24, 2022 - There has been a big push for users to upgrade their ETH.RUNE + BNB.RUNE -> native RUNE, as the wrapped versions will be depreciated. Have you seen an uptick in the amount of $RUNE being upgraded recently? Look at both the $RUNE volume + number of wallets. What is the trend over time + also how much is ETH vs BNB?
NEAR Centralized Exchange(CEX) Flows
May 2, 2023 - Using the labels table create a dashboard that illustrates the inflows and outflows of assets from NEAR to CEX and vice-versa. Look at items such as number of users and volume by CEX. Another thing to look at is which CEXes bring in the most active users to the ecosystem? Lastly what dApps in the ecosystem are users who onboarded funds from CEXes are using?
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?
Monthly Swap Volume
May 11, 2022 - Q2. Show the total monthly swap volume on ParaSwap over the past year. How has the swap volume changed over time? Which DEX’s is most of the swap volume coming from?
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.
Are NFT Creators Minting Money?
Jun 19, 2022 - What is the average and median return on investment for candy machine NFT creators? As in how much revenue are NFT creators making off mint and then off royalties? How has that trended over time and how do you see this shaping the NFT landscape on Solana?
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.
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.
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.
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?
Daily Active User
Oct 19, 2022 - What does a Daily Active User look like on Osmosis? First, plot out how many DAUs there are on Osmosis. For this exercise, consider a DAU would be any wallet transacting on Osmosis a majority of days every week. Once you have the DAUs, what does their activity look like? Do they LP more or swap more? How often do they transfer tokens into Osmosis? Where are these transfers coming from?
Top TOKE Holders
Jun 21, 2022 - Identify the top holders of the TOKE token in January 2022, have they kept their position today?
Tracking MarketingDAO Grants
Jan 30, 2023 - The NEAR MarketingDAO is in need of a grants tracking dashboard to better monitor the outcome of grant requests from their treasury. Discussion around these requests happen on the NEAR forum, but the formal decision is a vote on AstroDAO, codifying the results on chain.
NEAR partners with AlibabaCloud
Jun 30, 2023 - In the article above you can read about NEAR’s upcoming collaboration with Alibaba Cloud. This collab is going to boost the visibility of NEAR in APAC and make it easier for Alicloud users to spin up NEAR validators, hosted on there. Please research some insights into validators on NEAR: Number of validators, Seat price, Validators using poolv1.near vs pool.near, the new updateable pool factory, NEAR staked per validator in the active set, NEAR staked total, Effects of liquid staking solutions, and Yield on NEAR staking.