piper
Terra - 146. Whale Voters
Feb 13, 2022 - Question 146: For whale voters*, how many of them have voted in at least one Terra/Anchor/Mirror governance vote in the past 90 days? What is the percentage of whales who have voted? *Define whales; examples: addresses >$1M USD value, top 1000 addresses, top 1% of addresses
Algorand - 1. Most Popular ASAs
Jan 9, 2022 - What are the most popular ASAs on Algorand? How many wallets are holding each ASA? How many transactions happen with these ASAs? How have these stats changed over time?
LUNA Distribution Mvmt 2
Feb 7, 2022 - Question 144: Answer one of the following two questions (or both, to be eligible for the grand prize): What is the distribution of LUNA for active wallets (i.e. wallets with at least one transaction in the past 90 days? What is the distribution of LUNA if wallets that have never transacted are excluded?
ThorChain - 28. Price Correlation
Dec 14, 2021 - Is there any kind of correlation between the prices of $RUNE, $XRUNE, $THOR?
Terra - Luart Trends
Feb 8, 2022 - What projects currently exist on Luart, and what have been their respective volumes? Create a visualization showing Luart trading volumes since its launch. What have been the 10 largest NFT purchases on Luart?
Angel Protocol - 2. Restore Earth
Dec 23, 2021 - How much UST has been donated to the Restore Earth campaign? Which wallets are the top 10 donors and to whom do you think they belong? Conduct your own on-chain analysis to show your conclusions. To be eligible for the grand prize, add your own analysis of charitable donations to Restore Earth and make recommendations for charitable giving to reduce crypto-tax burdens in a jurisdiction of your choice.
Sushiswap - 8. Swap Volume
Dec 4, 2021 - Compare swap volume on the top 10 pools -- what is the best stablecoin pool and any differences you notice between Ethereum and Polygon
Paraswap - 1. New Active Users
Dec 11, 2021 - Show the number of new unique users (wallets) per day that transacted with ParaSwap over the past two months.
Sushiswap - Most Recent Transactions
Jan 26, 2022 - Find the top 10 tokens in terms of liquidity in USD on Sushiswap. Show the 10 most recent transactions on Sushiswap for each of those tokens.
Sushiswap Sushi Hunt
Oct 21, 2021 - First time using Sushiswap ... I decided for Polygon network for obvious reasons. :-)
ThorChain - 34. The Season of Swapping
Dec 23, 2021 - Which wallet address has performed the most swaps in the last 30 days?
THORChain - Net $THOR Staked
May 23, 2022 - Q91. 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. Show the net amount of $THOR staked over time.You will need to calculate the net amount staked + unstaked to get the net amount.
ENS - 1. Airdrop Stats
Dec 3, 2021 - How many wallets were eligible for the airdrop? How many addresses have claimed the airdrop? What percentage of all ENS that has been airdropped been claimed?
ThorChain - Liquidity
Nov 14, 2021 - 20. [Easy] Liquidity Of the wallets that have supplied liquidity in THORChain pools, what percentage have removed at least some of the liquidity?
Metamask - Total Metamask Users
Jun 22, 2022 - Q1. How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher order activity, like staking?
ThorChain - IL Protection By Pool
May 12, 2022 - Q89. Which pools have paid out the most IL protection in the last week? Month?
Terra - Pleasure to Burn
Mar 2, 2022 - How much LUNA has been burned over the past 30 days? How has the supply of UST changed over the same time period? Display both of these, using visualizations.
Lockdrops Keep Fallin' On My Head
Jan 22, 2022 - Explain, in your own words, what a “lockdrop” is. Choose a metric for ASTRO tokens (price, circulating supply, amount sold vs. HODL) and display it visually over a time period of your choosing.
Abracadabra - 1. Degenbox
Dec 18, 2021 - Design a Scavenger Hunt based around the “Degenbox” strategy - - laying out the steps for others to follow in order to participate.
Mirror - 3. Transaction Fees Per Asset
Nov 24, 2021 - What is the average transaction fee per asset (not fees charged by pools) ? Have these changed in the last 30 days
Orion Constellation Hunt
Oct 17, 2021 - These are my first steps exploring the Orion Eccosystem ...
Sushiswap - 15. Impacts of Price Changes
Dec 25, 2021 - The Sushi token has been trending downwards in price for the month or so. How do the changes in price affect trade volume? How do they affect number of users staking and amount staked?
Anchor - Back to Basics I: Deposits and Borrows
Jan 14, 2022 - Select a time period (minimum 1 month). Using visuals, compare borrow volume and deposit volume over that time period. BONUS: What relationship can you identify between borrows and deposits? What might be driving this relationship?
Sushiswap - 1. Active Weekly Users
Nov 14, 2021 - Show the number of active users (wallets) per week on Uniswap and Sushiswap over the past year. How do these two charts compare? Why might this be?
Sushiswap - 2. Monthly Swap Volume
Nov 14, 2021 - Show the total monthly swap volume on Sushiswap over the past year. How has the swap volume changed over time? Do the same for Uniswap. How do the changes in swap volume over time compare in the two DEX’s?
ThorChain - Wealth distribution
Nov 9, 2021 - 18. [Easy] Wealth distribution What is the distribution of wealth within the THORChain ecosystem? Show a histogram of the breakdown
Sushiswap - 5. Weekly Fees
Nov 19, 2021 - Show the total weekly fees collected each week over the past year. How has the total amount changed over time?
Rari Capital - Fuse Pool USDC Allocation
May 22, 2022 - Q2. How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
Solana - Genopets Staking
May 28, 2022 - Q78. Genopets is a move-to-earn game reminiscent of Pokemon Go on Solana. Create a visualization showing the amount of staked GENE over time. How many unique wallets have staked $GENE since its inception on May 18th? What percentage of those stakers have previously purchased a Genopets NFT? What trends are you seeing with the Genopets NFT collection?
Solana - More Mints
Apr 15, 2022 - Q56. Metaplex is an open source protocol that allows for the creation and minting of NFTs using a standardized format across wallets and applications. It is essentially the backbone architecture for Solana NFTs. How many NFTs have been minted over the past week? Since the beginning December, how many NFTs have been minted per week? Chart the growth of unique purchasers over time. What percentage of all mints have been via Metaplex's Candy Machine?
Terra - 108. The Fundamentals
Dec 7, 2021 - Build a dashboard that monitors and evaluates the relationship between Luna price and UST supply. Tell us what insights your visualizations provide.
Anchor - 125. Anchor Users
Dec 29, 2021 - How many new users has Anchor attracted in the last 3 months? How many remain active participants? Bonus points for additional metrics that categorize user behavior (ie -- Earn vs Borrow vs Supply vs ANC Staking, etc)
Wormhole Scavenger Hunt
Jan 12, 2022 - Transfer Luna Token from terra to Polygon via Wormhole Token Bridge
Stader Labs - 1. Active Daily Users
Dec 15, 2021 - Show the unique addresses depositing into Stader each day. How do these numbers compare to other protocols on the Terra blockchain? How much are these addresses depositing?
Terra - 152. Anchor Emissions
Feb 21, 2022 - Create a table of all addresses that have made at least one Anchor borrow in the last 3 months. Do some basic analysis and produce at least one interesting insight about Anchor borrowers.
Solana - Magic Eden Whales
Apr 10, 2022 - Track the top 20 wallets in terms of buying 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?