Saleh
Foundation Fees vs Others
Apr 22, 2022 - Foundation is an NFT platform that allows creators to mint their work as NFTs on the Ethereum blockchain. Foundation also offers an NFT exchange allowing creators
Validator Voting vs. Investor Inclinations
Apr 27, 2022 - Analyze the last 5 governance proposals. Out of the total Luna that voted in favor, how many % are from validators vs. retail investors for each proposal and on average? Grand Prize Worthy: are there any cases you can identify where retail voters and major validators tended to vote against each other?
New NFT Mints
May 18, 2022 - Q76. How many total new NFT projects have appeared on Magic Eden per day since the start of the new year (as in new projects that have minted that day)? Compare that to the total number of new NFT projects that were minted/created on Ethereum? Create a dashboard comparing the growth rates of the number of new NFT projects on Solana and Ethereum and understanding the amount of sales activity on ""new projects"" for each chain.
Token Activity
May 11, 2022 - What do people do with their PSP tokens? Once people acquire PSP tokens what do they do with them? Do they stake them? How long do they hold them for? Show the journey of PSP tokens.
Metaplex Bot Free
May 11, 2022 - Q72. Solana experienced another network downtime due to intense botting of a NFT mint. Solana has been working on a creative solution to deal with this botting issue called Quic, but Metaplex, the infrastructure protocol for Solana NFTs decided to implement a ""bot tax"" to help alleviate this issue.
Distinct Wallets (zSSync)
Jun 17, 2022 - Q1. ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. You can read more about ZkSync here. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
UST Competitive Advantages
May 4, 2022 - Why would a user choose to transact using UST over DAI (and vice versa)?
Stargate TVL Metrics
Apr 27, 2022 - Show how the Total Value Locked (TVL) of Stargate on Ethereum has changed since its inception. What percentage of the TVL is made up by each token staked on Stargate?
CowSwap Sushi Activity
Apr 22, 2022 - Using the Ethereum_core schema, find all transactions that interacted with the CoW settlement contract on ETH Mainnet (0x9008d19f58aabd9ed0d60971565aa8510560ab41) that also used Sushiswap as part of the execution. Why might they have done so?
Cross-chain Anchor
Mar 30, 2022 - Q7. Compare the Earn sides of Anchor protocol on Terra vs. Avalanche. What does the Earn side look like on Avalanche? In the last week, are people using it more? Is there more volume?
Rare Traits
May 4, 2022 - What Moon Bird traits are rarest? How have different traits performed with buyers and sellers?
Acquiring goBTC and goETH
Apr 6, 2022 - Where are users acquiring goBTC and goETH? Are they acquiring the assets by swapping or by minting? Has this changed over time? Explain the insights you find.
Swing and a Miss
Feb 14, 2022 - Question 147: In honor of the Terra <> Washington Nationals partnership, the Wormhole team is interested in “hit rate”: the percentage of successful vs. unsuccessful transactions.
Dynamic Rate, Mvmt. I
Mar 23, 2022 - Q170. A recent governance proposal (offers a dynamic Earn Rate as one solution to the problem of Anchor Protocol’s sustainability.
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%? BONUS: compare this to wealth distribution vs. a country or an index of your choosing.
Solana Competitive Advantages
May 4, 2022 - Why would a developer and / or a user choose Solana over Ethereum (and vice versa)?
Algorand x Fifa Partnership
May 12, 2022 - Q64. On May 2nd, Algorand announced a technical partnership with Fifa causing the price to move 25%. Over the rest of the week, how did this impact Algorand blockchain activity?
Active Weekly Users - ORBS
Dec 4, 2021 - Show the number of unique users (wallets) per week that transacted with Orbs over the past year
THOR-versary!
Apr 22, 2022 - THORChain Chaosnet just hit its 1-year anniversary. Calculate the following metrics, comparing THORChain in its first 30 days vs the last 30 days: total number of swaps, volume of swaps (in USD), TVL, # of pools, # of chains. Feel free to add any other metrics you feel would be interesting / relevant.
105. [Easy] Apollo’s Treasure
Dec 7, 2021 - During the $HALO farming event, how much new volume entered the Apollo vaults? Do you detect any trends? Provide at least one visualization to support your answer.
Swapping for YLDLY on DEXs
May 19, 2022 - Let’s get a better understanding of how people are swapping Yieldly(YLDY: Asset ID: 226701642). Show us the total volume inflow and outflow of Yieldly(YLDY: Asset ID: 226701642) by day in 2022 then break it out by DEX as well. Is swapping for YLDY more popular on some DEXs than others? Additionally what assets are users swapping for YLDLY? Are there any standout days of swap volume for Yieldly? If so, write about what may have caused that spike. Note any other interesting findings related to YLDY swaps!
Trend of Pools
May 18, 2022 - Q78. What kind of pools do user usually withdraw or deposit into for the last 90 days? is there any pattern/trend we can see from it?
NEAR Tournament Round 1: The Arts District
Jul 24, 2022 - What is a city without a thriving center for arts and culture?! (TOURNAMENT ENTRANTS ONLY) Analyze the NFT scene on NEAR. Projects, marketplaces, sales volume, user analysis, artist deep dive - as long as you provide an insightful and comprehensive take on an element of NEAR’s NFT ecosystem.
Velodrome Health (Redux)
Nov 16, 2022 - Create at least 5 metrics on Velodrome with a description for each that showcase traction and success in a data-driven manner.
LP Size Distribution
May 3, 2022 - What is the current distribution of LP size for each pool? You will have to use both 'add_liquidity' and 'remove_liquidity' to determine which LPs are stil current.
Fractional.art NFT Sales
Apr 27, 2022 - Q16. Using the Ethereum_core schema, analyze the 3 most actively traded fractional NFT vaults on Fractional over the past 3 months. How many NFTs are in these collections? What is the total trading volume? Add any other data points to your analysis that you find valuable.
Lido vs. The Field
Apr 6, 2022 - Q7. How does Lido usage compare to other top staking platforms? Choose 2 platforms to compare it to.
AB2 Gallery Wallets
May 24, 2022 - Q78. 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