Ultimate Pangolin DEX and PNG Token Dashboard
Mar 11, 2024 - an in-depth dashboard of Pangolin DEX on Avalanche. Offering real-time insights into trading activity, user behavior, and PNG token analytics.
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
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.
Open Analytics Bounty: ETH (November 13)
Nov 13, 2022 - Open analytics bounties are all about deep dive dashboards into one specific topic.
Hacks, Scandals and Scams - 4. CEL token flows.
Jul 23, 2022 - Celsius Network listed a $1.19 billion deficit on its balance sheet in a bankruptcy court filing a day after the cryptocurrency lender filed for Chapter 11. Currently Celsius owns a large portion of the CEL tokens. What are the top addresses swapping and transferring CEL? How have the CEL swap volumes changed over the past 90 days? How are Celsius wallets interacting with the CEL token?
Sushi and the Merge
Sep 29, 2022 - The Ethereum merge brought some uncertainty to DEFI markets. It got many market makers (MM) to remove liquidity from defi to lower their risk. After the merge, some have redeployed the liquidity, and some haven't. Analyze the behavior of Sushi MMs 2 weeks prior to and after the merge. How much capital did they withdraw? which pools/chains got affected the most? Have they redeployed back their capital? Can we say anything about their identity (Tokemak, etc)?
What's going on with USDC on Optimism?
Mar 24, 2023 - An analysis to realize what is going on with USDC on the Optimism chain after its depeg crisis on March 2023.
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.
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?
TraderJoe Meme-Coin Rush
Apr 3, 2024 - A dashboard to analyze staking pools and user participation in the Memecoin Rush campaign.
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?
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.
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.
Euro Stablecoin (EUROC) on Avalanche
Sep 25, 2023 - An in-depth examination of EUROC (Circle's euro-pegged stablecoin) on the Avalanche chain.
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.
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?
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.
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?
Avalanche and Its Sushiswap and TraderJoe During FTX Collapse
Nov 25, 2022 - A Comparison of Sushiswap vs TraderJoe on Avalanche Chain During FTX & Alameda Collapse.
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'.
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?
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.
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?
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?
Sushi Revenue (Sushiswap Bounty)
Jun 29, 2022 - Q98. What is the breakdown of revenue by unit for sushi? (swaps, kashi, etc)
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)
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.
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.
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?
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.
USDC on AVAX vs L2s
Jun 18, 2023 - an in-depth comparison of Circle's USDC usage in Avalanche VS layer2 blockchains (e.g: Arbitrum, Polygon and Optimism)
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.
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
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.
Avalanche DEXs Comparison Tool
May 2, 2023 - This dashboard serves as a comprehensive comparison tool for decentralized exchanges (DEXs) within the Avalanche ecosystem, providing users with valuable insights and enabling them to make informed decisions. By keeping users updated on the latest exchanges available and allowing them to compare their options, this tool facilitates seamless and efficient trading experiences.
ETH Flash Bounty: What’s Next?
Sep 30, 2022 - The Merge has come and gone — what will be the next story, trend, or outlier to dominate the ETH space? Identify at least 3 developing trends or events that could have a large impact on Ethereum between now and the end of this year. Back up your assertions with data and visualizations.
USDC & USDT Activities Around Coinbase & Binance News During December 2022
Dec 16, 2022 - an overview of USDC & USDT activities during December 2022 and the impact of Coinbase & Binance hot news on them.
TUSD De-pegging!
Jan 16, 2024 - Explore the TUSD On-Chain Activity Analysis Dashboard for a concise breakdown of TrueUSD's (TUSD) journey from de-pegging to the present moment.
