Q81. Octorand is a virtual world of opportunity built on top of the Algorand blockchain. Octo Primes are the only form of life existing in the world of Octorand. You can collect these Octo Primes, transform them to increase their value and trade them through the inbuilt marketplace. - Show the number of Octo Primes Gen1 and Octo Primes Gen2 each wallet holds. – - How many unique holders are there for Gen1 and Gen2? ---- How many Gen2 holders hold an Oct Prime Gen1? ---- Show Octo Primes Gen1 and Octo Primes Gen2 sales and ALGO volume over time. ---Note any other insights you find about the Octo Prime sales or holders!

Q95. 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. --- What is the distribution of $THOR currently staked? Are there any notable whales? You will need to calculate the net amount staked + unstaked to get the current amount. --- Hint: take a look at this query to get started on viewing $THOR staking examples: https://app.flipsidecrypto.com/velocity/queries/5be49e11-9d0f-4ccc-b8ae-b36a06c24784 --- Here is an example of an unstaking query: https://app.flipsidecrypto.com/velocity/queries/4a36565c-44b6-43df-b6b9-26f9e4f5794a

Calculate the distribution of $RUNE holdings by address. Include RUNE that is in liquidity pools. (e.g. if I have 100 $RUNE in my wallet and LP 50, I should still be considered to be holding 100). In terms of charts, feel free to create a histogram or whichever visual you think works best! Hint: use thorchain.transfers and thorchain.liquidity_actions

Q64. Traditional TVL metrics are imperfect because they are influenced by both the quantity and price of the tokens over time. We would like to see a version of this metric that abstracts out the price influence on this metric. There are many ways to approach this, but feel free to try out something like: assume asset and RUNE prices are fixed at their current value and show THORChain’s TVL over time or use the same methodology, but instead of current prices, fix them at their average price over a certain timeframe

Q65. How have the RUNE-UST, RUNE-LUNA pools been performing on Thorswap? How do the fees generated from these pools compare to other pools? Do the swaps in these 2 pools tend to be balanced or are they typically going in a certain direction (e.g. are there more swaps from $LUNA or to $LUNA)?

Q66. Measure and compare the first three days of swap volumes of the following tokens: Doge, LUNA and UST

Q48. Let's look at the whales are swapping for on the DEXes. First identify current whales with the balance field in the algorand.account table. ---- Describe your methodology of what signifies a whale What percent of whales participate in swaps(use the algorand.swaps table)? Additionally show the distribution of the number of swaps per whale in 2022. What assets are whales swapping from? Display this over time starting at the beginning of 2022. What assets are whales swapping into? Display this over time starting at the beginning of 2022.

Q43. Katana currently has 5 covered call vaults with a TVL of over $1 million (SOL, mSOL, BTC, ETH, wLUNA). What has been the rate of change of deposits and withdrawals for each of these vaults since the beginning of February? What vaults seem to be gaining in popularity the most? What percentage of wallets that have deposited into a covered call vault have also deposited into another vault? Which vaults seem to have the most crossover?

Terra Q153: 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?