Ali3N
Pool of The Week
Dec 3, 2022 - Since the start of November, the Osmosis Support Labs team has run the Pool of the Week program, highlighting important and/or new pools within the ecosystem. What kind of impact has this program had on the liquidity of these pools?
Aave - 10. Aave Transaction Explorer
Aug 9, 2022 - Create a transaction explorer similar to Etherscan but for Aave.
What's Going on with BUSD in AAVE Protocol ?
Feb 23, 2023 - Following the recent developments between Paxos (minter of BUSD) and the SEC, Paxos will stop minting BUSD from April 2023 and will only allow redemption for their underlying value by burning BUSD. The circulating supply of BUSD will thus trend toward zero over time. This ARFC presents the Aave governance with the opportunity to freeze BUSD reserve on the Aave V2 Ethereum market.
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?
Hacks, Scandals and Scams - 3. Whales On Alert
Jul 23, 2022 - Identify active wallets with a high balance of ETH (whales). Visualize the ETH transaction history of these whales in May and June 2022.
Cryptopunk Sales and Traders
Aug 27, 2022 - Which 10 wallets are the most successful Cryptopunk traders? Successful could either mean the wallet has accumulated a large balance from sales or has accumulated a large number of Punks. Explain your methodology and findings.
Reddit Avatar Holders
Nov 7, 2022 - Reddit Avatars (https://nft.reddit.com/) have picked up a lot of attention recently. Trading volumes have been extremely high, and there are almost 3 million wallets holding an Avatar. At first glance, it seems like Reddit has done an amazing job onboarding millions into web3, but let's dig deeper. Describe the web3 experience level of Reddit Avatar holders. Is this their first NFT? Or have they been interacting with NFTs and other web3 dApps for a while? What do new wallets do after receiving their Reddit Avatar? Are they actively exploring web3, or have they been inactive? Analyze trading activity of the NFTs.
Tornado Cash Sanctions
Aug 10, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online. (Hint: we also have them in our crosschain address labels table as well). What is Tornado Cash and why would it be targeted by the US government? Why might an address interact with the service? The addresses tied to the service have been publicly posted online. Using those addresses answer the following: How many addresses are still using the service despite the sanctions? Which addresses have been interacting the most with Tornado Cash? Break the addresses down by frequency and volume of tokens and describe how the groups are using the service differently. Is there anything else interesting about its users?
Open Analytics Bounty: ETH (November 13)
Nov 13, 2022 - Open analytics bounties are all about deep dive dashboards into one specific topic.
NFT crosschain showdown: y00ts vs Art Gobblers
Nov 23, 2022 - Two freshly launched NFT projects are going viral: the Art Globbers (on Ethereum) and yOOts (on Solana). Create a dashboard that compares the two projects.
Tornado Cash Addresses
Aug 10, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online. (Hint: we also have them in our crosschain address labels table as well). Using those addresses: Which of the Tornado Cash addresses received the most # of transactions in the last month, quarter, year Which addresses received the most transaction volume (worth) in the last month, quarter, year Over all the addresses, group the transactions into buckets by value. How many tx in the 0.01-0.1 ETH range went to Tornado? How many in the 0.1-1ETH range? How many in the 1-10ETH range? How many in the 10-100 ETH range? How many above 100 ETH? (split further if better)
True Freeze - 4. My Next Purchase
Jul 27, 2022 - What is the most common transaction (any transaction) users make after minting frETH?
Hacks, Scandals and Scams - 2. Bored Phish
Jul 24, 2022 - This spring the Bored Ape Yacht Club Discord and Instagram accounts were hacked. The hackers sent a phishing link to the community. As a result of this phishing scam, users lost some Bored Apes, Mutant Apes, and other assets. How many NFTs were stolen? What is the total value of all NFTs stolen? Show the percentage of compromised wallets that bought back more NFTs from the same collection that was stolen.
Quix vs Magic Eden vs OpenSea
Sep 24, 2022 - Create a dashboard highlighting at least 3 metrics comparing marketplace performance and adoption between Quix (formerly Quixotic) on Optimism, Magic Eden on Solana, and OpenSea on Ethereum, since July of this year. What has been the rate of change of these metrics since the start of the new year and are there any signs of growth of a certain marketplace or ecosystem of NFTs? Highlight the 5 most popular NFT collections for each marketplace over that timeframe in terms of sales volume. Is the turnover rate (number of transactions) for collections on Quix noticeably higher than on OpenSea and Magic Eden? Provide some insights on these findings.
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.
Aave and stAave Movements on Ethereum Mainnet
May 31, 2023 - An in-depth examination of AAVE token movement on the Aave protocol specifically occurring on the Ethereum Mainnet, including both supply and withdrawal activities, as well as the daily staking and unstaking of AAVE tokens.
NFT Wallet Behavior Comparison (Flow Bounty)
Jul 15, 2022 - Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to Ethereum and Solana. Is there more or less "whale" activity on Flow compared to each of the other chains? What do "whales" tend to focus on in Flow? How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? Are wallets more interested in new projects, or already existing projects on Flow?
True Freeze - 8. FRZ Airdrop Activity After Claim
Aug 4, 2022 - Approximately 230,000 addresses are eligible to claim FRZ. What percentage of all eligible addresses have claimed the airdrop? After claiming their allotment in the FRZ airdrop, what do participants do with their FRZ tokens?
KPverse (KPR) vs YuGiYn NFTs
Nov 25, 2022 - a comparison of KPR vs YuGiYn NFT projects on Ethereum on the occasion of their recent hype.
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.
Impact of FTX & Alameda on Solana Ecosystem and FTX,Alameda-Invested Tokens
Nov 19, 2022 - How has the recent tumult surrounding FTX and Alameda impacted SOL and the Solana ecosystem?
A Surge of Optimism
Dec 16, 2022 - The price of Optimism (OP) fell sharply in early November, dropping from highs above $1.30 on November 6 to as low as $0.79 on November 9. In the weeks since, prices have been on the rise, with OP hit $1.19 on December 14. Analyze the network and diagnose some of the possible reasons for the sudden drop, and slow climb, of OP price in recent weeks. Are there any notable trends in users, transactions, or any other metrics that could explain these events? Note any patterns or outliers you see.
FTX, Alameda and the Solana ecosystem
Nov 10, 2022 - How has the recent tumult surrounding FTX and Alameda impacted SOL and the Solana ecosystem?
OPtimitic or Pessimistic?
Oct 16, 2022 - Are you optimistic or pessimistic about the future of the layer-2 chain known as Optimism? How do you think it will fare going forward compared to other L2s?
Solana Surpasses Ethereum in NFTs (December 2023)
Jan 3, 2024 - Solana NFT Sales Skyrocket, Topping Ethereum in Monthly Volume for First Time!
DEX Change (Osmosis)
Nov 12, 2022 - This week has highlighted the need for transparency & decentralization in crypto markets. Let's see how users have reacted to this wild week in Web3. Have behaviors changed? Analyze growth in Osmosis Volumes & User Count this week. Has more money flowed into Osmosis this week compared to the past few weeks/months? Where is this money coming from? Centralized Exchanges? Have wallets moved more into stables?
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?
LUNA Price Run Investigation (Terra)
Jan 12, 2023 - Beginning in the wee hours of Monday, January 9 (ET), the price of LUNA skyrocketed, from $1.37 to a high of nearly $2 before settling down at roughly $1.60. Identify some of the major reasons for this recent upshot in price, and back up your assertions with data. Why did the price jump so suddenly on Monday night? Will prices remain at, or above, current marks in the coming weeks or will it return to at or near $1? Why?
Optimism Bridge Analysis 2
Oct 19, 2022 - Describe activity across Optimism bridges. Where are assets coming from, where are they going, and how are they used? How does activity on custom bridges compare to the standard Optimism bridge? Include any other questions or insights you find interesting.
Derivative Daze (GMX vs Gains Network)
Feb 1, 2023 - Derivatives DEX Gains Network recently crossed a major milestone, with more than $1.5 million in trading volume on Arbitrum, fueling further interest in derivatives trading on the platform. create a dashboard that shows some data for Gains Network and any other derivatives trading markets you can find.
Layer 2 Blocks (Starkware Bounty)
Jun 26, 2022 - Q2. How many layer2 StarkNet blocks have been accepted on Ethereum (L1) chain so far? How much fees have been paid(generated) to Ethereum network? Has StarkNet contributed to saving in transaction fees for its users?
Axelar's Squid Launch Analysis
Feb 10, 2023 - Background: Axelar’s first ecosystem project, Squid, launched last week as a cross-chain liquidity router. Analyze Squid’s first week of activity.
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.
Pooly NFTs (Pool Together Bounty)
Jun 19, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
Optimistic Bears (Redux)
Nov 4, 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?
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.
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
Aave Delegates' Gas Usage
Mar 17, 2023 - An analysis of gas used by delegates voting in AAVE protocol during the past 90 and 180 days.
Quixotic NFT Dashboard (Optimism Bounty)
Jul 30, 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.
FLOW Speed (redux)
Dec 9, 2022 - Flow is fast, but how fast? 6 months ago, we asked for a comparative analysis on blockchain speed - how has Flow increased its speed in transaction per minute since? Compare Flow and other L1 blockchains in terms of speed: identify the monthly average for transactions per minute, and how that's improved or worsened since the beginning of 2022. What types of events have raised or decreased the blockchain's performance over that time period? Are there bursts of transaction volume or interest on the chain? Compare Flow's speed to at least two other blockchains.
Comparing The Top Projects on NEAR
Nov 17, 2022 - Let’s take a closer look at some of the biggest and best-known projects in the NEAR ecosystem. Choose one of the Top projects in the NEAR ecosystem (a list can be found below). Analyze the project and its health.
Merry Christmas?
Jan 6, 2023 - The holidays and New Year are often chaotic in the crypto and defi space, as users make a spree of new transactions and wallets as they receive (and give) some cash and coins as holiday gifts. How has this activity impacted the broader Ethereum ecosystems? Are users creating new wallets or buying tokens with their newfound holiday wealth? Are they staking all these new tokens once they get them? Or are they selling tokens to pay for their own gifts and holiday travel?