banbannard
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?
AB2 Gallery NFTs
Feb 4, 2022 - Let's take a look at one of the most popular NFT marketplaces AB2 Gallery get a better understanding of their marketplace performance. Total Number of Assets Sold from AB2 Gallery? Daily Volume of sales in ALGOs from Assets being sold from AB2 Gallery? Daily Volume of assets being sold in from AB2 Gallery? What was the largest sale on AB2 Gallery?
Tracking UST on SOL
Feb 16, 2022 - There has been a focus of integrating UST in the SOL ecosystem in 2022. Identify the three most popular applications of UST in SOL DeFi in February. Can you calculate yield generated from these pools? Are "whales" more or less likely to transact in UST than USDC or USDT on SOL (can calculate this through avg value of each coin)? Highlight the 10 largest transactions in terms of UST in February. Are there patterns to the "whale" transactions and wallets?
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?
Content Bounty: Terra -> Osmosis
May 23, 2022 - Are Terra projects interested in migrating over to Osmosis? What is most important to Terra developers when looking for a chain to migrate to and why might Osmosis be a good choice?
Cross-chain Anchor
Mar 26, 2022 - 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?
RocketPool: User Profile - LIDO vs. RocketPool
Apr 25, 2022 - Compare and contrast activity on RocketPool vs. Lido over the past three months. Is one growing more quickly than the other? Can we conclude if one of these applications is better for users than the other? Are there different types of users using RocketPool compared to Lido, or are the user profiles similar? Visualize and explain your conclusions.
Transaction Fees
Feb 3, 2022 - All transactions on Algorand have a transaction fee of .001 but lets dive a little deeper into fees generated on Algorand. What is the total amount of fees generated on Algorand since the first block? Plot fees generated over time by day on Algorand since the beginning of 2021. Create a table of the top 10 wallets that have generated the most amount of fees in 2022. List both number of transactions and fees of the wallets. Using the asset transfers table, what are the top 10 assets besides Algos that have generate the most fees?
Facts_Lending
Mar 12, 2022 - Build a query for a fact table about sushi's lending activity on Polygon. What questions does your table answer(At least Two questions)? What other dimensions could potentially be extracted from sushi contracts and added to this table to make it more valuable?
Active Wallet Addresses
Jun 19, 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?
Who's That Going Across My Bridge (Redux)
Apr 19, 2022 - Pick one bridge from Terra and a destination of your choice. (e.g. Shuttle bridge Terra <-> Ethereum or Wormhole Terra <-> Solana). Assess the daily and cumulative amount of UST that goes through that bridge, both inflow and outflow. How many users are using the bridge on a daily basis? How many transactions take place on a daily basis?
Staking Yield, Mvmt 1: The Basics
Jan 16, 2022 - Explain in your own words (i.e. don't copy the documentations) how Terra's staking yield is calculated. Provide a graph that compares LUNA staking yield to LUNA price over a time period that you define.
Osmo Staking
May 29, 2022 - Over the past 30/60/90 days and since June 2021, how much OSMO has been staked per day? What is the staking percentage (OSMO staked vs. circulating supply) and how has it changed over time?
Flow vs Other L1s
Jun 20, 2022 - How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum
Is 2 Really Better than 1? (A Comparison Between Optimism and Ethereum)
Aug 4, 2022 - Lets compare the differences between Layer 1 (Ethereum) and Layer 2 (Optimism)!
% 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?
Orca User Growth
May 23, 2022 - Orca, a popular decentralized exchange on Solana seems to have been gaining significant adoptions over the last few months, especially compared to other exchanges. Create a visualization showing Orca adoption in terms of swap volume and number of unique wallets compared to at least two other popular Solana exchanges and Uniswap on Ethereum? What can explain this increase in adoption? Provide some insights on this trend and the types of users using Orca (hint look into which popular app on Solana is using Orca).
Impact of Adding New Chains/Tokens
Jan 15, 2022 - THORChain is planning on adding support for Dogecoin soon. Traditionally, what has been the impact of adding another chain (or token) on THORChain? Does swapping activity or THORChain wallet creation spike up?
Solana Outages
Jun 7, 2022 - Solana experienced another outage on 6/1 where validators were forced to restart the network. The network experienced a similar problem back on 5/1. After the restart happens during these outages, how do users on the network generally respond? Does the price of SOL drop because users lose confidence in the network? Is there more swapping behavior and more stablecoin activity? What protocols seem to have more activity after these types of events that on the average day in the Solana ecosystem? Is there more fear from defi Solana users than NFT enjoyers?
Synth Utilization
Apr 13, 2022 - Calculate the synth_utilisation of each pool and chart 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!
Impact of Terra integration on new wallets created
Apr 16, 2022 - Show the daily number of new Thorchain wallets created in the 10 days prior to and after the integration of LUNA and UST.
Opening Positions
Jun 28, 2022 - Over the last month, what volume of assets are Mean Finance (Polygon) users opening positions with (selling)? What assets are they dollar-cost averaging into (withdrawing swapped assets)? Note any large positions that don’t make sense on Ethereum due to transaction fees.
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?"
What Happens After A Withdrawal?
Feb 7, 2022 - Create a visualization showing net deposits vs withdraws into Ribbon pools over time. When a wallet withdraws their liquidity from an option strategy, what do they do with that liquidity? How often does a wallet deposit their liquidity into a different Ribbon pool after withdrawing from a vault (as their next transaction)? Which vault has seen the greatest inflow of deposits from another vault?