vivianngdora
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?
Hacks, Scandals and Scams - 3. Whales On Alert
Jul 30, 2022 - Identify active wallets with a high balance of ETH (whales). Visualize the ETH transaction history of these whales in May and June 2022.
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).
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.
Untitled Board
Oct 20, 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?
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.
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
Monthly Swap Volume
May 11, 2022 - Q2. Show the total monthly swap volume on ParaSwap over the past year. How has the swap volume changed over time? Which DEX’s is most of the swap volume coming from?
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).
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.
Arbitrum Governance Participation Data Analysis
Mar 24, 2024 - This dashboard provides comprehensive insights on the performance of Arbitrum Governance Participation over time.
Lido Raindrop Hunt by vivianngdora
Oct 20, 2021 - A brief description and data about Lido Raindrop Hunt.
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.
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?
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.
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)?
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
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?
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?
3. Active Wallet Growth
Jan 29, 2022 - What is the number of unique active wallets (signers) over the past 7 days? Create a visualization showing the number of active wallets per day since the start of 2022. What trends do you see?
Uniswap - 13. UNI token distribution
Mar 25, 2022 - What is the token distribution of UNI for active wallets (i.e. wallets with at least one transaction in the past 90 days? How much is controlled by whales (defined as you want, such as top 100, top 1000, top 1%, etc)? Does this distribution change if inactive wallets are included?
Pooly NFTs
Jun 23, 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?
Volume Market Share
Feb 13, 2022 - Question 41: Show daily transaction volume on Sushiswap as a proportion of the total volume across all of the DEXs over the past 60 days.
Who's That Going Across My Bridge (Redux)
Apr 25, 2022 - Pick one bridge from Terra and a destination of your choice. (e.g. Shuttle bridge Terra <-> Ethereum or Wormhole Terra <-> Solana). Assess the daily and cumulative amount of UST that goes through that bridge, both inflow and outflow. How many users are using the bridge on a daily basis? How many transactions take place on a daily basis?
Sushi rewards distribution
Apr 28, 2022 - Sushi’s “merkle distributor” is the contract that is used to distribute the rewards in SUSHI to eligible users. There was a vesting period of 27 weeks during which the rewards were gradually being assigned to users. But the vesting period finished on Oct 12th 2021 at 7:10 PM EDT. After this time, users should call the “merkle distributor” in order to withdraw their rewards because no more reward is being vested. How much in total has been distributed so far? (A daily chart could help too) How much is left to distribute today? What percentage of eligible addresses have not claimed anything so far? How many eligible addresses have not claimed anything so far? What percentage of the eligible addresses are dead addresses (A dead wallet is a wallet that has not executed any transaction in the last 3 months)
Daily stETH Metrics
Jun 9, 2022 - Q3. Find the following stETH metrics: -Daily volume of stETH? -Average stake size? -Number of stakers over time? -Average time staked? -Staking/unstaking per day?
RUNE bonded + slashed amounts
Jun 13, 2022 - Q103. How much RUNE is bonded, how much RUNE has been slashed from those bonds (total and or over time)?
Tokemak Popularity
Mar 3, 2022 - Tracer Q3: Tokemak is a protocol that allows tracer governance token holders (TCR) to seek further ROI by way of yield farming. What is the popularity of Tokemak among tracer users?
14. [Hard] Revenue Distribution
Dec 24, 2021 - How much revenue has been generated from ENS name registrations since the airdrop? How much revenue has been generated from ENS name renewals since the airdrop? Create at least one visual depicting the relationship between these two revenue streams. How do you expect this dynamic to change over the next two years.
9. [Easy] Claimed Token Distribution
Dec 20, 2021 - What’s the average amount of ENS claimed from the airdrop? Create a histogram that shows claim size distribution.
Uniswap - 14. The DEX Kings of L1
Mar 26, 2022 - Uniswap is the leading DEX on Ethereum. Use the standard metrics to compare Uniswap with similar dominant DEX's in other L1 chains such as Raydium, Terraswap, Tinyman, etc
Profit for AMMs
Apr 13, 2022 - Q63. What is the total profit (in dollars) per day that is generated from swaps out of the liquidity pools in 2022? Do you see a trend? Can you compare sushiswap with Uniswap?
Steady As She Goes
Mar 1, 2022 - A common talking point on Twitter is that LUNA is resistant to broader market downturns, when compared to other leading cryptocurrencies. Assess this claim, using data drawn from a time period of your choosing. In making your argument, acknowledge the unknowns and address potential criticisms of your chosen position. Additionally, clearly define your definition of stability or resistance to broader market pressures, as well as your benchmarks for comparison (i.e. what are you comparing LUNA to, and how does it perform vs. its peers/competitors?)
Head to Head
Mar 31, 2022 - Q172. Excluding the respective foundations, what are the top 10 addresses by amount of UST held? What are the top 10 addresses by amount of DAI held? Do you have any guesses to whom those addresses belong?
Anchor Dominance
Feb 15, 2022 - Question 148: What is the “Anchor dominance” for wallets on Terra? For active Terra wallets*, how much of their total asset value is held in Anchor at the time of analysis?
[25. [Hard] Same-Chain Swaps]
Dec 8, 2021 - In this dashboard, I will calculate the percent of swaps occur on the same chain as well as cross chain.
Bot Activity
May 17, 2022 - Q86. Create a way of identifying bots within THORChain (could be something like a certain number of swaps / day made). What % of the swaps and swap volume are made by bots? Are there certain strategies you can see them employing (most of them are likely arbitrage bots)? Are there many bots or mainly just a few that conduct a high % of bot activity?