hyoeiseman
ETH and BTC sell-off
May 1, 2023 - Investigate abnormal activity of massive wallets depositing BTC and ETH into CEXs right now. There is debate whether the US Government wallets, MT Gox wallet and Jump trading wallets may or may not be selling large sums of BTC and ETH. Jump trading was identified to have sent $26.6m BTC to various exchanges, their largest deposit is into binance $24.7m Read more from The Block and Julio Moreno for the debate. * In the past 24 hours, what wallets have been the largest deposits to a CEX (in $eth) . What CEX is being used the most? * Are there any other major whale activities to take notice of?
Untitled Board
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.
Untitled Board
Oct 27, 2022 - With the launch of Flipside's new Balances table, let's take a look at how the story of Osmosis can be told through wallet balances. Provide insights into following metrics: How has the ratio of liquid to staked OSMO changed overtime? Are the top 100 OSMO holders the same now as they were at the start of the year? What is the current average OSMO per wallet? How has that value changed over time? Plot average OSMO/wallet against user growth. Do wallets normally hold a majority of OSMO, or another token? How has this changed over time?
Polygon NFT
Jul 17, 2022 - Q3. How popular are NFTs on Polygon? Track daily volume over the past month/year/etc.
Untitled Board
Jul 1, 2022 - Flipside is holding a bounty tournament to celebrate the arrival of the World Cup — plus a weekly side quest bounty open each week to anyone, even those who arent participating in the tournament. For this week's side quest, the World Cup right around the corner help Fifa+ Collect(https://collect.fifa.com/drops) collectors understand how good their collection is by creating a rating system. Requirements: * Use the parameter feature on Flipside to allow users to put in their Fifa+ Collect Wallet address. * Show the users collection and the breakdown of the users score * Add a cool visualization that provides additional context
Uniswap - 16. UNI Market Correlation
Apr 2, 2022 - Does the price of UNI correlate with the price of ETH? Compare this with the correlation of UNI to other DEX coins (such as AAVE, SUSHI, or anything else you find suitable)
Tracking the Top Saber Lockers
Mar 10, 2022 - Create a time series analysis of Saber locked up over time, noting the start of each epoch. List the top 20 wallets that have locked Saber in the month of February. Have these top wallets added to their locked SBR positions to gain even more voting power, or do they lock all their SBR tokens in governance at once? What other activities are these top 20 wallets doing in the month of February (for example what other tokens are they transacting with, what other protocols are they engaging with)?
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.
NEAR Performance
Jul 21, 2022 - Q5. 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.
FLOW Usage During the NBA Playoffs
Jul 13, 2022 - Q19. Analyze the NBA Conference Finals (May 17th- May 29th) and determine whether it had an impact on NBA Top Shot's volume. Did the Warriors, Celtics, Mavericks, or Heat see higher sales volume?
Arbs, Arbs Everywhere!
Jul 21, 2022 - Q.112 One of the core actors in the THORChain ecosystem are the “Traders” (https://docs.thorchain.org/roles/trading). These traders swap at a high frequency to make a profit and are a key cog to helping balance prices on THORChain We are taking a deep dive on these traders. To do so, you have 2 options: 1) 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? 2) Identify a single Ethereum arb bot and show similar metrics. What is their THORChain address and what is their ETH address? Are there any other addresses that they are associated with (e.g. do they control several different addresses and transfer between them)? 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? Hint: use thorchain.swaps and ethereum.core.ez_dex_swaps (to get the profit)
Untitled Board!
Oct 15, 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?
Stablecoins on Kashi
Jul 14, 2022 - Q102. Analyze the behavior of stablecoins on Kashi markets. Which ones are being deposited for lending? Which ones as collateral? Do this for both polygon and Ethereum. You can use the cross-chain sushi ez_lending and ez_borrowing. Note: Currently the polygon data is only showing the recent months. We will back-fill the data in the future. Make sure your dashboard mentions the starting date on polygon data.
Active Wallet Growth_SOLANA
Feb 3, 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?
What makes a Top Shots moment valuable?
Jul 26, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table. What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.
Layer Zero Dashboard
Apr 29, 2023 - Build a multi-tab layerzero dashboard with a parameterized start and end date selection. Have the first tab display 3 charts: USD Inflows by chain USD outflows by chain Users by chain Next build an additional tab for each chain supported by Layer0 and breakout inflows and outflows to that chain by asset. Additionally, what is the average USD amount moved per asset? Lastly, write some observations about layer zero usage across chains. What chains seem to be adopting Layer zero usage the most?
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.
[Medium] Failed or not ?
Mar 11, 2022 - Create a visualization about the total transaction daily on harmony blockchain and show the success rate for transactions and compare it with others networks
The Law Offices of NEAR
Aug 4, 2022 - Q7. Provide your best assessment of the number of smart contracts deployed on NEAR and clearly outline your methodology (after all, contract lawyers love clearly specified terms).
Velodrome Locks
Jul 18, 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? For more information on Velodrome, please visit: https://docs.velodrome.finance/
Price Status Quo
Feb 2, 2022 - Does the price of the Sushi token tend to follow the trend of the rest of the market? Does the price follow the trend of the rest of the DEXs? Why or why not might this be?
Quixotic NFT Dashboard
Aug 4, 2022 - Q7. Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism! Include any data you think is relevant in our Optimism tables and tell us the most interesting trends you can find with the secondary NFT market.
Volume Market Share
Feb 14, 2022 - Show daily transaction volume on Sushiswap as a proportion of the total volume across all of the DEXs over the past 60 days.
Untitled Board
Jun 12, 2022 - Compare the market share of Sushiswap and Uniswap on the following L2 chains. Polygon, Arbitrum, Optimism. Use measures such as number of trade or number of swaps, etc.
Untitled Board!
Oct 15, 2022 - A war of the trading platforms? GMX (native to Arbitrum) - GNS (native to polygon, but announced will be launching on Arbitrum soon). Both platform native tokens (GMX - GNS) have seen meteoric price growth during a bear market. Since June GNS has gone from $0.68 to $3.68 and GMX has gone from $13.70 to $41.56 Observe Trading volume. Has one platform absorbed more volume than the other? How impactful is GNS volume to polygon? GMX volume to Arbitrum? Are there any insights that can reveal why Gains Network wants to move into the Arbitrum ecosystem?
Untitled Board!
Oct 15, 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.
Transaction Failure
Mar 22, 2022 - Q169. Make reference to this tweet: https://twitter.com/alphaDefi_/status/1504522066674003972/photo/1 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.