shawnedwards
24. Marketing Analytics - Monthly New Users
Apr 9, 2022 - Is Uniswap attracting new users? Using the last twelve months of Ethereum data, visualize the number of monthly new users onboarding to Uniswap. Definitions: -New users are addresses that have never used Uniswap before. -Onboarding to Uniswap means making any type of transaction on the protocol.
What makes a Top Shots moment valuable? (Part I)
Jul 25, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume.
9. [Easy] Claimed Token Distribution
Dec 22, 2021 - In this dashboard, we will find the average amount of ENS claimed from the airdrop. In addition, we will visualize the claim size distribution of ENS via histogram.
Active Addresses
Jun 8, 2022 - Q4. 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?
Bot Swappers
Apr 27, 2022 - Define bot swappers. How does the behaviour of bots differ from average swappers? For instance in terms of number of swaps, or in terms of distribution of swaps over a day. What percentage of swaps were executed by bots in the past 30 days? What pools and what pairs were most popular among bot swappers in the past 30 days.
$RUNE Movement from Crypto.com
Jun 20, 2022 - Q104. Show the in + outflow from crypto.com to native wallets over time. Are there any trends? Hint: use thorchain.transfers (crypto.com = thor1ty6h2ll07fqfzumphp6kq3hm4ps28xlm2l6kd6)
Whale Swaps
May 5, 2022 - How many swaps are above x$ and how much total amounts were swapped in such transactions?
Untitled Board
Oct 4, 2022 - Which user action results in the highest rate of failed transactions? Compare swapping, borrowing, lending, and adding/removing liquidity on Sushiswap-Ethereum.
Sorare Compete With Collectibles
Nov 22, 2022 - Flow’s DeFi landscape is nascent but growing quickly. For DeFi enthusiasts coming to Flow, what information might they need to best understand this part of Flow’s growing ecosystem? Build an analysis that tracks prices for Flow fungible tokens, looking for the following data points: ticker, volume on DEX by ticker, volume on CEX by ticker, liquidity on DEX, price, market capitalization, and fully diluted value.
Votes, Votes, Votes
Apr 22, 2022 - Q185. On average, how much voting power (in Luna) was used to vote 'YES' for governance proposals? Out of this, how much Luna comes from validators vs regular wallets?
Terra Bounties - Outbound Traffic
Mar 17, 2022 - Question 166: The Terra Bridge has expanded its capabilities: https://twitter.com/Speicherx/status/1501883479457288193 Create a dashboard to track the outflows of LUNA and UST to Osmosis, Secret, Axelar, and Injective. What conclusions can you draw from the outflows thus far?
Untitled Board
Nov 19, 2022 - In wake of the issues surrounding FTX, the old adage "not your keys, not your crypto" reinforces itself. Let's see how this played out during the fallout. Did bridge activity spike over the last 7 days? If so, to what ecosystems? At a more granular level, track net outflows from FTX onto Ethereum. Did any of these outflows flow across Satellite to another destination chain?
Untitled Board
Apr 18, 2022 - Who's managing to escape from the FTX debacle mostly unscathed? Create a single chart showing trading volume on dydx, gmx, and gns to show how people are exiting ftx and entering margin trading dapps. Are they off-boarding through any other methods? Are any particular exchanges, chains, or dapps seeing large increases in new users or trading volume? Note any trends or outliers you see.
Moonbirds Crossovers
May 5, 2022 - Are there any notable cross overs between the Moon Birds community and other communities? How many holders also have BAYC, Doodles, etc
LUNA Distribution
Jan 27, 2022 - People who do not like crypto often cite wealth inequality as a reason: they claim that the tokens are concentrated in the hands of a few whales. Assess this claim for LUNA. How much of circulating supply is held by the top 100 addresses? Top 1%? Top 10%?
AAVE and stAAVE movements
Aug 10, 2022 - Create visualizations showing the following: * Daily AAVE supplied and withdrawn on Aave protocol. * Daily AAVE staked and unstaked.
Who's That Going Across My Bridge (Redux)
Apr 22, 2022 - Q186. Pick one bridge from Terra and a destination of your choice. (e.g. Shuttle bridge Terra <-> Ethereum or Wormhole Terra <-> Solana).
Market Value <> Holders Overtime
Apr 16, 2022 - Does the market value of OlympusDAO correlate with the number of OHM holders?
Daily Transactions and Unique Addresses
Jul 12, 2022 - Q1. Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022. In your estimation, discuss whether Polygon is still growing, has reached a plateau, etc.
Top LDO Holders
Jun 3, 2022 - Q1. Who are the top LDO holders on ethereum and where have their LDO come from? Did they buy it or was it an airdrop?
Trend Analysis
Apr 7, 2022 - Q63. Analyze the trend of active users and number of swaps for sushiswap and draw a comparison with Uniswap. Describe the trends that you see.
Opensea Fees
Aug 2, 2022 - Q6. Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
