anniecrypto
Outbound Traffic
Mar 16, 2022 - Question 166: The Terra Bridge has expanded its capabilities: https://twitter.com/Speicherx/status/1501883479457288193 Create a dashboard to track the outflows of LUNA and UST to Osmosis, Secret, Axelar, and Injective. What conclusions can you draw from the outflows thus far?
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?
Cryptopunk Sales and Traders
Sep 1, 2022 - Which 10 wallets are the most successful Cryptopunk traders? Successful could either mean the wallet has accumulated a large balance from sales or has accumulated a large number of Punks. Explain your methodology and findings.
Votes, Votes, Votes
Apr 22, 2022 - On average, how much voting power (in Luna) was used to vote for governance proposals? Out of this, how much Luna comes from validators vs regular wallets?
DAI on the Market (May 13)
May 17, 2022 - Q3. Analyze large shifts in the amount of DAI on the market over the past year. What might have caused these shifts? Are these events related to Maker directly? Are they related to the crypto ecosystem as a whole? Provide metrics to support your analysis.
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.
Untitled Board
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.
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
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?
Price + Circulating Supply
Jun 8, 2022 - Q3. Draw a chart showing MATIC’s circulating supply from the start till today. Compare it with MATIC’s price.
Stablecoin Dominance
Jun 29, 2022 - Q20. Compare the transaction volume for USDC, USDT, and DAI on Osmosis. Is there a stable coin that Osmosis users prefer?
LUNA Market Cap
May 10, 2022 - Q201. Back to basics! Display the LUNA price and market cap trend over 30, 60, 90 days; the past year; and all time.
Killer Crossover, Mvmt. I
Feb 24, 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.
Uniswap - 20. Power Users
Apr 2, 2022 - Using data from January 2022, what percentage of swappers were also liquidity providers at some point in January? You may answer using data from any blockchain were Uniswap is available.
Bentobox Stats II
May 12, 2022 - Q76. Answer the following questions about user behaviour on Bentobox. Ideally choose both Ethereum and Polygon.
Bridge Volume (Optimism Bridge)
Jun 18, 2022 - Q2. Compare user bridge volume on the Optimism Native Token Bridge vs. another Mainnet <-> Optimism Bridge of your choosing (e.g. Hop). Can we conclude if there are differences in the types of users or transactions using the native bridge vs. the non-native bridge?
Tracking Realms DAOs
Aug 18, 2022 - Q104. We now have Solana Realms governace data! Their team would love to be able to see a list of DAOs / multisigs built on SPL Governance, and understand their: Number of Members (assuming unique voters is what he means here), Total Votes, Number of Proposals, Date of Last Proposal, Date of Creation Track these metrics and any other metrics that you find interesting for the following DAOs: Mango, Grape, Psy Finance, Solend, MonkeDAO, Metaplex, Jet, Serum, The Imperium of Rain, Synthetify
14. Revenue Distribution
Dec 25, 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.
FLOW Usage During the NBA Playoffs
Jul 13, 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?
Bentobox Stats
May 12, 2022 - "Answer the following questions about Bentobox. Ideally on both ethereum and polygon. - What's the average deposit size per user in 2022? compare with 2021? -What is the average number of coins deposited per user? For this question you can ignore deposits of less than $50 USD."
33. Price Status Quo
Jan 31, 2022 - Does the price of the Sushi token tend to follow the trend of the rest of the market? Does the price follow the trend of the rest of the DEXs? Why or why not might this be?
34. [Easy] The Season of Swapping
Dec 24, 2021 - Which wallet address has performed the most swaps in the last 30 days?
Untitled Board
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.
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.
IL INSURANCE
Apr 11, 2022 - Q54. What % of users that are removing liquidity are receiving IL insurance?
Untitled Board
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?
Overtime Markets - Volume
Aug 25, 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.