CryptoIcicle
Liquid Staking ETH Platforms Analysis
Sep 1, 2022 - -- Consider all possible liquid staking ETH platforms. Then, find out the following: -- How much ETH was staked over time? -- How many unique depositors are there? -- How likely are depositors to use multiple platforms vs using a single platform? -- Are depositors Dollar cost averaging their ETH into the platforms? -- What is the avg/median/max/min/distribution of ETH deposits? -- Compare all the metrics above between the various ETH staking methods/platforms
Gains Network vs GMX
Nov 4, 2022 - -- A war of the trading platforms? GMX (native to Arbitrum) - GNS (native to polygon, but announced will be launching on Arbitrum soon). -- Both platform native tokens (GMX - GNS) have seen meteoric price growth during a bear market. -- Since June GNS has gone from $0.68 to $3.68 and GMX has gone from $13.70 to $41.56 -- Observe Trading volume. Has one platform absorbed more volume than the other? -- How impactful is GNS volume to polygon? GMX volume to Arbitrum? Are there any insights that can reveal why Gains Network wants to move into the Arbitrum ecosystem? -- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Hacks, Scandals and Scams - 4. CEL token flows.
Jul 28, 2022 - Celsius Network listed a $1.19 billion deficit on its balance sheet in a bankruptcy court filing a day after the cryptocurrency lender filed for Chapter 11. Currently Celsius owns a large portion of the CEL tokens. What are the top addresses swapping and transferring CEL? How have the CEL swap volumes changed over the past 90 days? How are Celsius wallets interacting with the CEL token? Hint: Here is the list of Celsius Wallets Identified by @lawmaster on twitter: https://app.flipsidecrypto.com/velocity/queries/c5c1ca1b-5299-4105-aed5-7968e2426d94
EVM - 7. Derivative Daze
Feb 6, 2023 - Derivatives DEX Gains Network recently crossed a major milestone, with more than $1.5 million in trading volume on Arbitrum, fueling further interest in derivatives trading on the platform. Building on this Dune dashboard, create a dashboard that shows the following data for Gains Network and any other derivatives trading markets you can find: Total volume Total traders Total trade fees Trade volume over the past day/month/three months Traders over the past day/month/three months
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.
stETH/ETH Fluctuation
Jun 11, 2022 - -- Analyze the price of stETH in ETH denomination and find meaningful correlations that explain its fluctuation. -- Possible correlations could be with ETH’s price in USD, ETH’s gas price, volume in the curve pool, -- Curve stETH/ETH pool composition, etc.
NEAR - 7. Weekly Report - Redux
Jan 14, 2023 - Each week, the NEAR Foundation publishes data to help the NEAR community understand the ecosystem's health as part of their Transparency Report. We want your help in making the NEAR ecosystem even more transparent. How can you improve on the existing NEAR Transparency report? Explain which metrics should be taken into consideration and why. Then, analyze those metrics over the last several weeks and draw your own conclusions on the health of the NEAR ecosystem. Grand prize-winning dashboards will go above and beyond the existing report, allowing readers to get the best possible snapshot of NEAR, its users, and its ecosystem.
Open Analytics Bounty: ETH vs Solana - Battle of the NFT Marketplaces
Sep 15, 2022 - Open analytics bounties are all about deep dive dashboards into one specific topic. For this bounty, submissions should compare ETH + Solana in some way.
Yield Maximization 2
Mar 8, 2022 - Question 51: Of the people who have used Sushi's lending service on ethereum, show the top 50 addresses that have realized the most profit (ROI) considering gas fees. what where they lending? for how long?
Solana-103.Going Down The Wormhole
Aug 9, 2022 - -- Q103. Create a dashboard that can refresh daily with metrics that provide a detailed picture of Wormhole activity -- both from Ethereum to Solana and from Solana to Ethereum. -- How are tokens being bridged from chain to chain and which actions seem to be popular among users of Wormhole? -- What actions seem to influence bridging behavior? -- What are users doing before and after bridging? -- Do users seem to think that bridging is safe or more risky relative to transfers to centralized exchanges?
Tornado Cash Addresses
Aug 10, 2022 - -- Using those addresses: -- Which of the Tornado Cash addresses received the most # of transactions in the last month, quarter, year -- Which addresses received the most transaction volume (worth) in the last month, quarter, year -- Over all the addresses, group the transactions into buckets by value. -- How many tx in the 0.01-0.1 ETH range went to Tornado? -- How many in the 0.1-1ETH range? -- How many in the 1-10ETH range? -- How many in the 10-100 ETH range? -- How many above 100 ETH? (split further if better)
BendDAO Metrics
Sep 8, 2022 - -- Q1. Analyze deposits and withdrawals into BendDAO over the past month. Provide metrics such as total ETH volume and unique wallets, and explain any interesting findings
OPtimitic or Pessimistic?
Oct 18, 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?
Across-1.Bridge Transactions (Across)
Jun 20, 2022 - -- Q1. Analyze bridge transactions via the Across bridge over the last two weeks. -- What assets are users bridging from Ethereum, and to what chains? -- Across transaction event data is undecoded in the Ethereum core tables. -- Users can use these functions to parse and decode the data: -- regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}') AS segmented_data ethereum.public.udf_hex_to_int() -- Hint: A user begins a bridge transaction by calling the deposit function on the SpokePool contract from the origin chain. -- Ethereum SpokePool contract : 0x4D9079Bb4165aeb4084c526a32695dCfd2F77381
Inflows and Outflows (redux)
Oct 30, 2022 - -- What is the volume of ETH and three stablecoins of your choice that's moved between the Optimism -- network and the Ethereum network across the bridge? -- How has that changed over time? Note any interesting trends or outliers that you see.
WETH/THOR Pool
Sep 13, 2022 - -- Q111. ThorSwap just recently partnered with Sushiswap to create an Onsen farm for ETH-THOR LP providers to stake their liquidity to earn extra rewards. -- Previously ThorSwap offered their own contract for the same purpose but this switch allows for higher rewards as well as lower slippage for the users. -- Show how users reacted to this change: -- - How many funds has been moved from the old contract to the new one? How much is still left in the old one? -- - How many unique wallets did already move their liquidity over? How many still have to switch?
Bridger Destinations (redux)
Oct 31, 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? How has this changed over the last three months? Last six months? -- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
NFTx-1.Highest Sales Volume
Jun 11, 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.
Sushi-109.Liquidity Providers Stats
Aug 22, 2022 - Q109. Liquidity providers stats 1. Evaluate the distribution of various target segments who provide liquidity (LP): - What’s the total no. of unique LP providers? - What’s the ratio between Yield farmers vs. LP Providers? - What’s the average no. of LP positions opened by each unique wallet address - What’s the ratio of liquidity (Based on TVL) owned by the Protocol vs. Retail LP in both LP Pool and yield farms - The percentage (%) increase/decrease of LP Providers in Sushi over the last 1 year 2. Evaluate the profitability of an LP Provider & Yield Farmer - Evaluate if there’s a correlation between profitability vs. length of time? - Evaluate if there is a correlation between profit vs. time of withdrawal - Correlation between profitability vs type of pool? EX: stable pool
Across-2.Single-Sided Liquidity Pools
Jun 20, 2022 - -- Q2. Across uses single-sided liquidity pools to execute transactions between chains. -- How are Ethereum mainnet users interacting with these pools? How do these pool rewards compare to other liquidity pools?
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.
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.
NEAR - 6. NEAR Foundation Transparency Report: Q3, 2022
Jan 10, 2023 - Each quarter, the NEAR Foundation publishes data to help the NEAR community understand the health of the ecosystem as part of their NEAR Foundation Transparency Report. We want your help in making the NEAR ecosystem even more transparent. How can you improve on the existing Transparency Report? Explain which metrics should be taken into consideration and why. Then, analyze those metrics over the last several weeks and draw your own conclusions on the health of the NEAR ecosystem.
Aave - 5. Fees in Aave v2 and v3
Jul 30, 2022 - -- Compare the premium fees earned in AAVE v2 and AAVE v3 in the last 90 days. Which one is the leading fees generator? -- Has Aave v3 eaten Aave v2's premium fee share? -- If appropriate, set a daily refresh rate for your data. -- Note (July 26): because premium fees is not official Aave terminology, submissions comparing total fees in Aave v2 -- compared to v3 will also be accepted.
NEAR Tournament Round IV: The Journeymen
Aug 18, 2022 - -- Analyze the journey of active NEAR users. -- After bridging to NEAR, where do they head first? -- How many users are day trading in the financial district, -- and how many are buyers and sellers on the NFT marketplaces of the Arts district? -- Who are the whales, and is their activity any different from that of smaller fish? -- Top submissions should provide an in-depth analysis of the typical NEAR user journey, from small fish to the biggest whales.
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?
Optimism NFT Purchasing Behavior
Oct 20, 2022 - -- Show the distribution of all NFT sales on Optimism by price. -- What percentage of all sales have been above .01 ETH? Above .1 ETH? 1 ETH? -- Do you think that there is a limit to how high a floor for a NFT collection on Optimism can reach compared to on Ethereum?
EVM - 4. The “Flippening” Comparison
Jan 19, 2023 - -- It finally happened. The great Flip everyone’s been waiting for — Optimism and Arbitrum have officially surpassed Ethereum in combined transaction volume. -- (What, you were expecting some other flippening?) -- Use this historic event to compare and contrast these two major L2 chains. -- Include metrics such as total and average transaction volume, average transaction size, active users, new users added, and anything else you find relevant to this comparison.
ETH Merge: Selling Event?
Sep 30, 2022 - -- Was the Merge a selling event? Why or why not? -- Were miners the source of sell pressure? Show any wallets miners have transferred ETH into, -- along with any other visualizations you think will add to your analysis.
What's going on with Optimism?
Jul 22, 2022 - What's going on with Optimism? This is an open-ended bounty, what we call a Free Square, and it’s an opportunity for you to show us what you’ve got. Any topic is fair game; The goal here is to explore the data in creative ways and show off your explorations with visualizations (or even a tool/frontend if you’ve got eyes on the grand prize).
Aave - 7. AAVE and stAAVE movements
Aug 10, 2022 - -- Create visualizations showing the following: -- Daily AAVE supplied and withdrawn on Aave protocol. -- Daily AAVE staked and unstaked.
Hop-2.Bridge Volume (Hop Protocol)
Jun 20, 2022 - -- Q2. How much volume has Hop bridged to Polygon, Optimism, and Arbitrum compared to those protocols’ native bridges? -- What is Hop’s total TVL? -- Create an analysis on the Hop’s TVL and how it’s changed over a time period of your choosing.
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
NEAR Tournament Round 3: The Financial District
Aug 7, 2022 - Provide and explore key health metrics, as well as detailed data on at least 1 key project.
Sushi-95.Celsius Swaps
Jun 19, 2022 - -- Q95. Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. -- From which one of their wallets did they conduct most of the swaps? -- Hint: you can find all addresses belonging to Celsius network by querying this table: flipside_prod_db.crosschain.address_labels
Lil-Nouns-2.Secondary Sales Activity
Jun 17, 2022 - -- Q2. How many Lil Nouns have been sold on a secondary exchange within 24 hours of being minted? -- Are there any common traits among these Lil Nouns? Which Lil Noun’s have the biggest difference (positive or negative) -- between their mint price and secondary sale price? Visualize and analyze your findings. -- Hint: This query looks at Nouns traits. You will need to modify it for Lil Nouns!
In the News - 13. DYDX Unlock
Jan 26, 2023 - DYDX holders are bracing for a massive event next month, as 105% of the circulating supply will be distributed to investors and team members. Have holders begun preparing for this massive unlock? If so, what actions are they taking to prepare? How do you expect the market to react in the weeks leading up to and following the unlock? Back up your assertions with data.
Hacks, Scandals and Scams - 3. Whales On Alert
Jul 29, 2022 - -- Identify active wallets with a high balance of ETH (whales). -- Visualize the ETH transaction history of these whales in May and June 2022.
Mirror-1.Mirror Fundraising
Jun 26, 2022 - -- Q1. How much total funds has Mirror raised? How many unique sponsors are there? -- How many total publications have been written? What are the most popular accounts?
Metamask-2.Most Common Transactions
Jun 25, 2022 - -- Q2. What are the most common transactions for Metamask users? -- Create an analysis that shows the most common wallet activities and the most common platforms for those activities.
Flash Bounty: Post Merge Behavior
Sep 24, 2022 - -- The merge has occurred. How have users responded in days that followed? -- Analyze any notable trends or outliers you can see since ETH switched to POS. -- Compare this to user behavior in the days and weeks leading up. -- What major changes can you see?
Osmo-11.wETH Deposit Rate
Jun 13, 2022 - -- Q11. Calculate the deposit rate of wETH over time on Osmosis. -- How does this compare to SushiSwap and Thorchain now? -- How does the wETH deposit rate compare to when wETH was a relatively new asset (or the protocol was relatively new)? -- Is Osmosis growing at a faster rate than Thorchain and Sushiswap? -- Hint: There are two types of wETH on Osmosis, wETH from the Gravity Bridge (gwETH) and WETH from the Axelier Bridge (axlWETH).