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.
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.
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.
Flash Bounty: Miners Moving?
Sep 17, 2022 - -- How have miners reacted to the fast-approaching merge? -- Have they stopped mining in recent weeks? -- Show evidence of miners either stopping work or continuing to mine.
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?
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'
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!
Toke-2.Token Reactor Rankings
Jun 23, 2022 - -- Q2. Rank the token reactors by their TVL, analyze the pattern of liquidity (withdrawals, deposits) -- on the top ones. Is there a reason why some reactors have more liquidity than others?
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?
Sushi-94.SUSHI Noobs II
Jun 19, 2022 - -- Q94. What is the first thing new users do when they acquire SUSHI?
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.
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?
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
NFTs in 2022
Jan 5, 2023 - A retrospective on the NFT market in 2022. NFT project with the highest volume of trades in 2022? Which NFT project had the largest mint by dollar? Which NFT project decreased the most in value this year? Which NFT project gained the most value this year? What was the price of the highest-selling individual NFT? Which NFTs had the longest hold time this year? Which NFT project had the least amount of NFTs listed for sale on an exchange? Which project had the most NFTs listed for sale on an exchange?
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.
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!
Open Analyitics Bounty: Optimism
Jul 24, 2022 - Flipside Crypto has built pathways and provides the tooling for you to develop deep and thorough crypto analysis. Now, we want to see what you can do with them. Submit any dashboard you think is worthy of being shared with our partners, and with the world. We’ll select the best for payment and amplification through our social and content channels. (Please note that many dashboards submitted to this bounty will not be rewarded with payment — only the best of the best will do here.) As you dive in and work through your analyses, we would love to see what insights you find and dashboards you develop. Feel free to submit your work via this bounty card for internal review. Elite tier work will be shared out on our social channels and to partners highlighting the analyst. Be sure to use the Optimism tables, which can be found under the "Optimism
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-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
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?
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?
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?
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.
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.
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.
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
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.
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).
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
Flash Bounty: Merge Staking Providers
Sep 6, 2022 - Choose 1 liquid staking provider (Ankr / Lido / rocketpool, etc) and answer the following question: How much ETH was staked? How many unique depositors are there? What is the avg/median/max/min/distribution of ETH deposits?
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?
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).
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?
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 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.
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!
