Ali3N
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.
Avalanche ↔ Aptos: Bridging Dashboard
May 15, 2024 - This dashboard provides real-time insights and analytics on bridging activity between Avalanche and Aptos blockchains (Mainly via LayerZero & Wormhole). Users can customize their analysis by setting a specific time frame with the provided `Start_Date` and `End_Date` parameters, allowing for detailed examination of cross-chain transactions, bridge performance, and traffic trends within their chosen period.
Avalanche vs. Blast: A Comparative Analysis
May 3, 2024 - Compare Avalanche vs. Blast blockchain activity in any timeframe.
The Rise of Tensor on Solana
Mar 13, 2023 - Tensorswap is an NFT marketplace built for traders (think Blur on Solana). Recently, the first season of rewards for their airdrop was released with similar reward mechanics as Blur along with the start of season 2. Since then, activity on the marketplace has started to heat up and Tensor has risen to being the 2nd largest marketplace on Solana only behind Magic Eden and climbing. In this dashboard and using Flipside's newly curated Tensor NFT sales data, you are gonna see an in-depth analysis of this marketplace since its debut.
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.
Avalanche's Struct Finance
Feb 4, 2024 - Explore an in-depth analysis of the Struct Finance on the Avalanche chain. This dashboard delves into key metrics, providing insights into the platform's vaults, contributors, unique features, and its significance in the evolving landscape of decentralized finance on Avalanche.
Blur.io NFT marketplace
Dec 7, 2022 - Blur is a recently launched NFT marketplace built for pro traders with 0% marketplace fees and flexible royalty payments. There are multiple rounds of airdrops based on user activity on the platform. Compare the activity on blur with other NFT marketplaces (like Opensea).
NFT Royalty Comparison
Oct 4, 2022 - Which platform is the king of NFT royalties? Compare royalty payouts of 3 NFT marketplaces. Then choose at least 2 additional metrics to evaluate the impact of royalties on NFT market activity.
BAYC and Ape Staking
Dec 7, 2022 - In light of the Bored Ape Yacht Club's introduction of Staking, provide an analysis on the token and project. Provide data on APE token distribution in March 2022 and show how the activity has evolved since. Share analysis on future emissions schedule. How have the first hours of APE staking been? How do the staking rewards for each pool compare? Provide any relevant data.
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 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.
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?
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.
Merge Staking Providers
Sep 1, 2022 - Choose 1 liquid staking provider (Ankr / Lido / rocketpool, etc) and answer the following question: How much ETH was staked? How many unique depositors are there? What is the avg/median/max/min/distribution of ETH deposits?
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?
Top Brands Launching NFTs
Feb 1, 2023 - Quite a few non-Web3-native companies have gotten involved in NFTs — Reddit, Starbucks, Porsche, Nike, the NFL, and others across chains like Ethereum, Polygon, Flow, and more. How does each project compare, and does choice of chain seem to affect outcome? (Include any metrics you think are relevant — mint and trading volume, total revenue/royalties, unique wallets, hold time, etc).How has each project fared since launch? Have volumes fallen off, did are there any unusual effects on activity? Compare results with at least one Web3-native NFT project of your choice - how do the top brands' projects compare to the industry native one(s) you've chosen?
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.
FTX, Alameda and the Solana ecosystem
Nov 10, 2022 - How has the recent tumult surrounding FTX and Alameda impacted SOL and the Solana ecosystem?
DEXs Season
Dec 1, 2022 - With the collapse of FTX, do users want to remove their crypto from centralized exchanges and use decentralized options for trading?
USDC Deposits (PoolTogether Bounty)
Jun 20, 2022 - In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
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)
Kitaro World Official
Oct 29, 2022 - Kitaro World Official was one of the most hyped NFT projects during the recent weeks. perform a deep analysis about its sales and trades activity.
Bridger Destinations (Polygon Bounty)
Jul 27, 2022 - Q5. Where do people go when they bridge to Polygon from Ethereum? What are the 10 most popular first destinations for Polygon addresses that have just bridged from Ethereum?
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?
Secrets of the NETH-er World
Mar 1, 2023 - The day that many citizens of the City of Near had been waiting for finally arrived late last year. As of December 19, 2022, NEAR is compatible with MetaMask, marking the first time a non-EVM chain has offered compatibility with the popular ETH wallet. This was made possible by a smart contract called NETH. Now that the contact and ensuing compatibility has been live for nearly three months, it's time to dive deeper into the data.
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.
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.
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
Polygon Hard Fork
Feb 18, 2023 - ETH-scaling project Polygon completed a hard fork last month in hopes of reducing gas fees, as well as disruptive chain reorganizations known as "reorgs,” according to Coindesk. Let’s dive into the network’s health and performance leading up to and since the hard fork. Has the software upgrade led to lower gas fees as hoped? Have these changes affected any meaningful user metrics, such as volume, activity, monthly active users, or others?
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.
Aave - 10. Aave Transaction Explorer
Aug 9, 2022 - Create a transaction explorer similar to Etherscan but for Aave.
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?
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.
Aave - 7. AAVE and stAAVE movements
Aug 6, 2022 - Create visualizations showing the following: Daily AAVE supplied and withdrawn on Aave protocol. Daily AAVE staked and unstaked.
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 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.
Uniswap Phishing Attack on July 2022
Jul 26, 2022 - On July 2022, there was a phishing attack on Uniswap using a fake airdrop announcement. Describe anything interesting about this attack and its victims.
Ailing Alameda
Nov 8, 2022 - Analyze what Alameda is experiencing. Rumors over the weekend began swirling that alameda research is on the brink of insolvency. Observe net in and outflows of USD tokens from known Alameda or FTX accounts throughout different chains. Are they going somewhere specifically? Are there any signs of potential insolvency?
Flow Down Bad Really?
May 3, 2023 - Recently, an article published by The Block has raised concerns about the success of Dapper Labs' projects such as NFL All Day and NBA TopShot. However, we believe that some of the data presented in the article might be misleading. To provide a comprehensive comparison and clear any confusion, we suggest conducting a thorough analysis of the top NFT collections on FLOW, Ethereum, and Solana.
Aave - 1. AAVE Flash Loan Users
Jul 28, 2022 - Flash Loans allow users to borrow any available assets without putting up any collateral, as long as the liquidity is returned to the protocol within one block transaction. Show the frequency and volume of AAVE Flashloan use in 2022. Create a profile for a typical Flashloan user in 2022. Some of the metrics to look at could be wallet balance, transaction frequency, and dapps usage.
Optimism Bridger Destinations (Redux)
Oct 29, 2022 - Where do people go when they bridge to Optimism from Ethereum? What are the 10 most popular first destinations for users that have just bridged from Ethereum? What has this been for each day in the past month? How has this changed over the last three months? Last six months?