0xHaM-d
wETH Deposit Rate
Jun 11, 2022 - Q11. Calculate the deposit rate of wETH over time on Osmosis.
Active Addresses
Jun 6, 2022 - Q4. How many addresses on the MATIC network are active? What’s the daily evolution of active addresses? Is the activeness related some how to the price? Hint: Active address is an address that has done at least one transaction or has received at least once a token in the past 3 months. medium
Distributed Validator Technology
Apr 18, 2022 - Q1. Explain what Distributed Validator Technology (DSV) through the Obol network is and why it might help with decentralization on Ethereum 2.0 or other Proof-of-Stake chains.
Bridge Users (Hop Protocol)
Jun 18, 2022 - Q1. How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
Profit for AMMs (Sushiswap Bounties)
Apr 12, 2022 - Q63. What is the total profit (in dollars) per day that is generated from swaps out of the liquidity pools in 2022? Do you see a trend? Can you compare sushiswap with Uniswap?
Gain or Lose
Jun 15, 2022 - Q10. Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose depending on the peg of stETH to ETH at the time of the swap? Repeat the same analysis for stakers who have swapped stETH to ETH; how much ETH did they gain or lose?
Rare Traits (Moonbirds Bounties)
May 1, 2022 - What Moon Bird traits are rarest? How have different traits performed with buyers and sellers?
Moonbirds Mint Analysis - Terra
Apr 27, 2022 - Q7. What was the distribution at mint? How many wallets minted? Who minted the most?
Bots and success rate
Apr 24, 2022 - Compare the success rate of transactions executed by bots in the past 60 days with average users' transactions in the same time period. Is there any difference and any trends identifiable?
Sushiswap Bentobox Scavenger Hunt (Mandarin)
Mar 25, 2022 - Sushiswap Bentobox Scavenger Hunt (Asia)
Yet Another Acme Question (Terra Bounties)
Apr 21, 2022 - Q184. Refer to submissions for #175 - your own, or those of others. Pick your favorite Terra metric or visualization and recreate your own version. Your SQL can be similar or even identical to the original, but you should put your own narrative and explanation. Why is this metric/visualization your favorite? If you improved it, what changes did you make?
Rand Gallery NFT Sales (Algorand Bounties)
May 4, 2022 - Rand Gallery is one of the largest NFT marketplaces on Algorand. Let’s take a deeper look into rand gallery’s history and the performance of the marketplace.
Fault Tolerant Staking - Obol
Apr 18, 2022 - Q2. Define Fault Tolerant Staking (FTS). What are the advantages of FTS? What are the disadvantages? Explain what problems FTS might help solve.
ALGO Transaction Payment Size (Algorand Bounties)
Mar 30, 2022 - Q43. Let’s look at the quantities of ALGOs being sent in transactions since January 1st 2022 to see if we see any upwards or downwards trends. Group the transactions(algorand.payment_transactions) by size 0-10ALGOs, 10-100ALGOs,100-1000ALGOS, 1,000-10,000ALGOs and 10,000+ ALGOs. Count the number of transaction in each size and chart them by day from January 1st 2022 to current.
"Small" LP Actions (THORChain Bounties)
Apr 8, 2022 - Q55. What percent of LP adds to each pool are 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). Hint: use thorchain.liquidity_actions
Magic Eden Whales (Solana Bounties)
Apr 10, 2022 - Q50. Track the top 20 wallets in terms of sales volume on Magic Eden since March 1st. What have these wallets been buying the most over that time period? As in, which collections seem to have their attention? Do these wallets tend to ""sweep"" (buy a lot of the same collection at once) or patiently buy collections? How often are these wallets buying NFTs and what does their profit look like?
Governance Period 2 Payouts -Algorand Bounties
Apr 15, 2022 - Q49. Let's look at the Algorand Period 2 Governance Rewards Payouts
THORChain Scavenger Hunt (Farsi)
Apr 8, 2022 - این هانت برای ایجاد نقدینگی در استخر RUNE از طریق تورسواپ انجام شده ، ابتدا مقداری UST به RUNE سواپ شد ، سپس در استخر RUNE ایجاد نقدینگی صورت گرفته است.
Activity after re-enabling pools
Jun 7, 2022 - Q98. There is currently a proposal on THORChain to keep trading on Terra assets disabled and use the remaining RUNE in the pools to support actors within the THORChain ecosystem that have been impacted by the Terra collapse. The idea behind this proposal is that if trading were re-enabled on Terra assets, most of the RUNE would be scooped up by bots and sold for other assets. We are curious in exploring that hypothesis.
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.
Stablecoin Landscape on DEX
Jun 7, 2022 - Q87. Analyse the stablecoin landscape on Sushiswap, identifying the various tokens available and their main metrics (volume, number of swaps, TVL, and other relevant for you). Which one is the most successful? Is it the same at Uniswap?
Symmetric vs Asymmetric LPs
May 30, 2022 - Q99. On THORChain, you are allowed to add liquidity in 1 of 3 ways: Rune-only, asset-only, or symmetric (both Rune + asset). What is the breakdown of liquidity being added, according to those categories? Are there any trends over time or by pool?
MNDE Locked In Governance (Solana Bounties)
May 1, 2022 - Create a line chart showing the total amount of MNDE tokens locked in governance over time. What percentage of the current circulating supply does this represent?
Fuse Pool DAI Allocation
May 22, 2022 - Q1. How are the tokens in the DAI Vault being allocated into the various Fuse Pools?
Astroport Retention Cohort
Oct 26, 2023 - Introducing the Astroport Dashboard, your window into the dynamic world of decentralized finance on the Terra blockchain. As you embark on this data-driven journey, we'll uncover key insights into user engagement, retention, and spending trends within the Astroport protocol. From understanding the behavior of our community to assessing the impact of strategic initiatives, this dashboard offers a comprehensive view of our ecosystem's growth and potential areas for improvement. Join us as we explore the data shaping the future of Astroport.
Stablecoin Pegs (Stablecoin Flash Bounty)
May 13, 2022 - How have USD-pegged stablecoins across different chains, and with different backing mechanisms, fared through the last 5 days? Compare volume, peg stability, and any other metrics you think are relevant, and present a dashboard the summarizes your findings and conclusions.
Redemption Arc (Terra Bounties)
Apr 6, 2022 - Q177. Explore the limitations of redemption on Terra, i.e. the burn and mint mechanism. In what scenarios would the ability to burn & mint be insufficient for demand? Using data, illustrate occasions where these scenarios have occurred or come close to occuring. There are a number of ways to do this; one approach is to quantify a “Redemption Utilization”, i.e. a performance metric that encapsulates the extent to which demand for redemptions outstrips or comes close to the programmed caps, and then to explore the number of days over a specified time period that this metric has crossed a concerning threshold.