Discover expert insights on leading blockchains and protocols.
Avalanche🔺||🎅Trader Joe Bridger Destinations
Oct 9, 2023 - "If you'd like, please put a heart in the upper right corner for me. Thank you!"
Flash Bounty: Merge Open Analytics
Sep 26, 2022 - The merge has occurred. How have users responded in days that followed? Analyze any notable trends or outliers you can see since ETH switched to POS. Compare this to user behavior in the days and weeks leading up. What major changes can you see?
UNIBOT - Telegram Uniswap Sniper
Jun 18, 2023 - The following analysis is done by @Pierandrea21 (https://twitter.com/Pierandrea21). Telegram: @pierandrear TWITTER THREAD AT https://twitter.com/Pierandrea21/status/1670605900426387457
Exploring Uniswap & SushiSwap
Feb 6, 2023 - Exploring the Transactions that occurred on Uniswap & Sushiswap on the Ethereum Blockchain
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
ETH samples
Jul 8, 2022 - Click the three dots at the upper right corner of the tables to see SQL codes.
GMX Swap Activities
Apr 22, 2024 - GMX is a decentralized spot and perpetual exchange that supports low swap fees and zero price impact trades. Trading is supported by a unique multi-asset pool that earns liquidity providers fees from market making, swap fees, leverage trading (spreads, funding fees & liquidations) and asset rebalancing. website: https://gmx.io/#/
Curve.fi Stablecoin Pools
Mar 16, 2023 - Navigating the USDC Crisis through Curve Pool Analysis
wETH Deposit Rate
Jun 10, 2022 - Calculate the deposit rate of wETH over time on Osmosis. How does this compare to SushiSwap and Thorchain now? How does the wETH deposit rate compare to when wETH was a relatively new asset (or the protocol was relatively new)? Is Osmosis growing at a faster rate than Thorchain and Sushiswap?
Hacks, Scandals and Scams - 4. CEL token flows
Jul 29, 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?
Memecoins and the market
May 15, 2023 - How long does a meme last? Recently, memecoin activity and prices have spiked and crashed. Where did the liquidity come from, and where has it gone? Are markets returning to a risk-off mentality?Compare recent memecoin price action and activity with historical trends for memecoins of prior fame. Among today's notable choices are $pepe, $bonk, $chad, (etc), whereas older coins include $doge, $shib, etc.
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'.
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...
Metamask vs. Other Platforms
Jun 24, 2022 - How many users are swapping via MetaMask vs other platforms? How much volume have these users done? Chart a comparison between the two, and show the following metrics over a time period of your choosing: transaction volume, average amount swapped, and a comparison of fees.
ETH Down Bad
Nov 23, 2022 - The price of Ethereum has sank in recent days - how does it compare to other tokens amid a general market downturn?
HAUS - Exploring DEX Activity on Ethereum
Jun 6, 2023 - The present dashboard aims to provide a quick overview of trading activity on the HAUS token throughout decentralized exchanges living in the Ethereum network. DEX activity on other networks like GnosisChain or the recent liquidity migration to Optimism will be covered in a future release
CEL token flows
Jul 28, 2022 - This dashboard is created to analyze what are the top addresses swapping and transferring CEL how the CEL swap volumes has changed over the past 90 days and how are Celsius wallets interacting with the CEL token.
Maverick Protocol: The Next Generation of DeFi
Sep 14, 2023 - Maverick's data is initially explored on the Base blockchain.
ETHEREUM TRANSACTION FEES
Aug 28, 2024 - Transaction fees are fee paid to node validator to include a particular transaction to a block , the fee a user pay for transaction varies for different type of transactions . A user might decides to pay more fee in order for his/her transaction to be added if it is a time sensitive transaction like MEV arbitrage and other. Here i analyse total transaction fee paid for the past 30 days and total transaction fee each type of transaction has consumed.