vivianngdora
Arbitrum Governance Participation Data Analysis
Mar 24, 2024 - This dashboard provides comprehensive insights on the performance of Arbitrum Governance Participation over time.
Growth of Liquidity Providers
Oct 23, 2023 - Analysis can be done (but not limited to) the size of liquidity provided, the group of LPs who are most dominant volume wise (a lot of small LPs or a few whale LPs), how long do they tend to stay in pools to provide liquidity, how active the Liquidity Providers are and if this has a relation with the size of liquidity provided, impact of a large LP leaving small pool (will others fill the void?), Ethereum vs L2: is there a difference/overlap between LPs on L1 vs L2. For the above questions analyse trends over time and, where possible/relevant, differentiate between the pools (Eth-stables vs stable-stable vs stable-other).
MonkeDAO Validator
Feb 19, 2022 - The MonkeDAO was the first NFT DAO on Solana and also was the first NFT DAO to set up a validator in an effort to help decentralize and secure the network. When a user decides to stake their Solana, they delegate which validator to support with their staked Solana. How many unique wallets since February 1st have decided to delegate their staked Solana to the MonkeDAO validator? Create a visualization showing delegations per day.
LUNA Distribution Mvmt 1: The Basics
Jan 25, 2022 - People who do not like crypto often cite wealth inequality as a reason: they claim that the tokens are concentrated in the hands of a few whales. Assess this claim for LUNA. How much of circulating supply is held by the top 100 addresses? Top 1%? Top 10%?
Liquidity Provider Profitability
Aug 27, 2023 - The introduction of Automated Market Makers (AMMs) has brought numerous advantages. Uniswap, in particular, has gained popularity due to its innovative features like no order books, accessibility, and transparency. A crucial aspect of this ecosystem is Liquidity Providers (LPs), who play a vital role in ensuring smooth trading by maintaining sufficient liquidity in each pool. In this dashboard, we will delve into the world of liquidity providers and their profitability. This dashboard will analyze impermanent loss on Uniswap as a whole, across different pools, and for individual LPs and develop a tool that allows an LP to easily compare their profit/loss with simply holding the assets. Identify pools that might be more or less favourable for LPs and determine if this affects LP behaviour.
Market sentiment on Uniswap
Dec 26, 2023 - Volume, usage, TVL, pretty much all statistics in crypto are influenced by the state of the market at that time. In a bull run the amount of users and their activity rapidly increases while in a bear market everything seems to be really quiet. A few months ago we already analysed what happens and what people do in a bear market (see [Bounty #29 - Crypto winter usage of Uniswap](https://www.notion.so/71a7653da444464b80146b5d6ef60116?pvs=21)). However the crypto landscape is always rapidly changing, where with rumours of crypto ETFs we much just head in the other direction. For this bounty create a market sentiment dashboard. The dashboard can look at past data, and (where and if possible) also be forward looking. Explore historical data in past bull and bear markets, and look for indicators that might offer insights into potential future market trends to show where we might be heading. Furthermore, investigate behaviour of liquidity providers in bull and bear market, and how liquidity levels fluctuate in changing market sentiment. For example does increased volatility lead to more or fewer liquidity providers participating?
New NEAR Users
Sep 6, 2022 - Q9. What actions does a user take when they deposit money into the NEAR ecosystem? Show the most common actions taken by users on NEAR (new users using NEAR for the first time) over the past 3 months.
Opensea Fees
Aug 1, 2022 - Q6. Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
Uniswap - 5. Uniswap on Polygon: Which Bridge to Where?
Mar 18, 2022 - Over the past 30 days, which bridges are users of Uniswap using the most? Which ones are passing the most value?
The Nightmare Scenario
Apr 22, 2022 - Q183. Recently, attacks have been leveled against Terra, suggesting that it is doomed to collapse as UST reaches unsustainable levels. Specifically, concerns have been raised that at a low enough LUNA price, users will no longer be able to redeem $1 of UST for $1 of LUNA.
10. [Hard] New vs. Existing Holders
Dec 20, 2021 - What has grown more since the airdrop, the number of unique wallets creating a domain for the first time, or the number of wallets adding additional domains? What do you expect to grow more over the next 6 months? Provide at least one visualization to support your thesis.
Weighted-Average LP Duration
Apr 29, 2022 - What is the average duration of liquidity held in each pool, weighted by the size of the LP? Hint: use thorchain.liquidity_actions
Lido Raindrop Hunt by vivianngdora
Oct 20, 2021 - A brief description and data about Lido Raindrop Hunt.
What makes a Top Shots moment valuable? (Part I)
Jul 24, 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.
Polygon Block Performance
Jul 27, 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?
NEAR Gas Guzzlers
Jul 28, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month? Hint: The gas units in the table are in raw (not decimal adjusted) format. To adjust accordingly, divide by 10^12.
Overtime Markets - Volume
Aug 24, 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 Analyze the total volume on Overtime Markets over the past two weeks. Which games received the most activity, both in total users and total $ volume? Which sports are receiving the most bets in total dollar volume on a daily basis? Explain your findings.
LUNA Distribution, Mvmt II
Feb 10, 2022 - Question 144: Answer one of the following two questions: What is the distribution of LUNA for active wallets (i.e. wallets with at least one transaction in the past 90 days? What is the distribution of LUNA if wallets that have never transacted are excluded?
Bot Swappers
Apr 28, 2022 - Define bot swappers. How does the behaviour of bots differ from average swappers? For instance in terms of number of swaps, or in terms of distribution of swaps over a day. What percentage of swaps were executed by bots in the past 30 days? What pools and what pairs were most popular among bot swappers in the past 30 days.
Overtime Markets - Profitable Traders
Aug 22, 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?
Market Volatility
May 26, 2022 - Q82. The second week of May saw some huge volatility in the market and prompted many to sell their volatile assets and take a flight to safety.
Seedclub Members
Mar 16, 2022 - Question 1: How many members have joined the Seedclub? And How many projects have successfully launched and received their CLUB tokens?
Holder Behaviors
May 31, 2022 - Q2. Explore the behavior of top 5 LDO holders. Include: * LDO balances and history * Typical actions with LDO
stETH/ETH Fluctuation
Jun 13, 2022 - Analyze the price of stETH in ETH denomination and find meaningful correlations that explain its fluctuation. Possible correlations could be with ETH’s price in USD, ETH’s gas price, volume in the curve pool, Curve stETH/ETH pool composition, etc.
Moonbirds Crossovers
May 5, 2022 - Are there any notable cross overs between the Moon Birds community and other communities? How many holders also have BAYC, Doodles, etc
FLOW Usage During the NBA Playoffs
Jul 12, 2022 - Q19. Analyze the NBA Conference Finals (May 17th- May 29th) and determine whether it had an impact on NBA Top Shot's volume. Did the Warriors, Celtics, Mavericks, or Heat see higher sales volume?
Tracking the Top Saber Lockers
Mar 9, 2022 - Question 33: Building off last week's question - Saber is an automated market maker (AMM) built on Solana that provides cross-chain liquidity for stablecoin pairs such as UST/USDC. Create a time series analysis of Saber locked up over time, noting the start of each epoch. List the top 20 wallets that have locked Saber in the month of February. Have these top wallets added to their locked SBR positions to gain even more voting power, or do they lock all their SBR tokens in governance at once? What other activities are these top 20 wallets doing in the month of February (for example what other tokens are they transacting with, what other protocols are they engaging with)?
34. [Easy] The Season of Swapping
Dec 24, 2021 - Which wallet address has performed the most swaps in the last 30 days? Hint: Use thorchain.swaps
Swap Sizes
Feb 9, 2022 - Question 37: Show the daily average swap size over time for the 10 largest liquidity pools (in terms of value locked). How has this swap size changed over time? Why might this be?
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?
6. [Medium] Failed or not ?
Mar 10, 2022 - Create a visualization about the total transaction daily on harmony blockchain and show the success rate for transactions and compare it with others networks
NEAR Performance
Jul 20, 2022 - Q5. How does NEAR stock up to other L1s in terms of speed and performance? How fast is NEAR, and compare it with other blockchain speeds in terms of transactions per minute and percentage of transactions that fail.
Who's That Going Across My Bridge (Redux)
Apr 22, 2022 - Q186. Pick one bridge from Terra and a destination of your choice. (e.g. Shuttle bridge Terra <-> Ethereum or Wormhole Terra <-> Solana).
Uniswap - 24. Marketing Analytics - Monthly New Users
Apr 8, 2022 - Is Uniswap attracting new users? Using the last twelve months of Ethereum data, visualize the number of monthly new users onboarding to Uniswap.
2. Market Value <> Holders Overtime
Apr 16, 2022 - Does the market value of OlympusDAO correlate with the number of OHM holders?
Staking Yield, Mvmt 1: The Basics
Jan 19, 2022 - Explain how Terra's staking yield is calculated. Provide a graph that compares LUNA staking yield to LUNA price over a time period that you define.
23. [Easy] Swap Size
Dec 6, 2021 - This dashboard will be my answer for the question: What is the average size of each swap on THORChain?
Killer Crossover, Mvmt. I: LUNA/Solana
Feb 23, 2022 - Question 149: Friktion on Solana offers a “covered call” strategy for numerous assets, including LUNA. This strategy’s overall return depends on how often the call options are exercised, i.e. how often LUNA ends up above the strike price of the option. Determine how many weeks during the past month that LUNA’s price has increased more than 15% in a 7-day period. Based on this performance, what insights or implications can you draw about the true profitability of a LUNA covered-call strategy?