Ali3N
What makes a Top Shots moment valuable? (Part II) (clone)
Oct 12, 2022 - The NBA offseason is a season unto itself, with drama, trade rumors, blockbuster moves, and more. Just this year, we saw the Utah Jazz send out two franchise cornerstones in Donovan Mitchell and Rudy Gobert, rumors swirled around the future of Kevin Durant and Kyrie Irving in Brooklyn, and more. How have these rumors and moves impacted player values during the NBA offseason? Do players or teams who are featured heavily in trades, free agent signings, or other news see increases or decreases in sale prices?
Who's Got The Flow?
Nov 25, 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.
True Freeze - 8. FRZ Airdrop Activity After Claim
Aug 4, 2022 - Approximately 230,000 addresses are eligible to claim FRZ. What percentage of all eligible addresses have claimed the airdrop? After claiming their allotment in the FRZ airdrop, what do participants do with their FRZ tokens?
Realms vs Snapshot
Aug 27, 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?
Hacks, Scandals and Scams - 2. Bored Phish
Jul 24, 2022 - This spring the Bored Ape Yacht Club Discord and Instagram accounts were hacked. The hackers sent a phishing link to the community. As a result of this phishing scam, users lost some Bored Apes, Mutant Apes, and other assets. How many NFTs were stolen? What is the total value of all NFTs stolen? Show the percentage of compromised wallets that bought back more NFTs from the same collection that was stolen.
Osmosis Prop #466
Mar 22, 2023 - Osmosis Prop #466 was the first ever expedited vote on Osmosis. An expedited governance proposal must exceed 66.6% quorum within the first 24 hours of the voting period in order to succeed.
Exchange Flows in the Bear (Ethereum)
Aug 13, 2022 - Let's understand whether the bear market and recent issues with CeFi products have changed centralized exchange users' behavior. Explore trends in exchange withdrawal (specifically, moving money from CEX addresses onto the chain) patterns over the last 6 months. Have those withdrawals increased? Has the typical size of them changed? Most important: are people creating new wallets to take custody of their CeFi deposits?Also have a look at what people do after a withdrawal: are they holding their withdrawn tokens? Or are they fiat-on-ramping so they can swap, provide liquidity, buy NFTs, etc.hint: find centralized exchange addresses in [chainname].core.dim_labels where label_type = 'cex' and label_subtype = 'hot_wallet' other hint: feel free to include a couple of major chains for this analysis, but certainly at least include Ethereum
USDC Depegging Crisis After SVB Bankruptcy
Mar 12, 2023 - What's going on with USDC on the Ethereum chain after the Circle announcement and Silicon Valley Bankruptcy?
Active Wallets on Terra
Apr 29, 2022 - Hello and welcome! in this submission, I am going to define "Active Wallet" on Terra's Ecosystem (in my opinion) furthermore, display the active wallets on terra by day, month, and YTD in 2022
Superfluid Staking on Osmosis in 2023
Feb 1, 2023 - There are 19 SuperFluid Staking pools currently available on Osmosis (1, 678, 704, 712, 674, 722, 9, 604, 497, 812, 584, 3, 481, 42, 463, 15, 840, 789, 605) Let's take a deep dive into Osmosis superfluid staking on these pools since the start of the year 2023.
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. How many tx in the 0.01-0.1 ETH range went to Tornado? How many in the 0.1-1ETH range? How many in the 1-10ETH range? How many in the 10-100 ETH range? How many above 100 ETH? (split further if better)
User Behavior (redux)
Oct 21, 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?
Camelot Exchange & $GRAIL Token Dashboard
Mar 2, 2023 - An overview of Camelot Decentralized Exchange and its native token
Merry Christmas?
Jan 6, 2023 - The holidays and New Year are often chaotic in the crypto and defi space, as users make a spree of new transactions and wallets as they receive (and give) some cash and coins as holiday gifts. How has this activity impacted the broader Ethereum ecosystems? Are users creating new wallets or buying tokens with their newfound holiday wealth? Are they staking all these new tokens once they get them? Or are they selling tokens to pay for their own gifts and holiday travel?
Binance Bonanza (Osmosis)
Oct 29, 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.
Average Optimism Portfolio
Oct 9, 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?
The Flippening Comparison
Jan 13, 2023 - It finally happened. The great Flip everyone’s been waiting for — Optimism and Arbitrum have officially surpassed Ethereum in combined transaction volume. (What, you were expecting some other flippening?) Use this historic event to compare and contrast these two major L2 chains. Include metrics such as total and average transaction volume, average transaction size, active users, new users added, and anything else you find relevant to this comparison.
LUNA Price Run Investigation (Terra)
Jan 12, 2023 - Beginning in the wee hours of Monday, January 9 (ET), the price of LUNA skyrocketed, from $1.37 to a high of nearly $2 before settling down at roughly $1.60. Identify some of the major reasons for this recent upshot in price, and back up your assertions with data. Why did the price jump so suddenly on Monday night? Will prices remain at, or above, current marks in the coming weeks or will it return to at or near $1? Why?
JustBanana NFT Analysis on Optimism
Oct 10, 2022 - JustBanana is an NFT collection on Optimism, Quix Marketplace, which had experienced a massive rise in its activity during recent weeks. Perform a full analysis of this collection's sales and users since July 2022.
Velodrome Health (Optimism)
Aug 13, 2022 - Create at least 3 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 Bounty: ETH (November 13)
Nov 13, 2022 - Open analytics bounties are all about deep dive dashboards into one specific topic.
Solana NFT Championship
Oct 8, 2022 - There’s no shortage of sports-related NFTs on Solana, from Collectorz Club and Suites to Laidback Lions and Aaron Jones’ Showtime collection — but who can lay claim to the title of Solana sports NFT champion? Create a dashboard that shows off the top collections. Include at least these metrics, along with any others you find notable or interesting: Sales volume (daily/weekly/monthly) Total Sales Volume Daily Average Sales Price and 7-day moving average Total Unique Buyers Average Buyers/Day
USDC Deposits (PoolTogether Bounty)
Jun 20, 2022 - In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Polygon Block Performance
Jul 23, 2022 - What is the average time between blocks on Polygon? What was the maximum and minimum recorded time between two blocks? How many transactions are done in a block on average? How do these numbers compare to L1 such as Flow or Solana, or other L2 such as Arbitrum or Optimism?
Solana Phantom/Slope Hack (August 2022)
Feb 24, 2023 - One of my closest friends was a victim of Solana Phantom hack and as a result, he lost more than $1000 money.
USDC Declining on Solana?
Oct 3, 2022 - It looks like over the last few weeks the market cap of USDC on Solana has been declining. 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. Are other stablecoins also dropping in market cap on Solana?
Overtime Markets - Profitable Traders
Aug 19, 2022 - Thales is a protocol that allows for the creation of peer-to-peer parimutuel markets that anyone can join. A Parimutuel Market is a market where the collateral is locked in a pool and the final payout to participants is not determined until after the market-settling event finalizes. There are several types of markets, including Up and Down markets, ranged markets, exotic markets, and Overtime Markets. Overtime markets is a fully on-chain sports AMM with Chainlink sport feeds, allowing users to bet on Soccer, Football, MMA, and Baseball. For this bounty we will be focused on the Overtime volume on Optimism. Single tx example: https://optimistic.etherscan.io/tx/0x2072d57af9eb255993f0307d9713a2518ba7686cee15a47d6af1ba07031fa865 For more information on Thales and Overtime Markets, see https://thalesmarket.io/ & https://overtimemarkets.xyz/#/markets Identify the 5 most profitable traders on Overtime Markets in the last two weeks. How much has each wallet won by sport?
Osmosis Quarterly Performance Report
Apr 14, 2023 - a Q1 2023 Analysis of the Osmosis Ecosystem
Osmosis Validators' Comparison Tool
Jan 13, 2024 - A comprehensive tool empowering you to compare the voting activity of multiple Osmosis validators within the governance framework of this dynamic blockchain.
Hop In the Pool (Osmosis)
Nov 25, 2022 - Analyze how users join pools on Osmosis. Do they dive in headfirst (add both assets; joinpool) or do they wade in carefully (singleside; join swap extern amount in). Also analyze how deep the pool is (typical swap size in token and USD for both activities).
NEAR.Social Dashboard
Mar 1, 2023 - a comprehesive dashboard using the new Flipside's NEAR.social schema in order to document the activity happening on NEAR.Social.
Flipside's World Cup of Bounties Side Quest: Fifa+ Collect Collection Scorecard
Nov 12, 2022 - Use the parameter feature on Flipside to allow users to put in their Fifa+ Collect Wallet address. Show the users collection and the breakdown of the users score Add a cool visualization that provides additional context
Aave - 3. AAVE positions in Euro stablecoins around July 13th.
Jul 27, 2022 - On July 13th, for the first time in 20 years the Euro reached 1:1 parity with the U.S. Dollar. Show daily or hourly positions (supply and borrow) of Euro stablecoins on AAVE before and after July 13th.
Red Bank USDC Repayments
Mar 18, 2023 - Earlier this week Flipside team analyzed how traders leveraged the USDC de-peg to repay loans across decentralized lending platforms. Let's see if similar behavior occurred via Mars' Red Bank.
Bridger Destinations (Polygon Bounty)
Jul 27, 2022 - Q5. Where do people go when they bridge to Polygon from Ethereum? What are the 10 most popular first destinations for Polygon addresses that have just bridged from Ethereum?
Merry $BONK-ing Christmas
Jan 4, 2023 - It's still Christmas for Solana's dog coin $BONK — people all over crypto twitter are giving away billions of $BONK tokens, and its price has risen over 40% in the last day (NFA). Bring the world up to speed on Bonk Inu, with all of our favorite metrics.
MakerDAO Governance Voting
Feb 24, 2023 - a Comprehesive Analysis of Governance Voting in MakerDAO.
New Year, New LUNA?
Jan 6, 2023 - The holidays and New Year are often chaotic in the crypto and DEFI space, as users make a spree of new transactions and wallets as they receive (and give) some cash and coins as holiday gifts. Has this flurry of winter activity impacted the Terra ecosystem? Are users creating new wallets or buying tokens with their newfound holiday wealth? Are they staking all those new tokens once they get them? Or are they selling tokens to pay for their own gifts and holiday travel?