gaming_on_solana
Feb 10, 2023 - Between Star Atlas, Genopets, and Aurory, games are beginning to allow users to experiment with what they have been building over the past year and a half. Create a dashboard showing user activity and growth of these three games. Is there any crossover between these three games in terms of users or does each game seem to have its own fan base? What is the profile of gaming users on Solana? What types of activities are these users doing within the games and within the Solana ecosystem?
EVM - 17. Avalanche Gas Fees
Mar 27, 2023 - Create a dashboard to analyze gas usage on the Avalanche network. The dashboard should have two tabs: one for contracts and one for dApps. Each tab should show which ones generate the most network fees and use the most gas over a user-selectable time period. Include any other metrics or charts that reveal contracts and dApps with growing usage based on data such as network fees, number of unique users, or other relevant metric.
A Surge of Optimism
Dec 17, 2022 - The price of Optimism (OP) fell sharply in early November, dropping from highs above $1.30 on November 6 to as low as $0.79 on November 9. In the weeks since, prices have been on the rise, with OP hit $1.19 on December 14. Analyze the network and diagnose some of the possible reasons for the sudden drop, and slow climb, of OP price in recent weeks. Are there any notable trends in users, transactions, or any other metrics that could explain these events? Note any patterns or outliers you see.
Aave - 12. Aave Delegates' Gas Usage
Mar 18, 2023 - How much gas was used by delegates voting in Aave in the past 90 days? In the past 180? How much gas on average is spent by voters in a single vote?
Osmosis Airdrop Review: Skill-building Bounty 27 (Hard)
Nov 12, 2022 - Long overdue but let’s look at the Osmosis airdrop that happened a year and a half ago. Using the Osmosis airdrop table, make arguments if the airdrop was effective in gaining long term ‘active’ participants in the ecosystem.
Near_whales
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?
Osmosis - 14. Ultimate Trading Dashboard Challenge
Apr 14, 2023 - Build the trader dashboard to end all trader dashboards! The Osmosis community wants to know the top trending assets - what is being actively traded, staked, liquid, & pooled. What assets are moving in/out of Osmosis right now? ETC! Top dashboards will utilize Flipside's tabs to organize this dashboard. Additionally, give individuals the option to filter by different times (30d, 7d, 1d, etc.)
Terradash Part 2: Staking and Supply
Dec 11, 2022 - We’re working with Terra to rebuild the great Terradash , a dazzling dashboard full of analytic insights providing an overview of the entire Terra ecosystem— and we need your help! We are building out this new and improved Terradash in parts. This week for Part 2: examine token supply and staking activity on Terra, both in terms of transactions, volumes and wallets. Be sure to include the following metrics (and more), noting any trends or outliers you see. Total Supply Circulating Supply Vesting Schedule % LUNA IBC-ed out Richlist (Top 100) of LUNA staked % of LUNA staked Staking rewards distributed in USD trend
AVALANCHE
Mar 6, 2023 - Create a dashboard looking at assets transferred to and from the C-chain to subnets on the avalanche. Have your first tab of the dashboard be an overview looking at all live subnets and comparing USD volumes to and from the C chain by assets in by subnet. Next have additional tabs that breakdown the asset movement to and from each individual subnet that is currently active.
EVM - 23. Avalanche Bridges
Apr 26, 2023 - Create a multi-tab dashboard that illustrates the inflows and outflows of Avalanche by bridges and have it be parameterized by a start and end date. Have the first tab looking at the USD inflows and outflows by bridge and the number of users using each bridge. Have an additional tab for each bridge breaking out the inflows and outflows by asset.
Flow - 2. Dimension X Activity
Mar 31, 2023 - Dimension X is one of Flow's hottest NFT games where you can create a team of heroes to go on quests and battle enemies. Each quest is a competition with other hero teams. Analyze Dimension X activity by showing Month over Month (MoM) active users, monthly user growth, new users over time, average transactions per user, and MoM fees paid (if any). Explore Dimension X yourself and see if you can uncover other useful metrics to compare Dimension X to other popular NFT games (you can compare to games on other chains if you'd like).
Axelar - 12. Chain Swaps
Apr 23, 2023 - Since February 23rd, you have been able to swap into 13 different Cosmos Chains via Squid: https://twitter.com/squidrouter/status/1628796403076964354?s=20 What chain has had the most activity?
christmas for OPTIMISM
Jan 11, 2023 - The holidays and New Year are often chaotic in the crypto and defi space, as users make a spree of new transactions and wallets as they receive (and give) some cash and coins as holiday gifts. How has this activity impacted the broader Ethereum ecosystems? Are users creating new wallets or buying tokens with their newfound holiday wealth? Are they staking all these new tokens once they get them? Or are they selling tokens to pay for their own gifts and holiday travel?
Fifa Collect Users & NEW Algorand Tables: Skill-building Bounty 29 (Hard)
Nov 23, 2022 - Using these new tables (navigate to the Algorand table -> NFT), find out the following: How many new users has the Fifa+ platform onboarded since its launch? How much volume (in algo and in number of transactions) in trading Fifa NFTs was contributed by new users vs ‘old’ users?
EVM - 15. Avalanche Protocol or Project dashboard
Mar 22, 2023 - this analysis is about Aave project on Avalanche
Flash challenge_borrowing on Aave
Mar 9, 2023 - Create a dashboard that covers and answers the questions below: How many unique borrowers of SNX, UNI, & MKR are there on Aave V2? What is total cumulative borrow for each asset on Aave V2? Can you visualize borrowing of each asset over time?
Fifa Collect Overview & NEW Algorand Tables: Skill-building Bounty 28 (Easy)
Nov 22, 2022 - It’s world cup season! In case you missed it, Fifa partnered with Algorand to launch an NFT platform to collect and trade digital football moments a few months ago (https://collect.fifa.com/ ). To surface these NFT mints and trades, we launched several new tables in Algorand specifically catered for Fifa.
Mars
Mar 1, 2023 - This past week the Flipside team released Mars EZ tables - let's put them to work! Create your best Mars dashboard leveraging these new tables. Top dashboards will not only provide professional grade visuals, but will incorporate sound insights to guide the reader towards the most important data points.
