hyoeiseman
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/
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?
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.
Steady As She Goes
Mar 2, 2022 - A common talking point on Twitter is that LUNA is resistant to broader market downturns, when compared to other leading cryptocurrencies. Assess this claim, using data drawn from a time period of your choosing. In making your argument, acknowledge the unknowns and address potential criticisms of your chosen position. Additionally, clearly define your definition of stability or resistance to broader market pressures, as well as your benchmarks for comparison (i.e. what are you comparing LUNA to, and how does it perform vs. its peers/competitors?)
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?
ETH Staked
Jun 15, 2022 - Q9. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
LUNA & Drawdowns
Apr 14, 2022 - Evaluate the price performance of LUNA following liquidation-inducing drawdowns. What is the average time (days) for LUNA to recover its previous price level. How does this period change relative to the size of the drawdown (in percentage terms)?
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?
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?
$RUNE Movement from Crypto.com
Jun 20, 2022 - Q104. Show the in + outflow from cryto.com to native wallets over time. Are there any trends?
Who's That Going Across My Bridge
Apr 27, 2022 - Pick one bridge from Terra and a destination of your choice. (e.g. Shuttle bridge Terra <-> Ethereum or Wormhole Terra <-> Solana). Assess the daily and cumulative amount of UST that goes through that bridge, both inflow and outflow. How many users are using the bridge on a daily basis? How many transactions take place on a daily basis?
Question 37: Swap Sizes
Feb 10, 2022 - Show the daily average swap size over time for the 10 largest liquidity pools (in terms of value locked). How has this swap size changed over time? Why might this be?
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
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?
[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
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)
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).
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
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.
Sushi rewards distribution
Apr 28, 2022 - Sushi’s “merkle distributor” is the contract that is used to distribute the rewards in SUSHI to eligible users. There was a vesting period of 27 weeks during which the rewards were gradually being assigned to users. But the vesting period finished on Oct 12th 2021 at 7:10 PM EDT. After this time, users should call the “merkle distributor” in order to withdraw their rewards because no more reward is being vested. How much in total has been distributed so far? (A daily chart could help too) How much is left to distribute today? What percentage of eligible addresses have not claimed anything so far? How many eligible addresses have not claimed anything so far? What percentage of the eligible addresses are dead addresses (A dead wallet is a wallet that has not executed any transaction in the last 3 months)
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.
ETH Deposited or Withdrawn
Jun 30, 2022 - Q1. StarkNet is a layer 2 chain, that ensures interoperability with the Ethereum mainnet. People are using it to move real ETH to StarkNet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors?
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.
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?
Profit for AMMs
Apr 13, 2022 - Q63. What is the total profit (in dollars) per day that is generated from swaps out of the liquidity pools in 2022? Do you see a trend? Can you compare sushiswap with Uniswap?
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?