Ali3N
Secrets of the NETH-er World
Mar 1, 2023 - The day that many citizens of the City of Near had been waiting for finally arrived late last year. As of December 19, 2022, NEAR is compatible with MetaMask, marking the first time a non-EVM chain has offered compatibility with the popular ETH wallet. This was made possible by a smart contract called NETH. Now that the contact and ensuing compatibility has been live for nearly three months, it's time to dive deeper into the data.
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.
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.
Hacks, Scandals and Scams - 3. Whales On Alert
Jul 23, 2022 - Identify active wallets with a high balance of ETH (whales). Visualize the ETH transaction history of these whales in May and June 2022.
NFT Wallet Behavior Comparison (Flow Bounty)
Jul 15, 2022 - Create a series of dashboards comparing wallet behavior for buying and selling NFTs on Flow compared to Ethereum and Solana. Is there more or less "whale" activity on Flow compared to each of the other chains? What do "whales" tend to focus on in Flow? How common is "flipping" on Flow (selling within 24 hrs, within a week etc) compared to other chains, or do wallets tend to hold onto their NFTs? Are wallets more interested in new projects, or already existing projects on Flow?
Aave - 2. Borrow Durations
Jul 29, 2022 - How long on average and median do wallets borrow on AAVE? Measure this duration across at least three different tokens. Compare the borrow duration on AAVE with at least one other lending platform like Compound.
Avalanche Swaps vs Transfers (Redux)
Dec 3, 2022 - Lets look at volume of USDC swaps vs transfer by hour since 7/1. What is the average amount of USDC transferred vs swapped? Show number of unique swapper addresses vs transfer addresses by day for USDC Next lets look at mints and burns of pairs involving Lets look at the volume of USDC mints and burns by hour since 7/1 How many unique wallets are minting and burning USDC by day What is the average mint vs burn for USDC by day Note anything else interesting about USDC transactions
Ailing Alameda
Nov 8, 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?
Cat Attack Fighting in Base!
Mar 18, 2023 - An analysis of Cat Attack NFT, the most popular and used contract in the Base network.
Algorand Competitive advantages Algorand NFTs Atomic Transfer Sales
Jun 13, 2022 - Q104. On Algorand there is a functionality called the atomic swap(or atomic transfer) which allows you to safely sell an asset to a buyer without the need of a marketplace. One place to perform this is https://www.randswap.com/. Using https://www.asalytic.app/ and https://www.nftexplorer.app/stats as references let's look at atomic transfer volumes for NFTs in 2022. Show the number of NFT atomic transfers and the ALGO volume for these sales by day in 2022. Further breakdown these atomic transfer sales into ARC3 and ARC69 sales. What were the top ten most expensive atomic transfer sales in 2022? What wallets are participating most in atomic transfer sales-both buying and selling? Tips: User NFTexplorer and asalytics stats as a ALGO volume guide for atomic transfer sales NFT Atomic Transfer Example: https://algoexplorer.io/tx/group/GnJpbxk49DN5FOvmR6tzq9WZ7hTaXMP17ryPmHKKsQk%3D https://www.nftexplorer.app/stats https://www.asalytic.app/ All NFTs have a supply of 1 and 0 decimal places For NFTs configured to the arc69 stanard, look at asset_configuration transactions such as 6Z5R47GSIMQC4JDCTRAPLPC5BTNCC5K5DJ2QKSACW4KV5RZFZDQQ and decode the note using
Velodrome and Quix Activity During FTX & Alameda Collapse!
Nov 13, 2022 - Open analytics bounties are all about deep dive dashboards into one specific topic.
2022 Retrospective
Dec 21, 2022 - Let’s explore some key indicators of the health of the Web3 industry. Project ETH supply growth for 2023 by using various average gas prices. What is the highest value DEX swap, by protocol? Where was there the most DEX swaps by protocol? Which were the highest gas consuming NFT mints?
The Battle of The SG-1 vs GAME Validators on Cosmos Hub!
Dec 11, 2022 - In-Depth comparison of SG-1 vs GAME Validators on Cosmos Hub.
Blur Analysis
Feb 22, 2023 - Recently, Blur launched its native ERC-20 governance token, $BLUR, with a maximum supply of three billion. The token's launch has been eagerly anticipated, with airdrops given to platform users who traded NFTs on Ethereum in the months before Blur's launch and users who listed NFTs on Blur.Why was the airdrop so successful? How did it affect the NFT activity? Did the recipients sell the token?
Tornado Cash Sanctions
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). What is Tornado Cash and why would it be targeted by the US government? Why might an address interact with the service? The addresses tied to the service have been publicly posted online. Using those addresses answer the following: How many addresses are still using the service despite the sanctions? Which addresses have been interacting the most with Tornado Cash? Break the addresses down by frequency and volume of tokens and describe how the groups are using the service differently. Is there anything else interesting about its users?
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.
New NEAR Contract Usage
Mar 17, 2023 - A dynamic tool to analyze newly deployed contracts on NEAR protocol and examine which of the new contracts are gaining more users and expanding the NEAR ecosystem.
Lebron James NFT Dashboard and The Significant Impact of His All-Time Record Breaking
Mar 11, 2023 - An in-depth analysis of Lebron James NFT brand on Flow on the occasion of his all-time record-breaking.
Velodrome Health (Redux)
Nov 12, 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?"
USDC on AVAX vs L2s
Jun 18, 2023 - an in-depth comparison of Circle's USDC usage in Avalanche VS layer2 blockchains (e.g: Arbitrum, Polygon and Optimism)
Everyone Needs a 1-of-1
Jan 21, 2023 - Exchange Art is the leading digital art marketplace on Solana for 1-of-1 art and fine digital art. This category has been rising on Solana as more artists have realized the ease and low costs of launching digital art on Solana. Create a dashboard diving into the key growth metrics of Exchange Art over time. How has the marketplace grown over time and how does that compare to the general NFT growth on Solana? Does it appear that 1-of-1 art is popular among many users on Solana, or is it primarily collected by select individuals? Are most users on Exchange Art whales or art lovers or both? Are there any unique purchasing behavior patterns that you see out of wallets that buy art on Exchange Art? What does the average price look like on Exchange Art and is there more of an appetite for high end pieces? How does the holding period of NFTs bought on Exchange Art compare to that of Magic Eden? Are users truly collecting or are they still interested in short term flipping? What wallets have been most profitable on Exchange Art and what has their strategy been so far?
Flipside's World Cup Kick Off: Gas Guzzlers
Nov 12, 2022 - Welcome to Flipside's World Cup of Bounties. To celebrate the arrival of the FIFA World Cup, we'll be holding a tournament to determine the top bounty hunters in the world across several blockchains, projects, and more. This year's theme is cross-chain comparisons. To qualify for this tournament, create a gas tracking dashboard that looks at gas usage by a chain over the last couple of months. Include Ethereum, Solana, Algorand, Flow, NEAR, Optimism and Osmosis, and add any other chain you think is worth noting. Breakout the following metrics by a chain in the dashboard Total amount USD of gas spent on the chain in the last 30 days. Average cost of gas in USD per $1,000,000 of liquidity transferred on each chain 30 days Average block gas price hourly and daily The top 10 addresses on each chain that spend the most on gas in the past month Daily amount spent on gas by chain tracked over the last 30 days Chart gas spend to network token price
USDC Activity on Optimism During Binance Conversation Announcement and Circle Announcement
Oct 1, 2022 - Analyse the USDC activity on Optimism network during 2 weeks prior to the Binance Conversation Announcenemnt about delisting this token from its platform and converting it to BUSD and also during Circle announcement to launch USDC natively on Optimism.
Merge Staking Providers
Sep 1, 2022 - Choose 1 liquid staking provider (Ankr / Lido / rocketpool, etc) and answer the following question: How much ETH was staked? How many unique depositors are there? What is the avg/median/max/min/distribution of ETH deposits?
Solana Outages
Jun 4, 2022 - Solana experienced another outage on 6/1 where validators were forced to restart the network. The network experienced a similar problem back on 5/1. After the restart happens during these outages, how do users on the network generally respond? Does the price of SOL drop because users lose confidence in the network? Is there more swapping behavior and more stablecoin activity? What protocols seem to have more activity after these types of events that on the average day in the Solana ecosystem? Is there more fear from defi Solana users than NFT enjoyers?
Optimism DEXs
Jul 31, 2022 - Q8. Let’s take a closer look at DEXs on Optimism, specifically Velodrome. Make a dashboard that compares Velodrome to any other Optimism DEX 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
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
Not Your Keys
Nov 15, 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?
Digging Deep into NEAR, Arbitrum & Optimism User Retention
Nov 1, 2023 - This analysis delves into the user retention strategies of three prominent blockchain platforms: NEAR, Arbitrum, and Optimism. We explore how NEAR's "killer apps" - Kaikai and Sweat - have attracted a substantial user base, while major Ethereum Layer 2s, Arbitrum and Optimism, utilized airdrops and liquidity mining programs. The central question we address is: do users tend to depart once incentives disappear, and do they continue engaging with blockchains during non-incentive days?
Open Analytics Bounty: Optimism (October 22) (Tally Ho NFT Collection)
Oct 24, 2022 - A Deep Analysis of Tally Ho NFT Collection On the Occasion of Its Massive Growth During Recent Weeks.
Osmosis Active vs Hyper-Active Users
Feb 9, 2023 - An in-depth comparison of Daily Active vs Hyper-Active users in the Osmosis chain.
LUNC Head
Oct 6, 2022 - What's going on with LUNC, aka LUNA Classic? Is there any unusual activity? Major whales buying, selling, or burning? What dApps are people using? Tell us the story of LUNC using on-chain data. Include at least three visualizations in your analysis.
Optimism + Axelar Bridge Analysis
Mar 11, 2023 - How many unique Ethereum addresses have used both Optimism and 1 or more of the Axelar bridges? How many have used both Optimism and the Ethereum <> Osmosis bridge specifically? Of the group of addresses that have used both Optimism and 1 or more Axelar bridges, how many have used DEXs like Osmosis, Uniswap or Velodrome? How many have provided liquidity (LP) to earn yield on these DEXs?
What's Going on with FTX?
Nov 8, 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.
Governing the Cosmos
Jan 11, 2023 - The bear market is for the builders. Governance is for the action. Throughout the cosmos, ecosystem builders are molding the future of their app chain by actively participating in governance and debating actionable measures. Every chain is different so let's take a peak under the hood and compare governance performance on Osmosis, Cosmos, and Terra chains.
A Surge of Optimism
Dec 16, 2022 - The price of Optimism (OP) fell sharply in early November, dropping from highs above $1.30 on November 6 to as low as $0.79 on November 9. In the weeks since, prices have been on the rise, with OP hit $1.19 on December 14. Analyze the network and diagnose some of the possible reasons for the sudden drop, and slow climb, of OP price in recent weeks. Are there any notable trends in users, transactions, or any other metrics that could explain these events? Note any patterns or outliers you see.
Sushi Revenue (Sushiswap Bounty)
Jun 29, 2022 - Q98. What is the breakdown of revenue by unit for sushi? (swaps, kashi, etc)
Failed Transactions
Sep 29, 2022 - Which user action results in the highest rate of failed transactions? Compare swapping, borrowing, lending, and adding or removing liquidity on Sushiswap-Ethereum.
Opti Ape Yacht Club Analysis
Oct 17, 2022 - During the past week, The NFT Collection OAYC $OP (Opti Ape Yacht Club) had second most sale volume in Quix marketplace on Optimism after the leading project, Early Optimisits. Analyse the activity of sales and trades on this collection and note any interesting trends or notes.
Terradash Part 1: Activity
Dec 5, 2022 - We’re working with Terra to rebuild the great Terradash, a dazzling dashboard full of analytic insights providing an overview of the entire Terra ecosystem— and we need your help! We’ll be building out this new and improved Terradash in parts. First up — examine activity on Terra, both in terms of transactions and wallets.