#18.Profiling Early GodMode Minters
Jun 9, 2022 - Based on FlipsideCrypto's provided on-chain data, we want to profile the Early Minter of the GodMode NFTs in the first hour of listing on OpenSea.io and answer these questions: - Analyze the Ethereum profile of those who minted during the first hour after launch. - How many of them moved the minimum .1 ETH into their minting wallet vs. already had at least .1 ETH in that wallet? - How many of them have been active in NFT purchases over the past six months? - Can you construct a “typical minter” profile/profiles based on their wallet behavior?
#20. USDC Deposits on PoolTogether
Jun 22, 2022 - Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Squid Cross-Chain Swaps: Identifying the Top DEXs for Popular Chains
Apr 14, 2023 - Squid offers asset-to-asset cross-chain swaps with the click of a button. For the user, the process is simple; however, behind the scenes Squid leverages DEX swaps in order to transfer these assets. In this analysis, we aim to identify the most popular decentralized exchanges (DEXs) used by Squid cross chain swaps. On a source and destination basis, what are the most popular DEXs used by Squid?
Liquid Staking ETH Platforms Analysis
Sep 5, 2022 - As the time of Ethereum Merge and the change of validation mechanism of this popular blockchain is approaching, in this dashboard we will examine the platforms that offer Ethereum liquid staking services to see what is the trend and tendency of users towards this platform. Have they embraced it and are they prepared for it or not?
Realms vs Snapshot - A Quick Overview
Aug 31, 2022 - In this dashboard, we are looking for a quick comparison of two voting platforms in the Ethereum and Solana blockchains, namely Snapshot and Realms, and we want to see which of them is superior in terms of user growth rate and DAO activities.
On-Chain Analysis of OP Price
Dec 23, 2022 - Is there a relationship between OP price and trade volume?
Angle Protocol on Ethereum - A Quick Overview
Nov 18, 2022 - In this dashboard, we will review the usage of the Angle protocol in the Ethereum blockchain and see what the user community looks like, review the trading volume of the main token, agEUR, over time and see what users are doing with their agEUR tokens.
Lido ETH Staking Analysis
Apr 5, 2022 - Q9. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
NEAR Bridge Dashboard: Analyzing Asset Flows and User Activity
Mar 22, 2023 - In this dashboard we are using the Flipside app to analyzes asset flows to and from NEAR across three bridges: Rainbow Bridge, Allbridge, and Multichain. The dashboard compares the activity of each bridge and answer several questions such as which bridge is bringing the most users and liquidity into the ecosystem, which ecosystems users are coming in from, and which bridge is responsible for most of the liquidity leaving the ecosystem. Additionally, the dashboard identifies which blockchains liquidity is going to if it's leaving NEAR and which bridge is bringing users to use Near.Social.
ETH Deposited or Withdrawn on StarkNet
Jun 29, 2022 - Q1. StarkNet is a layer-2 chain that ensures interoperability with Ethereum mainnet. People are using it to move real ETH to starknet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors?
Tornado Cash Banned Addresses Analysis
Aug 9, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online.
Unpacking the Growth and User Behavior of Zeta & Drift Markets
Mar 26, 2023 - This analysis dashboard examines two emerging options and perpetuals exchanges in DeFi, Zeta Markets and Drift Markets. It analyzes their growth trajectory since 2023 and how they have attracted users during a period of minimal attention and liquidity. The dashboard explores popular product offerings, user demographics, trading activity, and user behavior. It evaluates whether these platforms are dominated by whale activity or if there are significant numbers of retail traders using them. The insights from this dashboard will provide a comprehensive understanding of the performance and user adoption of these platforms in the current Solana DeFi landscape
Opensea Fees on Polygon
Jul 31, 2022 - Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
Sushi Xswap Revenue
Sep 6, 2022 - In this dashboard, let's take a quick look at the collaboration between SushiSwap and Stargate, and in particular, the volume of transfers made and the revenue generated by the two platforms from this joint collaboration.
Analyzing Bridge Usage on Axelar: Impact of the Arbitrum Airdrop
Apr 4, 2023 - For users claiming the Arbitrum airdrop, we want analyze their bridge use on Axelar. Have these wallets increased transfers into Arbitrum since the announcement of the airdrop? For any wallets who have sold ARB, are they moving their tokens out of Arbitrum? For those bridging out, what bridges are they primarily using?
#20. Lil Nouns DAO Voting Activity
Jun 20, 2022 - Q1. The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.
#19. ERC20 Tokens (zkSync)
Jun 14, 2022 - Q2. ZkSync is a scaling solution for Ethereum that is live on mainnet. Some of the main features of ZkSync are the extremely low transaction fees and trustless protocol design. You can read more about ZkSync here. Users can also deposit ERC20 tokens into ZkSync. Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days? Visualize and explain both findings.
#19. User Activity - NFTX
Jun 14, 2022 - Q2. Analyze user activity providing and removing liquidity from NFTX vaults. Which three vaults have seen the most activity over the past 60 days? Are there any similarities between these vaults or NFT projects? Explain and visualize your findings.
CryptoPunk Traders
Aug 30, 2022 - In this dashboard, we try to find answers to these questions about one of the oldest Ethereum NFT collections, CryptoPunks: Which 10 wallets are the most successful Cryptopunk traders? Successful could either mean the wallet has accumulated a large balance from sales or has accumulated a large number of Punks. Explain your methodology and findings.
The Bridge from Ethereum to Solana
Jun 16, 2022 - Q1. Create a visualization of the volume of assets being bridged from Ethereum to Solana over time via Wormhole. What does the average profile / size of wallets bridging to Solana from Ethereum look like (what is the average value of assets being bridged over)? What have been the most popular bridged assets from Ethereum to Solana and has that changed over time?
#19. Highest Sales Volume - NFTX
Jun 14, 2022 - Q1. Which 3 NFT collections have the most total sales volume in the last 60 days on NFTX? These are transactions where someone redeems their NFTX tokens for a specific NFT.
#20. Pool Together - Pooly NFTs
Jun 22, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
OPtimistic or Pessimistic?
Oct 19, 2022 - Are you optimistic or pessimistic about the future of the layer-2 chain known as Optimism? How do you think it will fare going forward compared to other L2s?
NEAR Performance
Jul 19, 2022 - In this dashboard, we want to review the position of Near blockchain compared to other competitors among layers 1s and compare the number of transactions per minute or TPM of several main blockchains with Near. We also want to compare the number of errors(failure) per minute (FPM) between these blockchains. Stay with us.
Uncovering Trends and Insights in the Polygon NFT Market
Mar 3, 2023 - The Polygon NFT market has been growing rapidly in recent months, attracting a significant amount of attention from investors and collectors alike. To better understand this market and identify potential investment opportunities, this analysis uses on-chain data from FlipSideCrypto's datasets and analytical tools to explore key metrics such as the number of NFT mints and sales, sales volume, and unique buyers over the past three months. By conducting a weekly analysis and leveraging data pre-processing, statistical analysis, and data visualization techniques, we aim to provide a data-driven perspective on the state of the Polygon NFT market and its growth prospects in the near future.
FLOW User Retention vs Other Chains
Nov 29, 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?
Bridge Analysis
Jul 5, 2022 - Q7. Building off last week's question investigating when transactions fail on Flow, what addresses and contracts are causing the majority of failures? What types of activities and events are these addresses doing that are spamming the network? What types of arbitrage opportunities are they seeking and how profitable are these efforts? Compare these transaction failures to the botting issue that Solana has bene facing causing outages. How do they compare and how could Flow attempt to mitigate these issues?
#19. Distinct Wallets (zkSync)
Jun 14, 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.
Liquidity Provider Stats
Sep 9, 2022 - In this dashboard we evaluate the effectiveness of a yield farm program - wstETH/DAI Incentive revards - in attracting TVL: - What’s the average TVL of the LP Pool before the start of liquidity mining (LM) - What’s the percentage (%) increase in APR incentivized by Projects via LM (optional) - How much percentage (%) increase in TVL was achieved via LM - How much percentage (%) conversion of LP providers to Yield farmers during the active LM - What’s the average duration of LM - After the end of LM program, how much (%) of TVL is pulled out from pool
#20. Bridge Users (Hop Protocol)
Jun 22, 2022 - Q1. How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
ETH Deposited or Withdrawn on StarkNet L2 Layer
Jun 29, 2022 - Q1. StarkNet is a layer-2 chain that ensures interoperability with Ethereum mainnet. People are using it to move real ETH to starknet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors?
Sorare Compete With Collectibles
Nov 4, 2022 - Sorare is a digital, playables and collectibles platform where users can compete across futbol, NBA, and MLB in a fantasy sport setting. Build a dashboard that covers the Sorare project: - Statistics on Sorare NFTs being sold on Opensea such as buyers, volume, number of NFTs etc - Transfers and mints over time - Statistics on contract events such as players and clubs added Provide - additional insight into the players and clubs added in from the event inputs
Bridger Destinations
Sep 9, 2022 - Where do people go when they bridge to Optimism from Ethereum? What are the 10 most popular first destinations for users that have just bridged from Ethereum? What has this been for each day in the past month?
An Overview of Rocket Pool ETH2 Staking
Sep 5, 2022 - As the Ethereum Merge approaches, it is expected that more users will use Ethereum staking to make profits and participate in network validation. In this dashboard, which focuses on Rocketpool, one of the major providers of staking in Ethereum, we examine this question statistically.
Comparing User Entry and Transactions via Squid/Satellite Bridge in Ecosystems
Mar 31, 2023 - In this dashboard, we present an analysis of Squid/Satellite bridge activity on Axelar and explore the impact of user entry method and asset type on subsequent transactions within the ecosystem. Specifically, we investigate the similarities and differences between users leveraging Satellite and Squid to enter both Cosmos and EVM chains. Additionally, we analyze how subsequent transactions differ for users who entered with stablecoins versus non-stablecoins.
An Overview of NFT Sales Volume on Uniswap NFT Aggregator
Nov 29, 2022 - DeFi giant Uniswap launched a marketplace for non-fungible tokens Wednesday, November 30, promising the best prices on NFTs and lower gas fees. Let's Analyze this new nft aggregator by data.
Sushi and the Merge
Oct 3, 2022 - The Ethereum merge brought some uncertainty to DEFI markets. It got many market makers (MM) to remove liquidity from defi to lower their risk. After the merge, some have redeployed the liquidity, and some haven't. Analyze the behavior of Sushi MMs 2 weeks prior to and after the merge. How much capital did they withdraw? which pools/chains got affected the most? Have they redeployed back their capital? Can we say anything about their identity (Tokemak, etc)?
axlUSDC: Soon to be forgotten?
Oct 29, 2022 - Recently, Circle announced the implementation of an IBC-native USDC, inserting itself into an ecosystem where axlUSDC currently dominates. Let's look at how pervasive axlUSDC is within IBC.
Flash Bounty: Miners
Sep 9, 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? You can define what can be considered low or high transaction count based on the transaction count distribution