CryptoIcicle
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.
Tornado Cash Sanctions
Aug 10, 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. (Hint: we also have them in our crosschain address labels table as well). What is Tornado Cash and why would it be targeted by the US government? Why might an address interact with the service? The addresses tied to the service have been publicly posted online. Using those addresses answer the following: How many addresses are still using the service despite the sanctions? Which addresses have been interacting the most with Tornado Cash? Break the addresses down by frequency and volume of tokens and describe how the groups are using the service differently. Is there anything else interesting about its users?
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.
Metamask-1.Total Metamask Users
Jun 25, 2022 - -- Q1. How many total Metamask wallet holders are there? -- What’s the average value of ETH held in wallets? -- What percentage of wallets are engaging in a higher order activity, like staking? -- Hint: For the purpose of this bounty, we can categorize Metamask wallets as wallets who have -- used the Metamask swap feature (interacted with this contract 0x881D40237659C251811CEC9c364ef91dC08D300C)
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?
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.
Inflows and Outflows
Sep 14, 2022 - -- What is the volume of ETH and a stablecoin of your choice that's moved between the Optimism network -- and the Ethereum network across the bridge? How has that changed over time?
$MATIC Staking
Sep 21, 2022 - How many $MATIC have been staked since July 1, 2022? What is the staking ratio of $MATIC (amount of $MATIC staked vs circulating $MATIC) during the same time frame? Has it changed or are there any visible trends? What is the daily amount of $MATIC being staked and unstaked?
Bridge Volume (Optimism Bridge)
Jun 15, 2022 - -- Q2. Compare user bridge volume on the Optimism Native Token Bridge vs. another Mainnet <-> Optimism Bridge -- of your choosing (e.g. Hop). -- Can we conclude if there are differences in the types of users or transactions using the native bridge -- vs. the non-native bridge?
Optimism-9.Optimistic Bears
Aug 9, 2022 - Q9. Analyze Optimism during the month of July as markets were get turbulent, showing whatever metrics you care to unearth. You can choose any topic you’d like: How did the network perform? What about market performance? Were there significant inflows or outflows on bridges? Were there any notable patterns in user behavior?
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.
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
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.
Bridger Destinations - Optimism
Sep 15, 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?
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).
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.
NEAR-5.Performance
Jul 16, 2022 - Q5. How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.
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
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
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!
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.
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.
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.
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?
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?
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?
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.
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.
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
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.
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'
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.
Optimism Free Square Question
Jun 25, 2022 - -- Show us what you can do with this new Optimism data!
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?
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.
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?
Distinct Wallets (zkSync)
Jun 14, 2022 - Q1. 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. -- How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
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
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?
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).
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?