CoinConverse
Top LDO Holders
Jun 2, 2022 - Q1. Who are the top LDO holders on Ethereum and where have their LDO come from? Did they buy it or was it an airdrop?
stETH Most Common Pools
Apr 25, 2022 - Use the ethereum_core tables to determine the pools most commonly used to swap in and out of stETH. What are the most common pairs? Which pools are most often used?
Popular Contracts on Flow
May 28, 2022 - Q1. What are the 10 most popular contracts that have been used on Flow since May 9th? What do each of those contracts do and why do you think they are so popular? Are there any contracts that seem to be trending and growing in popularity?
140. Anchor Collateralization
Feb 3, 2022 - In this query, We compared the overall bLUNA and bETH collateral provided on Anchor in terms of total USD and the number of unique users. Furthermore, we visualized the amount of USD collateralization and the number of unique users of bLUNA over the past 90 days.
When Do Transactions Fail?
May 31, 2022 - Q2. Do times of high transaction volume lead to more transaction failures? Create a visualization that shows the relationship between transaction volume and success rate of transactions since May 9th. Are there any noticeable patterns to when transactions are more likely to fail? Were there specific events that seem to cause transaction failures?
$RUNE Movement from Crypto.com
Jun 19, 2022 - Q104. Show the in + outflow from cryto.com to native wallets over time. Are there any trends?
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
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.
"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?
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?