Ali3N
Impermanent Loss; Mainnet vs. Polygon (Sushiswap Bounty)
Jul 22, 2022 - Compare impermanent loss on Sushi pools on Mainnet vs. on Polygon, and create visualizations to illustrate the comparison. You are free to draw your own conclusions on the comparison analysis, but the goal here is to put your skills to the test and help us develop a TWAP methodology that allows for understanding changes in LP value (not adjusted for fee revenue) over time at the deposit level. Since each deposit happens at a different time, there must be something specific to each deposit. Withdrawals of liquidity can be ignored for now. Hints: Using Sushi USDC/WETH Pool on Mainnet: 1. Identify all liquidity deposits between ETH Block Number 14000000 and Block Number 15180000 into the mainnet pool 2. For each depositor-deposit get the ETH price in USDC at that deposit time (can use hourly_price table as a shortcut, but ideally, create a time weighted average price using SWAPS in the pool within the last 100 blocks of that deposit) and identify their ETH/USDC deposit ratio (how much ETH did they deposit, how much USDC, what is that total value in USDC terms) 3. Use the depositor-deposit ETH/USDC ratio at time of its deposit (changes for every depositor-deposit) to calculate the impermanent loss of each deposits at Block Number 15180000 The resulting table may look like this (tweak as needed, we have not done this query before so adjust to fit your analysis): BLOCK_NUMBER_OF_DEPOSIT | TX_HASH | Liquidity_Provider | Amount ETH Deposited in Pool | Amount USDC Deposited in Pool | ETH/USDC TWAP price at Block_Number_OF_DEPOSIT | ETH/USDC TWAP Price at BLOCK 15180000 | Impermanent Loss as of BLOCK 15180000 (in USDC) You can leverage this IL Calculator to help calculate IL without adjusting for revenue
Swap Pairs on Optimism (Sushiswap Bounty)
Jul 17, 2022 - Create a document that includes all addresses for all swap pairs for Sushiswap on Optimism plus the addresses of the two tokens belonging to each pair. Getting the decimals for each of the tokens in the pair would be a bonus. If you are using sources from sushi github, please include the link.
Sushi Pairs on Avalanche and BSC
Aug 4, 2022 - Q108. Let's dive deep into Sushi pairs on Avalanche and BSC Create a document that includes all addresses for all Swap pairs on Avalanche for sushi, plus the addresses of the two tokens belonging to each pair. Create a document that includes all addresses for all Swap pairs on the BSC chain for sushi, plus the addresses of the two tokens belonging to each pair. Create a document that includes all addresses for all Kashi pairs on Avalanche for sushi, plus the addresses of the two tokens belonging to each pair. Ideally, define which one is the main asset and which one is the collateral. Create a document that includes all addresses for all Kashi pairs on the BSC chain for sushi, plus the addresses of the two tokens belonging to each pair. Ideally, define which one is the main asset and which one is the collateral.
Bridge Volume (Optimism Bridge)
Jun 17, 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?
Untitled BoardGOOD
Sep 29, 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 prove 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.
Untitled BoardRNF
Oct 26, 2022 - Reddit is officially in the NFT game. Find 3 metrics to compare the Reddit NFT launch to the launches of other major NFTs. Add any other interesting metrics comparing this launch to Polygon NFTs in general
Polygon NFT
Jul 14, 2022 - Q3. How popular are NFTs on Polygon? Track daily volume over the past month/year/etc. How many Polygon users started off with NFTs? Who made the most profit?
Cosmic Champs Genesis NFT Shuffle (Algorand Bounty)
Jul 11, 2022 - Q117. Algorand-based NFT Game, Cosmic Champs, dropped their collection of 1,000 Genesis NFTs this past week. Let’s look at how the shuffle went! -How quickly did it sell out? Show shuffle sales over time! -What percent of Genesis NFT holders also hold COSG tokens, show the distribution of COSG balances for the NFT holders -Show the distribution of ALGO balances for the NFT holders and when their wallets were created over time. -Did this NFT drop bring in new wallets into the ecosystem? -Look at how many Genesis NFTs does each wallet holds. -How much in ALGO sales were generated from the shuffle?
Applications on Algorand
Jun 26, 2022 - Q108. How have the number of application calls changed in the first 6 months of 2022 compared to the last 6 months of 2021? Start off by looking at: -Average number of TX calls per block, day -Number of wallets making application calls Then do your own analysis that shows whether there is more or less application usage on Algorand in the first half of 2022 compared to the 2nd half of 2021.
Going Down The Wormhole
Aug 5, 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?
Fuse Pool USDC Allocation
May 21, 2022 - Hello and Welcome! In this submission, we are going to find out How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
Staking GARD on Algostake
May 20, 2022 - Users can stake GARD on Algostake to earn GARDIAN, a token that will be used to redeem GARD governance tokens. Let’s look at how many wallets have staked GARD to earn GARDIAN. The average amount staked by wallet. And the amount of Gardian redeemed each day through the staking pool. Do we see any of the wallets that received the Gardian from the referral airdrop also staking GARD on Algostake? If so, what percent of wallet's received the Gardian airdrop and staked GARD on algostake? Note any other interesting findings!
Algorand Price Correlation
Jun 26, 2022 - Q109. Is the price of Algorand more closely correlated with the crypto market, and assets such as BTC or ETH, or is it more correlated with network usage such as number of transactions or ALGO transfers? How does this compare to other networks such as Solana? Note your findings and anything else that may be interesting in relation to Algorand's price movement!
Symmetric vs Asymmetric LPs (Thorchain Bounty)
May 26, 2022 - Q99. On THORChain, you are allowed to add liquidity in 1 of 3 ways: Rune-only, asset-only, or symmetric (both Rune + asset). What is the breakdown of liquidity being added, according to those categories? Are there any trends over time or by pool?
$RUNE Movement from Crypto.com (THORChain Bounty)
Jun 16, 2022 - Q104. Show the in + outflow from crypto.com to native wallets over time. Are there any trends?
Untitled BoardDER
Sep 9, 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?
Solanart vs X2Y2
Sep 25, 2022 - Compare Solanart in Solana vs X2Y2 in Ethereum marketplaces (the 2 marketplaces with custom royalty fees) in some metrics of your choice during the past 2 months. note any important findings.
NFDomains (Algorand Bounty)
Jun 19, 2022 - Q107. NFDomains are .ALGO domains NFTs that have launched on Algorand. Lets look how many domains NFDomains have sold -Look at number of NFDomains have sold by day and how much revenue they have generated for NFDomains? -Look at how many wallets have bought an NFDomain by day. -Show the distribution of the number of NFDomains purchased by wallet. -Show the distribution of the amount of ALGOs spent on NFDomains purchased by wallet. -What are the top 10 biggest NFDomain sales? -Note any other interesting insights such as fees generated from secondary sales or average purchase price of an NFDomain sale.
Untitled BoardDEST
Sep 10, 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?
wETH Deposit Rate (Osmosis Bounty)
Jun 14, 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).
Voting Activity (Lil Nouns Bounty)
Jun 16, 2022 - Q1. The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.
Untitled BoardMNG
Oct 13, 2022 - What has been happening in the Solana defi ecosystem since the Mango Markets Hack? Has activity increased? Decreased? Are users flocking to any particular defi apps? Are they leaving the ecosystem? Chart flows in and out of centralized exchanges from the Solana ecosystem. Has staking behavior changed on Solana since the hack? Note any trends or outliers you see in Solana defi.
Active Wallet Addresses (ThorChain Bounty)
Jun 16, 2022 - Q105. We are interested in knowing how many users are currently in the ecosystem. In this case, how many are holding $RUNE in their wallet or have an open LP position. What is this number currently, and how has it trended over time?
Smart Money NFT Traders (Solana Bounty)
Jun 4, 2022 - Which wallets have made the most SOL off NFT mints and NFT trades since the start of the new year? What types of actions have led to being a profitable NFT trader on SOL? Is there a pattern behind their NFT trading strategy and can you define some of these traders as "smart money"? Do you think you need to be a "whale" to do well trading SOL NFTs, or can anyone have success in this market?
Sushi During Volatile Times
May 27, 2022 - How did the recent spike in market volatility affect the overall activity of sushi on ethereum? Analyze both swaps and lendings?
Sushi Treasury
Jun 26, 2022 - Q97. What are the in-flows and outflows from sushi treasury? Analyze the trends. Build a dashboard. Hint: Treasury: 0xe94b5eec1fa96ceecbd33ef5baa8d00e4493f4f3 Operations multisig: 0x19b3eb3af5d93b77a5619b047de0eed7115a19e7 Sushi house: 0x7b18913D945242A9c313573E6c99064cd940c6aF
Untitled BoardOPA
Sep 24, 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.
Untitled BoardNFTC
Sep 13, 2022 - Time to do some NFT analysis. 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 vs L1s
May 26, 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?
Distinct Wallets (zkSync)
Jun 15, 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.
Untitled BoardMESEEV
Sep 28, 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.
ERC20 Tokens (zkSync)
Jun 16, 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.
Friktion Liquidity (Solana Bounty)
Jun 4, 2022 - Friktion now has many different Volt offerings for all types of market conditions (bear, bull, crab). How is liquidity flowing into and out of their different Volt offerings? Create a chart highlighting incoming / outgoing liquidity as well as liquidity flowing from one pool to another. How have market conditions and new offerings changed how users have handled liquidity on Friktion? How do you think user behavior will change when we get into a bull market?
Rand Gallery Wallets
May 20, 2022 - Q77. Let’s look at wallets that buy from Rand Gallery to get a better understanding of purchasing behavior. How many wallets are buying NFTs on rand gallery. What is the total number of unique wallets that have purchased from rand gallery? Create a distribution plot of how many NFTs each wallet has purchased from Rand Gallery Are we seeing new wallets purchasing on Rand Gallery or is it only wallets that have purchased from Rand Gallery before? Chart the first purchase on Rand Gallery by wallet over time. Create a table of the top 10 wallets that are purchasing from rand gallery by ALGOs and number of NFTs
Liquid Staking ETH Platforms Analysis
Aug 31, 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
Untitled BoardPOOVA
Sep 16, 2022 - Q118. Who are the unique new entities that are participating in pooled validators that did not participate in classic validators?
HODL or Sell? (Lido Bounty)
Jun 13, 2022 - 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?
Uniswap Phishing Attack on July 2022
Oct 3, 2022 - On July 2022, there was a phishing attack on Uniswap using a fake airdrop announcement. Describe anything interesting about this attack and its victims.
Optimistic Bears
Aug 6, 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?