Discover expert insights on leading blockchains and protocols.
Curve.fi Stablecoin Pools
Mar 16, 2023 - Navigating the USDC Crisis through Curve Pool Analysis
Cryptopunk Sales and Traders
Aug 26, 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.
Hacks, Scandals and Scams - 4. CEL token flows.
Jul 28, 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?
Celsius Swaps
Jun 17, 2022 - Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. From which one of their wallets did they conduct most of the swaps?
Liquidity Provider Stats
Sep 9, 2022 - In this dashboard we evaluate the effectiveness of a yield farm program - wstETH/DAI Incentive revards - in attracting TVL: - What’s the average TVL of the LP Pool before the start of liquidity mining (LM) - What’s the percentage (%) increase in APR incentivized by Projects via LM (optional) - How much percentage (%) increase in TVL was achieved via LM - How much percentage (%) conversion of LP providers to Yield farmers during the active LM - What’s the average duration of LM - After the end of LM program, how much (%) of TVL is pulled out from pool
Squid DEX Usage
Apr 10, 2023 - The dashboard focusing on the DEX usage in EVM chains for Squid Router that perform General Message Passing (GMP).
WBTC performance . 2023 .
Mar 15, 2023 - In this dashboard, I have reviewed the performance of wbtc since the beginning of the new year.
Liquidity Providers Stats
Aug 24, 2022 - 1. Evaluate the distribution of various target segments who provide liquidity (LP) 2. Evaluate the profitability of an LP Provider & Yield Farmer
Lido: HODL or SELL
Jun 15, 2022 - Lido is liquid staking for Ethereum where the user can stake their ETH for stETH for the profits. In this report, the daily amount of holders has been investigated to see the trend of whether they are likely to hold the stETH or sell it into the market within the recent 90-day activity.
Sushiswap - 4. Sushi Stablecoin Activity
Mar 17, 2023 - What are the most actively traded stables on Sushi on Ethereum, Optimism, Arbitrum, and others? Chart monthly volume and inflow/outflow of stablecoins through Sushi on various chains. Which chain has seen the most stablecoin activity pick up in the last 3 months?
MetaMask Versus UniSwap and SushiSwap
Jun 25, 2022 - In this dashboard we are going to see some information about Metamask users and compare them to other well known platforms of UniSwap and SushiSwap...
Analysis on Base
Mar 15, 2024 - This report comprehensively analyses Wallet Frequency, user engagement, User retention and recency, and financial transactions. The focus is on metrics such as total user count, active users, transaction volume, user retention, and the popularity of traded tokens. The data suggests user behaviour, growth patterns, and financial performance. The aim is to provide insights into the retention rate, the strengths and potential areas for improvement from a Marketing Perspective.
Open Analytics Bounty: ETH (October 30)
Nov 4, 2022 - Open analytics bounties are all about deep-dive dashboards into one specific topic.
Open Analytics Bounty: ETH vs Solana
Sep 15, 2022 - Open analytics bounties are all about deep dive dashboards into one specific topic. For this bounty, submissions should compare ETH + Solana in some way.
[Optimism] User Behavior (redux)
Oct 26, 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?
Open Analytics Bounty: ETH vs Solana
Sep 30, 2022 - Open analytics bounties are all about deep dive dashboards into one specific topic. For this bounty, submissions should compare ETH + Solana in some way.
ETH Derivatives
Sep 13, 2022 - Consider the liquid staking ETH derivates from ankr, rocketpool and lido(aETH , rETH and stETH ). What are some trends around the price volatility for these tokens? Swap activity?
Sushi-95.Celsius Swaps
Jun 19, 2022 - -- Q95. Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. -- From which one of their wallets did they conduct most of the swaps? -- Hint: you can find all addresses belonging to Celsius network by querying this table: flipside_prod_db.crosschain.address_labels
EVM - 3. Merry Christmas?
Jan 13, 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?Choose an Ethereum chain, fork or Layer 2, such as BSC, Polygon, Arbitrum, Optimism, or Mainnet.Create a dashboard that captures activity across metrics such as new users onboarding, token prices, NFT prices, or any other notable trends or events for your chosen chain. Feel free to examine multiple chains or ecosystems in your dashboard.