0xHaM-d
Ambient on Blast || Power vs. Normie Users
May 4, 2024 - This dashboard delves into users on Ambient Finance by tracking their transactions and retention rates. It also distinguishes users using a Pareto approach to identify power and normie users.
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.
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.
SUSHI Noobs
Jun 19, 2022 - Q93. From which address do users acquire their first $SUSHI token ? is it CEX ? DEX ? Dual LP Staking Rewards ? Airdrop ?
USDC Usage: Unveiling the Dynamics Across Avalanche vs L2
Jun 19, 2023 - This analysis delves into the utilization of USDC (USD Coin) on multiple blockchain networks, including Avalanche, Optimism, Arbitrum, and Polygon. By examining various metrics such as minting and burning, number of holders, velocity of transfers, and top protocols, key insights emerge. The findings reveal that while Avalanche and Polygon exhibit comparable levels of USDC utilization, Optimism lags behind, and Arbitrum demonstrates the highest volume. Minting and burning activities remain relatively consistent across the chains, with Avalanche showcasing a higher average mint volume. Furthermore, decentralized exchanges (DEXes) emerge as the prominent protocols for USDC usage, with Aave and Binance leading the pack on Avalanche. The most popular swap pair on Avalanche involves USDC and AVAX tokens. These insights shed light on the dynamics of USDC usage and the ecosystem surrounding these blockchain networks.
Stable Coins Lent on Kashi
Jun 12, 2022 - Q92. Draw a chart showing the TVL of Stable coins on kashi pairs across all markets.
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/)
Bridge Transactions (Across)
Jun 20, 2022 - Q1. Analyze bridge transactions via the Across bridge over the last two weeks. What assets are users bridging from Ethereum, and to what chains?
Osmosis - 4. WAVAX Activity
Feb 5, 2023 - Last week, wrapped AVAX (WAVAX) was listed on Osmosis and seeded with liquidity via Pool 899 (OSMO/WAVAX). Analyze WAVAX activity over its first week of trading on Osmosis. How does WAVAX trading on Osmosis compare to native swaps on Avalanche? Hint: leverage Flipside's Avalanche tables to complement your analysis.
ARB Everywhere
Apr 6, 2023 - This dashboard provides an overview of the transfer and bridging activities of airdrop recipients on the Arbitrum ecosystem since the announcement of the airdrop. The data shows that while there has been an overall outflow of assets from the ecosystem, there has also been an increase in transfers into the ecosystem. Additionally, the majority of bridging transactions have been focused on transferring assets out of the ecosystem, with the Axelar bridge being the most popular platform for this purpose. Overall, the data provides valuable insights into the behavior of airdrop recipients on the Arbitrum ecosystem.
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.
The Typical Minter
Jun 9, 2022 - Analyze the Ethereum profile of those who minted during the first hour after launch.
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?
Daily Active Users
Apr 9, 2023 - Based on the findings, we can draw some key insights: The Flow blockchain has experienced an increase in the number of new users since 2022. On March 31st, there was an uncommon spike in the number of daily active users primarily driven by transfer activity. The most popular contracts on March 31st were related to NFTs and Dapper Labs' offerings, with three Joyride contracts accounting for nearly one-third of all transactions. Even for the most popular contracts, the total number of users and transactions was significantly lower than on March 31st, indicating that this was a unique event. By analyzing user behavior and interactions with smart contracts, we can gain valuable insights into user engagement and experience, which can help optimize the network and improve user satisfaction.
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.
Flash Bounty - 5. Top Brands Launching NFTs
Feb 2, 2023 - Quite a few non-Web3-native companies have gotten involved in NFTs — Reddit, Starbucks, Porsche, Nike, the NFL, and others across chains like Ethereum, Polygon, Flow, and more. We want to know: How does each project compare, and does choice of chain seem to affect outcome? (Include any metrics you think are relevant — mint and trading volume, total revenue/royalties, unique wallets, hold time, etc). How has each project fared since launch? Have volumes fallen off, did are there any unusual effects on activity? Choose at least 3 NFT projects from non-Web3-native companies for your analysis. For reference, compare results with at least one Web3-native NFT project of your choice - how do the top brands' projects compare to the industry native one(s) you've chosen? BONUS: Share your work on Twitter and tag @flipsidecrypto, @metricsdao and any other projects you mention that might find your work valuable.