hesam
FLOW User Retention vs Other Chains
Dec 19, 2022 - How sticky are the users on Flow? Create a detailed analysis comparing user retention on Flow vs. other L1 chains like Ethereum and Solana. How often do users who make a transaction come back and make another transaction one month later? How do monthly active users compare between chains? Bonus: add a section of your analysis comparing retention specifically with regard to NFT purchases. How often do users who purchase an NFT come back and make another purchase one month later? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Tornado Cash Addresses
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). Using those addresses: - Which of the Tornado Cash addresses received the most # of transactions in the last month, quarter, year - Which addresses received the most transaction volume (worth) in the last month, quarter, year - Over all the addresses, group the transactions into buckets by value.
Sushi vs Uni on L2
Oct 16, 2022 - Compare the market share of Sushiswap and Uniswap on the following L2 chains. Polygon, Arbitrum, Optimism. Use measures such as number of trade or number of swaps, etc. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
USDC Deposits
Jun 22, 2022 - In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? Whatβs the average deposit amount per user?
What's Going on with FTX?
Nov 9, 2022 - It's been a hectic few days in crypto β especially when it comes to FTX. Show us what's been going on on-chain by analyzing relevant data and presenting it in an original dashboard. 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 under this heading is fair game; The goal here is to explore the data in creative ways and use it to show what has been happening in recent days. Good luck!
Quixotic NFT Dashboard
Aug 4, 2022 - Create a secondary market dashboard for NFT sales on Quixotic, the largest NFT marketplace on Optimism! Include any data you think is relevant in our Optimism tables and tell us the most interesting trends you can find with the secondary NFT market.
Optimism Bridge Analysis
Oct 23, 2022 - Describe activity across Optimism bridges. Where are assets coming from, where are they going, and how are they used? How does activity on custom bridges compare to the standard Optimism bridge? Include any other questions or insights you find interesting. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto, @OptimismFND, and any relevant accounts!
Bridge Users (Hop Protocol)
Jun 22, 2022 - In this dashboard, we completely analyzed the Hop Protocol. How many users have bridged to L2 through this protocol or how many days the volume of this protocol has gone above normal. I also compared how tokens were distributed and their popularity and Layer 2 networks.
Total Value Locked
Jun 30, 2022 - What is the total value locked in the Opyn Squeeth (osQETH) contract? And where does osqeth draw its value from?
Most Common Transactions
Jun 25, 2022 - 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.
Pool of The Week
Dec 8, 2022 - Since the start of November, the Osmosis Support Labs team has run the Pool of the Week program, highlighting important and/or new pools within the ecosystem. What kind of impact has this program had on the liquidity of these pools? Track LP volume in and out of these pools based on the following dates: 11/11/22 Pool 833 - stOSMO / OSMO. 11/15/22 Pool 837 - IST / OSMO. 11/22/22 Pool 840 - BNB / OSMO. 11/29/22 Pool 634 - wETH.grv / OSMO. For each pool track from date above to present. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
DEX Change
Nov 17, 2022 - This week has highlighted the need for transparency & decentralization in crypto markets. Let's see how users have reacted to this wild week in Web3. Have behaviors changed? Analyze growth in Osmosis Volumes & User Count this week. Has more money flowed into Osmosis this week compared to the past few weeks/months? Where is this money coming from? Centralized Exchanges? Have wallets moved more into stables? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
ETH Merge: Actually Good?
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.
Flash Bounty: GMX Protocol Overview
Sep 18, 2022 - GMX, a perp protocol, has been attracting attention recently for the massive fee revenue being generated. Examine and compare the protocol over recent days and weeks on Arbitrum. How has the protocol been performing over the past month? Three months? How is it absorbing these massive fees? Note any overarching themes or narratives that you find.
Who's Escaping FTX?
Nov 16, 2022 - Who's managing to escape from the FTX debacle mostly unscathed? Create a single chart showing trading volume on dydx, gmx, and gns to show how people are exiting ftx and entering margin trading dapps. Are they off-boarding through any other methods? Are any particular exchanges, chains, or dapps seeing large increases in new users or trading volume? Note any trends or outliers you see. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Decentralization Post Merge
Nov 9, 2022 - Ethereum recently switched to using a Proof-of-stake (PoS) consensus protocol. For more information on this switch, please see The Ethereum Organization.A new schema (`ethereum.beacon_chain`) was just released containing data around the Consensus Layer that can be used to analyze the Beacon Chain. Documentation for these tables can be found here. Using the beacon_chain schema, analyze the decentralization of the PoS network, as well as slashings of proposers and attesters since the Merge. Build a dashboard to summarize your findings / provide ongoing slashing monitoring.
Stable Coins Lent on Kashi
Jun 15, 2022 - In this dashboard, I calculated TVL of Stable coins on kashi pairs across all markets And I showed it on the chart.
Optimistic Bears (Redux)
Nov 9, 2022 - Analyze Optimism during the recent bear as markets were 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? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Bridger Destinations (redux)
Nov 2, 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? How has this changed over the last three months? Last six months? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Inflows and Outflows (redux)
Nov 2, 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. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
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.
Ailing Alameda
Nov 9, 2022 - Analyze what Alameda is experiencing. Rumors over the weekend began swirling that alameda research is on the brink of insolvency. Observe net in and outflows of USD tokens from known Alameda or FTX accounts throughout different chains. Are they going somewhere specifically? Are there any signs of potential insolvency? Note any other interesting trends or events you see. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and anywallets
User Behavior (redux)
Oct 26, 2022 - How is user behavior different on Optimism compared to L1? Specifically, create a comparison between swaps and transactions on ETH mainnet vs Optimism, looking for things like daily swap volume, daily active users, and average volume swapped (use a single DEX for your comparison, either Uniswap or Sushiswap). L2 is far cheaper, but by how much? What are the average fees for a swap on Optimism compared to ETH Mainnet? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Flash Bounty: SAFE Airdrop Farmers
Sep 13, 2022 - Use your analytical prowess to earn a potential big payout + get some serious spotlight! SafeDAO is currently reworking its SAFE token airdrop in order to include a broader section of their community. However, the DAO wants to ensure those tokens go to the community β not airdrop farmers.
Opensea Fees
Aug 1, 2022 - Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
ETH Flash Bounty: Whatβs Next?
Oct 2, 2022 - The Merge has come and gone β what will be the next story, trend, or outlier to dominate the ETH space? Identify at least 3 developing trends or events that could have a large impact on Ethereum between now and the end of this year. Back up your assertions with data and visualizations.
Gains Network vs GMX
Nov 5, 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!
Axelar Bridge
Nov 25, 2022 - In previous bounties, we have tracked token flows using Satellite. Today, let's take that a step further and plot out user types and their behavior leveraging Axelar's bridge. How often are people using Satellite - one-time transfers into IBC or more consistent/steady streams? Does this vary based on wallet size? Does this vary based on the ecosystem they are bridging from/to? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
ETH Deposited or Withdrawn
Jun 30, 2022 - 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?
Optimism NFT Purchasing Behavior
Oct 18, 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? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Realms vs Snapshot
Aug 31, 2022 - Building off previous recent bounties on Realms and Snapshot, create a dashboard that shows how Realms and Snapshot are growing and used in comparison to one another. Feel free to build off previous bounty work on these platforms. What trends do you see between governance behavior between the two chains? Does a platform seem to capture more market share of its users on their respective chain than the other? What seems to influence voting behavior on each platform? Does one platform have more proposals and voting opportunities than the other? Are whales more powerful on Realms or on Snapshot? How can each platform become more decentralized?
OPtimitic or Pessimistic?
Oct 19, 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? Make your case with Flipside data. Include at least three visualizations in your submission, and note any particularly interesting trend our outliers you see. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
ETH Merge: Selling Event?
Sep 29, 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.
Flow vs Other L1s Pt (II)
Jul 19, 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.
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? BONUS: share this 2022 NFT highlight on Twitter and @Flipsidecrypto and any NFT projects who should see your analysis on their performance this year.
NEAR Meta-Analysis
Sep 14, 2022 - Take a look at the winning submission to our NEAR Tournament, as well as the three runner-up submissions. Craft your own remix to these dashboards, analyzing and summarizing the most important points in a single easy-to-view dashboard, with your own original commentary. You can draw on any dashboards submitted as part of the tournament (including your own), but make sure to give credit to anyone whose work you use!
Not Your Keys
Nov 18, 2022 - In wake of the issues surrounding FTX, the old adage "not your keys, not your crypto" reinforces itself. Let's see how this played out during the fallout. Did bridge activity spike over the last 7 days? If so, to what ecosystems? At a more granular level, track net outflows from FTX onto Ethereum. Did any of these outflows flow across Satellite to another destination chain? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Voting Activity
Jun 20, 2022 - This dashboard contains interesting information. Information such as analyze voting activity on Lil Nouns proposals, List of Top holders and the behavior of small holders.
Which platform is the king of NFT royalties?
Oct 6, 2022 - Which platform is the king of NFT royalties? Compare royalty payouts of 3 NFT marketplaces. Then choose at least 2 additional metrics to evaluate the impact of royalties on NFT market activity. Bonus: Share your findings on Twitter and tag @flipsidecrypto