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?
#15.Token Activity - ParaSwap
May 9, 2022 - Q3. What do people do with their PSP tokens? Once people acquire PSP tokens what do they do with them? Do they stake them? How long do they hold them for? Show the journey of PSP tokens.
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?
Mars Protocol Farm Vaults Analysis: OSMO-axlUSDC/ATOM
Mar 17, 2023 - Last week Mars Protocol launched their Farm Vaults - allowing users to LP and leverage yield farms. Currently, Mars supports two pairs launched by Apollo DAO: OSMO-axlUSDC & OSMO-ATOM. Analyze activity within these two vaults. A top-tier dashboard should provide visualizations for all major data points related to these vaults. Additionally, please provide the source of the OSMO, axlUSDC and ATOM used to LP - did these tokens come from Mars Red Bank borrows or Osmosis/Cosmos Hub IBC Transfers directly?
#10. Stablecoin Popularity for Swaps
Apr 6, 2022 - Q45. Which stablecoin is more popular for a wallet to use in swaps(use algorand.swaps table): USDT, USDC, STBL? Compare volumes and number of swaps for each over the month of March 2022. Tips: USDC(31566704) USDT(312769) STBL (465865291)
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.
#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.
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?
#13.Fractional.art NFT Sales
Apr 27, 2022 - Q16. Using the Ethereum_core schema, analyze the 3 most actively traded fractional NFT vaults on Fractional over the past 3 months. How many NFTs are in these collections? What is the total trading volume? Add any other data points to your analysis that you find valuable.
#7. L1 Unique Users
Mar 15, 2022 - Compare the number of unique wallets that have sent a transaction since February 1st on Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Solana compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks?
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.
#8. GMT Airdrop
Mar 22, 2022 - Q38. GMT, the governance token of StepN, was airdropped to its 5000 trailblazers (early adopters and supporters of the game) on 3/15. The airdrop amount was calculated from the amount of time played in the game.
#3.TVL Sushi vs. Uni
Feb 16, 2022 - Question 39: Show the daily Total Value Locked (TVL) on Sushiswap over the past 3 months. How does this compare to the daily TVL on Uniswap over the same time period?
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.
#17. Net $THOR Staked
May 24, 2022 - Q91. Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards. Show the net amount of $THOR staked over time.You will need to calculate the net amount staked + unstaked to get the net amount.
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?
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?
#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?
Polygon Block Performance
Jul 23, 2022 - What is the average time between blocks on Polygon? What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
#6.To Be Bankless or not to be ?
Mar 6, 2022 - Why might someone go Bankless? Outline the BED index strategy deployed by Bankless DAO. Show how the BED index strategy has performed over time compared to a more traditional investment route (such as sticking your money into the S&P 500). Use this analysis to suggest why or why not someone should consider going Bankless. BED Index Strategy: https://www.bankless.community/bed-index BED Index Token Address: 0x2aF1dF3AB0ab157e1E2Ad8F88A7D04fbea0c7dc6
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.
#17. $THOR Staking Distribution
May 24, 2022 - Q95. Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards. What is the distribution of $THOR currently staked? Are there any notable whales? You will need to calculate the net amount staked + unstaked to get the current amount.
#11.SOL Staker Activity
Apr 13, 2022 - Q52. How frequently are SOL stakers interacting with DeFi protocols over the past month? Which protocols are they interacting most with? Which actions are they mostly taking? Staking? Farming? Swapping? Mining?
Going Down the Gnosis Native Bridges - Part 1 : xDai Bridge
Aug 6, 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.
Polygon NFT Market Analysis
Jul 8, 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?
#7.Fractionalized Dragons
Mar 13, 2022 - Create a graph showing the total volume of $DRGNZ traded and the total deposits into the DRGNZ-SOL liquidity pool over time. Highlight the largest deposits and largest withdrawals from the pool to date. How many $BOKU tokens have been farmed so far from this rewards program?
Osmosis Decentralizing Power: Governance & the Active Set (Part 2)
Nov 4, 2022 - Props 114, 196 & 337 were all passed in an effort to promote decentralization within the ecosystem. After these proposals, how was governance impacted by this effort? Analyze the participation of the new validators on the governance proposals after the active set increases. Did new validators vote more or less than the original top 66% of validators? Did time play a factor? Analyze changes in governance participation after these proposals.
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.
#9. Forefront Holder Distribution
Mar 29, 2022 - Q1. Forefront has ownership tiers based on the number of tokens that you hold. These tiers provide access to different tools and community features. One example of an exclusive access is https://signal.forefront.club/ Create a histogram of token ownership amounts to understand the percentage of holders that buy tokens to provide access to these tiers. Where are token amounts most commonly distributed?
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?
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?
#14.Swap Volume vs. LP Rewards
May 3, 2022 - Chart the weekly swap volume and LP rewards on the same chart. What is the relationship between the two? Hint: use thorchain.daily_pool_stats to get swap volume and earnings_to_pools from thorchain.daily_earnings to get LP rewards
Axelar Token Launch
Sep 28, 2022 - Axelar recently launched its native token, AXL. We want to analyze the activity within the AXL/OSMO pool (#812), as well as trading activity on the Osmosis DEX.
OP Price vs Swapper Activity - Is there a Relationship?
Oct 5, 2022 - Is there a relationship between OP price and trade volume?
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.
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.
USDC Analysis on Avalanche: Swaps vs Transfers & Mints vs Burns
Nov 16, 2022 - Lets look at volume of USDC swaps vs transfer by hour since 7/1. What is the average amount of USDC transferred vs swapped? Show number of unique swapper addresses vs transfer addresses by day for USDC Next lets look at mints and burns of pairs involving Lets look at the volume of USDC mints and burns by hour since 7/1 How many unique wallets are minting and burning USDC by day What is the average mint vs burn for USDC by day Note anything else interesting about USDC transactions
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.
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
#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.