LTirrell
Thorchain: Daily Reward Distribution
Oct 26, 2021 - Total block rewards distributed to nodes and LPs by day.
Gasless Terra Scavenger Hunt
Dec 17, 2021 - Getting LUNA, depositing it to a validator for good!
Algo -- Algorand Governance: Rewards Distribution for Period 1
Jan 20, 2022 - Let's look at the rewards that were distributed for Algorand Period 1! - How many Algos were distributed in rewards for period 1. - How many transactions did it take to distribute the rewards. - Show a distribution of the rewards size. - How long did it take Algorand to distribute these rewards and how much did it cost in fees to distribute these rewards. TIP: look at the transaction table and decode the note by doing the following: select try_base64_decode_string(tx_message:txn:note::string), * from . We want to look at notes that contain: af/gov1:j{""rewardsPrd"": Additionally, we should make sure to filter on block_id, rewards were finished being distributed on Jan 5th, 2022. Make sure to only look at block_ids before this date
Magic Mirror Hunt
Sep 24, 2021 - Completing the Magic Mirror Hunt with a Delta Neutral Strategy
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?
Let it burn!
Apr 26, 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.
THORChain Scavenger Hunt
Apr 8, 2022 - Using thorswap to provide UST-RUNE liquidity! :lightning: :moon:
Around & Around We Go (Circulating Supply)
Feb 24, 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.
Thorchain: Wealth distribution
Nov 2, 2021 - What is the distribution of wealth within the THORChain ecosystem? Show a histogram of the breakdown
Apollo Sunchaser Hunt
Oct 9, 2021 - Completing the Sunchaser Hunt by participating in Phase 1 Community Farming
Staking Yield, Mvmt 1: The Basics
Jan 20, 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.
Airdrop Query Repo
Oct 4, 2021 - Some airdrop oriented queries, to help find address that projects airdrop to
Thor -- Node Operators Over Time
Jan 20, 2022 - How many unique node operators have ever bonded $RUNE? How has that number progressed over time?
Levana Meteor Shower Participants
Nov 16, 2021 - For those who bought and participated in the Levana Meteor Shower, is there a relationship between their participation and their LUNATIC degen score?
Thorchain: Total volume swapped by pool and over time
Oct 26, 2021 - The swap volume over time, broken down by each pool on THORChain.
Airdrop Price Impact
Oct 5, 2021 - Exploring how Airdrop Claims affect the price of MIR and ANC
Most Popular ASAs
Jan 10, 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?
Flipside Validator Activity
Oct 25, 2021 - Inflows and outflows to Flipside's Terra validator
125. [Easy] Anchor Users
Dec 30, 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)
Spectrum Protocol Scavenger Hunt
Jan 27, 2022 - Autocompounding and governance on Spectrum Protocol
141. Staking Yield, Mvmt. II: Anchor
Feb 2, 2022 - Imagine it is February 20 and the Anchor yield reserve has reached 0. Using data to support your answer, assess what the APY on Anchor Earn would be, based on LUNA staking yield and ANC incentives. How might this compare to stablecoin yields that are currently available from other protocols (not limited to Terra)?
Whale Voters
Feb 16, 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
Whale Dependency Index
Jan 27, 2022 - Create a Bar Chart Graph displaying DEX pool vs total liquidity on Loop - with the number of total wallets holding LP tokens typed on each bar. The goal for this is for us to determine: - Which of our pools are highly dependent on whales….because lower number of wallets associated with the highest liquidity pools will tell us this for each pool. This type of info can help us figure out our own “whale dependency” index, which could help guide us on how to best allocate farming rewards. In general, do we want to keep one whale happy or is it better for us to keep a lot of farmers happy?
Solana -- When Do Transactions Fail?
Jan 20, 2022 - Do times of high transaction volume lead to more transaction failures? Create a visualization that shows the relationship between transaction volume and success rate of transactions throughout the month of December. Are there any noticeable patterns to when transactions are more likely to fail?
Anchor Mariner Hunt
Sep 18, 2021 - Here are Transactions to complete the Mariner Hunt and learn about Anchor Protocol. The Tx_Description column describes the actions performed.
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?
Flow Scavenger Hunt: NFL ALL DAY
Sep 9, 2022 - Creating a Flow wallet and exploring NFL ALL DAY
3. Tinyman Assets
Jan 13, 2022 - - Before the Tinyman hack, what were the most popular assets to swap with Algo in the Tinyman Dex[App ID 350338509]? - Does the average amount of algo swapped changed based on the asset that it was swapped for?
Thorchain: Liquidity
Nov 8, 2021 - Of the wallets that have supplied liquidity in THORChain pools, what percentage have removed at least some of the liquidity?
123. [Easy] Anchor Borrows and Deposits
Dec 28, 2021 - How have the average and total borrows and deposits on Anchor changed over time?
Bridgesplit and MonkeDAO's DAOJONES
Feb 24, 2022 - Bridgesplit enables any unique asset to become liquid and yield generative via NFT-collateralized lending, indexes, and more. Essentially, Bridgesplit allows for NFT fractionalization. In partnership with MonkeDAO, a Solana Monkey Business NFT (the MonkeDAO mascot) was fractionalized on 12/6 and trading began soon after. 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.