Biggest Losers
Jan 21, 2022 - Who lost the most upside by redeeming their PEOPLE tokens instead of selling them? Build a future proof query that shows how much they would make by selling them now. Build another query that shows how much they would have made if they had sold the top (if we reach a new high, the query should identify that as the new top)
Fastest Growing Uniswap Pool
Apr 1, 2022 - What is the fastest growing pool in the last 30 days? Define any metrics that you use to determine what the “fastest growing pool” means.
PEOPLE on the Secondary Market
Jan 24, 2022 - Has anyone bought PEOPLE tokens on the secondary market and then redeemed them instead of selling them or holding them? In cases where this happened, did they make or lose money?
Validator Ranking
Jul 9, 2021 - Are the same validators that were in the top 10 (by rewards received) last month in the top 10 this month? Top 5? Break this down by change over the weeks in the past 2 months as well.
Net Liquidity
Dec 18, 2021 - How much liquidity is being added and removed from the THORChain pools over time? Is there a noticeable trend?
Sushi Rewards
Jan 20, 2022 - Which pools are giving out the most Sushi tokens per $1000 per day? What are the returns on these pools without the Sushi tokens?
Arbitrum Network Health Check
Mar 29, 2023 - ARB Token Airdrop Impact: User Behavior, Network Growth, and Ecosystem Insights
DAI on the Market
Jan 18, 2022 - Analyze large shifts in the amount of DAI on the market over the past year. What might have caused these shifts? Are these events related to Maker directly? Are they related to the crypto ecosystem as a whole? Provide metrics to support your analysis.
When Do Flow Transactions Fail
Jun 4, 2022 - what addresses and contracts are causing the majority of failures? What types of activities and events are these addresses doing that are spamming the network? What types of arbitrage opportunities are they seeking and how profitable are these efforts?
Limit Swap Orders
Feb 27, 2022 - How popular is the limit order functionality in sushiswap? How many users have used it so far by placing limit orders?
The DEX Kings of L1
Mar 25, 2022 - Uniswap is the leading DEX on Ethereum. Use the standard metrics to compare Uniswap with similar dominant DEX's in other L1 chains such as Raydium, Terraswap, Tinyman, etc
Flow vs L1s
May 30, 2022 - Create a dashboard comparing the following metrics between Flow, Solana, Ethereum, and Algorand. Visualize these metrics over time since May 9th.
Gas guzzler
May 5, 2022 - How much of the total daily Ethereum gas fees are related to Uniswap usage since the start of 2022?
Aave Staking Reward Flows
Oct 13, 2021 - Analyze how Aave rewards (staking) are spent on mainnet -- are they reinvested into positions? Used to pay down loans? Simply liquidated/swapped for ETH?
Volume Scoring with NBA Top Shot
Jun 4, 2022 - NBA Top Shot allows users to buy, sell, and collect NBA NFTs that showcase influential “Moments” minted on the FLOW blockchain. Create a visualization tracking the total sales volume traded on NBA Top Shot since May 9th by day. How many unique wallets have made a trade on Top Shot over that timeframe?