elay
ETH Staked
Jun 12, 2022 - What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
Bot Swappers
Apr 27, 2022 - Define bot swappers. How does the behaviour of bots differ from average swappers? For instance in terms of number of swaps, or in terms of distribution of swaps over a day. What percentage of swaps were executed by bots in the past 30 days? What pools and what pairs were most popular among bot swappers in the past 30 days.
Top TOKE Holders
Jun 22, 2022 - Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
Getting Your Feet Wet, Part 1
Mar 7, 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)
Active Wallets on Terra
May 3, 2022 - Define "Active Wallets" on Terra. Based on your definition, display the active wallets by day, month, and Year-To-Date in 2022.
Synth Utilization
Apr 13, 2022 - Calculate the synth_utilisation of each pool and chart over time.
Governance Period 2 Payouts
Apr 15, 2022 - Q49. Let's look at the Algorand Period 2 Governance Rewards Payouts How many reward payments were sent? And what was the total amount of ALGO rewards paid out? How much time elapsed from the first to the last rewards payment? What wallet had the largest rewards payout and how much did they receive? Create a plot to show the distribution of rewards payouts.
Kujira Scavenger Hunt (Vietnamese)
Jan 28, 2022 - Kujira Scavenger Hunt (Vietnamese)Một nền tảng tuyệt vời và hấp dẫn giúp làm việc với người đó gần hơn với ước mơ tài chính của anh ấy
Saber Proposals & Gauges
May 31, 2022 - Create a visualization showing the total amount of SBR locked over time and voter participation rates. How many wallets that have locked SBR actually voted on a proposal? How many wallets that have locked SBR actually voted on a gauge? Wallets that have voted on proposals and gauges? What trends are you seeing in voter participation?
Terra Altcoin Behavior
Feb 10, 2022 - Select a Terra “altcoin” (i.e. not LUNA/ANC/MIR) and assess their performance over the past 90 days, using a metric of your choice (examples: price, number of transactions, volatility.) What do you think are the prospects for your chosen altcoin?
Celsius Swaps
Jun 22, 2022 - Q95. Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. From which one of their wallets did they conduct most of the swaps? Hint: you can find all addresses belonging to Celsius network by querying this table: flipside_prod_db.crosschain.address_labels
Gain or Lose
Jun 12, 2022 - Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose depending on the peg of stETH to ETH at the time of the swap?
Magic Eden Volume Trends
Mar 16, 2022 - Question 36: Create a visualization of Magic Eden total sales volume per day since January 1st. How has sales volume trended over time? Are there any trends to when sales volume seems to go up or down on certain days of the week or during certain times of the day? Are users more likely to trade a NFT during the week or the weekend?
Terra Scavenger Hunt (Farsi)
Jan 25, 2022 - Flipside پیش LUNA کردن( Stake/Delegate( دلیگیت/استیک)
What Are Whales Swapping For
Apr 15, 2022 - 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.
NBA Playoff Usage
Jun 28, 2022 - Analyze the start of the NBA playoffs (mid-April) and determine whether it had an impact on Flow transaction volume. What about NBA Top Shots?
User Growth Per Sector
May 4, 2022 - What sectors / Apps are driving user growth on Terra ?Choose the top apps per sector (DEXs, Borrowing, Staking, NFTs ...) and create a dashboard of user growth per sector and App. Are there any sectors / apps that are driving more user growth than others?
Pros of SOL
May 25, 2022 - Why should developers build on Solana compared to other L1 chains? What features for developers does Solana offer that make it appealing?
Terra LP-ers: Aftermath
Jun 21, 2022 - Q102. What did people that were LP-ing in the Terra pools do? Are they just holding onto their $RUNE now or are they back in the arena LP-ing somewhere? Or did they sell their $RUNE and leave the ecosystem completely.
Privacy Coins + Politics
Jun 14, 2022 - Q10. Do major news events result in more people swapping to SCRT? :Look at the volume of swaps to SCRT over the past three months. Do periods of high volume swaps into SCRT line up with major international news events? Or is there a pattern in SCRT swap volume? For payment, submit the address of your Osmosis wallet.
HODL or Sell
Jun 15, 2022 - dentify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. Have they held or sold their stETH?
Transactions by Protocol
Jul 14, 2022 - Q115. Using the following App ID lists from Folks Finance, AlgoFi, Tinyman, and AlgoDex, lets look at what percent of transactions their app calls and associated transactions(transactions in the same tx_group_id) make up on the Algorand blockchain. How have the number of transactions changed over time for each Protocol? Also how much in fees have been spent on transactions relating to each protocol? Other things that can be explored are what type of transactions are each protocol producing, or has the price of ALGO been an influence on the number of transactions produced by each protocol.
Around & Around We Go (Circulating Supply)
Feb 23, 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.
Bridge Users (Hop Protocol)
Jun 20, 2022 - How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
What Are Users Swapping gALGO3 For?
Apr 28, 2022 - Show the number of trades to gALGO3 and from gALGO3 by day? Also chart the volume of trades to gALGO3 and from gALGO3 by day? Are there any notable days? If so, what may have caused this? What DEXes are users swapping gALGO3 on? Show the breakout of number of gALGO3 swaps(to or from) by day for each dex. What are the top 10 most popular to swap from to get gALGO3? What are the top 10 most popular to swap to from gALGO3?
Orca + Jupiter Volumes
Mar 16, 2022 - Question 35: Compare the 5 most popular swaps SOL -> coin swaps (SOL swapped for another coin) on Orca and on Jupiter since January 1st. Create a visualization showing the total volume per day on Orca and Jupiter since January 1st for SOL to another coin swaps. What has been the historical swap success rate since January 1st on Orca and on Jupiter?
"Small" LP Actions
Apr 13, 2022 - What percent of LP adds to each pool are small (<$1k USD)? Is there a relationship between the chain and the proportion of “small” LPs?
Total Metamask Users
Jun 25, 2022 - How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher order activity, like staking?
Bots and success rate
Apr 27, 2022 - Compare the success rate of transactions executed by bots in the past 60 days with average users' transactions in the same time period. Is there any difference and any trends identifiable?
Solport vs. Magic Eden
Apr 5, 2022 - Q48. Solport - a NFT marketplace on Solana - launched a V2 on March 12th that includes various new features for marketplaces. Beginning on March 12th, compare the NFT sales volume on Solport to Magic Eden's sales volume. How many unique wallets have used Solport over that timeframe compared to Magic Eden?