Sniper
Distinct Wallets (zkSync)
Jun 16, 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.
Solana Since The Mango Hack
Oct 16, 2022 - What has been happening in the Solana defi ecosystem since the Mango Markets Hack?
Comparative Analysis of Governance Voting and Staking Metrics on the NEAR Blockchain
Jun 16, 2023
Liquidity Providers Stats
Aug 24, 2022 - Q109. Liquidity providers stats 1. Evaluate the distribution of various target segments who provide liquidity (LP) 2. Evaluate the profitability of an LP Provider & Yield Farmer
The Whales of NEAR
Feb 15, 2023 - Where in the ocean of NEAR do the whales hang out? Examine the top 20 addresses by amount of NEAR held - excluding any custodial or exchange addresses that you can. Can you identify any “power players” or wallets of interest? What behaviors do these whales exhibit?
Wildlife Warriors NFT Drop
Jun 23, 2022 - Q105. Wildlife Warriors was a project established by Steve Irwin in 2002 as a way to include and involve other caring people to support the protection of injured, threatened or endangered wildlife. They recently had an NFT drop(https://twitter.com/wildwarriors) on Algorand to support the project. Lets look at the wallets that own one of these NFTs: -Look at when the wallets were created(created_at) that own a wildlife warrior. Were wallets created recently for the drop or are they more established wallets? -Look at the ALGO balances of wallets that own a wildlife warrior and show the distribution balances -Look at how many Wildlife Warriors each wallet holds. -Is there a correlation between how many Wildlife Warriors a wallet holds and their ALGO balance?
FLOW User Retention vs Other Chains
Dec 19, 2022 - How sticky are the users on Flow? Create a detailed analysis comparing user retention on Flow vs. other L1 chains like Ethereum and Solana. How often do users who make a transaction come back and make another transaction one month later? How do monthly active users compare between chains?
Opensea Fees
Jul 30, 2022 - Q6. Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
Quarterly Overview of Avalanche in 2023
Dec 31, 2023 - In this dashboard, we are going to review quarterly transactions, users and fees on the Avalanche network in 2023.
New Wallets from NFTs
Jun 9, 2022 - in this dashboard i Let’s look at the month of May and June to understand if the Algorand NFT scene is onboarding new wallets. For this we want to focus on wallets that have >1 ALGO and look at two different groups all wallets >1 ALGO and wallets created in May and June with >1 ALGO. we only want to look at arc69 NFTs.
Stable Coins Lent on Kashi
Jun 15, 2022 - Q92. Draw a chart showing the TVL of Stable coins on kashi pairs across all markets. Hint: You can include USDC, USDT, DAI and UST in your analysis and look for the transactions where they are deposited on Kashi for lending. The event name would be 'LogAddAsset'. Removing them will generate 'LogRemoveAsset'.
Open Analytics Bounty: Optimism (October 8)
Oct 13, 2022 - This dashboard is about the Velodrome. In this dashboard, all the items in the Velodrome have been reviewed
Stablecoins on Kashi
Jul 14, 2022 - Q102. Analyze the behavior of stablecoins on Kashi markets.