mhm
Top Kashi Pairs
May 19, 2022 - Q79. Find the top 5 Kashi pairs on Ethereum based on TVL. Choose one that you like and describe the following information: How many people are borrowing on this pair at the moment? How much collateral has each user added to the pair? How many users have already partially paid their loans?
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.
Osmo Staking
May 31, 2022 - Q8. Over the past 30/60/90 days and since June 2021, how much OSMO has been staked per day? What is the staking percentage (OSMO staked vs. circulating supply) and how has it changed over time?
Hot Contracts on Osmosis
Jul 13, 2022 - Since the beginning of May, answer the following questions: What are the top ten most popular contracts on Osmosis? What is the cumulative total of contracts launched on Osmosis, and have there been any spikes since the Terra crash or other noteworthy events?
Not Your Keys
Nov 19, 2022 - Did bridge activity spike over the last 7 days? If so, to what ecosystems?At a more granular level, track net outflows from FTX onto Ethereum. Did any of these outflows flow across Satellite to another destination chain?
Sushi vs Uni on L2
Oct 14, 2022 - Compare the market share of Sushiswap and Uniswap on the following L2 chains. Polygon, Arbitrum, Optimism. Use measures such as number of trade or number of swaps, etc.
Axelar & Osmosis: Liquidity on Liquidity
Nov 12, 2022 - Analyze activity on Osmosis once a user bridges via Axlear's Satellite. What asset do they most use to bridge? Once bridged what do they do next?
NFT Comparison
Sep 17, 2022 - Compare and contrast the NFT market and ecosystem across at least three different chains (you can do more if you wish, but there must be at least three included.) Explain how the various chains differ in terms of metrics such as: Total Sales, Total Unique Buyers, Total Volume, Average Sales/Day, Average Buyers/Day, Average Sales Price/Day
DEX Change
Nov 17, 2022 - This week has highlighted the need for transparency & decentralization in crypto markets. Let's see how users have reacted to this wild week in Web3. Have behaviors changed? Analyze growth in Osmosis Volumes & User Count this week.
Velodrome Locks
Jul 18, 2022 - Analyze new locks created on Velodrome Finance. What durations are most common? Which wallets have locked the most in the last 4 weeks? Which pools are wallets voting for with their locked tokens most often?
Quixotic NFT Dashboard
Aug 3, 2022 - Q7. Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism!
Miners: Flash
Sep 9, 2022 - Do certain miners prefer mining blocks with lower transaction count? Do certain miners only mine blocks with high transaction count? You can define what can be considered low or high transaction count based on the transaction count distribution
Burn the House Down
Jun 8, 2022 - Q8. Find the week that the largest volume of OSMO burning happened. What caused this event? Show some of the events that this burning had on the Osmosis ecosystem. Hint: Look at the msg_types of transactions to determine when Osmosis is being burnt.
What makes a Top Shots moment valuable? (Part II)
Oct 12, 2022 - Building off Part I of this question, released earlier this year, create an analysis of NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume.
Secondary NFT Market Mega Dashboard
Oct 5, 2022 - Sales volume (daily/weekly/monthly) Total Sales Volume Daily Average Sales Price and 7-day moving average Total Unique Buyers Average Buyers/Day
Polygon Block Performance
Jul 26, 2022 - What is the average time between blocks on Polygon? What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
Swap Pairs on Optimism
Jul 21, 2022 - Create a document that includes all addresses for all swap pairs for Sushiswap on Optimism plus the addresses of the two tokens belonging to each pair. Getting the decimals for each of the tokens in the pair would be a bonus. If you are using sources from sushi github, please include the link.
Opensea Fees
Aug 2, 2022 - Q6. Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
Failed Transactions
Oct 3, 2022 - Which user action results in the highest rate of failed transactions? Compare swapping, borrowing, lending, and adding or removing liquidity on Sushiswap-Ethereum.
Transaction Fees
Feb 4, 2022 - 1-What is the total amount of fees generated on Algorand since the first block? 2-Plot fees generated over time by day on Algorand since the beginning of 2021. 3-Create a table of the top 10 wallets that have generated the most amount of fees in 2022. List both number of transactions and fees of the wallets.
New Year, New LUNA?
Jan 12, 2023 - Create a dashboard documenting significant trends in transactions, wallets, supply, staking, development, or other aspects of the Terra ecosystem. Note any changes in metrics such as the average and total transactions per week and the fees associated with them, the total and average number of new wallets created each week, the total and average number of contracts deployed, LUNA staked, and anything else you find interesting.
Flash Bounty: LUNA Head
Oct 7, 2022 - What's going on with LUNA, aka LUNA 2.0? Is there any unusual activity? Major whales buying or selling? What dApps are people using?
OP Price vs Swapper Activity
Oct 6, 2022 - Is there a relationship between OP price and trade volume?