Ali3N
Sushi During Volatile Times
May 27, 2022 - How did the recent spike in market volatility affect the overall activity of sushi on ethereum? Analyze both swaps and lendings?
Untitled BoardOPA
Sep 24, 2022 - Earlier this summer, Optimism offered an airdrop to users. Let’s examine the airdrop after a few months. How many users claimed optimism airdrop? How much of total airdrop was claimed? How many wallets are still holding tokens from airdrop? How much of users delegated their OPs? Feel free to provide any information that you think is related to token price.
Untitled BoardNFTC
Sep 13, 2022 - Time to do some NFT analysis. Compare and contrast the NFT market and ecosystem across at least three different chains (you can do more if you wish, but there must be at least three included.) Explain how the various chains differ in terms of metrics such as: Total Sales Total Unique Buyers Total Volume Average Sales/Day Average Buyers/Day Average Sales Price/Day
Largest Tokemak DEX Pools
Jun 21, 2022 - Q3. What are the largest dex pools for TOKE (UNI, SUSHI, etc.)? What is the behavior of TOKE holders on these token pools currently?
Untitled BoardETHR
Sep 13, 2022 - Examine user behavior in recent weeks leading up to the merge on at least 3 major protocols. Have there been any changes in the amount of ETH removed from protocols like Uniswap and Aave? Note any trends or outliers you find.
The Great Solana Royalty Debate
Nov 2, 2022 - The most controversial topic on Solana over the past month has been NFT royalties. After platforms like Yawww and Solanart moved to 0% creator royalties, and eventually Magic Eden followed, the market has been in a chaotic state. Magic Eden had cited that almost all funds for a project are coming from the mint, not royalties: https://twitter.com/MagicEden/status/1580367439824826368 Is this accurate, or a misrepresentation of how successful NFT projects have been operating? What projects have been more reliant on NFT royalties than others? What collections were wallets pivoting towards using 0% royalties more frequently? Higher royalty percentages? Higher floor volumes? Are flowing royalties a sign of project health and sustainability? How much volume from 0% royalty sales can be accounted for by wash trading rather than actual user interest? Was this actual user demand, or were decisions made based on inflated data?
Untitled BoardMESEEV
Sep 28, 2022 - Was the Merge a selling event? Why or why not? Were miners the source of sell pressure? Show any wallets miners have transferred ETH into, along with any other visualizations you think will add to your analysis.
Liquidity Providers Stats
Aug 17, 2022 - 1. Evaluate the distribution of various target segments who provide liquidity (LP): - What’s the total no. of unique LP providers? - What’s the ratio between Yield farmers vs. LP Providers? - What’s the average no. of LP positions opened by each unique wallet address - What’s the ratio of liquidity (Based on TVL) owned by the Protocol vs. Retail LP in both LP Pool and yield farms - The percentage (%) increase/decrease of LP Providers in Sushi over the last 1 year 2. Evaluate the profitability of an LP Provider & Yield Farmer - Evaluate if there’s a correlation between profitability vs. length of time? - Evaluate if there is a correlation between profit vs. time of withdrawal - Correlation between profitability vs type of pool? EX: stable pool
Arbs, Arbs Everywhere! (THORchain Bounty)
Jul 15, 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 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?
Celsius Swaps (Sushiswap Bounty)
Jun 18, 2022 - Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. From which one of their wallets did they conduct most of the swaps?
User Activity (Ethereum NFTX Bounty)
Jun 10, 2022 - Analyze user activity providing and removing liquidity from NFTX vaults. Which three vaults have seen the most activity over the past 60 days? Are there any similarities between these vaults or NFT projects? Explain and visualize your findings. Hint: fact_event_logs is probably the best table to use here.
New Year, New Solana Outage...
Apr 21, 2023 - An analysis on the recent Solana blockchain outage that occurred in February 2023. This event has caused significant disruptions to the Solana network and has impacted many users and projects relying on the platform.
Optimistic Bears
Aug 6, 2022 - Q9. Analyze Optimism during the month of July as markets were get 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?
True Freeze - 3. Timing the market, or time in the market?
Jul 29, 2022 - Identify addresses that have purchased ETH more than once and have held it for more than two years without selling any. Show the ETH buying and selling history of these addresses following their two year holding period. Is there an association between the price of ETH and the buying and selling activity of these ETH hodlers? The best submissions will compare the transaction history of long term ETH hodlers with that of frequent ETH traders. Are hodlers better at timing the market?
Untitled BoardMIS
Sep 14, 2022 - Q112. Analyze the user base of Miso. How many users does it have across how many chains? Chart that by week and by month. Has the recent bear market affected that?
Total Metamask Users
Jun 21, 2022 - Q1. How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher order activity, like staking?
Sushi Activity on Ethereum
Jun 25, 2022 - Q96. How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
Flow vs Other L1s Pt (II)
Jul 15, 2022 - How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum.
Untitled BoardPOSTMR
Sep 21, 2022 - The merge has occurred. How have users responded in days that followed? Analyze any notable trends or outliers you can see since ETH switched to POS. Compare this to user behavior in the days and weeks leading up. What major changes can you see?
Bridge Volume (Flow Bounty)
Jun 30, 2022 - Q17. What is the gross bridge activity (in usd, by day) for Blocto Teleport and cBridge to and from the FLOW blockchain?
Metamask vs. Other Platforms
Jun 21, 2022 - Q3. How many users are swapping via MetaMask vs other platforms? How much volume have these users done? Chart a comparison between the two, and show the following metrics over a time period of your choosing: transaction volume, average amount swapped, and a comparison of fees.
Untitled BoardGMXP
Sep 17, 2022 - GMX, a perp protocol, has been attracting attention recently for the massive fee revenue being generated. Examine and compare the protocol over recent days and weeks on Arbitrum. How has the protocol been performing over the past month? Three months? How is it absorbing these massive fees? Note any overarching themes or narratives that you find.
Most Common Transactions (Metamask Bounty)
Jun 25, 2022 - What are the most common transactions for Metamask users? Create an analysis that shows the most common wallet activities and the most common platforms for those activities.
Optimism "Bedrock" Upgrade
Jan 20, 2023 - Optimism recently completed a Bedrock upgrade to their testnet. This update promises to lower gas fees and allow the usage of zk proofs. Examine activity on Optimism in the days leading up to and the days following the update on January 12. Have gas fees decreased in the days since compared to before the update? Has the update had any impact on activity, new wallets, etc? Back up your assertions with data.
MergeOpenAnalyticss
Sep 24, 2022 - We want to know all about the merge — and we’re turning to you for the answers. Take a deep dive into the ETH merge and switch to POS with this Open Analytics Bounty. This is a chance to explore the topic without any specific prompt, just a direction and a reward. It’s your chance to have your brain follow your heart — got a spark of interest, or a loose thread, or a weirdly-specific question gnawing at the back of your mind? Follow it as far as you can!
Untitled BoardUNSUL2
Oct 13, 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.
NEAR Performance
Jul 16, 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.
Untitled BoardGOOD
Sep 29, 2022 - Recently, ETH devs and observers have opined on Twitter regarding whether the Merge was good or bad for the Ethereum network. We want you to prove one side or the other, with the help of Flipside data. Demonstrate whether the Merge had positive or negative effects on the network. Include least three queries and visualizations in your submission.