CryptoIcicle
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?
Bounty #3 - Uniswap V2 vs. V3(L1)
Feb 26, 2022 - -- Uniswap V3 (on L1) has now been 'live' for ~10 months; V2 for ~22months. A lot has happened in crypto- and DeFi-sphere in the meantime, -- likely to have a lot of insights waiting to be discovered and presented! -- For this bounty, pick a **fixed timeframe** that you think shows some interesting trends and insights, -- and provide **analytics and commentary** on the observed differences and changes in various metrics -- between Uniswap V2 and V3(L1) **during that timeframe**. -- Things of interest can include, but not restricted to, liquidity (inc. migration and fragmentation?), -- swap volumes, swap tx sizes, LP fees (inc. impacts of V3 fee tiers?), impacts/trends of key external events -- (e.g. launch of new DEXes, new incentives, new Uniswap fee tiers?), etc.
Osmo-8.Osmo Staking
May 29, 2022 - -- Q8. Over the past 30/60/90 days and since June 2021, how much OSMO has been staked per day? -- What is the staking percentage (OSMO staked vs. circulating supply) and how has it changed over time?
ETH Removed
Sep 16, 2022 - -- Examine user behavior in recent weeks leading up to the merge on at least 3 major protocols. -- Have there been any changes in the amount of ETH removed from protocols like Uniswap and Aave? -- Note any trends or outliers you find.
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?
Osmosis-21.Swap Fees - From
Jun 27, 2022 - -- Q21. Do fees on Osmosis differ when users swap to or from different tokens? -- On average, which tokens have the highest and lowest swap fees on Osmosis?
Governance Reaction to Terra
May 24, 2022 - The period between May 8th - May 13th was a busy week for Osmosis governance. What was the community response like to these proposals? How quickly did these proposals hit quorum compared to the last two months of proposals? What was the voter turnout for these proposals vs the last two months of proposals?
Sushi-89. Gas as a proxy of activity
Jun 5, 2022 - -- Q89. How much did sushi users pay for gas in 2022? Is there a correlation with the price of ETH? Can you comment on the spikes in the chart?
Open Analytics Bounty: Optimism (August 14)
Aug 18, 2022 - This open bounty investigates the Overall Optimism Health Metrics Like DEXes Velodrome vs Uniswap vs Sushiswap, $VELO Locked, Voting, ETH Deposits and Transaction success rate.
Open Analytics Bounty: Optimism (August 28)
Sep 1, 2022 - In this open bounty our focus is Overtime Markets - Volume
Osmo-12.Do Whales Have Diamond Hands?
Jun 18, 2022 - -- Q12. Does the swap behavior of OSMO whales differ from everyday users? How does it differ? -- Create visuals showing what whales swap to and from compared to a normal Osmosis user. -- For payment, submit the address of your Osmosis wallet.
Axelar Token Launch
Sep 28, 2022 - -- Axelar recently launched its native token, AXL, and we're celebrating with some bounties! -- For this bounty, analyze the activity within the AXL/OSMO pool (#812), as well as trading activity -- on the Osmosis DEX. Note any trends or outliers you see. -- BONUS: The best dashboards will update over time
Miso User Base
Sep 19, 2022 - -- How many users does it have across how many chains? -- Chart that by week and by month. -- Has the recent bear market affected that?
Osmo-7.Unique Users
Jun 4, 2022 - -- Q7. How many unique wallets are active on Osmosis per day? How has this changed over time? -- What has been the largest event that has brought the most wallet activity to Osmosis? -- Hint: Determine events by comparing to news sources as well as on-chain data.
Osmosis One Year Anniversary
Jun 23, 2022 - -- What did the users who received the initial airdrop of OSMO do with their tokens? -- Create a visual that shows how many sold, staked, LPed, swapped, and held. -- How many individuals who received the airdrop still hodl their OSMO one year later?
Solana-85.Onboarding with Solana NFTs - Onboarding
Jun 14, 2022 - -- Q85. It has been said that Solana NFTs have become a powerful onboarding tool into the Solana ecosystem. -- Is this narrative true? Which NFTs have captured the most first time users of the Solana blockchain? -- What kinds of activities do these wallets tend to do after buying their first NFT? -- Do you think the NFT growth on Solana will spill over into Defi?
Flash Bounty: Merge Open Analytics
Sep 24, 2022 - We want to know all about the merge — and we’re turning to you for the answers. Take a deep dive into the ETH merge and switch to POS with this Open Analytics Bounty. This is a chance to explore the topic without any specific prompt, 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!
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.
Open Analytics Bounty: MakerDAO (September 1) - Flash Loan Users
Sep 7, 2022 - 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!
Optimism DEXs (redux)
Oct 25, 2022 - -- Let’s take a closer look at DEXs on Optimism. Make a dashboard that compares at least three DEXs based on: -- Total number of swaps by day over the last month -- Total number of wallets swapping by day -- What are the most popular asset pairs to swap from and too -- Top 10 assets swapping from -- Top 10 assets to swap to -- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
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?
Liquidity Pools - Wallet Composition
Oct 27, 2022 - What type of wallets provide liquidity on Osmosis? Is liquidity concentrated and owned by a small number of whales? Or, are there a diverse range of participants in the LP ecosystem? Do LP composition change based on TVL of the pools themselves? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
NEAR Meta-Analysis
Sep 15, 2022 - Take a look at the winning submission to our NEAR Tournament, as well as the three runner-up submissions (links can be found below).
Quix vs Magic Eden vs OpenSea
Sep 28, 2022 - -- Create a dashboard highlighting at least 3 metrics comparing marketplace performance and adoption -- between Quix (formerly Quixotic) on Optimism, Magic Eden on Solana, and OpenSea on Ethereum, since July of this year. -- What has been the rate of change of these metrics since the start of the new year and are there any signs of growth of a certain marketplace -- or ecosystem of NFTs? -- Highlight the 5 most popular NFT collections for each marketplace over that timeframe in terms of sales volume. -- Is the turnover rate (number of transactions) for collections on Quix noticeably higher than on OpenSea and Magic Eden? -- Provide some insights on these findings.
Osmosis-20.Stablecoin Dominance
Jun 28, 2022 - Q20. Compare the transaction volume for USDC, USDT, and DAI on Osmosis. Is there a stable coin that Osmosis users prefer?
Overtime Markets - Volume
Aug 23, 2022 - -- 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? Explain your findings.
Sushi-104.Celsius and Sushi
Jul 12, 2022 - -- Q104. Find out what Celsius platform has done on sushi (swaps, lending, LP'ing, farming). -- Make sure to use cross-chain tables as much as possible to capture data on all chains. -- currently, we have swaps, lending, and borrowing data cross-chain. -- Hint: you can find all addresses belonging to Celsius network by querying this table: flipside_prod_db.crosschain.address_labels -- NOTE: This bounty will be paid on the ETH network. Please give your Sushiswap address on ETH when submitting
$OP Airdrop
Sep 28, 2022 - Earlier this summer, Optimism offered an airdrop to users. Let’s examine the airdrop after a few months. How many users claimed optimism airdrop? How much of total airdrop was claimed? How many wallets are still holding tokens from airdrop? How much of users delegated their OPs? Feel free to provide any information that you think is related to token price.
Sushi-110. Sushi Xswap Revenue
Sep 7, 2022 - -- How much fee in total do sushi Xswap users pay per transaction? -- What part of that goes to sushi, what part goes to stargate and what part goes to miners? (stargate does the bridging for sushi and its usually a stable coin that gets bridged) -- Chart sushi’s revenue per month from Xswap?
1.Ribbon-Theta Vault Covered Calls
Feb 6, 2022 - -- Question 1: Ribbon offers ETH and BTC covered call option Theta Vaults. -- Create a visualization charting the TVL in both the T-ETH-C and T-WBTC-C pools over time. -- Has one pool been more popular than the other? Why do you think that's the case?
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?
Optimism-10.Velodrome Health
Aug 14, 2022 - -- Q10. Create 3 dashboards on Velodrome with a description for each that showcase traction and success in a data-driven manner. -- Most importantly, your insights should help our readers answer the question "How healthy is this project?"
Lido-11.HODL or Sell?
Jun 13, 2022 - -- Q11. Identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. -- Have they held or sold their stETH?
Exchange Flows in the Bear
Aug 13, 2022 - Let's understand whether the bear market and recent issues with CeFi products have changed centralized exchange users' behavior Explore trends in exchange withdrawal (specifically, moving money from CEX addresses onto the chain) patterns over the last 6 months. Have those withdrawals increased? Has the typical size of them changed? Most important: are people creating new wallets to take custody of their CeFi deposits?Also have a look at what people do after a withdrawal: are they holding their withdrawn tokens? Or are they fiat-on-ramping so they can swap, provide liquidity, buy NFTs, etc.hint: find centralized exchange addresses in [chainname].core.dim_labels where label_type = 'cex' and label_subtype = 'hot_wallet'
Sushi vs Uni on L2
Oct 17, 2022 - Compare the market share of Sushiswap and Uniswap on the following L2 chains.
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.
ETH Derivatives
Sep 13, 2022 - Consider the liquid staking ETH derivates from ankr, rocketpool and lido(aETH , rETH and stETH ). What are some trends around the price volatility for these tokens? Swap activity?
ETH Merge: Actually Good?
Sep 30, 2022 - -- Recently, ETH devs and observers have opined on Twitter regarding whether the Merge was good or bad for the Ethereum network. -- We want you to prov11e one side or the other, with the help of Flipside data. -- Demonstrate whether the Merge had positive or negative effects on the network. -- Include least three queries and visualizations in your submission.