nsa2000
Average Optimism Portfolio (redux)
Nov 10, 2022 - What does the average Optimism user's portfolio look like and how has that changed over time? What % of a user's activity (in OP terms) is staked, unstaked, in liquidity pools/farms, in NFTs? How has this trend changed over time?
ETH Down Bad [Ethereum]
Nov 23, 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?
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?
DEX Change [Osmosis]
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?
Ailing Alameda [Ethereum]
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.
FLOW Speed (redux)
Dec 12, 2022 - Flow is fast, but how fast? 6 months ago, we asked for a comparative analysis on blockchain speed - how has Flow increased its speed in transaction per minute since? Compare Flow and other L1 blockchains in terms of speed: identify the monthly average for transactions per minute, and how that's improved or worsened since the beginning of 2022. What types of events have raised or decreased the blockchain's performance over that time period? Are there bursts of transaction volume or interest on the chain? Compare Flow's speed to at least two other blockchains. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
What's Going on with FTX?
Nov 10, 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!
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.
What's Going On With Gnosis?
Oct 16, 2022 - There’s been some unusual activity with Gnosis as pointed out by our community. Time to figure out exactly what’s going on. Take a deep dive into recent activity on Gnosis, especially recent rapid rises in the number of active users, transactions, and more. Make any hypothesis you can about what is driving this activity. Is there a new dapp that launched? Is there some incentive program going on? Or is the spike in users/txns due to some sybil attack? Note any trends or outliers you see.
The Battle of the Solana NFT Aggregator
Oct 31, 2022 - Hyperspace and Coral Cube are the two most popular NFT aggregators on Solana. This means that they list all NFTs across different marketplaces along with allowing listings on their own marketplace. Create a dashboard comparing KPIs between Hyperspace and Coral Cube. Which marketplace has done more volume? Which collections are popular on each marketplace? Why would I use one marketplace over the other? Are there any noticeable market trends between the marketplaces, especially after Solana marketplaces moved to a 0% creator royalty?
Pool of The Week [Osmosis]
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!
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). BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
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? Note any trends or outliers you see in Solana defi.
NEAR Gas Guzzlers
Jul 27, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month?
Osmosis Governance: 362 and Beyond
Nov 24, 2022 - Governance in the Cosmos ecosystem has been a hot topic of late - first with Cosmos Hub 82 and now in Osmosis. Osmosis Prop 362 is a vote to decide the fate of the Osmosis Grants Program (OGP). Contention aside, there have been many points and counterpoints, AND a ton of vote switching. Let's take a look at the governance behavior surrounding Proposal 362. On the outside, it seems that a ton of voters have been switching their votes - is this actually true, or is it just big whales/validators causing these swings? What is the average wallet size (in OSMO) of the people voting? Of the people who have changed their vote more than once? Compare and contrast voting behavior of validators and average users in this context. Further, is Prop 362 significantly different than other proposals from an engagement perspective? Analyze voting for 362 vs. other recent governance proposals. BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Liquidity Pools - Wallet Composition [Osmosis]
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?
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.
$MATIC Staking
Sep 19, 2022 - How many $MATIC have been staked since July 1, 2022? What is the staking ratio of $MATIC (amount of $MATIC staked vs circulating $MATIC) during the same time frame? Has it changed or are there any visible trends? What is the daily amount of $MATIC being staked and unstaked?
Binance Bonanza
Nov 3, 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.
Flash Bounty: Miners Moving?
Sep 17, 2022 - How have miners reacted to the fast-approaching merge? Have they stopped mining in recent weeks? Show evidence of miners either stopping work or continuing to mine.
Cosmoverse Free Play [Osmosis]
Oct 13, 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.
Who's Got The Flow?
Nov 29, 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!
[Optimism] Velodrome Health (Redux)
Nov 16, 2022 - Create at least 5 metrics on Velodrome with a description for each that showcase traction and success in a data-driven manner. Most importantly, your insights should help our readers answer the question "How healthy is this project?"
Open Analytics Vol. II: Environmental Impact Study [NEAR]
Oct 6, 2022 - Recently, we analyzed SWEAT - one of the premier projects on NEAR. Do a deep dive into another project on NEAR and analyze its impact, defining metrics for “impact” and displaying them with data. What contributions is your chosen project making to NEAR? You don’t need to choose one of the biggest or most impactful projects - and your research can include qualitative assessment as well. A brief overview of your chosen project will suffice; focus your power on answering the question: "What impact is this project having on NEAR? How much is it contributing, and how do you know?
Just Keep Swimming
Jul 27, 2022 - Swim Protocol provides a simple way to transfer tokens across chains via multi-token liquidity pools. It is built on top of one of the most infamous bridges, Wormhole, which allows users to more seamlessly transfer assets across multiple blockchains Create a dashboard for Swim on Solana including at least the following metrics (add anything else you find interesting): Total Volumes Total unique users Most popular destinations from Solana Most popular stablecoins and non-stablecoins traded over time
Sushi vs Uni on L2 [Sushiswap]
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.
Decentralization Post Merge [Ethereum]
Nov 10, 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.
Axelar Fee Generation
Dec 10, 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?
[Optimism] Inflows and Outflows (redux)
Nov 3, 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.
BAYC and Ape Staking [Ethereum]
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.
Flash Bounty: LUNA Head [Ethereum]
Oct 7, 2022 - What's going on with LUNA, aka LUNA 2.0? Is there any unusual activity? Major whales buying or selling? What dApps are people using?
NFL ALL (THANKSGIVING) DAY
Dec 6, 2022 - The NFL's annual Thanksgiving games recently drove record viewership in the U.S., with 42 million people tuning in to see the Giants take on the Cowboys. Did FLOW NFT project NFL ALL DAY see similar boosts in popularity? Create a dashboard that analyzes NFL ALL DAY NFT activity over the past week, and compares it to activity over the past year. Include at least these metrics, along with any others you find notable or interesting: Sales volume (daily) Total Sales Volume Daily Average Sales Price and 7-day moving average Total Unique Buyers Average Buyers/Day BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Flash Bounty: Art Gobblers [Ethereum]
Nov 3, 2022 - Art Gobblers is a pre-reveal NFT project that generates "goo" when you feed it (upload) art you've created. Some say the project is revitalizing NFTs in the bear market - Compare various metrics across NFT activity to support or oppose that idea. Then evaluate how the project's metrics stack up to other top NFT collections before their art reveals. Create a dashboard that shows off stats for Art Gobblers NFTs, and compare it to other top collections. Include at least these metrics, along with any others you find notable or interesting: Mint volume Total and Average Sales Volume Secondary Sales vs Mint sales Daily Average Sales Price and 7-day moving average Floor price % of Gobblers Listed Total Unique Buyers Social Mentions/Shares Any available metrics on GOO token and art uploads Broader activity in the NFT space
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?
Cosmos & Delegation
Dec 14, 2022 - Let's explore movement of delegation on Cosmos. When delegators un-stake from one validator and move to another, is there any pattern to where they re-stake? Are users more likely to re-delegate after their validator votes in a way they disagree with? Do they re-align their stake with validators whose values reflect their own? How do validator votes change over the course of a proposal? Share any interesting voting statistics you find. Examine any voting propositions here (example: Prop 82) as a use case to explore these questions. BONUS: share your work on Twitter, tag @flipsidecrypto or any other delegates you mention in your analysis
The Great Solana Royalty Debate
Nov 7, 2022 - The most controversial topic on Solana over the past month has been NFT royalties. After platforms like Yawww and Solanart moved to 0% creator royalties, and eventually Magic Eden followed, the market has been in a chaotic state. Magic Eden had cited that almost all funds for a project are coming from the mint, not royalties: https://twitter.com/MagicEden/status/1580367439824826368 Is this accurate, or a misrepresentation of how successful NFT projects have been operating? What projects have been more reliant on NFT royalties than others? What collections were wallets pivoting towards using 0% royalties more frequently? Higher royalty percentages? Higher floor volumes? Are flowing royalties a sign of project health and sustainability? How much volume from 0% royalty sales can be accounted for by wash trading rather than actual user interest? Was this actual user demand, or were decisions made based on inflated data? Compare the rise of 0% royalty market behavior on Solana to on Ethereum. Are users less likely to pay royalties on Solana?
ETH Derivatives
Sep 13, 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?
Daily Active User [Osmosis]
Oct 18, 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?
ALGO NFT Tooling
Nov 12, 2022 - 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!
Pooly NFTs
Jun 22, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
Ecosystem Entrances [Axelar]
Oct 29, 2022 - Axelar recently launched its native token, AXL, and we're celebrating with some bounties! Welcome to Axelar! What better to way to get used to Axelar data than to analyze how people enter the ecosystem? With that in mind, analyze the activity that occurs on Axelar's Satellite Bridge. Since inception, what are the top paths over Satellite. by volume and $ amount? What is the most used token to transfer (USDC, wETH, wAXL, etc.)?