Ali3N
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.
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).
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.
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'.
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?
FTX, Alameda and the Solana ecosystem
Nov 10, 2022 - How has the recent tumult surrounding FTX and Alameda impacted SOL and the Solana ecosystem?
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?
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.
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.
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.
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.
Who's Got The Flow?
Nov 25, 2022 - Who is holding the most FLOW? Build a list of rankings to help us find the address with the most FLOW tokens. Identify any trends or outliers you see in this collection of whales. Bonus points if you can identify the wallet holders.
Blast Network Overview
Mar 1, 2024 - This dashboard offers a real-time glimpse into the performance and key metrics of Blast Network, a cutting-edge Ethereum Layer 2 solution
Not Your Keys
Nov 15, 2022 - In wake of the issues surrounding FTX, the old adage "not your keys, not your crypto" reinforces itself. Let's see how this played out during the fallout. Did bridge activity spike over the last 7 days? If so, to what ecosystems? At a more granular level, track net outflows from FTX onto Ethereum. Did any of these outflows flow across Satellite to another destination chain?
$MATIC Liquid Stakingg
Sep 20, 2022 - Define what liquid staking is in your words, and evaluate the different liquidity staking options based on three different metrics of your choice Bonus: How do people use these "liquid" derivatives? Do you see any trends?
Ethereum Name Services (ENS) Retrospective in 2022
Jan 8, 2023 - An Overview of ENS in The Year 2022 and its Comparison vs Other Years.
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?
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.
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?
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.
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.
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.
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.
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?
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.
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.
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.
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.
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)?
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
Opti Azuki Club NFT Collection
Oct 29, 2022 - One of the most trending NFT collections on Optimism during recent days is Opti Azuki Club. This collection is currently among the most hyped NFT collections on both Opensea and Quixotic marketplaces. Make a deep analysis of this collection and note any interesting trends or notes.
Sushi Revenue (Sushiswap Bounty)
Jun 29, 2022 - Q98. What is the breakdown of revenue by unit for sushi? (swaps, kashi, etc)
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?
Optimism NFT Purchasing Behavior
Oct 14, 2022 - Show the distribution of all NFT sales on Optimism by price. What percentage of all sales have been above .01 ETH? Above .1 ETH? 1 ETH? Do you think that there is a limit to how high a floor for a NFT collection on Optimism can reach compared to on Ethereum?
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.