0xHaM-d
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?
Total Value Locked
Jun 29, 2022 - Q1. What is the total value locked in the Opyn Squeeth (osQETH) contract? And where does osqeth draw its value from?
Folks Finance: Minting gALGO3 For Governance - Algorand Bounties Copy
Apr 26, 2022 - Q53. We want to look at the users who committed their ALGOs to this liquid governance pool and minted gALGO3. How much gALGO3 was minted during the governance commitment period? Show the total amount of gALGO3 minted during the governance commitment period over time? Show the total amount of gALGO3 minted over time by day including outside the governance commitment period. Has a lot of gALGO3 been minted outside the governance commitment period?
Validator Voting vs. Investor Inclinations
Apr 24, 2022 - Analyze the last 5 governance proposals. Out of the total Luna that voted in favor, how many % are from validators vs. retail investors for each proposal and on average? Grand Prize Worthy: are there any cases you can identify where retail voters and major validators tended to vote against each other?