Ali3N
CLY Insights Hub
May 14, 2024 - An in-depth analysis of $CLY (Colony Lab's native token) on the Avalanche blockchain.
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.
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
ETH Deposited or Withdrawn (StarkWare Bounty)
Jun 25, 2022 - Q1. StarkNet is a layer 2 chain, that ensures interoperability with the Ethereum mainnet. People are using it to move real ETH to StarkNet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors? Hint: Each deposit/withdrawal on StarkNet is done through the StarkNet proxy contract on Ethereum: 0xae0Ee0A63A2cE6BaeEFFE56e7714FB4EFE48D419. The logs will tell you more.
Distinct Wallets (Optimism Bridge)
Jun 15, 2022 - Many blockchain bridges exist allowing users to move assets between different blockchains. One of the blockchains currently receiving a lot of bridge volume is Optimism. There are several bridges you can use to move tokens to Optimism, but for this bounty we are particularly interested in Optimism’s bridge. You can find more information on their native bridge here and here. How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
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
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.
Lending Wars: Avalanche's Benqi vs NEAR's Burrow
Aug 17, 2024 - This dashboard provides a comparison of two major DeFi lending protocols, Benqi Finance on Avalanche and Burrow on NEAR Protocol.
User Activity (Ethereum NFTX Bounty)
Jun 10, 2022 - Analyze user activity providing and removing liquidity from NFTX vaults. Which three vaults have seen the most activity over the past 60 days? Are there any similarities between these vaults or NFT projects? Explain and visualize your findings. Hint: fact_event_logs is probably the best table to use here.
Sushi Activity on Ethereum
Jun 25, 2022 - Q96. How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
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.
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.
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?
Sorare Compete With Collectibles
Nov 21, 2022 - Sorare is a digital, playables and collectibles platform where users can compete across futbol, NBA, and MLB in a fantasy sport setting. Build a dashboard that covers the Sorare project: Statistics on Sorare NFTs being sold on Opensea such as buyers, volume, number of NFTs etc Transfers and mints over time Statistics on contract events such as players and clubs added Provide additional insight into the players and clubs added in from the event inputs
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?
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?
Opensea Fees (Polygon Bounty)
Jul 28, 2022 - Q6. Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
Largest Tokemak DEX Pools
Jun 21, 2022 - Q3. What are the largest dex pools for TOKE (UNI, SUSHI, etc.)? What is the behavior of TOKE holders on these token pools currently?
Bridge Volume (Optimism Bridge)
Jun 17, 2022 - Q2. Compare user bridge volume on the Optimism Native Token Bridge vs. another Mainnet <-> Optimism Bridge of your choosing (e.g. Hop). Can we conclude if there are differences in the types of users or transactions using the native bridge vs. the non-native bridge?
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?
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.
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.
2023 GMX Traders Analysis (Arbitrum)
Feb 20, 2023 - an in-depth analysis of traders utilizing the GMX platform on Arbitrum in 2023.
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
$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?
True Freeze - 1. Early Redemptions
Jul 26, 2022 - True Freeze users can pay a fee to unlock their ETH early. What is the sum of fees paid for early unlocks? So far, what percentage of locked ETH was unlocked early?
SNX, UNI & MKR Borrowing Activity on Aave v2
Mar 8, 2023 - an in-depth analysis of borrowing activity on SNX, UNI, and MKR pools in the AAVE protocol (version 2).
2022 Retrospective
Dec 21, 2022 - Let’s explore some key indicators of the health of the Web3 industry. Project ETH supply growth for 2023 by using various average gas prices. What is the highest value DEX swap, by protocol? Where was there the most DEX swaps by protocol? Which were the highest gas consuming NFT mints?
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?
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.
Untitled BoardGMXP
Sep 17, 2022 - GMX, a perp protocol, has been attracting attention recently for the massive fee revenue being generated. Examine and compare the protocol over recent days and weeks on Arbitrum. How has the protocol been performing over the past month? Three months? How is it absorbing these massive fees? Note any overarching themes or narratives that you find.
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?
Long vs Short Option Contracts (Opyn Bounty)
Jun 28, 2022 - Q2. How many long vs short option contracts have been bought on opyn? What’s their value? Has there been any liquidations?
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.
Uniswap NFT Aggregator
Dec 16, 2022 - Show daily transaction volumes on Uniswap's NFT aggregator. Describe in your own words the benefits of using this marketplace to trade NFTs. Optionally, you may also show some of the following data: Gas savings (if any) on the Uniswap NFT aggregator compared to other NFT aggregators on the same chain. Genie users USDC airdrop statistics.