Josh956
36. Thorchain: The cost of swaps
Dec 24, 2021 - Analyzing the cost of swaps on the Thorchain Network
New Users on Algorand vs. Ethereum vs. Solana vs. Terra
May 3, 2022 - Create a Dashboard for new users on : Algorand, Ethereum, Solana and Terra What trends do you see?
Magic Eden Volume Trends
Mar 14, 2022 - Create a visualization of Magic Eden total sales volume per day since January 1st. How has sales volume trended over time? Are there any trends to when sales volume seems to go up or down on certain days of the week or during certain times of the day? Are users more likely to trade a NFT during the week or the weekend?
What Are Whales Swapping For?
Apr 14, 2022 - Let's look at the whales are swapping for on the DEXes. First identify current whales with the balance field in the algorand.account table.
NFL ALL DAY Tournament Round of 16
Sep 27, 2022 - How much more valuable, on average, are touchdown rushes than a rush that did not result in a touchdown? For this, you could compare sales of a rushing touchdown like this one vs. a 50-yard rush that did not result in a touchdown like this one. Since whether the play was a touchdown is not always present in the description, you could take a sample set to test your hypothesis. What about for quarterbacks, or wide receivers? Defense vs. Offense analysis, looking at how well sales of OL plays that result in the team scoring vs. defensive linemen highlights like a sack. If the player's team won the game, does that correlate to higher sales for that individual moment vs. a play where the team lost?
Optimistic Bear (Redux)
Nov 4, 2022 - Analyze Optimism during the recent bear as markets were turbulent, showing whatever metrics you care to unearth. You can choose any topic you’d like: How did the network perform? What about market performance? Were there significant inflows or outflows on bridges? Were there any notable patterns in user behavior?
Velodrome Health (Redux)
Nov 12, 2022 - Create at least 5 metrics on Velodrome with a description for each that showcase traction and success in a data-driven manner.
IL Payout vs LP Age
May 9, 2022 - Show a breakdown of the average IL payout by the amount of time spent in the pool
ALGO Transaction Payment Size
Mar 30, 2022 - Q43. Let’s look at the quantities of ALGOs being sent in transactions since January 1st 2022 to see if we see any upwards or downwards trends. Group the transactions(algorand.payment_transactions) by size 0-10 ALGOs, 10-100 ALGOs, 100-1000 ALGOS, 1,000-10,000ALGOs and 10,000+ ALGOs. Count the number of transaction in each size and chart them by day from January 1st 2022 to current.
Solana Competitive Advantages
Apr 29, 2022 - Why would a developer and / or a user choose Solana over Ethereum (and vice versa)?
Optimism In & Out Flow
Oct 31, 2022 - What is the volume of ETH and three stablecoins of your choice that's moved between the Optimism network and the Ethereum network across the bridge? How has that changed over time? Note any interesting trends or outliers that you see
Flash Bounty: Miners
Sep 7, 2022 - Do certain miners prefer mining blocks with lower transaction count? Do certain miners only mine blocks with high transaction count? You can define what can be considered low or high transaction count based on the transaction count distribution
The Meme's game
Mar 20, 2022 - Q56. Choose the three largest meme tokens on Sushiswap. Was there ever a time when the swap volume of these tokens soared? What, if any, is the cause of this sudden increase in swap volume?
Tracking UST on SOL
Feb 15, 2022 - There has been a focus of integrating UST in the SOL ecosystem in 2022. Identify the three most popular applications of UST in SOL DeFi in February. Can you calculate yield generated from these pools? Are "whales" more or less likely to transact in UST than USDC or USDT on SOL (can calculate this through avg value of each coin)? Highlight the 10 largest transactions in terms of UST in February. Are there patterns to the "whale" transactions and wallets?
Wormhole Hack
Feb 16, 2022 - This week a hacker managed to exploit the Wormhole contract and steal 120K wETH. Jump Crypto was able to restore the liquidity after a few hours, but for a brief period on 2/2 this created imbalances and a difficult situation since the stolen wETH backed all ETH on Solana. Create a dashboard showing the transaction volume change in the 2 most popular ETH pools on Solana compared to the previous week's volume. Can you visualize panic in the market? How long did it take for activity in that pool to stabilize?
Bridger Destinations (redux)
Nov 1, 2022 - What are the 10 most popular first destinations for users that have just bridged from Ethereum? What has this been for each day in the past month? How has this changed over the last three months? Last six months?
Top Kashi Pairs (II)
May 18, 2022 - Find the top 5 Kashi pairs on Ethereum based on the number of loans they have given out so far. Choose one that you like, and describe the following information: How many people are lending on this pair at the moment ? How much each user is lending at the moment?
Algorand Governance Period 2 Voting
Mar 10, 2022 - Algorand's 2nd Governance Voting Period Ran From January 31st to February 28th 2022(https://governance.algorand.foundation/governance-period-2), lets take a look at how wallets voted for or against xGovs.
Acquiring goBTC and goETH
Apr 5, 2022 - Where are users acquiring goBTC and goETH? Are they acquiring the assets by swapping or by minting? Has this changed over time? Explain the insights you find.
User Growth Per Sector (Terra)
May 4, 2022 - What sectors / Apps are driving user growth on Terra ?Choose the top apps per sector (DEXs, Borrowing, Staking, NFTs ...) and create a dashboard of user growth per sector and App. Are there any sectors / apps that are driving more user growth than others?
Sushi Borrowing
Mar 10, 2022 - Has the recent price slump affected the sushi borrowing and lending activity? Describe the patterns and correlations with price, if any.
5. [Easy] Daily Transactions and Unique Addresses
Aug 31, 2021 - Tracking daily transactions on the POLY network
Airdrop Assessment
May 11, 2022 - Q4. Paraswap recently undertook a novel approach to conducting their airdrop. Provide a well-reasoned assessment: was this an effective airdrop design or not? What does it demonstrate about how to conduct airdrops to accomplish particular goals? How are you measuring these? Define and display at least two data-driven metrics for effective airdrops to support your answer.
$THOR Staking Wallets
May 23, 2022 - Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards. How many unique wallets have staked $vTHOR? Chart this number over time.
Algofi Decentralized Lending
Feb 16, 2022 - Algofi is a decentralized lending platform where you can provide collateral to take a loan on your asset. Chart liquidity supplied and borrowed for each asset(ALGO, STBL, USDC, goBTC, goETH) from the launch Dec 17th to February 1st.
Most Popular Jupiter Swaps
Feb 26, 2022 - Since February 1st, what have been the 10 most popular tokens to swap away? Over that same timeframe, what have been the 10 most popular tokens to swap for? What are the 10 most popular swapping pairs (combination of swap away to swap for)? Define 'popular' as the number of swaps and create a visualization showing total number of swaps over that time frame, highlighting these most popular tokens.
NFL ALL (THANKSGIVING) DAY
Dec 2, 2022 - The NFL's annual Thanksgiving games recently drove record viewership in the U.S., with 42 million people tuning in to see the Giants take on the Cowboys. Did FLOW NFT project NFL ALL DAY see similar boosts in popularity?