banbannard
Active Daily Wallets
Mar 2, 2022 - Let's look at daily active addresses on Algorand. -Compare the number of active daily wallets for the month of January 2022 to December 2021 and January 2021. What day had the most active number of wallets in January 2022? Was there an event on Algorand associated with this date?
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).
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.
New NFT Mints
May 16, 2022 - 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.
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)
MIM + Anchor
Feb 9, 2022 - How much of the current deposits to Anchor Protocol’s Earn product are from the MIM Degenbox Strategy? How has this changed over the past 30 days ? What would be the implications of Disabling MIM Degenbox Strategy? Could Anchor limit the MIM Degenbox Strategy to a certain percentage of deposits?
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?"
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?
What's Going On With Gnosis?
Oct 16, 2022 - Let's learn about Gnosis together by looking at some Gnosis data and statistics!
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?
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?
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?
Dynamic Rate, Mvmt. I
Mar 21, 2022 - Based on defensible assumptions for key inputs (e.g. Anchor’s collateral blend and growth, as well as rates paid to borrowers), define a target range (+/- 1.5%) for the Anchor Earn rate that you think would be sustainable without regular capital infusions Assess the impact of declines in “earn rate” for other protocols, e.g. Aave, Compound, on key protocol metrics (e.g. user growth/decline, rate of user growth/decline, capital deposited, etc.)
Flipside GodMode NFT
Jun 8, 2022 - This dashboard will go through Ethereum profile of those who minted during the first hour after GodMode's launch
Stability Fee
May 15, 2022 - How impactful is the stability fee (the interest rate) on DAI loans in terms of the impact on volume and dollar amount of loans taken out? How does activity with DAI tokens change when the stability fee is different?
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?
New Users on Algorand vs. Ethereum vs. Solana vs. Terra
May 4, 2022 - Algorand, Ethereum, Solana and Terra What trends do you see?
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)
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?
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?