CoinConverse
Collateral Impact (May 13)
May 15, 2022 - Q2. How does the volume on MakerDAO (in terms of DAI minting) change as more collateral tokens are added to the platform? Which tokens have impacted volume the most?
IL Protection Over Time
May 17, 2022 - Q88. With highly volatile prices recently, more IL protection has been paid out on THORChain. How do recent days or weeks compare to historical amounts? Hint: use thorchain.liquidity_actions
OP Price vs Swapper Activity
Oct 4, 2022 - Dashboard by PM...#6566 --> Question: Is there a relationship between OP price and trade volume?
ERC20 Tokens (zkSync)
Jun 16, 2022 - Q2. ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. Users can also deposit ERC20 tokens into ZkSync. Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days? Visualize and explain both findings.
Sushibar Servings
Apr 21, 2022 - Q66. Draw charts showing sushi tokens transferred to the Sushibar. Do it at different frequencies and describe the trends if any.
Liquidity Pool Popularity
Feb 1, 2022 - In this analysis, we observed the most popular Gamma liquidity pools considered by the number of wallets and also by TVL.
"Small" LP Actions
Apr 9, 2022 - Q55. What percent of LP adds to each pool is small (<$1k USD)? Is there a relationship between the chain and the proportion of “small” LPs? We're particularly curious to know if chains with low gas fees (like Terra) have a larger proportion of small LPs than chains with high gas fees (like Ethereum).
14. Transaction Fees
Feb 4, 2022 - All transactions on Algorand have a transaction fee of .001 but let's dive a little deeper into fees generated on Algorand.
UST-LUNA Highway
Apr 20, 2022 - Q182. Over a time period of your choosing, display the following: -daily minted UST and burned LUNA -daily burned UST and minted LUNA What are some trends you can observe for each of the charts above?
Swap Volume vs. LP Rewards
May 3, 2022 - Chart the weekly swap volume and LP rewards on the same chart. What is the relationship between the two? Hint: use thorchain.daily_pool_stats to get swap volume and earnings_to_pools from thorchain.daily_earnings to get LP rewards
Swapping for YLDLY on DEXs
May 21, 2022 - Q77. Let’s get a better understanding of how people are swapping Yieldly(YLDY: Asset ID: 226701642). Show us the total volume inflow and outflow of Yieldly(YLDY: Asset ID: 226701642) by day in 2022 then break it out by DEX as well. Is swapping for YLDY more popular on some DEXs than others? Additionally what assets are users swapping for YLDLY? Are there any standout days of swap volume for Yieldly? If so, write about what may have caused that spike. Note any other interesting findings related to YLDY swaps!
Let it burn!
Apr 24, 2022 - Find the week that the most volume of Luna burning happened. What caused this event? Show some effects of this burning had on Terra ecosystem by your opinion.
Sushi During Volatile Times
Jun 1, 2022 - Q85. How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
ETH Staked (new)
Jun 12, 2022 - Q9. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
3. Gamma Gas Savings
Feb 2, 2022 - According to the assumption, a wallet would have changed its Uniswap v3 position range when the Gamma pool does. In this query, we showed a visualization for the number of wallets in each Gamma liquidity pool. Since we found that the WETH-USDT pool is the most popular pool in terms of the number of wallets, this analysis calculated gas fees for all transactions from all wallets to indicate the amount of gas fee that has been saved when changing its Uniswap v3 position range.
IL Protection By Pool
May 17, 2022 - Q89. Which pools have paid out the most IL protection in the last week? Month? Hint: use thorchain.liquidity_actions
Distinct Wallets (ZkSync)
Jun 16, 2022 - Q1. ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
Market Volatility
May 25, 2022 - Q82. The second week of May saw some huge volatility in the market and prompted many to sell their volatile assets and take a flight to safety. What did the volume look like in decentralized exchanges on Ethereum during that period? Which assets were being sold/bought the most?