CoinConverse
Solana Bounty: Solana Outages
Jun 8, 2022 - Q82. Solana experienced another outage on 6/1 where validators were forced to restart the network. The network experienced a similar problem back on 5/1. After the restart happens during these outages, how do users on the network generally respond? Does the price of SOL drop because users lose confidence in the network? Is there more swapping behavior and more stablecoin activity? What protocols seem to have more activity after these types of events that on the average day in the Solana ecosystem? Is there more fear from defi Solana users than NFT enjoyers?
Fuse Pool USDC Allocation (New)
May 21, 2022 - Q2. How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
Swap Fees
Jun 28, 2022 - Q21. Do fees on Osmosis differ when users swap to or from different tokens? On average, which tokens have the highest and lowest swap fees on Osmosis?
Most Popular ASA To Swap From ALGOs
Apr 14, 2022 - Q50. Let’s look at what ASAs(Algorand Standard Assets) are most popular to swap into from ALGOs in 2022 using the swaps table Create a bar chart visualization of the top 10 ASAs by total ALGO swap volume. (Tip: This means we want to look at swaps where the wallet is sending in ALGOs(asset ID: 0) and receiving another asset in return. The volume would in ALGOs would be the sum of all the ALGOs wallets sent in to receiver the asset). Create a table for the top 10 ASAs found in part 1. In this table, list the ALGO swap volume and the average amount of ALGOs involved in a swap. Create a time series chart to look at the number of swaps (from ALGOs) to each of these 10 ASAs over time by day since the beginning of 2022. Note any trends on the increasing or decreasing popularity of any of the ASAs.
Lido Bounty Q2: stETH vs. ETH
Jun 7, 2022 - Q2. How has the price of stETH compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
DAI Volume (May 13)
May 14, 2022 - Q1. How does the daily volume of DAI transactions compare to other stablecoins? What is DAI most used for?
2. Staking Before and Post-Gamma Airdrop
Feb 1, 2022 - In this query, we showed the amount of VISR, vVISR, and tVISR was being staked on December 20th. We also provided the visualization of the change of Gamma staking before and after the date of the airdrop event (December 26th, 2021). Finally, we compared the change in Gamma and VISR staking after December 26th, 2021.
Fuse Pool Analysis (New)
May 21, 2022 - Q3. Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? What differences can you identify?
Trend of Pools
May 18, 2022 - Q78. What kind of pools do users usually withdraw or deposit into for the last 90 days? is there any pattern/trend we can see from it?
Price + Circulating Supply
Jun 8, 2022 - Q3. Draw a chart showing MATIC’s circulating supply from the start till today. Compare it with MATIC’s price.
Cryptopunk Sales and Traders
Aug 30, 2022 - Dashboard by PM...#6566 Question: 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.
Unique Programs
Feb 10, 2022 - In this analysis, we aim to track developer growth in an ecosystem is through the number of unique contracts used. We created a visualization of the number of unique programs used per day since the beginning of January 2022. Moreover, we explored the 5 most commonly used programs since the beginning of January.
Tinyman 1.1 Launch Swaps
Jan 27, 2022 - In this query, we show the most popular swaps since the launch of the new Tinyman dApp. Also, we indicate the largest amount of swaps by ALGO volume since the new launch (Tinyman, relaunched on January 19th).
$OP Airdrop (Redux)
Nov 16, 2022 - Dashboard by PM...#6566 Question: Earlier this summer, Optimism offered an airdrop to users. Let’s examine the airdrop after a few months. How many users claimed optimism airdrop? How much of total airdrop was claimed? How many wallets are still holding tokens from airdrop? How much of users delegated their OPs?
IL Insurance
Apr 8, 2022 - Q54. What % of users that are removing liquidity are receiving IL insurance?
Liquidity and Volume
Jan 18, 2022 - This analysis visualized the daily number of liquidity pools in Sushi Swap over the past 30 days. Furthermore, we analyzed the daily volume in Sushi Swap over the past 30 days. Finally, we identified liquidity pools contributing the most to each of these metrics.
9. [Easy] Claimed Token Distribution
Dec 21, 2021 - Outline: - We will calculate the average amount of ENS claimed according to the ENS airdrop. - We will visualize the ENS claim size distribution by using the histogram technique.
Sushi during Volatile Times II
Jun 1, 2022 - Q86. During the recent spike in market volatility, which chain saw the most activity in swaps for sushi? Polygon, Ethereum or Harmony? Hint: For harmony and ethereum swap info, you can use the table in the easy swap table in the crosschain schema
Top TOKE Holders
Jun 22, 2022 - Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
DAI on the Market (May 13)
May 16, 2022 - Q3. Analyze large shifts in the amount of DAI on the market over the past year. What might have caused these shifts? Are these events related to Maker directly? Are they related to the crypto ecosystem as a whole? Provide metrics to support your analysis.