Discover expert insights on leading blockchains and protocols.
SUSHI Noobs II
Jun 17, 2022 - What is the first thing new users do when they acquire SUSHI?
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.
Survey across Uniswap-v3, Curve, Sushiswap, Balancer
Feb 22, 2024 - This Dashboard shows the key metrics reflecting the activity and performance across Uniswap-v3, Curve, Sushiswap, Balancer from January 1st, 2023 till February 22nd, 2024. Metrics Used: ⛓ Trading Volume ⛓ Number Of Transactions ⛓ Active Users.
WBTC performance 2023
Apr 6, 2023 - In this dashboard, I have reviewed the performance of wbtc since the beginning of the new year. Wrapped crypto or wrapped tokens are digital assets that; represent the exact value of an original cryptocurrency from a different blockchain or follow a different token standard to the chain its on. WBTC and WETH are good examples of the former and latter respectively.
What's going on with USDC on Optimism after depegging?
Mar 28, 2023 - The intention of this dashboard is to take a deep dive look about USDC movements on Optimism since the SVB news and its depegging.
USDC De-peg!
Mar 17, 2023 - This analysis focuses on the recent USDC de-peg on the Ethereum chain and examines the user response to this event over the past two weeks.
Sushi and the Merge
Oct 4, 2022 - 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)?
What's going on Bebop?
Nov 2, 2022 - Detail of Bebop's new contract on both Ethereum and polygon
Curve Trading Volume & Dynamics
Nov 21, 2023 - We performed an exploratory data analysis about the Curve DEX protocol and investigated why Curve is one of the prominent protocols when it comes to stability.
Liquidity Providers Stats
Aug 24, 2022 - Q109. Liquidity providers stats 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
ZigZag exchange airdrop: $zz bridges to Ethereum
Mar 6, 2023 - Tracking bridged $zz tokens to Ethereum
SVB Bank Collpase
Mar 23, 2023 - As a DeFi analyst, I've been closely tracking the impact of the recent USDC depegging crisis on the DeFi ecosystem using flipside warehouse, Sql and excel. One important question that has arisen is which stablecoins were affected by the depeg and how it impacted the market. After USDC's depeg, many users were concerned about potential losses and decided to sell their USDC. The majority of these users converted their USDC to other stablecoins, with the largest swap being from USDC to USDT, followed by WETH. This shift happened quickly, with the majority of swaps taking place in the first hour and transaction volumes gradually declining over time. It's interesting to note that in the early hours following the depegging event, many users showed fear and transferred their assets to both centralized and decentralized exchanges (CEXs and DEXs). Approximately 70% of the transferred amount went to these exchanges, with Coinbase receiving the largest amount of USDC among CEXs. Overall, this event highlighted the importance of risk management in DeFi and the potential risks associated with stablecoins. As DeFi continues to grow and mature, it's crucial for investors and analysts to stay informed and make informed decisions to mitigate risks and ensure sustainable
Open Analytics - 26. Optimism
Mar 10, 2023 - Let's examine their market share in Sushiswap L2 chains.
PEPE meme Analysis
May 14, 2024 - The PEPE coin is a meme coin built upon the legacy of Pepe the Frog, a popular internet character. The cryptocurrency draws on the lighthearted and humorous nature of the meme to create a unique and engaging digital asset. it's Built on the Ethereum blockchain, The project seeks to leverage the success of meme coins, such as Shiba Inu and Dogecoin, and aims to become a leading meme-based cryptocurrency
The Footprint of Top 100 Airdrop Hunters
Sep 7, 2023 - Welcome to monitoring airdrop hunting by top hunters. In the current dynamic dashboard, we track the activities of the top 100 airdrop hunters on ZkSync, Base, and LayerZero networks, which are expected to be of interest to nearly all airdrop hunters. The queries are dynamic and are updated every 24 hours, so it may take a few minutes to load all of the visualizations
Euro Stablecoin on Avalanche
May 30, 2023 - We are seeking talented data analysts to provide insights and metrics regarding the newly launched Euro stablecoin on the Avalanche blockchain. The stablecoin, developed by Circle, aims to provide a reliable and secure digital representation of the Euro.
Pancakeswap on BNB Smart Chain and veCAKE staking
Jun 11, 2024 - This dashboard currently provides a comprehensive overview of Pancakeswap on BSC (BNB Smart Chain) as well as an in-depth analysis of veCAKE, the vote-escrowed CAKE token that gives governance rights and also accrues rewards from revenue sharing.