Kiba
DAI Volume (May 13)
May 19, 2022 - Q1. How does the daily volume of DAI transactions compare to other stablecoins? What is DAI most used for?
When Do Transactions Fail?
Jan 19, 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?
140. Anchor Collateralization
Jan 28, 2022 - How much of the collateral provided on Anchor is bLUNA vs. bETH? How has this changed over the past 90 days?
ALGO Transaction Payment Size
Mar 31, 2022 - 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?
12. [Easy] Opensea ENS Sales
Dec 24, 2021 - Make a dashboard that is set to update daily showing a leaderboard of the most expensive recent ENS sales on Opensea. Make sure to include the domain names and the sale amounts. HINT use the table ethereum.nft_events.
129. Transactions on Wormhole
Jan 12, 2022 - Assess transaction size & volume of transactions on Wormhole. Define a number of buckets, e.g. Minnow, Fish, Whale, and group the transactions into them. How many transactions are in each bucket?
SOL Swaps on Jupiter
Feb 19, 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.
Saber and daoSOL
Feb 18, 2022 - Since the start of February, how much liquidity has been deposited in the daoSOL-SOL pool per day? How many unique wallets have added liquidity to that pool since February 1st? Create a visualization showing liquidity trends with this pool.
Weighted-Average LP Duration
May 3, 2022 - What is the average duration of liquidity held in each pool, weighted by the size of the LP?
Top LDO Holders
Jun 2, 2022 - Who are the top LDO holders on ethereum and where have their LDO come from? Did they buy it or was it an airdrop?
1. Most Popular ASAs
Jan 7, 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?
MonkeDAO Validator
Feb 16, 2022 - The MonkeDAO was the first NFT DAO on Solana and also was the first NFT DAO to set up a validator in an effort to help decentralize and secure the network. When a user decides to stake their Solana, they delegate which validator to support with their staked Solana. How many unique wallets since February 1st have decided to delegate their staked Solana to the MonkeDAO validator? Create a visualization showing delegations per day.
11. [Easy] Claims vs Price
Dec 24, 2021 - Is ENS just for cred? Or do people actually use their ENS-addresses? Look at all addresses with an ENS registration in the last 6 months, what percent of those addresses have done transactions?
Prep for Flight
Jan 16, 2022 - Investigate the timing for people who use both Shuttle and Wormhole. For users who use Shuttle, how long is it before they adopt Wormhole? Do they continue using Shuttle after using Wormhole? If so, do they continue to use both protocols? How much?
UST Competitive Advantages
May 2, 2022 - Why would a user choose to transact using UST over DAI (and vice versa)?
Sushi during Volatile Times II
Jun 1, 2022 - During the recent spike in market volatility, which chain saw the most activity in swaps for sushi? Polygon, Ethereum or Harmony?
Unique Users on Algorand
Apr 7, 2022 - -Chart daily unique wallets by day since February 1st for each major blockchain(Algorand, Solana, Ethereum, Terra) -Does it appear that market conditions are slowing down growth or activity on the networks?
Getting Your Feet Wet, Part 1
Mar 9, 2022 - Question 160: Make a table containing wallet addresses whose first transaction was 90 days ago or less. Analyze how active they have been since that first transaction, based on either 1) the number of transactions; 2) the number of protocols interacted with, or 3) the number of different types of transactions undertaken. (deposit, delegate, vote)
1. Weigh Anchor (Users)
Jan 11, 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.