mhm
Getting Your Feet Wet, Part 1
Mar 6, 2022 - Question 160: Make a table containing wallet addresses whose first transaction was 90 days ago or less. Analyze how active they have been since that first transaction, based on either 1) the number of transactions; 2) the number of protocols interacted with, or 3) the number of different types of transactions undertaken. (deposit, delegate, vote)
"Small" LP Actions
Apr 14, 2022 - What percent of LP adds to each pool are small (<$1k USD)? Is there a relationship between the chain and the proportion of “small” LPs? We're particularly curious to know if chains with low gas fees (like Terra) have a larger proportion of small LPs than chains with high gas fees (like Ethereum). Hint: use thorchain.liquidity_actions
Folks Finance Scavenger Hunt
May 19, 2022 - In this dashboard, I will show the transactions of receiving ALGO in my Pera wallet. Deposit ALGO in Folk Finance and Borrow Asset on that platform.
Ecosystem Anchor
Mar 17, 2022 - Question 165: Create a graph to show either: a) the token price (over a time period of your choosing) OR b) a bubble chart with total value locked, for all the Terra projects that depend on Anchor to create their yield Bonus: for grand prize consideration, show a visualization of the number of Anchor-dependent protocols over time.
Fuse Pool Analysis
May 26, 2022 - Q3. Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? What differences can you identify?
New Addresses
Jun 1, 2022 - Q2. Draw a chart showing the number of new addresses every day on polygon(matic) network. New addressses are unique addresses that appeared for the first time in a transaction of Matic.
1. NFT Crossovers
Oct 12, 2022 - Create a dashboard that shows the crossover between the Optimism OP NFT projects by market cap. Which of the strongest projects tend to have the most crossover, and which projects have a wider mix of other communities?
1M New Algorand Wallets In May
May 19, 2022 - Q66. From May 4th to May 10 we saw over a million wallets being created. What are these new wallets doing on Algorand? Some things to look at: -Using the account table, show the distribution of ALGOs these wallets have? -Are these wallets swapping assets? If so, what assets are these wallets swapping for? -What assets do these wallets hold using the account_asset table? -Do we see any commonalities our patterns across these wallets?
Algorand Governance Period 2 Voting
Mar 11, 2022 - Algorand's 2nd Governance Voting Period Ran From January 31st to February 28th 2022(https://governance.algorand.foundation/governance-period-2), lets take a look at how wallets voted for or against xGovs.
Algorand - ASA Asset Transfers
Apr 7, 2022 - Q41. What have been the most popular assets to transfer since the beginning of February 2022 by the number of asset transfers and number of users who have transferred that asset? What announcements could have lead to these assets being popular?
Flow Scavenger Hunt
Mar 11, 2022 - The first step in getting involved in the Flow ecosystem is, perhaps unsurprisingly, creating wallet. This wallet will allow you to store your FLOW and interact with the applications in the ecosystem.
stETH - HODL or Sell?
Jun 16, 2022 - Q11. Identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. Have they held or sold their stETH?
LoftyAI Tokenized Real Estate
Mar 4, 2022 - Algorand Q27: LoftyAI is a tokenized real estate platform(https://www.lofty.ai/). You can invest in property via tokens distributed by Lofty AI, each being worth $50.
Algofi Scavenger Hunt
May 19, 2022 - In this dashboard, I will show the acquisition of ALGO tx. Show confirmation of a swap for STBL and I'll show the staking transaction on Algofi.
Most Popular Centralized Exchange For Algorand Wallets
Feb 25, 2022 - In this dashboard, we look at the popularity of centralized exchanges(CEX) when it comes to Algorand.
Top Kashi Pairs (II)
May 19, 2022 - Q80. Find the top 5 Kashi pairs on Ethereum based on the number of loans they have given out so far. Choose one that you like, and describe the following information: How many people are lending on this pair at the moment? How much each user is lending at the moment?
L1 Unique Users
Mar 17, 2022 - Question 37: Compare the number of unique wallets that have sent a transaction since February 1st on Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Solana compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks?
New User Onboarding
Jun 29, 2022 - Q.106 When a new wallet gets created, where are they first getting their $RUNE? Is it from a direct transfer? Or from a centralized exchange? From a $RUNE upgrade from BNB.RUNE or ETH.RUNE? Or from a swap from another chain's asset to $RUNE? If it's a swap, which chain/asset are they coming from? Are there any trends over time you can see?