Ali3N
TraderJoe Meme-Coin Rush
Apr 3, 2024 - A dashboard to analyze staking pools and user participation in the Memecoin Rush campaign.
CLY Insights Hub
May 14, 2024 - An in-depth analysis of $CLY (Colony Lab's native token) on the Avalanche blockchain.
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.
Avalanche Memecoin Mania
Mar 13, 2024 - This dynamic dashboard is designed to capture the excitement of the meme-coins within the Avalanche ecosystem.
Avalanche's BenQi Dashboard
Jan 26, 2024 - An analysis to discover the dynamics of BenQi's protocol on the Avalanche chain, analyzing yield farming, liquidity provision, and lending activities.
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'.
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.
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 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)
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.
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.
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?
Euro Stablecoin (EUROC) on Avalanche
Sep 25, 2023 - An in-depth examination of EUROC (Circle's euro-pegged stablecoin) on the Avalanche chain.
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.
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.
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 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?
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.
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?
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?
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)?
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.
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.
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?
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
Open Analytics Bounty: ETH (November 13)
Nov 13, 2022 - Open analytics bounties are all about deep dive dashboards into one specific topic.
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.
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.
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?
Sushi Revenue (Sushiswap Bounty)
Jun 29, 2022 - Q98. What is the breakdown of revenue by unit for sushi? (swaps, kashi, etc)
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.
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.
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.
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.
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?
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.
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?
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.
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.