#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?
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.
#20.Wildlife Warriors NFT Drop
Jun 19, 2022 - Q105. Wildlife Warriors was a project established by Steve Irwin in 2002 as a way to include and involve other caring people to support the protection of injured, threatened or endangered wildlife. They recently had an NFT drop(https://twitter.com/wildwarriors) on Algorand to support the project. Lets look at the wallets that own one of these NFTs.
Lofty AI Platform Dashboard
Jul 13, 2022 - In this dashboard we want to create a visually appealing dashboard using the new FlypSideCrypto multicolumn layout to display statistics and general information of the LoftyAI project: to illustrate all the properties(assets), the tokenized revenue Lofty has generated through sales, and the total asset value that Lofty AI manages.
#13.Tracking top Solana NFT Collections
Apr 27, 2022 - Track sales volume and average sales price across marketplaces for the following NFT collections: -Solana Monkey Business (hint you will need to use the SMB marketplace programId) -DeGods -Degen Ape Academy -Shadowy Super Coders -Aurory -Stoned Ape Crew -Cets on Creck -Taiyo Robotics -SolGods -Portals -Boryoku Dragonz -Catalina Whale Mixer -The Famous Fox Federation -Galactic Geckos -Thugbirdz -Mindfolk -Solsteads -Astrals -Pesky Penguins -Meerkat Millionaires Country Club
#18. Polygon Active Addresses
Jun 7, 2022 - Q4. How many addresses on the MATIC network are active? What’s the daily evolution of active addresses? Is the activeness related some how to the price? Hint: Active address is an address that has done at least one transaction or has received at least once a token in the past 3 months.
Pooled Validator Participants
Sep 19, 2022 - Q118. Who are the unique new entities that are participating in pooled validators that did not participate in classic validators?
#6. Marinade Staking
Mar 8, 2022 - Question 32: Marinade Finance is the first non-custodial liquid staking protocol built on Solana. By staking SOL with Marinade, users receive mSOL tokens in return that can be used to explore other DeFi protocols and earn additional yield. mSOL can also be swapped for other tokens on decentralized exchanges like Jupiter and Orca. Create a visualization showing the amount of SOL staked on Marinade since the beginning of February. What is the average amount of SOL staked on Marinade per transaction, and what were the 10 largest transactions? Create a histogram showing the distribution of SOL staked per transaction. What are the most popular tokens that mSOL is swapped for on Jupiter?
Optimism NFT Market
Jun 25, 2022 - In this dashboard, we are going to analyze the daily sales volume of NFTs on Optimism and see which collections are the most popular among users, which NFTs are the most sold, and the what is the number of active NFT traders. How much is Fee in this network and has it affected the activity of users or not?
Arbitrum Blockchain and Smart Contract Development
Aug 7, 2022 - Arbitrum is currently one of the most popular and strongest Layer 2 (L2) solutions for Ethereum. Since its launch in August 2021, it has quickly gained traction among developers and users due to its high throughput, low fees, and compatibility with Ethereum. In this dashboard, we look at how the activity of the developers of this blockchain has been in terms of the number of smart contracts deployed on it.
The Law Offices of NEAR
Aug 2, 2022 - Provide your best assessment of the number of smart contracts deployed on NEAR and clearly outline your methodology (after all, contract lawyers love clearly specified terms).
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.
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.
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
Overtime Markets - Volume
Aug 22, 2022 - In this dashboard, we want to analyze the total volume on Overtime Markets over the past two weeks. - Which games received the most activity, both in total users and total $ volume? - Which sports are receiving the most bets in total dollar volume on a daily basis?
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.
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?
#11.SOL OpenSea vs Magic Eden
Apr 13, 2022 - OpenSea launched its SOL compatibility on 4/6 - giving the SOL NFT landscape access to the largest source of NFT liquidity. However, Magic Eden remains the top NFT marketplace on SOL. Compare sales volumes between OpenSea (for solana NFTs) and Magic Eden since OpenSea's Solana launch. How many unique users have bought a SOL NFT on OpenSea vs Magic Eden since 4/6. How do you expect this trend to develop over time?
#12.Sablier Top 10 Users
Apr 21, 2022 - Q10. List 10 users who received the most funds and 10 users who sent the most funds through cash streams. Use Ethereum_core schema.
Ribbon Finance On Solana - SOL Theta Vaults
Nov 23, 2022 - In this dashboard, we analyze the SOL vault (T-SOL-C) of Ribbon Finance to learn more about the success and popularity of the vault on Solana since its inception on Feb and, most importantly, to see how this vault has performed during the days of Solana's historic decline.
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.
What's All The Hubbub for Hubble Protocol?
Oct 10, 2022 - Create a KPI dashboard that shows Hubble metrics such as: daily active users, new users, mint/burn rates, different rates of instructions etc. (anything you find relevant)
#17.Rand Gallery Wallets
May 25, 2022 - Q77. Let’s look at wallets that buy from Rand Gallery to get a better understanding of purchasing behavior.
Arbitrum NFT Market Analysis
Jun 30, 2022 - In this dashboard, we are going to analyze the daily sales volume of NFTs on Avalanche and see which collections are the most popular among users, which NFTs are the most sold, and the what is the number of active NFT traders. How much is Fee in this network and has it affected the activity of users or not?
#4. Friktion SOL vs mSOL Volts
Feb 20, 2022 - "Friktion offers an income generating covered call product to users. A covered call option involves holding a long position in a particular asset, for example, SOL, and writing a call option on that same asset with the goal of realizing additional income from the option premium. How much SOL was deposited during the February 4th and February 11th epochs and how many unique users were in the SOL covered call volt? How much mSOL was deposited during those same epochs and how many unique users were in the covered call volt? Why do you think one volt has been gaining more adoption than the other?
#16.Borrowing On Folks Finance
May 19, 2022 - Q69. Let’s look at borrows on Folks.Finance a borrowing and lending protocol built on Algorand. We want to get an understanding of how what assets users most want to borrow, how often borrows are happening, and the average collateral ratio between the collateral offered and the asset that is borrows. Ultimately, we want to get a better understanding of what people are borrowing, and what the collateral ration looks like.
#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.
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.
#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?
Going Down the Gnosis Native Bridges - Part 2 : Omni Bridge
Aug 7, 2022 - There are currently two bridges to the Gnosis network. If you want to transfer to layer 2, you must go through the bridges as they act as a gateway between the two networks.
#6.Algorand Governance Period 2 Voting
Mar 10, 2022 - Question 34: Algorand's 2nd Governance Voting Period Ran From January 31st to February 28th 2022(https://governance.algorand.foundation/governance-period-2), lets take a look at how wallets voted for or against xGovs. - Show wallet votes over time - Which had more individual wallet votes, A or B? - Show the voting result(A vs B) based on the ALGOs committed by wallets for this governance period.
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.
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?
ALGO NFT Tooling
Nov 4, 2022 - Using the new Algorand.NFT schema in your build, create a dashboard or tool that helps Algorand NFT traders learn about the ecosystem.
#13.User Profile - LIDO vs. RocketPool
Apr 27, 2022 - Q19. Lido is another application that also offers ETH2 liquid staking. Compare and contrast activity on RocketPool vs. Lido over the past three months. Is one growing more quickly than the other? Can we conclude if one of these applications is better for users than the other? Are there different types of users using RocketPool compared to Lido, or are the user profiles similar? Visualize and explain your conclusions.
Ultimate On-Chain Exchange Dashboard - Algorand DEXs Comparison Tool
Nov 4, 2022 - With this dashboard, we aim to create a convenient and simple tool for quick comparison of the main decentralized exchanges on Algorand. Simply enter the names of the two exchanges in the parameters section of this dashboard to quickly see a side-by-side comparison of the two using FlipSideCrypto OnChain data
#11. Flipside Algorand Wallet Behavior
Apr 9, 2022 - Lets look at wallet behavior associated with wallets that have been paid a Flipside Algorand bounty payout.
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?
Avalanche NFT Market Analysis
Jun 26, 2022 - In this dashboard, we are going to analyze the daily sales volume of NFTs on Avalanche and see which collections are the most popular among users, which NFTs are the most sold, and the what is the number of active NFT traders. How much is Fee in this network and has it affected the activity of users or not?
