Tracking Realms DAOs
Aug 16, 2022 - We now have Solana Realms governace data! Their team would love to be able to see a list of DAOs / multisigs built on SPL Governance, and understand their: - Number of Members (assuming unique voters is what he means here) - Total Votes - Number of Proposals - Date of Last Proposal - Date of Creation Track these metrics and any other metrics that you find interesting for the following DAOs: Mango-Grape-Psy Finance-Solend-MonkeDAO-Metaplex-Jet-Serum-The Imperium of Rain-Synthetify
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!
What's going on with Avalanche?
Nov 30, 2022 - What's going on with Avalanche? 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 is fair game; The goal here is to explore the data in creative ways and show off your explorations with visualizations (or even a tool/frontend if you’ve got eyes on the grand prize). Good luck! BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Stablecoin Pegs
May 13, 2022 - I compared 7 USD-pegged stablecoins from different blockchains over a 5-day period in terms of price (peg stability), volume and number of transactions.
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.
Seedclub Members
Mar 13, 2022 - Here we intend to address 2 questions; first, How many members have joined the Seedclub? And How many projects have successfully launched and received their CLUB tokens? The first thing I did was research the main site seedclub.xyz and get information from it.
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? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
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!
Solana Staking Madness
Nov 14, 2022 - How has staking pool behavior on Solana responded to recent events? Analyze Flipside's new staking pools data to analyze staking behavior in the Solana ecosystem over the past week. How are stakers responding to recent events? Have there been any notable inflows or outflows to staking pools? What staking pools have seen the most notable behavior? Can you link any staking behavior to other defi activity or other accounts on Solana? Note any trends or outliers you see.
Ultimate On-Chain Exchange Dashboard
Nov 19, 2022 - We’ve launched our new Algorand database and now it’s time to dive into the new DEFI tables. The challenge here is to build the Ultimate On-chain Exchange Dashboard that will keep Algorand ecosystem users informed about the exchanges in the algorand ecosystem and allow them to compare their options.
What makes a Top Shots moment valuable? (Part I)
Jul 25, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume. This week, focus specifically on the play_type column in the flow.core.dim_topshot_metadata table. What play_types do users hold most, and how much volume in sales do these play_types generate? Include any other transactional metrics you can think of.
The Unstakeeeeers
Jul 20, 2022 - How frequently do users on Osmosis unstake their Osmosis? What do they do with the OSMO once unstaked? Do they re-delegate, enter a LP position, or swap into another token? Do they re-delegate to certain validators more frequently than others? Why might this be so?
Transactions by Protocol
Jul 14, 2022 - Using the following App ID lists from Folks Finance, AlgoFi, Tinyman, and AlgoDex, lets look at what percent of transactions their app calls and associated transactions(transactions in the same tx_group_id) make up on the Algorand blockchain. How have the number of transactions changed over time for each Protocol? Also how much in fees have been spent on transactions relating to each protocol? Other things that can be explored are what type of transactions are each protocol producing, or has the price of ALGO been an influence on the number of transactions produced by each protocol.
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!
Binance Bonanza
Nov 2, 2022 - On October 28th, 2022 Binance became the first CEX to list spot trading for $OSMO. Abruptly, OSMO price shot up around 32%. How did this news impact trading on Osmosis. Analyze OSMO trading activity on October 28th and this past week vs. daily & weekly averages. This analysis should occur against two time periods: the 60-day averages & the 60-days prior to the May Terra collapse. Did any other tokens see a spike in trading on Osmosis? Further, can you trace OSMO liquidity flowing into Binance in the last few days? Centralized exchange listings of OSMO are permissionless so liquidity on Binance should be funded through purchases on Osmosis. Note: given this question is being released BEFORE the week of analysis in question please structure your queries accordingly to capture the data that will be populated in the future. Please create dynamically updated queries. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Anchor Scavenger Hunt (Farsi)
Jan 28, 2022 - مقداری ust واریز شد به پروتکل آنکر و برای گرفتن سود 19.5 تا 20 درصد
Kujira Scavenger Hunt (Farsi) (April 8)
Apr 8, 2022 - ما در این هانت یاد گرفتیم که ust را به kuji سواپ کنیم و آن را برای کسب سود استیک کنیم. و در آخر یک bid روی bLuna بزاریم.
Optimism DEXs (redux)
Oct 26, 2022 - Let’s take a closer look at DEXs on Optimism. Make a dashboard that compares at least three DEXs based on: Total number of swaps by day over the last month, Total number of wallets swapping by day, What are the most popular asset pairs to swap from and too, Top 10 assets swapping from, Top 10 assets to swap to BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Axelar Fee Generation
Dec 8, 2022 - Axelar currently generates fees in $axlUSDC for all transfers via Satellite. Map out these fee streams. How much total $axlUSDC has been generated via Satellite. What origin chains have generated the most fees? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
BAYC and Ape Staking
Dec 7, 2022 - In light of the Bored Ape Yacht Club's introduction of Staking, provide an analysis on the token and project. 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. BONUS: Show the BAYC community what you’ve uncovered. Share your dashboard and tag @BoredApeYC and @flipside on Twitter.
FLOW NFT Ecosystem - Market depth
Sep 25, 2022 - Happy Flow NFT Day! As part of today’s celebration of FLOW NFTs, we want you to dive deep into the ecosystem. Treat this as an open analytics bounty specifically focusing on the FLOW ecosystem. Open Analytics (OA) bounties are bounties without specific prompts, 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!
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.
ETH Down Bad
Nov 24, 2022 - The price of Ethereum has sank in recent days - how does it compare to other tokens amid a general market downturn? Can you find evidence of any potential causes for ETH's struggle? Are there any other indicators that could help us predict whether/when it could recover? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Flipside's World Cup of Bounties Side Quest: Fifa+ Collect Collection Scorecard
Nov 16, 2022 - Flipside is holding a bounty tournament to celebrate the arrival of the World Cup — plus a weekly side quest bounty open each week to anyone, even those who arent participating in the tournament. For this week's side quest, the World Cup right around the corner help Fifa+ Collect(https://collect.fifa.com/drops) collectors understand how good their collection is by creating a rating system. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Cosmoverse Free Play
Oct 12, 2022 - Cosmoverse was full of amazing announcements and alpha leaks. Analyze your favorite token’s LP & trading activity on Osmosis over the past week. Please provide volume and user growth metrics into this analysis and focus on deep insights on ONE token. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
axlUSDC: Soon to be forgotten?
Nov 4, 2022 - Recently, Circle announced the implementation of an IBC-native USDC, inserting itself into an ecosystem where axlUSDC currently dominates. Let's look at how pervasive axlUSDC is within IBC. Track Satellite bridge activity strictly related to axlUSDC transfer. Which app-chains have the most/least flows of axlUSDC? Looking at Osmosis specifically, analyze how dominant axlUSDC has become compared to both ATOM and other USDC assets in trading and pools. Hint: You will need to analyze both Axelar tables and Osmosis tables for the second half of this question. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
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!
Mars Protocol Lockdrop Scavenger Hunt
Mar 4, 2022 - In this hunt we learned about the Mars Protocol. Creating liquidity in the MARS-UST pool is the training of this hunt.
ALGO NFT Tooling
Nov 13, 2022 - Using the new Algorand.NFT schema in your build, create a dashboard or tool that helps Algorand NFT traders learn about the ecosystem. We’ve launched our new Algorand database. Now let’s build some tools for the ecosystem! We’ve launched our new Algorand database. Now let’s build some tools for the ecosystem! Using the new Algorand.NFT schema in your build, create a dashboard or tool that helps Algorand NFT traders learn about the ecosystem. Get creative, the sky's the limit! Docs https://docs.flipsidecrypto.com/our-data/tables/algorand-tables/algorand-base-tables
Flash Bounty: Post Merge Behavior
Sep 25, 2022 - The merge has occurred. How have users responded in days that followed? Analyze any notable trends or outliers you can see since ETH switched to POS. Compare this to user behavior in the days and weeks leading up. What major changes can you see?
Sushiswap Bentobox Scavenger Hunt (Farsi)
Mar 25, 2022 - در این هانت کار کردن با limit orders را در اکوسیستم Bentobox بروی Sushiswap یاد گرفتیم.
User Segmentation Analysis
Jan 3, 2023 - Last week we analyzed how users join pools, single or double-sided, which showed that most users join two-sided. This means that most users are already engaged within the Osmosis ecosystem. Let's analyze a typical user journey through Osmosis. Analyze the following: The most common ways of entering Osmosis (Axelar (Satellite) or elsewhere). The most common asset transferred into Osmosis for first transfer. Stay or leave: What do wallets do when they first come to Osmosis? Join to swap and then transfer that asset out? Join to stake OSMO? Join to swap and then LP? Which assets are most commonly swapped for and transferred out? Which assets are most commonly swapped for and then LP'd? Calculate the above from both a volume and # of user standpoint. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Swap Fees
Jun 28, 2022 - Do fees on Osmosis differ when users swap to or from different tokens? On average, which tokens have the highest and lowest swap fees on Osmosis?
TVL Sushi vs. Uni
Feb 17, 2022 - As you can see, Total Value Locked (TVL) amount locked on Uniswap is about 14 times that of Sushiswap over the past 3 months. (90 days daily)
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.
Who's Got The Flow?
Nov 28, 2022 - Who is holding the most FLOW? Build a list of rankings to help us find the address with the most FLOW tokens. Identify any trends or outliers you see in this collection of whales. Bonus points if you can identify the wallet holders. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Opensea Fees
Aug 1, 2022 - Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
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!
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.