piper
How to use other's work?! Don't plagiarize, give credit instead...
Oct 3, 2024 - Don't plagiarize, give credit instead...
Solana - Orca + Jupiter Volumes
Mar 14, 2022 - Compare the 5 most popular swaps SOL -> coin swaps (SOL swapped for another coin) on Orca and on Jupiter since January 1st. Create a visualization showing the total volume per day on Orca and Jupiter since January 1st for SOL to another coin swaps. What has been the historical swap success rate since January 1st on Orca and on Jupiter?
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.
Prism Scavenger Hunt
Mar 4, 2022 - Prism Scavenger Hunt - an enjoyable entry into the Prism Protocol.
ThorChain - Whale activity
Nov 10, 2021 - 19. [Easy] Whale activity Among the wallets that own 10k+ RUNE, which pools are they currently LP-ing to?
Based Rekt Chickens π - First NFT PFP collection on Base Mainnet
Aug 2, 2023 - On August 1st, 2023, Rekt Gang released their Based Rekt Chickens collection at MintDAO for minting on Base Mainnet. This Dashboard provides a some insights about the min, sales, bridging, ...
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?
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?
Anchor - 1. Weigh Anchor (Users)
Jan 7, 2022 - Who are the top users (by address) of Anchor Protocol? Are they retail investors or protocol/enterprise users? Whales or small fry? Note: you may define βtop userβ as you wish, but your definition and results should be defensible using data and at least one visualization.
Algorand - 2. Algorand Governance
Jan 11, 2022 - What percentage of non-closed wallets have committed to Algorand governance? How many wallets total is this? What percent of wallets committed to period 1? What percent of wallets committed to period 2? What percent of wallets committed to period 1 and period 2?
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)
Solana - SOL Swaps on Jupiter
Feb 17, 2022 - Since January 1st, how much SOL has been swapped for other tokens using Jupiter per day? Over the same time period, how much SOL has added from swaps using Jupiter per day? Create a visualization showing the flow of SOL from swaps on Jupiter since January 1st per day and provide insights around any spikes you see.
140. Anchor Collateralization
Jan 30, 2022 - How much of the collateral provided on Anchor is bLUNA vs. bETH? How has this changed over the past 90 days?
Solana - Most Popular Jupiter Swaps
Feb 27, 2022 - Jupiter is the best swap aggregator on Solana, meaning that it optimizes the best token swap rate across all decentralized exchanges for users. Since February 1st, what have been the 10 most popular tokens to swap away? Over that same timeframe, what have been the 10 most popular tokens to swap for? What are the 10 most popular swapping pairs (combination of swap away to swap for)? Define 'popular' as the number of swaps and create a visualization showing total number of swaps over that time frame, highlighting these most popular tokens.
Terra - Staking Yield, Mvmt 1: The Basics
Jan 16, 2022 - Explain in your own words (i.e. don't copy the documentations) how Terra's staking yield is calculated. Provide a graph that compares LUNA staking yield to LUNA price over a time period that you define.
Terra - 52 Pickup
Mar 2, 2022 - Recently, a deal was announced wherein LUNA was sold for BTC at a price of about $52/LUNA. Some commentators on crypto-Twitter are contending that this represents the new floor price for LUNA. Over a time period of your choosing, how many days has LUNA closed above this price? How many days has it closed below this price?
AAVE - Gas Prices and Deposit/Borrow Amounts dependencies
Nov 9, 2021 - 29. [Easy] Gas Prices and Deposit/Borrow Amounts As gas prices have continued to rise, how have average deposit and borrow amounts changed in response?
Rari Capital - Fuse Pool Analysis
May 22, 2022 - Q3. Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? What differences can you identify?
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
Solana - USDC, USDT, UST on Jupiter
Mar 8, 2022 - Create a visualization comparing USDC, USDT, and UST (wormhole) popularity in swaps on Jupiter since December 1st (both in terms of count and amount - swaps from and swaps to). Is there a dominant stablecoin in swaps on Jupiter? What percentage of all Jupiter swaps are stablecoin swaps (as in a swap between USDC, USDT, and UST)? Have we seen more instances of users swapping USDC or USDT for UST over time? Why or why not based on your knowledge of Terra's cross-chain efforts?
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?
Lido - stETH vs ETH
Jun 8, 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?
Flash Bounty: #GodMode Mint The Typical Minter
Jun 9, 2022 - Analyze the Ethereum profile of those who minted during the first hour after launch. How many of them moved the minimum .1 ETH into their minting wallet vs. already had at least .1 ETH in that wallet? How many of them have been active in NFT purchases over the past six months? Can you construct a βtypical minterβ profile/profiles based on their wallet behavior?