banbannard
Crazy Goose Flock and $CRUMB Token
Jun 9, 2022 - Chart the holder breakdown of the CGF NFTs. How many holders hold more than one CGF NFT? Who holds the most CGF? Show the wallet balance distribution of CGF holders. Are there any whales holding a CGF? Also chart the wallet creation date for crazy goose flock holders. Are the wallets who hold CGF newer or older? The Crazy Goose Flock are also airdropping their community utility token to CGF holders. Show these airdrop transactions. Who are the biggest $CRUMB holders?
Daily stETH Metrics
Jun 7, 2022 - Find the following stETH metrics: -Daily volume of stETH? -Average stake size? -Number of stakers over time? -Average time staked? -Staking/unstaking per day?
Tracer Voters
Mar 1, 2022 - How many people (addresses) have voting rights in tracer? How much of that has been deposited in major decentralized exchanges(DEX)? what is the breakdown per DEX
Single-Sided Liquidity Pools
Jun 22, 2022 - Across uses single-sided liquidity pools to execute transactions between chains. How are Ethereum mainnet users interacting with these pools? How do these pool rewards compare to other liquidity pools?
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?
NFDomains
Jun 23, 2022 - Look at number of NFDomains have sold by day and how much revenue they have generated for NFDomains? -Look at how many wallets have bought an NFDomain by day. -Show the distribution of the number of NFDomains purchased by wallet. -Show the distribution of the amount of ALGOs spent on NFDomains purchased by wallet. -What are the top 10 biggest NFDomain sales? -Note any other interesting insights such as fees generated from secondary sales or average purchase price of an NFDomain sale.
zkSync Scavenger Hunt
Jun 14, 2022 - I had fun completing this zkSync Hunt. Thanks Flipside :D
Tinyman Assets
Jan 11, 2022 - - Before the Tinyman hack, what were the most popular assets to swap with Algo in the Tinyman Dex[App ID 350338509]? - Does the average amount of algo swapped changed based on the asset that it was swapped for?
Ch-ch-ch-ch-changes
Feb 9, 2022 - How has MIM usage changed since January 23rd? Are there any notable changes in market cap, transaction volume (transaction count and dollar values), users holding it, or in liquidity pools?
Tinyman 1.1 Launch Swaps
Jan 27, 2022 - What have been the most popular swaps on since the launch of the new Tinyman dApp? What swaps have had the largest amount of swaps by ALGO volume since the new launch?
RocketPool Recent Activity
Apr 26, 2022 - Using the Ethereum_core schema, analyze inflows and outflows to RocketPool over the past three months. As we near the ETH 2 merge, are there any emerging trends? What is the average deposit size and how has that changed vs. historical performance?
New Wallets In May
Jun 16, 2022 - How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May? How many new wallets were created in May? What % of total wallets with more than 1 ALGO is this? Additionally, show the distribution of ALGO holdings for these new wallets. What is the average ALGO holding of these new wallets? What other ASAs do these new wallets from May hold? How many of these wallets have performed a swap?
IL Payout vs LP Age
May 7, 2022 - Show a breakdown of the average IL payout by the amount of time spent in the pool
Current Wallet Rewards
Feb 3, 2022 - Let's check out the rewards wallets have received. Show the distribution of rewards among wallets.(Look at the total rewards column in the account column for the current rewards total distributed to each wallet) Do we see wallets that are more engaged in the ecosystem received more rewards?(Look at total number of transactions by wallet and plot that against total_rewards in a scatter plot) We should see a correlation between wallet size and total rewards received. Is this true? (Plot the wallets' current balance against total rewards received with a a scatter plot)
Market Module
Apr 5, 2022 - Explain in your own words what Terra’s “market module” is, and how it functions. Define at least two key metrics for the market module, and demonstrate how it’s performing in its stated goals based on these metrics.
LUNA Distribution Mvmt 1: The Basics
Jan 22, 2022 - People who do not like crypto often cite wealth inequality as a reason: they claim that the tokens are concentrated in the hands of a few whales. Assess this claim for LUNA. How much of circulating supply is held by the top 100 addresses? Top 1%? Top 10%?
Volume Scoring with NBA Top Shot
Jun 6, 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? How do those metrics compare to sales volume and unique users of Magic Eden on Solana and OpenSea on Ethereum?
LUNA Distribution, Mvmt II
Feb 5, 2022 - What is the distribution of LUNA for active wallets (i.e. wallets with at least one transaction in the past 90 days? What is the distribution of LUNA if wallets that have never transacted are excluded?
Terra NFT Trading Volume Trends
Feb 11, 2022 - For the 10 most popular project on RandomEarth, what projects have seen the greatest increase in volume in the last 30 days? (LUNA + UST figures) Create a visualization showing percentage change in volume over the past 30 days for these projects. What projects seem to be trending and what seems to be fading?
Hop Whales
Jun 20, 2022 - Are whales choosing Hop to go to L2s? Or are they choosing the native bridges? Compare Hop vs the native bridges for Polygon, Optimism, and Arbitrum over the following metrics: unique users on each, frequency of use, and the average amount of assets moved on each?
Burn the House Down
Jun 6, 2022 - 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.
Active Wallet Addresses
Jun 27, 2022 - We are interested in knowing how many users are currently in the ecosystem. In this case, how many are holding $RUNE in their wallet or have an open LP position. What is this number currently, and how has it trended over time?
Do Users Hodl?
Feb 6, 2022 - What is the average length of time between a deposit and a withdrawal in the ETH and BTC covered call vaults? Has this holding length changed over time? Use a visualization to show this trend and provide some insight on why the observed trend is occurring.
Foundation Fees vs Others
Apr 22, 2022 - Compare creator and platform fees on Foundation vs. other NFT platforms over the past three months. Can we make a conclusion on if one platform is better for creators that others?
ETH + USD in the FWB Treasury
Feb 20, 2022 - Create a visualization showing the amount of ETH and USDC held by the treasury wallet over time (quantity and USD value). What other assets has this wallet been holding? How do you think treasury wallet performance affects $FWB token price?
Sushi Rewards
Jan 18, 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?
AB2 Gallery Wallets
May 25, 2022 - Let’s look at wallets that buy from AB2 Gallery! How many wallets are buying NFTs on AB2 gallery. What is the total number of unique wallets that have purchased from AB2? Create a distribution plot of how many NFTs each wallet has purchased from AB2. Are we seeing new wallets purchasing on AB2 or is it only wallets that have purchased from AB2 before? Chart the first purchase on AB2 by wallet over time. Create a table of the top 10 wallets that are purchasing from AB2 by ALGOs and number of NFTs
Outbound Traffic
Mar 13, 2022 - The Terra Bridge has expanded its capabilities: https://twitter.com/Speicherx/status/1501883479457288193 Create a dashboard to track the outflows of LUNA and UST to Osmosis, Secret, Axelar, and Injective. What conclusions can you draw from the outflows thus far?