marcmonclus
Solana Bounties: Stablecoin Arbitrage on Jupiter
Mar 24, 2022 - Q40. Because Jupiter is a dex aggregator, there are naturally opportunities where one could take advantage of liquidity pairs across the ecosystem to create arbitrage.
Ethereum: Top TOKE Holders
Jun 22, 2022 - Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
StarkWare: ETH Deposited or Withdrawn
Jun 29, 2022 - Q1. StarkNet is a layer 2 chain, that ensures interoperability with the Ethereum mainnet. People are using it to move real ETH to StarkNet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors?
Polygon: Polygon NFT
Jul 16, 2022 - Q3. How popular are NFTs on Polygon? Track daily volume over the past month/year/etc.
THORChain Bounties: $RUNE Movement from Crypto.com
Jun 21, 2022 - Q104. Show the in + outflow from cryto.com to native wallets over time. Are there any trends?
Hot on ETH Week Day 4: Stargate Fishes and Whales
Apr 22, 2022 - 1 billion Stargate tokens were minted at genesis and will be the entire finite supply of STG. Define the terms fish and whale in terms of Stargate token ownership (in your opinion). What proportion of users fall into each of the categories you defined (fish and whale). Note: Use the new ethereum_core data
Solana: Solana Protocol Feature
Jul 13, 2022 - Q97. Choose a defi protocol from the following list and create a dashboard with the new Flipside layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the protocol and what is happening on it.
Optimism: Velodrome Locks
Jul 17, 2022 - Analyze new locks created on Velodrome Finance. Analyze new locks created on Velodrome Finance. What durations are most common? Which wallets have locked the most in the last 4 weeks? Which pools are wallets voting for with their locked tokens most often?
ZK Sync Bounties: 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. 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.
Polygon: Daily Transactions and Unique Addresses
Jul 12, 2022 - Q1. Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022.
Optimism Bridge Bounties: Distinct Wallets (Optimism Bridge)
Jun 17, 2022 - Q1. Many blockchain bridges exist allowing users to move assets between different blockchains. One of the blockchains currently receiving a lot of bridge volume is Optimism. There are several bridges you can use to move tokens to Optimism, but for this bounty we are particularly interested in Optimism’s bridge. How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
Flow Bounties: Trending NFT Projects
Jun 10, 2022 - Q8. Create a visualization showing NFT sales volume on Flow since May 9th. Which NFT projects are trending on Flow right now and what is the general trend of NFT sales over the last month? Do the projects that are trending seem to have common wallets or is there not much crossover between buyers/sellers?
Obol Bounties: Distributed Validator Technology
Apr 13, 2022 - Q1. Explain what Distributed Validator Technology (DSV) through the Obol network is and why it might help with decentralization on Ethereum 2.0 or other Proof-of-Stake chains.
Sushiswap Bounties: Sushi Reward Program for Farmers
May 4, 2022 - How much in total has been distributed so far? How much is left to distribute? What percentage of eligible addresses have not claimed anything so far? What percentage have totally claimed their rewards? What percentage have partially claimed their rewards? What percentage of the eligible addresses are dead addresses (A dead wallet is a wallet that has not executed any transaction in the last 3 months) Hints: Distributors address: 0x1026cbed7b7E851426b959BC69dcC1bf5876512d The table that shows the list of eligible addresses with their total vested rewards as at Oct 22 2021 at 5:47 PM EDT can be found under ethereum_sushi as “distributor_rewards_schedule_Farmers” The reward program started on Sep 24th 2021 the merkle_root for this merkle distributor is '0x015e6c2cd1a4d6fa77aa1884c436b2435aae4beab5c9a091f18fd0c00dc7e577'
THORChain Bounties: Active Wallet Addresses
Jun 21, 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?
Sushiswap: Stablecoins on Kashi
Jul 13, 2022 - Q102. Analyze the behavior of stablecoins on Kashi markets:
Sushiswap Bounties: Swap Volume and Ukraine War
Apr 21, 2022 - Q68. How has the Ukraine war affected the swap volume on Sushi and Uniswap? Has there been a surge in demand for a particular token?
Hot on ETH Week Day 3: Lido Rocket Pool Comparison
Apr 21, 2022 - Q13. Use the ethereum_core tables to compare deposits to Lido and Rocket Pool Hint: rETH contract: https://etherscan.io/token/0xae78736cd615f374d3085123a210448e74fc6393 Lido sETH contract: https://etherscan.io/txs?a=0xae7ab96520de3a18e5e111b5eaab095312d7fe84
Lido Bounties: ETH Staked
Apr 4, 2022 - Q5. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months.
Terra Bounties: LUNA Staking and Trends
May 6, 2022 - Over the past 30/60/90 days and the past year, how much LUNA has been staked per day? What is the staking percentage (LUNA staked/Circulating Supply), and how has it changed over time?
Terra Bounties: State of the State (redux)
Apr 6, 2022 - Many bounties come from Terra clients. This time, Flipside is the client! Review the existing Terra Console for accuracy.
THORChain Bounties: LP-er Retention
Apr 22, 2022 - Take a look at thorchain addresses that have ever added liquidity. Group them by the month of their first date of adding liquidity. What % are still providing liquidity in the THORChain ecosystem? How does it look if you filter those that provided at least $10,000 in liquidity? Hint: use thorchain.liquidity_actions
Terra Bounties: Successful Bids on Kujira
Apr 8, 2022 - Determine the total unique users placing bids on Kujira since its inception. Compare bids on bLUNA vs bETH. What portion of these users are seeing their bids filled?
Solana Bounties: Solana Free Square
Jun 16, 2022 - Q86. This week we want to try something new. We want you to essentially write your own bounty question and answer it yourself. Pick any topic around Solana that you find relevant and interesting and analyze it.
THORChain Bounties: Pool Ranks
Apr 13, 2022 - Q56. Visualize the TVL of each pool over time. Feel free to get creative here. Here’s some chart types to check out if you need some inspiration. https://www.google.com/search?q=multi+line+chart https://www.google.com/search?q=bump+chart We are particularly interested in how TERRA.LUNA and TERRA.UST have fared since making their debut on THORChain.
Optimism: Velodrome Health
Aug 17, 2022 - Q10. Create at least 3 metrics on Velodrome with a description for each that showcase traction and success in a data-driven manner.
Terra Bounties: State of the State (redux)
May 4, 2022 - Many bounties come from Terra clients. This time, Flipside is the client! Review the existing Terra Console for accuracy. Accuracy: Are there any data errors you can identify? Usefulness: Is there anything missing that would be critical for new users to Terra? For Definition, describe the process you used to check the data. For Completeness, make your case for what needs to be included that is currently lacking.
Solana: Network Performance Dashboard
Jul 12, 2022 - Q95. Create a dashboard displaying Solana network performance over time.
Terra Bounties:
Apr 21, 2022 - Q184. Refer to submissions for #175 - your own, or those of others. Pick your favorite Terra metric or visualization and recreate your own version. Your SQL can be similar or even identical to the original, but you should put your own narrative and explanation. Why is this metric/visualization your favorite? If you improved it, what changes did you make? You can also refer to the Dashboards from Question #157 here: https://teamflipside.notion.site/Terra-Dashboards-Powered-by-the-Flipside-Community-defa0c2160694af599beecba089b813d
Ethereum: USDC Deposits
Jun 22, 2022 - Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Flow: NBA Playoff Usage
Jun 28, 2022 - Q.15 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?
Terra Bounties: LUNA & Drawdowns
Apr 8, 2022 - Evaluate the price performance of LUNA following liquidation-inducing drawdowns. What is the average time (days) for LUNA to recover its previous price level. How does this period change relative to the size of the drawdown (in percentage terms)?
Lido Bounties: ETH Staked
Jun 14, 2022 - Q9. What is the total amount of ETH that has been staked with Lido? Show the daily amount of ETH staked with Lido in the past 3 months. Are there any trends you can see?
Solana Bounties: MonkeDAO Whale Voters
Apr 8, 2022 - Q51. Extension off the MonkeDAO question last week: A month ago, the MonkeDAO pressed the Solana Monkey Business team for various changes to be made to the royalty and NFT structure to foster growth for the collection. Ultimately this resulted in the first NFT on-chain vote on Solana to accept or reject the SMB team's proposal, with a 'no' likely resulting in a separation of the two groups. In the end, the MonkeDAO voted to unify with the SMB team and to grow their relationship together. Break down the voting behavior for the first three proposals by the following number of monkes per wallet (1 SMB, 2-3 SMBs, 4+ SMBs). Are there any patterns that you see based on number of SMBs used to vote in a wallet? Why do you think ""whales"" voted the way that they did?
Sushiswap Bounties: Top Kashi Pairs
May 17, 2022 - Q79. Find the top 5 Kashi pairs on Ethereum based on TVL. Choose one that you like and describe the following information: How many people are borrowing on this pair at the moment ? How much collateral has each user added to the pair? How many users have already partially paid their loans? Hint: Borrowing generates a “LogAddCollateral” event Repaying generates a “LogRemoveCollateral” event
Terra Bounties: UST Competitive Advantages
May 4, 2022 - Why would a user choose to transact using UST over DAI (and vice versa)?
stETH/ETH Flash Bounty
Jun 13, 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.
Lido Bounties: Gain or Lose
Jun 15, 2022 - Q10. Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose depending on the peg of stETH to ETH at the time of the swap? Repeat the same analysis for stakers who have swapped stETH to ETH; how much ETH did they gain or lose?
Flow Bounties: Crossover with NBA Top Shot
Jun 13, 2022 - Q9. Which Flow NFT projects appear to have the most crossover of buyers with NBA Top Shot addresses? Is NBA Top Shot an effective onboarding tool in getting users interested into other Flow collections? Does this crossover tend to come from Top Shot "whales", or does the crossover come from average to smaller players? How can Flow projects better attract liquidity from Top Shot players?
Lil Nouns bounties: Voting Activity
Jun 21, 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.