Mojtaba-Banaei
#12.Moonbirds Mint Analysis
Apr 21, 2022 - What was the distribution at mint? How many wallets minted? Who minted the most?
#8. GMT Airdrop
Mar 22, 2022 - Q38. GMT, the governance token of StepN, was airdropped to its 5000 trailblazers (early adopters and supporters of the game) on 3/15. The airdrop amount was calculated from the amount of time played in the game.
Hot Contracts on Osmosis
Jul 12, 2022 - Since the beginning of May, answer the following questions: What are the top ten most popular contracts on Osmosis? What is the cumulative total of contracts launched on Osmosis, and have there been any spikes since the Terra crash or other noteworthy events?
Binance Bonanza
Oct 29, 2022 - On October 28th, 2022 Binance became the first CEX to list spot trading for $OSMO. Abruptly, OSMO price shot up around 32%. -- How did this news impact trading on Osmosis. -- Analyze OSMO trading activity on October 28th and this past week vs. daily & weekly averages. -- This analysis should occur against two time periods: the 60-day averages & the 60-days prior to the May Terra collapse. -- Did any other tokens see a spike in trading on Osmosis?
xx - NFL ALL Day - Thanks Giving Day
Nov 16, 2022 - The NFL's annual Thanksgiving games recently drove record viewership in the U.S., with 42 million people tuning in to see the Giants take on the Cowboys. Did FLOW NFT project NFL ALL DAY see similar boosts in popularity? Create a dashboard that analyzes NFL ALL DAY NFT activity over the past week, and compares it to activity over the past year. Include at least these metrics, along with any others you find notable or interesting: Sales volume (daily)/ Total Sales Volume/ Daily Average Sales Price and 7-day moving average/ Total Unique Buyers/ Average Buyers/Day
#8. ASA Dex Degens
Mar 23, 2022 - Q38. Let's look at DEX wallet behavior with the algorand.swaps table to get an idea of how many swaps wallets are being conducted and see how many ASAs wallets are trading.
Going Down the Gnosis Native Bridges - Part 1 : xDai Bridge
Aug 6, 2022 - There are currently two bridges to the Gnosis network. If you want to transfer to layer 2, you must go through the bridges as they act as a gateway between the two networks.
Osmosis Decentralizing Power: Governance & the Active Set (Part 2)
Nov 4, 2022 - Props 114, 196 & 337 were all passed in an effort to promote decentralization within the ecosystem. After these proposals, how was governance impacted by this effort? Analyze the participation of the new validators on the governance proposals after the active set increases. Did new validators vote more or less than the original top 66% of validators? Did time play a factor? Analyze changes in governance participation after these proposals.
#17. Net $THOR Staked
May 24, 2022 - Q91. Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards. Show the net amount of $THOR staked over time.You will need to calculate the net amount staked + unstaked to get the net amount.
#7. L1 Unique Users
Mar 15, 2022 - 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?
#21. Solana Flash Bounty: Saga
Jun 24, 2022 - How many wallets have pre ordered Saga (the new solana phone) so far? Note: the preorder is a NFT purchase on-chain. Who is preordering the phone? Provide a breakdown of the type of wallets ordering so far. Example metrics to investigate: what other programs are these wallets interacting with, how active have these wallets been on Solana, are they average users or whales?!
WePiggy LockDrop on Optimisim
Aug 4, 2022 - WePiggy lending protocol (Beta) has been officially launched on the Optimism mainnet at 16:00 (UTC+8) on November 15, 2021! Based on what WePiggy’s core development team mentioned in the proposal of Optimism Governance Fund, WePiggy’s core development team developed the “LockDrop” function to achieve the purpose of locking more funds in the Optimism ecosystem, giving users more freedom of participation, and giving appropriate rewards based on their contributions. let's analyze this event on Optimism.
#13.Stargate User Growth
Apr 26, 2022 - How many unique users are staking capital on Stargate on Ethereum each day since its inception? What might this suggest about the protocol's growth? Note: Use the new ethereum_core data
#12. Forefront Participation Incentives
Apr 19, 2022 - Compare the incentives for participating in Forefront with at least two other social tokens/DAOs of your choice citing two metrics of your choice.
#19. User Activity - NFTX
Jun 14, 2022 - Q2. Analyze user activity providing and removing liquidity from NFTX vaults. Which three vaults have seen the most activity over the past 60 days? Are there any similarities between these vaults or NFT projects? Explain and visualize your findings.
#12.NFT Mint Sweet Spot
Apr 20, 2022 - Q54. Compare the mint price of popular Solana NFT collections to their resale price.
Bridge Volume
Jul 4, 2022 - Q7. Building off last week's question investigating when transactions fail on Flow, what addresses and contracts are causing the majority of failures? What types of activities and events are these addresses doing that are spamming the network? What types of arbitrage opportunities are they seeking and how profitable are these efforts? Compare these transaction failures to the botting issue that Solana has bene facing causing outages. How do they compare and how could Flow attempt to mitigate these issues?
#11. Most Popular ASA To Swap from ALGOs
Apr 14, 2022 - Let’s look at what ASAs (Algorand Standard Assets) are most popular to swap into from ALGOs in 2022 using the swaps table
#17.$THOR Staking Wallets
May 24, 2022 - Q90. Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards. How many unique wallets have staked $vTHOR? Chart this number over time.
#11. Magic Eden Whales
Apr 13, 2022 - Solport - a NFT marketplace on Solana - launched a V2 on March 12th that includes various new features for marketplaces. Beginning on March 12th, compare the NFT sales volume on Solport to Magic Eden's sales volume. How many unique wallets have used Solport over that timeframe compared to Magic Eden?
#13.LP-er Retention
Apr 26, 2022 - Take a look at thorchain addresses that have ever added liquidity. Group them by the month of their first date of adding liquidity. What % are still providing liquidity in the THORChain ecosystem? How does it look if you filter those that provided at least $10,000 in liquidity? Hint: use thorchain.liquidity_actions
#6. BANKLESS Liquidity Profiling
Mar 7, 2022 - Which liquidity pools and platforms are users using to acquire BANK tokens? Which tokens are being swapped most to acquire BANK tokens?
#12.Sablier Cash Streams
Apr 22, 2022 - Q9. Out of all streams of cash created on Sablier, how many have been cancelled before their stop time? Use Ethereum_core schema.
Flash Bounty: Miners
Sep 9, 2022 - Using the ethereum.core.fact_blocks table , Do certain miners prefer mining blocks with lower transaction count? Do certain miners only mine blocks with high transaction count? You can define what can be considered low or high transaction count based on the transaction count distribution
#2-143. Terra Altcoin
Feb 5, 2022 - Question 143: Select a Terra “altcoin” (i.e. not LUNA/ANC/MIR) and assess their performance over the past 90 days, using a metric of your choice (examples: price, number of transactions, volatility.) What do you think are the prospects for your chosen altcoin?
#19. ERC20 Tokens (zkSync)
Jun 14, 2022 - Q2. 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. Users can also deposit ERC20 tokens into ZkSync. Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days? Visualize and explain both findings.
#15.Token Activity - ParaSwap
May 9, 2022 - Q3. 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.
#19. Distinct Wallets (zkSync)
Jun 14, 2022 - Q1. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
#5. StepN Growth
Mar 1, 2022 - Solana Q30: . Create a visualization showing the number of unique wallets that have transacted with GST by day since January 1st. How much total GST has been transacted per day since January 1st? Provide some insights over the adoption of GST and how long it can accommodate its limitless supply as an in-game token.
#17.The Octorand Universe
May 26, 2022 - Q81. Octorand is a virtual world of opportunity built on top of the Algorand blockchain. Octo Primes are the only form of life existing in the world of Octorand. You can collect these Octo Primes, transform them to increase their value and trade them through the inbuilt marketplace.
#12.Hop Bridge Volume
Apr 21, 2022 - How many Matic token were bridged in 2022 per day from ethereum to layer2 using Hop?
#19. Highest Sales Volume - NFTX
Jun 14, 2022 - Q1. Which 3 NFT collections have the most total sales volume in the last 60 days on NFTX? These are transactions where someone redeems their NFTX tokens for a specific NFT.
#13.Cosmic Champs Token Launch
Apr 27, 2022 - Algorand based NFT Game Cosmic Champs have launched their project token $COSG. Let’s look at what users are doing with it.
#11. Fault Tolerant Staking
Apr 13, 2022 - Q2. Define Fault Tolerant Staking (FTS). What are the advantages of FTS? What are the disadvantages? Explain what problems FTS might help solve.
#13.Stargate Fishes and Whales
Apr 25, 2022 - 1 billion Stargate tokens were minted at genesis and will be the entire finite supply of STG. Define the terms fish and whale in terms of Stargate token ownership (in your opinion). What proportion of users fall into each of the categories you defined (fish and whale). Note: Use the new ethereum_core data
Avalanche BTC.b Bridge Insights
Mar 15, 2023 - In this analytical dashboard, our focus is on wallets that have used the BTC.b bridge on Avalanche and the actions they have taken with it. Specifically, we examine the chains to which users are bridging BTC.b using Layer0 and investigate the contracts and protocols they're using on the network. Additionally, we track the number of transactions they've made and analyze whether they're swapping BTC.b for other assets on Avalanche. These metrics will provide us with valuable insights into user behavior and trends on the Avalanche network.
#2. MIM + Peg
Feb 10, 2022 - How has MIM performed at holding/regaining its peg over the past few weeks. Is MIM depegging correlated with the price of other stablecoins, especially UST?