theshaho
Terra Bounties(Votes, Votes, Votes)
Apr 16, 2022 - On average, how much voting power (in Luna) was used to vote 'YES' for governance proposals? Out of this, how much Luna comes from validators vs regular wallets?
Terra Bounties(Whale Voters)
Feb 12, 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 Bounties ( Vote! )
Feb 12, 2022 - Question 9: Create a visualization that compares the number of non-vote transactions to vote transactions per block since the start of February (hint, use the block table and the votes_block_agg table). What is the average ratio of votes to non-votes in a block? Have there been any timeframes of noticeable fluctuations of this ratio?
Solana Bounties(SOL OpenSea vs Magic Eden)
Apr 9, 2022 - OpenSea launched its SOL compatibility on 4/6 - giving the SOL NFT landscape access to the largest source of NFT liquidity. However, Magic Eden remains the top NFT marketplace on SOL. Compare sales volumes between OpenSea (for solana NFTs) and Magic Eden since OpenSea's Solana launch. How many unique users have bought a SOL NFT on OpenSea vs Magic Eden since 4/6. How do you expect this trend to develop over time?
Terra Bounties(Anchor Emissions)
Feb 19, 2022 - Question 152: 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.
Terra Bounties(Ecosystem Anchor)
Mar 14, 2022 - Create a graph to show either: a) the token price (over a time period of your choosing) OR b) a bubble chart with total value locked, for all the Terra projects that depend on Anchor to create their yield.
Terra Bounties(52 Pickup)
Feb 26, 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?
Sushiswap Bounties(Price vs Volume)
Feb 13, 2022 - Question 40: Look at the price of the Sushi token and volume on Sushiswap over the past 30 days. Does the price of the Sushi token seem to impact volume on Sushiswap?
Solana Bounties(Bridgesplit and MonkeDAO's DAOJONES)
Feb 21, 2022 - Create a chart showing daily transaction volume and the number of distinct wallets that transacted with DAOJONES. When was the peak amount of trading volume and seemingly ""hype"" around DAOJONES? What was the most amount of distinct wallets that made a transaction with DAOJONES in a day? Provides some insights around why these numbers peaked when they did.
Mango Markets Bounties(First Time Deposits at Mango Markets)
Feb 19, 2022 - How many new trading accounts have been created by users since February 10th? How much SOL has been transferred into Mango Markets (don't count the one time fee) since February 10th from first time deposits? What was the average deposit amount? Create a visualization showing these trends over the time specified.
Terra Bounties( Pleasure to Burn )
Mar 1, 2022 - Terra Q154: 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
Algorand Bounties(ALGO Transaction Payment Size)
Mar 27, 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. Do we see any trends of increasing or decreasing payment sizes? What might this indicate for the Algorand network?
Terra Bounties(The Red Planet)
Apr 5, 2022 - Q174. Define and assess two key metrics for the performance of Mars Protocol since launch. How is Mars doing, according to these metrics?
Terra Bounties(UST-LUNA Highway)
Apr 19, 2022 - Q182. Over a time period of your choosing, display the following: -daily minted UST and burned LUNA -daily burned UST and minted LUNA What are some trends you can observe for each of the charts above?
LUNA Distribution Mvmt 1: The Basics
Jan 26, 2022 - People who do not like crypto often cite wealth inequality as a reason: they claim that the tokens are concentrated in the hands of a few whales. Assess this claim for LUNA. How much of circulating supply is held by the top 100 addresses? Top 1%? Top 10%? BONUS: compare this to wealth distribution vs. a country or an index of your choosing.
Solana Bounties(StepN Growth)
Mar 1, 2022 - Solana Q30: StepN is a Solana based ""move-to-earn' game (you earn the game's native token GST by moving around using their NFT sneakers and GPS system). The game has seen steady growth in popularity since it launched at the end of December (transitioned from a private beta mode to its current public mode). Create a visualization showing the number of unique wallets that have transacted with GST by day since January 1st. How much total GST has been transacted per day since January 1st? Provide some insights over the adoption of GST and how long it can accommodate its limitless supply as an in-game token.
Terra Bounties(Around & Around We Go (Circulating Supply))
Feb 21, 2022 - Question 151: Display the circulating supply of LUNA over the past 3 months. Use on-chain data for your calculation, but you are welcome to reference outside sources to support and validate your answer.
Jupiter Bounties(SOL Swaps on Jupiter)
Feb 17, 2022 - upiter is the best swap aggregator on Solana, meaning that it optimizes the best token swap rate across all decentralized exchanges for users. 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.
Terra Bounties(Validator Pageant)
Mar 14, 2022 - Select one validator outside the top 10 and make a case for why newcomers to Terra should delegate to that validator. Define any metric of your choosing that marks a good validator (airdrops, voting, community benefits, uptime); assess the average for the full set of ~130 validators (i.e. if you pick airdrops, assess how many of them offer an airdrop); and assess how your chosen validator performs based on that metric.