0xHaM-d
Joepegs, the top Avalanche's NFT Marketplace
Mar 19, 2023 - Use Flipside’s new fact_decoded_event_logs and ez_decoded_event_logs tables and build a dashboard covering either: one of the top 15 Avalanche projects by TVL featured on Defi Llama (https://defillama.com/chain/Avalanche), a bridge into Avalanche, or a popular NFT marketplace. Show the activity and usage of the protocol through the events. Some of the things to consider are the number of unique wallets, asset volumes, swaps, LP actions, or fees. Build a dashboard you think the protocol and the ecosystem would find useful to use and monitor the usage of the protocol.
stETH Use Cases
Jun 4, 2022 - Q1. What are users doing with stETH from Lido? (Possible use cases to explore: https://blog.lido.fi/steth-defi-usecases/)
Arbitrum Network Health Check
Mar 30, 2023 - The Arbitrum token is officially in the hands of the broader crypto economy. Over 900M $ARB tokens have been claimed thus far, representing a vast majority of the total airdrop supply. Let's check in how the network is behaving and see what's going on in the Arbitrum economy. What are users doing with $ARB? Selling, bridging, holding? How's bridging activity? Are airdrop claimers bridging out? Are there non-airdrop allocated users entering the ecosystem - if yes, what are they mostly doing? What is the general network activity? Are certain platforms experiencing more or less volume? What is trading activity looking like? Are certain tokens being trading most? Are token prices depressed?
Single-Sided Liquidity Pools
Jun 19, 2022 - Q2. Across uses single-sided liquidity pools to execute transactions between chains. How are Ethereum mainnet users interacting with these pools? How do these pool rewards compare to other liquidity pools?
Sei Network Health Check
Aug 31, 2023 - This dashboard was designed to monitor the health of the Sei network, particularly in relation to events surrounding the Token Generation Event (TGE). The analysis of data covers the period from August 15th, the date of the TGE, up to the current date of August 31st.
Secondary Sales Activity
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.
RaceDay NFTs
Feb 25, 2023 - The Addressed issues in this dashboard are include: How does Speedway Motorsports RaceDay NFTs stack up to sports NFT collections in the FLOW ecosystem? What other projects are RaceDay fans buying? The assessed Metrics: Average Sales volume Total Sales Volume Secondary Sales vs. Mint Sales Daily Average Sales Price and 7-day moving average Total Unique Buyers Average Buyers/Day Social Mentions/Shares Cross-Project comparative assessed metrics: Other collections RaceDay fans are buying Purchase frequency, or the distribution of tokens owned per wallet Average Number of NFTs held per wallet Average Purchase Price of NFTs held by RaceDay fans BONUS: Find free redemption buyers to future buyers, i.e., were first time purchasers someone that claimed a free NFT previously, or, was their first experience with RaceDay an actual purchase.
Sushiswap - 4. Sushi Stablecoin Activity
Mar 17, 2023 - What are the most actively traded stables on Sushi on Ethereum, Optimism, Arbitrum, and others? Chart monthly volume and inflow/outflow of stablecoins through Sushi on various chains. Which chain has seen the most stablecoin activity pick up in the last 3 months?
Bridge Volume (Hop Protocol)
Jun 21, 2022 - Q2. How much volume has Hop bridged to Polygon, Optimism, and Arbitrum compared to those protocols’ native bridges? What is Hop’s total TVL? Create an analysis on the Hop’s TVL and how it’s changed over a time period of your choosing.