Ali3N
Osmosis Quarterly Performance Report
Apr 14, 2023 - a Q1 2023 Analysis of the Osmosis Ecosystem
True Freeze - 4. My Next Purchase
Jul 27, 2022 - What is the most common transaction (any transaction) users make after minting frETH?
ETH Down Bad
Nov 23, 2022 - The price of Ethereum has sank in recent days - how does it compare to other tokens amid a general market downturn? Can you find evidence of any potential causes for ETH's struggle? Are there any other indicators that could help us predict whether/when it could recover?
How Have Users Welcomed Mars Protocol & Its Token ?
Feb 26, 2023 - A comparison of Mars Protocol and $MARS token users since its launch on Osmosis in order to realize how have Osmosis users have welcomed Mars. Liquidity Providing, Swapping and Red Bank actions are the main analyzed actions in this dashboard.
Lava Network Overview
Jul 31, 2024 - Lava Public Mainnet Has Finally Launched on July 30, 2024...
Are Crypto-backed Stablecoins Broken?
Sep 8, 2023 - This dashboard offers a comprehensive comparison between crypto-backed stablecoins and the dominant players, USDT and USDC, within the Avalanche chain. We delve into their activity, adoption, and user trends to provide a clear picture of their respective positions in the stablecoin landscape. Join us in uncovering which stablecoin model truly reigns supreme.
Cats vs Sharks vs Squirrels!
Dec 12, 2022 - an in-depth comparison of Degen Fat Cats, Sharx & The Sinister Squirrel Syndicate NFT projects on Solana on the occasion of their recent hype during nowadays !
Average Optimism Portfolio
Oct 9, 2022 - What does the average Optimism user's portfolio look like and how has that changed over time? What % of a user's activity (in OP terms) is staked, unstaked, in liquidity pools/farms, in NFTs? How has this trend changed over time?
Decentralization Post Merge
Nov 9, 2022 - Ethereum recently switched to using a Proof-of-stake (PoS) consensus protocol. For more information on this switch, please see The Ethereum Organization.A new schema (`ethereum.beacon_chain`) was just released containing data around the Consensus Layer that can be used to analyze the Beacon Chain. Documentation for these tables can be found here. Using the beacon_chain schema, analyze the decentralization of the PoS network, as well as slashings of proposers and attesters since the Merge. Build a dashboard to summarize your findings / provide ongoing slashing monitoring.
NEAR City Layout
Oct 29, 2022 - How centralized or decentralized is NEAR, really? Choose at least two distinct measures of decentralization that can be explored with on-chain data; clearly define those metrics; and outline how NEAR performs based on those metrics. In your view, is NEAR becoming more centralized or decentralized over time? You are welcome to draw on any past submissions in your work, but ensure you credit and link to the original creator (bonus points if you shout them out on Twitter). Grand Prize submissions will also explore these metrics for at least one other blockchain.
Aave - 10. Aave Transaction Explorer
Aug 9, 2022 - Create a transaction explorer similar to Etherscan but for Aave.
NFT Royalty Comparison
Oct 4, 2022 - Which platform is the king of NFT royalties? Compare royalty payouts of 3 NFT marketplaces. Then choose at least 2 additional metrics to evaluate the impact of royalties on NFT market activity.
Optimism DEXs (redux)
Oct 22, 2022 - Let’s take a closer look at DEXs on Optimism. Make a dashboard that compares at least three DEXs.
USDC Declining on Solana?
Oct 3, 2022 - It looks like over the last few weeks the market cap of USDC on Solana has been declining. What appears to be the cause of this? Where is USDC being removed from the ecosystem and where is it being sent to? Does this trend seem to be driven by a few big whales, or does it seem more broad-based throughout the ecosystem. Are other stablecoins also dropping in market cap on Solana?
Orderly BTSE DEX (NEAR)
Mar 25, 2024 - Digging into the activity and users utilizing Orderly, one of NEAR’s most innovative and recently launched exchanges with an on-chain order book.
StarsArena Exploration
Oct 10, 2023 - StarsArena (also known as StarShares) is a SocialFi project on Avalanche with a unique burning mechanism. Let's Explore the top users and other metrics of the project that is taking the ecosystem by storm!
Build Your Own Mega Dashboard (Polygon)
Jul 31, 2022 - Q7. Combine prior grand-prize-winning submissions into a single, interactive dashboard that can give users a broad view into the Polygon ecosystem.
New Wallets In May (Algorand Bounty)
Jun 12, 2022 - How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May? How many new wallets were created in May? What % of total wallets with more than 1 ALGO is this? Additionally, show the distribution of ALGO holdings for these new wallets. What is the average ALGO holding of these new wallets? What other ASAs do these new wallets from May hold? How many of these wallets have performed a swap? Finally, note anything else interesting about these wallets! Why are these wallets being created and what are they doing on Algorand?"
Osmosis One Year Anniversary
Jun 21, 2022 - What did the users who received the initial airdrop of OSMO do with their tokens? Create a visual that shows how many sold, staked, LPed, swapped, and held. How many individuals who received the airdrop still hodl their OSMO one year later?
Flow vs Other L1s
Jun 18, 2022 - Q13. 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
NEAR Gas Guzzlers
Jul 23, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month? Hint: The gas units in the table are in raw (not decimal adjusted) format. To adjust accordingly, divide by 10^12.
Do Whales Have Diamond Hands? (Osmosis Bounty)
Jun 16, 2022 - Does the swap behavior of OSMO whales differ from everyday users? How does it differ? Create visuals showing what whales swap to and from compared to a normal Osmosis user.
Terra LP-ers: Aftermath (THORChain Bounty)
Jun 21, 2022 - Q102. What did people that were LP-ing in the Terra pools do? Are they just holding onto their $RUNE now or are they back in the arena LP-ing somewhere? Or did they sell their $RUNE and leave the ecosystem completely.
Sushiswap DEX Loyal Users
May 11, 2022 - Hello and welcome to Sushiswap DEX Loyal Users Bounty! in this submission, we are going to rank wallets that used SushiSwap based on the number of trades and number of days they used the DEX (in different frequencies). Moreover, we are going to show how many users keep coming back to the platform?
Secondary Sales Activity (Lil Nouns Bounty)
Jun 18, 2022 - Q2. How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) between their mint price and secondary sale price? Visualize and analyze your findings.
Long vs Short Option Contracts (Opyn Bounty)
Jun 28, 2022 - Q2. How many long vs short option contracts have been bought on opyn? What’s their value? Has there been any liquidations?
Untitled BoardAG
Nov 1, 2022 - Art Gobblers is a pre-reveal NFT project that generates "goo" when you feed it (upload) art you've created. Some say the project is revitalizing NFTs in the bear market - Compare various metrics across NFT activity to support or oppose that idea. Then evaluate how the project's metrics stack up to other top NFT collections before their art reveals. Create a dashboard that shows off stats for Art Gobblers NFTs, and compare it to other top collections. Include at least these metrics, along with any others you find notable or interesting:
Untitled BoardBAL
Sep 7, 2022 - Q2. Build a comprehensive balance sheet dashboard for BendDAO. Include things such as collateral by collection, total debt, total reserves, utilization rates, and any other metrics you feel are relevant.
Untitled Board
Sep 2, 2022 - Q9. What actions does a user take when they deposit money into the NEAR ecosystem? Show the most common actions taken by users on NEAR (new users using NEAR for the first time) over the past 3 months.
Trending NFT Projects (Flow Bounty)
Jun 10, 2022 - Create a visualization showing NFT sales volume on Flow since May 9th. Which NFT projects are trending on Flow right now and what is the general trend of NFT sales over the last month? Do the projects that are trending seem to have common wallets or is there not much crossover between buyers/sellers?
Unknown Gnosis Activity
Oct 15, 2022 - There’s been some unusual activity with Gnosis as pointed out by our community. Time to figure out exactly what’s going on. Take a deep dive into recent activity on Gnosis, especially recent rapid rises in the number of active users, transactions, and more. Make any hypothesis you can about what is driving this activity. Is there a new dapp that launched? Is there some incentive program going on? Or is the spike in users/txns due to some sybil attack?
2022 Yieldly Staking Pool Analysis
May 20, 2022 - Hello and Welcome! Let's get a better understanding of the YLDY staking pool usage in 2022. In 2022 what have been the most popular Yieldly staking pools by the amount of YLDY staked, total number of stakers, and average amount staked? Additionally, show us how staking pool participating has evolved over time in 2022. Do we see more wallets participating in staking pools now or less? Do we see more wallets participating in staking pools but committing less amounts? Note how behavior has changed around these staking pools. Does the price of ALGO impact the number of users participating and staking pools? Are there any standout wallets that have staked in a lot of these Yieldly staking pools? Note any other interesting findings about the Yieldly staking pools and their usage.
Untitled BoardMI
Sep 6, 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?