0xHaM-d
Sushibar Servings "Sushiswap Bounties"
Apr 22, 2022 - Draw charts showing sushi tokens transferred to the Sushibar. Do it at different frequencies and describe the trends if any.
StreamSwap Launch #2
May 11, 2023 - This dashboard provides valuable insights into the user behavior and engagement within the FLIX/ATOM stream on StreamSwap. By examining the different phases and actions performed by users, we gain a deeper understanding of the dynamics and patterns within the stream. The analysis highlights trends such as increased activity during the Streaming Phase, concentration of deposits before the start, and a comparison with the FLIX/OSMO stream. This summary offers a comprehensive overview of user interactions, contributing to a better understanding of the FLIX/ATOM stream on StreamSwap.
Saber Proposals & Gauges
May 30, 2022 - Q79. Create a visualization showing the total amount of SBR locked over time and voter participation rates.
Foundation Mint and Sales (Hot on ETH Week)
Apr 19, 2022 - Using the Ethereum_core schema, analyze mint and sales activity on the Foundation platform over the past 3 months. How do both the mint and sales activity compare to Opensea?
Stargate User Growth (Hot on ETH Week Day 4)
Apr 22, 2022 - How many unique users are staking capital on Stargate on Ethereum each day since its inception? What might this suggest about the protocol's growth? Note: Use the new ethereum_core data
Song That Own Itself(STOI) Airdrop #3 (Algorand Bounties)
Apr 5, 2022 - Q44. Let's look at how many wallets have claimed the STOI Song #3 “Million Scars” Airdrop. - How many users have claimed the airdrop? - Chart the STOI Song #3 airdrop token distribution by day.
IL Payout vs LP Age (THORChain Bounties)
May 6, 2022 - Show a breakdown of the average IL payout by the amount of time spent in the pool
Ecosystem Growth (Terra Bounties)
May 12, 2022 - Q198. Create a chart that shows total # of Ecosystem projects that have launched on Terra Mainnet, and a table below that shows what these projects are, as well as their date launched. To be eligible for a grand prize, please add an additional column that either links to that project’s documentation/Twitter, or provides a brief explanation of that project.
Who's That Going Across My Bridge
Apr 25, 2022 - Q186. Pick one bridge from Terra and a destination of your choice. (e.g. Shuttle bridge Terra <-> Ethereum or Wormhole Terra <-> Solana).
NEAR - 13. Insight of the Week
Feb 18, 2023 - The NEAR Foundation is running an "Insight of the Week" series. Keeping your analysis short and focused on excellent-quality visualization - provide the most fascinating or illuminating fact or insight that you can about the NEAR ecosystem, or any of the projects building on NEAR, over the past 7 to 14 days. When you tweet about the insight, don't just describe it - do your best to explain "why" what you chose is unusual, valuable, or noteworthy.
$THOR Staking Wallets (THORChain Bounties)
May 24, 2022 - Q90. Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards. How many unique wallets have staked $vTHOR? Chart this number over time.
DAI on the Market (May 13)
May 19, 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.
Rand Gallery Wallets (Algorand Week: NFTs)
May 23, 2022 - Q77. Let’s look at wallets that buy from Rand Gallery to get a better understanding of purchasing behavior.
What's going on in Ref-finance?
Apr 8, 2023 - key insights: The protocol saw a decrease in staking activity over the past 6 months, with staking transactions and stakers dropping from over 150 per day to below 50. Staking volume followed this pattern as well. The USDT-NEAR pool had a significant amount of liquidity added, while the ETH-NEAR and REF-NEAR pools had liquidity drop below zero due to market conditions. The most popular pairs for swapping to/from $NEAR over the past 6 months were stablecoin pairs, but non-stablecoin pairs have recently overtaken them in terms of swap metrics due to an upward trend in the crypto market. The wNEAR => USDC.e pair had the most swap transactions count and swapped volume in all time periods.
Unique Users on Algorand (Algorand Bounties)
Apr 7, 2022 - Q46. Compare the number of unique wallets that have sent a transaction since February 1st on Algorand vs Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Algorand compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks?
AlgoFi's AlgoVault Governance Period 3 (Algorand Bounties)
Apr 5, 2022 - Q54: What is the current total amount of ALGOs in AlgoFis AlgoVault?(Look at all the wallets that are created via the AlgoVault then use the algorand.account table to calculate total balance) What percent of the AlgoVault Wallets have committed to governance? What percent of the ALGOs in the AlgoVault have been committed to the How much have they committed? Show the algoVault wallets governance commitment by number of wallets and amount of ALGOs over time.
Stargate Fishes and Whales (Hot on ETH Week Day 4)
Apr 22, 2022 - 1 billion Stargate tokens were minted at genesis and will be the entire finite supply of STG. Define the terms fish and whale in terms of Stargate token ownership (in your opinion). What proportion of users fall into each of the categories you defined (fish and whale).
Privacy Coins + Politics
Jun 11, 2022 - Q10. Do major news events result in more people swapping to SCRT?
Monthly Swap Volume (Paraswap Bounties)
May 8, 2022 - Q2. Show the total monthly swap volume on ParaSwap over the past year. How has the swap volume changed over time? Which DEX’s is most of the swap volume coming from?
Sushi on Polygon (Sushiswap Bounties)
Mar 22, 2022 - Q57. What are the 10 largest sushi liquidity pools on Polygon? What is their volume and TVL?
Collateral Impact (May 13)
May 18, 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?
Celsius Swaps
Jun 21, 2022 - Q95. Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. From which one of their wallets did they conduct most of the swaps?