CryptoIcicle
Flow-3.Flow vs L1s
May 29, 2022 - -- Q3. Create a dashboard comparing the following metrics between Flow, Solana, Ethereum, and Algorand. -- Visualize these metrics over time since May 9th. -- Number of transactions -- -Transaction success rates -- -Number of unique wallets to make a transaction -- -Number of wallets that used the chain everyday since May 9th -- -Transaction fees -- How does Flow compare to these other chains and how do you think it will trend over time?
Flow NFT Comparison
Sep 16, 2022 - -- Compare and contrast the NFT market and ecosystem across at least three different chains -- (you can do more if you wish, but there must be at least three included.) -- Explain how the various chains differ in terms of metrics such as: -- Total Sales -- Total Unique Buyers -- Total Volume -- Average Sales/Day -- Average Buyers/Day -- Average Sales Price/Day
Flow-10.NFT Buying Behavior on Flow
Jun 12, 2022 - -- Q10. Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to on Ethereum and Solana. -- Is there more or less "whale" activity on Flow compared to each of the other chains? -- What do "whales" tend to focus on in Flow? -- How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? -- Are wallets more interested in new projects, or already existing projects on Flow?
Flow During Market Downturn
Jun 28, 2022 - Q.14 Analyze Flow during the month of May when markets began to get turbulent, showing whatever metrics you care to unearth.
Flow-9.Crossover with NBA Top Shot
Jun 12, 2022 - -- Q9. Which Flow NFT projects appear to have the most crossover of buyers with NBA Top Shot addresses? -- Is NBA Top Shot an effective onboarding tool in getting users interested into other Flow collections? -- Does this crossover tend to come from Top Shot "whales", or does the crossover come from average to smaller players? -- How can Flow projects better attract liquidity from Top Shot players?
In the News - 12. Groundhog Day
Jan 17, 2023 - It’s been a harsh few months of winter in the crypto market, with token prices falling hard and once-stable companies and organizations reducing workforces or even vanishing overnight. With Coinbase announcing another layoff of nearly 20% of employees, some might be feeling like Bill Murray in Groundhog Day, forced to relive events over and over again. With that in mind, let’s turn to our friend the groundhog for an early crypto-winter prediction: are we nearly through to spring, or will winter’s cold snap continue on even longer? Back your assertion by creating a dashboard with on-chain data that supports your arguments in favor of either a continued downturn in the space or a soon-to-come rally.
FLOW NFT Ecosystem
Sep 25, 2022 - Happy Flow NFT Day! As part of today’s celebration of FLOW NFTs, we want you to dive deep into the ecosystem. Treat this as an open analytics bounty specifically focusing on the FLOW ecosystem. Open Analytics (OA) bounties are bounties without specific prompts, just a direction, and a reward. It’s your chance to have your brain follow your heart — got a spark of interest, or a loose thread, or a weirdly-specific question gnawing at the back of your mind? Follow it as far as you can!
RaceDay NFTs
Oct 23, 2022 - -- How does Speedway Motorsports RaceDay NFTs stack up to sports NFT collections in the FLOW ecosystem? What other projects are RaceDay fans buying? -- Create a dashboard that shows off a high-level project overview of RaceDAY. Include at least these metrics, along with any others you find notable or interesting:
Terra - 6. New Year, New LUNA?
Jan 7, 2023 - The holidays and New Year are often chaotic in the crypto and DEFI space, as users make a spree of new transactions and wallets as they receive (and give) some cash and coins as holiday gifts. Has this flurry of winter activity impacted the Terra ecosystem? Are users creating new wallets or buying tokens with their newfound holiday wealth? Are they staking all those new tokens once they get them? Or are they selling tokens to pay for their own gifts and holiday travel? Create a dashboard documenting significant trends in transactions, wallets, supply, staking, development, or other aspects of the Terra ecosystem. Note any changes in metrics such as the average and total transactions per week and the fees associated with them, the total and average number of new wallets created each week, the total and average number of contracts deployed, LUNA staked, and anything else you interesting.
Flow-4. Flow Speed
Jun 4, 2022 - -- Q4. One of Flow's main features is its speed compared to other blockchains. -- Blockchain performance can be measured as Transactions per minute. -- Measure the transactions per minute of Flow since May 9th and 'Successful transactions per minute' and create a chart showing how that metric -- has fluctuated during that time period. -- What types of events have raised or decreased the blockchain's performance over that time period? -- Are there bursts of transaction volume or interest on the chain? Compare Flow's speed to at least two other blockchains.
Flow Ecosystem 2022 Dec vs 2023 Jan
Jan 8, 2023 - Pick your favorite ecosystem or project and tell us why it’s your favorite using data
Flow-19.FLOW Usage During the NBA Playoffs
Jul 9, 2022 - Analyze the start of the NBA playoffs (mid-April) and determine whether it had an impact on Flow transaction volume. What about NBA Top Shots?
Flow-13.Flow vs Other L1s
Jun 17, 2022 - Q13. How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum
Polygon Block Performance
Jul 23, 2022 - -- Polygon Block Performance -- 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?
FLASH BOUNTY: FLOW NFT Floor Tracker
Oct 27, 2022 - -- Let’s sweep some floors. Build a dashboard that tracks the floor by contract for various NFT projects in the FLOW ecosystem. -- We’re interested to see how you come up with your own methodology. -- Include at least five projects in your dashboard, as well as any interesting metrics, notes, trends, or outliers that you see. -- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Flow - 3. Daily Active Users
Apr 11, 2023 - Track how the Flow blockchains daily active users have evolved over time. What about monthly? All-time wallets? Recently, we’ve identified some interesting spikes (in both directions) in daily active users. Chart this activity, and try to uncover any reasonable explanations for the results.
Flow-NFT Wallet Behavior Comparison
Jul 16, 2022 - Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to Ethereum and Solana. Is there more or less "whale" activity on Flow compared to each of the other chains? What do "whales" tend to focus on in Flow? How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? Are wallets more interested in new projects, or already existing projects on Flow?
Flow-5.Volume Scoring with NBA Top Shot
Jun 7, 2022 - -- Q5. NBA Top Shot allows users to buy, sell, and collect NBA NFTs that showcase influential “Moments” minted on the FLOW blockchain. -- Create a visualization tracking the total sales volume traded on NBA Top Shot since May 9th by day. -- How many unique wallets have made a trade on Top Shot over that timeframe? -- How do those metrics compare to sales volume and unique users of Magic Eden on Solana and OpenSea on Ethereum?
Flow-15.NBA Playoff Usage
Jun 28, 2022 - Analyze the start of the NBA playoffs (mid-April) and determine whether it had an impact on Flow transaction volume. What about NBA Top Shots?
What makes a Top Shots moment valuable? (Part I)
Jul 24, 2022 - -- Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. -- This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table. -- What play_types do users hold most and how much volume in sales do these play_types generate? -- Include any other transactional metrics you can think of.
NFL All Day Tournament [Round 1]
Sep 14, 2022 - -- For the first round of this tournament, create an analysis that shows top-line NFL All Day metrics and stats. -- Chart total sales and sales volume growth, user analysis, player. Track metrics by player and position, -- and see if there are any notable spikes in sales so far this preseason. -- Only the top 32 most stellar dashboards submitted will receive payment + make it to the next round, so get creative with your analysis to stand out!
Flow-8.Trending NFT Projects
Jun 11, 2022 - -- Q8. Create a visualization showing NFT sales volume on Flow since May 9th. -- Which NFT projects are trending on Flow right now and what is the general trend of NFT sales over the last month? -- Do the projects that are trending seem to have common wallets or is there not much crossover between buyers/sellers?
Flow-11.User Behavior
Jun 17, 2022 - -- Q11. What are users swapping for? What activities are the most common for users on Flow right now? -- Create a visualization on what’s causing spikes in swapping behavior.
Flow-12.Active Wallets
Jun 18, 2022 - -- Q12. What are active wallets doing more broadly? What type of activities are the most common on average, -- and what are the whales doing? Is there a way to identify real users and organic transaction activity? -- Hint: Track wallets by activity using the events table to derive activity type based on what events are in the transaction
Flow vs Other L1s Pt (II)
Jul 16, 2022 - How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum.
Flow-1.Popular Contracts on Flow
May 29, 2022 - -- Q1. What are the 10 most popular contracts that have been used on Flow since May 9th? -- What do each of those contracts do and why do you think they are so popular? -- Are there any contracts that seem to be trending and growing in popularity?
Flow-2.When Do Transactions Fail?
May 29, 2022 - -- Q2. Do times of high transaction volume lead to more transaction failures? -- Create a visualization that shows the relationship between transaction volume and success rate of transactions since May 9th. -- Are there any noticeable patterns to when transactions are more likely to fail? -- Were there specific events that seem to cause transaction failures?