Cryptopunk Sales and Traders
Aug 31, 2022 - Which 10 wallets are the most successful Cryptopunk traders? Successful could either mean the wallet has accumulated a large balance from sales or has accumulated a large number of Punks. Explain your methodology and findings.
Bug Exploiters
Jun 9, 2022 - What is the list of addresses that were explicitly exploiting the bug by doing multiple join/exits, i.e. who were the attackers? What was the total dollar amount that was taken by the attackers? What amount of stolen assets in the attackers’ wallets remain on Osmosis?
Not Your Keys
Nov 18, 2022 - Did bridge activity spike over the last 7 days? If so, to what ecosystems?
Smart Money NFT Traders
Jun 8, 2022 - Q81. Which wallets have made the most SOL off NFT mints and NFT trades since the start of the new year?
Magic Eden Whales
Apr 9, 2022 - Track the top 20 wallets in terms of sales volume on Magic Eden since March 1st. What have these wallets been buying the most over that time period? As in, which collections seem to have their attention? Do these wallets tend to "sweep" (buy a lot of the same collection at once) or patiently buy collections? How often are these wallets buying NFTs and what does their profit look like?
Across Protocol Airdrop
Nov 30, 2022 - The ACX airdrop took place this week. Create an analysis of the Across protocol bridge volumes, airdrop distribution and TVL. Compare this to any other bridges, like Synapse or Hop.
Bots and success rate
Apr 27, 2022 - Compare the success rate of transactions executed by bots in the past 60 days with average users' transactions in the same time period. Is there any difference and any trends identifiable?
Bridge Volume (Optimism Bridge)
Jun 16, 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?
RaceDay NFTs
Oct 23, 2022 - How does Speedway Motorsports RaceDay NFTs stack up to sports NFT collections in the FLOW ecosystem? What other projects are RaceDay fans buying?
Gain or Lose
Jun 11, 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?
NFT Buying Behavior on Flow
Jun 10, 2022 - Q10. Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to on Ethereum and Solana.
Top TOKE Holders
Jun 22, 2022 - Q1. Identify the top holders of the TOKE token in January 2022, have they kept their position today?
Solana Since The Mango Hack
Oct 17, 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?
Solana Protocol Feature
Jul 14, 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.
Fault Tolerant Staking
Apr 9, 2022 - Define Fault Tolerant Staking (FTS). What are the advantages of FTS? What are the disadvantages? Explain what problems FTS might help solve.
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.
USDC Declining on Solana?
Oct 7, 2022 - What appears to be the cause of this? Where is USDC being removed from the ecosystem and where is it being sent to? Does this trend seem to be driven by a few big whales, or does it seem more broad-based throughout the ecosystem?
BAYC and Ape Staking
Dec 7, 2022 - The ACX airdrop took place this week. Create an analysis of the Across protocol bridge volumes, airdrop distribution and TVL. Provide data on APE token distribution in March 2022 and show how the activity has evolved since. Share analysis on future emissions schedule. How have the first hours of APE staking been? How do the staking rewards for each pool compare? Provide any relevant data.
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.
Liquidity Pools - Wallet Composition
Oct 26, 2022 - What type of wallets provide liquidity on Osmosis? Is liquidity concentrated and owned by a small number of whales? Or, are there a diverse range of participants in the LP ecosystem? Do LP composition change based on TVL of the pools themselves?
Wallet Balances & Ecosystem Growth
Oct 26, 2022 - With the launch of Flipside's new Balances table, let's take a look at how the story of Osmosis can be told through wallet balances. Provide insights into following metrics: How has the ratio of liquid to staked OSMO changed overtime? Are the top 100 OSMO holders the same now as they were at the start of the year? What is the current average OSMO per wallet? How has that value changed over time? Plot average OSMO/wallet against user growth. Do wallets normally hold a majority of OSMO, or another token? How has this changed over time?
Opening Positions
Jun 29, 2022 - Q1. Over the last month, what volume of assets are Mean Finance (Polygon) users opening positions with (selling)? What assets are they dollar-cost averaging into (withdrawing swapped assets)? Note any large positions that don’t make sense on Ethereum due to transaction fees.
Content Bounty: Terra -> Osmosis
May 20, 2022 - Are Terra projects interested in migrating over to Osmosis? What is most important to Terra developers when looking for a chain to migrate to and why might Osmosis be a good choice?
SUSHI Noobs II
Jun 22, 2022 - Q94. What is the first thing new users do when they acquire SUSHI?
Secondary Sales Activity
Jun 21, 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.
Overtime Markets - Profitable Traders
Aug 26, 2022 - Identify the 5 most profitable traders on Overtime Markets in the last two weeks. How much has each wallet won by sport?
Daily Active User
Oct 19, 2022 - What does a Daily Active User look like on Osmosis? First, plot out how many DAUs there are on Osmosis. For this exercise, consider a DAU would be any wallet transacting on Osmosis a majority of days every week. Once you have the DAUs, what does their activity look like? Do they LP more or swap more? How often do they transfer tokens into Osmosis? Where are these transfers coming from?
Decentralization Post Merge
Nov 10, 2022 - Using the beacon_chain schema, analyze the decentralization of the PoS network, as well as slashings of proposers and attesters since the Merge.
Opensea Fees
Aug 1, 2022 - Q6. Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
CowSwap Sushi Activity
Apr 21, 2022 - Q1. Using the Ethereum_core schema, find all transactions that interacted with the CoW settlement contract on ETH Mainnet (0x9008d19f58aabd9ed0d60971565aa8510560ab41) that also used Sushiswap as part of the execution. Why might they have done so?
