banbannard
GMT Airdrop
Mar 20, 2022 - Create a graphic showing the wallets that received the GMT airdrop and highlight the top recipients of the airdrop. What have recipients done with the airdrop? Are these "trailblazers" holding their airdrop or are they selling? Have the top recipients been more or less likely to hold onto their tokens?
State of RUNE Activity
Dec 22, 2023 - These metrics exclude data from arbitrage bots - excluding wallets that have conducted more than 150 swaps within a two-hour window.
$RUNE Distribution
Apr 24, 2022 - Calculate the distribution of $RUNE holdings by address. Include RUNE that is in liquidity pools. (e.g. if I have 100 $RUNE in my wallet and LP 50, I should still be considered to be holding 100).
Magic Eden vs OpenSea vs Random Earth
Mar 22, 2022 - What has been the rate of change of these metrics since the start of the new year and are there any signs of growth of a certain marketplace or ecosystem of NFTs? Highlight the 5 most popular NFT collections for each marketplace over that timeframe in terms of sales volume. Is the turnover rate (number of transactions) for collections on Magic Eden noticeably higher than on OpenSea and Random Earth? Provide some insights on these findings.
FWBpro Airdrop
Feb 23, 2022 - What percentage of people receiving the FWBpro airdrop have held onto their tokens? Were people more likely to sell right after the start of the airdrop or has selling happened over time? Are there any patterns to holding vs selling behavior among wallets? Were larger holders of $FWB Classic more likely to try and mitigate risk after the hack?
P2P NFT Lending with Yawww
May 10, 2022 - Which wallets have been most active in Yawww in terms of lending and in borrowing? Which NFTs have been the most involved in these lending agreements since Yawww has launched? What percentage of these loans have been paid back so far?
Weigh Anchor (Users)
Jan 9, 2022 - Who are the top users (by address) of Anchor Protocol? Are they retail investors or protocol/enterprise users? Whales or small fry?
DAI Volume (May 13)
May 14, 2022 - How does the daily volume of DAI transactions compare to other stablecoins? What is DAI most used for?
ETH Staked
Apr 4, 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?
Staking SOL on Marinade
Mar 7, 2022 - Create a visualization showing the amount of SOL staked on Marinade since the beginning of February. What is the average amount of SOL staked on Marinade per transaction, and what were the 10 largest transactions? Create a histogram showing the distribution of SOL staked per transaction. What are the most popular tokens that mSOL is swapped for on Jupiter?
Sushimaker
Apr 27, 2022 - Ever wondered why you generate yield by parking your SUSHI's in the sushibar? (yes yes, the staking). Well, the Sushibar is always served with fresh SUSHI from a contract that is called Sushimaker. Describe the role of sushimaker and say how many SUSHI's it serves to the sushibar per day. Also compare the amount of sushi that is being staked by users with the amount of sushi that is being served by sushimaker.
Top Kashi Pairs III
May 25, 2022 - Find the top 5 kashi pairs based on: A- The number of loans they have generated B- The total available for lending (in USD) C- Total collateral deposited (in USD)
Unique Programs
Feb 12, 2022 - One way to track developer growth in an ecosystem is through the number of unique contracts used. Create a visualization of the number of unique programs used per day since the beginning of January. What are the 5 most commonly used programs over that timeframe? What do those programs do and why do you think they are so popular?
Lido Rocket Pool Comparison
Apr 25, 2022 - Use the ethereum_core tables to compare deposits to Lido and Rocket Pool
Algorand Blockchain Block Performance
Jan 17, 2022 - Let's take a deeper dive into Algorand's blockchain performance! First, let's look at block times: What’s the average time between block and how has this changed over time What’s the max recorded time between two blocks? What’s the minimum recorded time between blocks? Next, let's look at block size: How many transactions did the biggest block have? And what was the make up of this block(i.e. what type of transactions did it contain?)? Has the number of transactions per block increased as network adoption increased(Chart the number of transactions per block over time)?"
Contractually Obligated
Mar 8, 2022 - Based on your analysis for #161, provide the top 20 smart contract addresses that users interact with or the top 2 smart contract addresses per each of the protocols that you previously analyzed. Grand prize-winning submissions will assess both!
Bubblegoose Ballers Mint
Jun 15, 2022 - How many unique wallets minted a Bubblegoose Baller NFT and how many NFTs did these wallets purchase on average? How many NFTs were purchased with ETH using Crossmint? Identify any notable trends in minting activity and secondary market sales in the days following the launch. Which group(s) was most likely to "diamond fin" their NFTs?
Realized APY
May 14, 2022 - Visualize the realized APY of LP-ers that have removed liquidity from THORChain. What was their actual APY vs HODL (accounting for impermanent loss) when you pro-rate it for how long they were LP-ing for? Are certain pools out-performing others?
Astroport Rewards Analysis
Apr 15, 2022 - How much ASTRO is allocated for rewards? What percent is currently being used and how is this changing over time?
Node RUNE in/outflows
Feb 1, 2022 - Are Node operators selling/swapping more Rune per week than before EMISSIONCURVE changes? (blocks: 3636274 value: 16), (block: 3704556: value 8)
Proof-of-Work on Ethereum
Sep 9, 2022 - We will explore Ethereum miners and their transaction count per mined block in this dashboard
Wallets Investigation - Transactions, Interactions and Transfers
Aug 10, 2022 - [DAILY UPDATED] This dashboard tracks Metaplex wallets' transactions, interactions and transfers
Mango Market Flows
May 10, 2022 - Track Exchange wallet flows and volume in and out of Mango Markets. Generate a daily aggregate of how the following venues exchange value with Mango Markets and also between each other on the Solana blockchain. Is FTX a central source of capital flowing into Mango? From what protocols does capital seem to be flowing into Mango programs? Where do users send assets to after using Mango Markets? Limit the analysis since the month of March.
Solana Fees
Feb 5, 2022 - One of the main advantages for a user of Solana is the extremely low fees relative to other blockchains. Create a visualization showing transaction fees per day accumulated since the beginning of January. Also create a visualization that shows transaction fees per transaction on each day. Do fees ever seem to spike or is it consistent?
% of Solana Staked
Feb 12, 2022 - Using the "Events" table, what percentage of Solana that has been transacted is staked? How has that percentage changed throughout the month of January? Create a visualization showing % SOL staked over time. What is the average amount of Solana staked during a staking transaction?
GMT and SOL into StepN
May 5, 2022 - GMT is the governance token for StepN that will provide holders with a share of all fees earned within the app. However, recently StepN has made some changes to require using GMT in the game mechanics itself to give it additional utility and incentivize burning of the supply. Currently, the only way acquire GMT is by trading for it (you can not currently earn it in the game, this will change soon). Track the flow of GMT into the app. How are users acquiring GMT? Is by swapping using a DEX like Jupiter, or do flows seem to be coming from centralized exchanges? How often is GST (the token earned in the game) swapped for GMT? What other actions are wallets that are sending GMT into the app doing? Additionally, where do SOL inflows into the app seem to be coming from? Does it seem like most StepN users were already active within the Solana ecosystem, or is there a lot of activity that originated from inflows from centralized exchanges? Essentially, is StepN onboarding users into Solana? Create visualizations showing these inflows of GMT and SOL into the StepN app and if the announcement of Coinbase adding StepN to their list of tokens sparked additional interest from sources outside of the Solana ecosystem."
It's the Catalina Whale Mixer
May 17, 2022 - Catalina Whales are a popular NFT collection on Solana with an experienced team from the entertainment industry. Chart their sales history and unique holder trends over time. The project has a tier system of holders (5 whales gets you tier 2 status and 10 whales gets you tier 3 status), has this noticeably influenced wallet activity? The project recently announced that you had to own a whale before 5/11 at noon EST in order to qualify for the whitelist of an extremely hyped mint Bubblegoose Ballers along with other benefits. How has that influenced sales activity and holder activity over the past few weeks?"