Ali3N
TraderJoe Meme-Coin Rush
Apr 3, 2024 - A dashboard to analyze staking pools and user participation in the Memecoin Rush campaign.
Exchange Flows in the Bear (Ethereum)
Aug 13, 2022 - Let's understand whether the bear market and recent issues with CeFi products have changed centralized exchange users' behavior. Explore trends in exchange withdrawal (specifically, moving money from CEX addresses onto the chain) patterns over the last 6 months. Have those withdrawals increased? Has the typical size of them changed? Most important: are people creating new wallets to take custody of their CeFi deposits?Also have a look at what people do after a withdrawal: are they holding their withdrawn tokens? Or are they fiat-on-ramping so they can swap, provide liquidity, buy NFTs, etc.hint: find centralized exchange addresses in [chainname].core.dim_labels where label_type = 'cex' and label_subtype = 'hot_wallet' other hint: feel free to include a couple of major chains for this analysis, but certainly at least include Ethereum
Avalanche's TraderJoe vs Blast's Thruster
Jun 24, 2024 - A Comparative Analysis of Avalanche's Pioneer DEX "Trader Joe" Vs. Blast's Pioneer DEX (Thruster)
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?
ETH Positive Price Action
Jan 19, 2023 - Let’s examine ETH's positive price action this year: Looking at Ethereum Mainnet activity from block: 16310000 (Jan 1, 2023) to block 16420000 (Jan 16, 2023) what on-chain activity could correspond to the recent increases in ETH's price? What major dapps, tokens, or similar have risen with or more than ETH over that time span? How has user activity, including in specific protocols, changed over the time period?
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?
USDC 2023 Journey in Solana vs Ethereum
Dec 29, 2023 - This analysis offers a concise exploration of the trends and activities surrounding the USDC stablecoin on Solana and Ethereum throughout the year 2023.
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
Optimism + Axelar Bridge Analysis
Mar 11, 2023 - How many unique Ethereum addresses have used both Optimism and 1 or more of the Axelar bridges? How many have used both Optimism and the Ethereum <> Osmosis bridge specifically? Of the group of addresses that have used both Optimism and 1 or more Axelar bridges, how many have used DEXs like Osmosis, Uniswap or Velodrome? How many have provided liquidity (LP) to earn yield on these DEXs?
User Behavior (redux)
Oct 21, 2022 - How is user behavior different on Optimism compared to L1? Specifically, create a comparison between swaps and transactions on ETH mainnet vs Optimism, looking for things like daily swap volume, daily active users, and average volume swapped (use a single DEX for your comparison, either Uniswap or Sushiswap). L2 is far cheaper, but by how much? What are the average fees for a swap on Optimism compared to ETH Mainnet?
Euro Stablecoin (EUROC) on Avalanche
Sep 25, 2023 - An in-depth examination of EUROC (Circle's euro-pegged stablecoin) on the Avalanche chain.
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.
DYDX Unlock
Jan 23, 2023 - DYDX holders are bracing for a massive event next month, as 105% of the circulating supply will be distributed to investors and team members. Have holders begun preparing for this massive unlock? If so, what actions are they taking to prepare? How do you expect the market to react in the weeks leading up to and following the unlock? Back up your assertions with data.
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?
Open Analytics Bounty: ETH (November 13)
Nov 13, 2022 - Open analytics bounties are all about deep dive dashboards into one specific topic.
Stablecoin Dominance (Osmosis Bounty)
Jun 24, 2022 - Q20. Compare the transaction volume for USDC, USDT, and DAI on Osmosis. Is there a stable coin that Osmosis users prefer? Extra credit: Is stablecoin dominance the same on Osmosis as it is on Sushiswap and Thorchain? Why might this be or not be the case?
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?
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.
Commodity-Backed-Stables Avalanche
May 5, 2023 - Commodity-backed stablecoins AGX & AUX are now available on the rank #1 DEX on Avalanche, TraderJoe. Let's See how these tokens are being used within Avalanche and what type of users are using them.
Sushi Stablecoin Activity
Mar 14, 2023 - An in-depth analysis of Stablecoins' activity on Sushiswap within Arbitrum, Avalanche, Ethereum, Binance Smart Chain, Optimism and Polygon Chains.
Stable Coins Lent on Kashi (Sushiswap Bounty)
Jun 14, 2022 - Draw a chart showing the TVL of Stable coins on kashi pairs across all markets. Hint: You can include USDC, USDT, DAI and UST in your analysis and look for the transactions where they are deposited on Kashi for lending. The event name would be 'LogAddAsset'. Removing them will generate 'LogRemoveAsset'.
Optimism DEXs (redux)
Oct 22, 2022 - Let’s take a closer look at DEXs on Optimism. Make a dashboard that compares at least three DEXs.
The Flippening Comparison
Jan 13, 2023 - It finally happened. The great Flip everyone’s been waiting for — Optimism and Arbitrum have officially surpassed Ethereum in combined transaction volume. (What, you were expecting some other flippening?) Use this historic event to compare and contrast these two major L2 chains. Include metrics such as total and average transaction volume, average transaction size, active users, new users added, and anything else you find relevant to this comparison.
Failed Transactions
Sep 29, 2022 - Which user action results in the highest rate of failed transactions? Compare swapping, borrowing, lending, and adding or removing liquidity on Sushiswap-Ethereum.
Are Crypto-backed Stablecoins Broken?
Sep 8, 2023 - This dashboard offers a comprehensive comparison between crypto-backed stablecoins and the dominant players, USDT and USDC, within the Avalanche chain. We delve into their activity, adoption, and user trends to provide a clear picture of their respective positions in the stablecoin landscape. Join us in uncovering which stablecoin model truly reigns supreme.
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!
Avalanche BTC.b Bridgooors
Mar 10, 2023 - The behavior of wallets that have used the BTC.b bridge on Avalanche and what they are doing with it.
ETH Down Bad
Nov 23, 2022 - The price of Ethereum has sank in recent days - how does it compare to other tokens amid a general market downturn? Can you find evidence of any potential causes for ETH's struggle? Are there any other indicators that could help us predict whether/when it could recover?
Impact of "Base" Announcement & The Activity of "Meet Base" NFT on Optimism
Mar 4, 2023 - What Has Happened on Optimism During The Announcement of Coinbase's "Base" Launch on Optimism?
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.
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?
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.
Up The Mountain
Feb 15, 2023 - An Avalanche has been building up steam as of late — the price of AVAX rose by nearly 100% in the month of January and BTC hodlers have been moving holdings to the Avalanche chain. What’s been fueling this growth over the past month — and what does the future hold for Avalanche? Will this growth continue into the new year? Or will growth stagnate as 2023 continues to progress?
Who's Escaping FTX?
Nov 16, 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.
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 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?
USDC Depegging Crisis After SVB Bankruptcy
Mar 12, 2023 - What's going on with USDC on the Ethereum chain after the Circle announcement and Silicon Valley Bankruptcy?
Euler Finance Exploitation
Mar 14, 2023 - On March 13th at approximately 8:50 UTC Euler Finance was exploited for - $197M in token value. Due to a flaw in the "Etoken" implementation (EToken::donateToReserves) an exploiter was able to create "bad debt" within the protocol. The dashboard provides some useful insights about this protocol's Exploitation on 13th March 2023.
USDC Activity on Optimism During Binance Conversation Announcement and Circle Announcement
Oct 1, 2022 - Analyse the USDC activity on Optimism network during 2 weeks prior to the Binance Conversation Announcenemnt about delisting this token from its platform and converting it to BUSD and also during Circle announcement to launch USDC natively on Optimism.
wETH Deposit Rate (Osmosis Bounty)
Jun 14, 2022 - Q11. Calculate the deposit rate of wETH over time on Osmosis. How does this compare to SushiSwap and Thorchain now? How does the wETH deposit rate compare to when wETH was a relatively new asset (or the protocol was relatively new)? Is Osmosis growing at a faster rate than Thorchain and Sushiswap? Hint: There are two types of wETH on Osmosis, wETH from the Gravity Bridge (gwETH) and WETH from the Axelier Bridge (axlWETH).