mehrancrypto-H2EvNK
January 2022 New Wallets Created
Feb 17, 2022 - In January 2022, we see a surge in new wallets created. Were these new wallets interacting with any assets in particular? Were there any patterns in the amount of Algos these wallets held?
Swapping goBTC and goETH on DEXs
May 21, 2022 - Q72. goETH and goBTC are wrapped forms of ETH and BTC minted by algoMint. Let's look at goBTC and goETH swaps across the DEXs since the beginning of April and get a better understanding of how wallets are swapping goETH and goBTC - especially during the price crash in May. Track the volume and the number of wallets that are buying and selling goETH and goBTC on DEXs. Are more users acquiring goETH and goBTC or are they selling it? How does each DEX compare? Are wallets swapping goBTC and goETH for just ALGO? If not, what other ASAs are wallets swapping goETH and goBTC for? Did the price crash in May impact the number or volume of goBTC and goETH trades? Are there any notable days of trade for goBTC or goETH? What may have caused this? Note anything else interesting you find in your analysis on goBTC and goETH swaps! Tips: goETH asset_id = 386195940 goBTC asset_id = 386192725
Gain or Lose
Jun 15, 2022 - Q10. Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose depending on the peg of stETH to ETH at the time of the swap? Repeat the same analysis for stakers who have swapped stETH to ETH; how much ETH did they gain or lose?
Crossover with NBA Top Shot
Jun 14, 2022 - Q9. Which Flow NFT projects appear to have the most crossover of buyers with NBA Top Shot addresses? Is NBA Top Shot an effective onboarding tool in getting users interested into other Flow collections? Does this crossover tend to come from Top Shot "whales", or does the crossover come from average to smaller players? How can Flow projects better attract liquidity from Top Shot players?
ALGOxNFT Marketplace
May 12, 2022 - ALGOxNFT is one of the quickest growing NFT marketplaces on Algorand. Let’s take a deeper look into ALGOxNFT sales over 2022. Show daily and monthly NFT sale volume in # of sales, ALGOs, and USD over time for 2022. Show how much ALGOxNFT has earned in fees daily and accumulated over time for 2022. -How many NFTs have been sold through AlgoXNFT and what is the total volume in ALGOs of NFT sales. What was the biggest NFT sale in both ALGOs and USD. What was the NFT?
Impermanent Loss; Mainnet vs. Polygon
Jul 21, 2022 - Compare impermanent loss on Sushi pools on Mainnet vs. on Polygon, and create visualizations to illustrate the comparison.
Active Addresses
Jun 5, 2022 - Q4. How many addresses on the MATIC network are active? What’s the daily evolution of active addresses? Is the activeness related some how to the price? Hint: Active address is an address that has done at least one transaction or has received at least once a token in the past 3 months. medium
Polygon vs Harmony
May 31, 2022 - Q1. Draw a chart comparing Polygon with Harmony on the following metrics: Average tx_fee Average number of transactions per hour
Votes, Votes, Votes
Apr 16, 2022 - Q185. On average, how much voting power (in Luna) was used to vote 'YES' for governance proposals? Out of this, how much Luna comes from validators vs regular wallets?
New Wallets from NFTs
Jun 9, 2022 - Q99. Let’s look at the month of May and June to understand if the Algorand NFT scene is onboarding new wallets. For this we want to focus on wallets that have >1 ALGO and look at two different groups all wallets >1 ALGO and wallets created in May and June with >1 ALGO. Also note we only want to look at arc69 NFTs.
NFDomains
Jun 23, 2022 - Q107. NFDomains are .ALGO domains NFTs that have launched on Algorand. Lets look how many domains NFDomains have sold -Look at number of NFDomains have sold by day and how much revenue they have generated for NFDomains? -Look at how many wallets have bought an NFDomain by day. -Show the distribution of the number of NFDomains purchased by wallet. -Show the distribution of the amount of ALGOs spent on NFDomains purchased by wallet. -What are the top 10 biggest NFDomain sales? -Note any other interesting insights such as fees generated from secondary sales or average purchase price of an NFDomain sale.
NEAR Performance
Jul 19, 2022 - 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.
Whale Voters
Feb 17, 2022 - Question: For whale voters, how many of them have voted in at least one Terra/Anchor/Mirror governance vote in the past 90 days? What is the percentage of whales who have voted?
Highest Sales Volume
Jun 14, 2022 - Q1. Which 3 NFT collections have the most total sales volume in the last 60 days on NFTX? These are transactions where someone redeems their NFTX tokens for a specific NFT. Hint: You can find these sales in ez_nft_sales. Visualize your findings.
Sushi on Polygon
Mar 18, 2022 - What are the 10 largest sushi liquidity pools on Polygon? What is their volume and TVL?
UST-LUNA Highway
Apr 20, 2022 - Q182. Over a time period of your choosing, display the following: -daily minted UST and burned LUNA -daily burned UST and minted LUNA What are some trends you can observe for each of the charts above?
Bentobox Stats
May 11, 2022 - Q75. 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.
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). 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?
Uniswap on Polygon Scavenger Hunt
Feb 12, 2022 - Working Experience with Unisawp on Polygon network
StarkWare Scavenger Hunt
Jun 27, 2022 - Familiarity with the StrakWare test network
Transaction Failure
Mar 23, 2022 - Q169. Make reference to this tweet: https://twitter.com/alphaDefi_/status/1504522066674003972/photo/1 Establish the failed transaction rate for Terra over a time period of your choosing. Is this analysis correct? Additionally, make a case for what is causing the failure transaction rate you assess, and provide recommendations to mitigate it.
The Nightmare Scenario
Apr 20, 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. In what circumstances would the price and supply of LUNA and the supply of UST constitute a serious threat to UST redemption, i.e. create an imbalance wherein the UST-LUNA exchange mechanism would no longer function properly? What is the likelihood of such a scenario, and how might it be mitigated?
Active Wallets on Terra
May 3, 2022 - Define "Active Wallets" on Terra. Based on your definition, display the active wallets by day, month, and Year-To-Date in 2022.
The Unstakeeeeers
Jul 18, 2022 - How frequently do users on Osmosis unstake their Osmosis? What do they do with the OSMO once unstaked?
Rug Pull?
May 12, 2022 - Crypto assets can have high volatility. On March 28th 2022, the price of ANIRAND (604643747) dropped when 99% of the liquidity was removed from the ANIRAND/ALGO pool on Tinyman. For reference: https://twitter.com/AlgoScout/status/1508495588148531208 Were there a suspicious number of swaps or volume of swaps or LP burns in that hour? Was there one or a small number of accounts doing the duping? What did the dumpers do with the proceeds? Find others assets/events that follow a similar pattern – Note any interesting findings or events that occurred around this time that would have affected the price Tips: Use the prices_swap table and the swaps table to lead your investigation.
Polygon NFT
Jul 16, 2022 - Q3. How popular are NFTs on Polygon? Track daily volume over the past month/year/etc. How many Polygon users started off with NFTs? Who made the most profit?
Arbitrum Scavenger Hunt: Odyssey Pt. 1
Jun 26, 2022 - Getting started with arbitrum network
Forefront Treasury
Apr 17, 2022 - Q3. Create a visualization showing Forefront's treasury holdings over time. How have they allocated funds over time between FF holdings, USDC holdings and ETH holdings? Has the structure of holdings changed as Forefront has transitioned to "Season 2"? Provide some insight on Forefront's new structure of incentivizing contributions and how the treasury can best be set up to do this. What percentage of payments made by the treasury are in USDC vs FF?
Getting Started With Terra Bounties (March 1)
Mar 2, 2022 - Learn how to explore Terra data by finding specific transactions, grouping them, and visualizing them over time. Publish your results and submit them to win your first Terra bounty! For this bounty, we’ll find all delegations to Flipside that happened on the day you did the Terra Scavenger Hunt, and highlight your delegation among all the others. Don’t worry, we’ll walk you through it each step of the way
Validator Voting vs. Investor Inclinations
Apr 27, 2022 - Analyze the last 5 governance proposals. Out of the total Luna that voted in favor, how many % are from validators vs. retail investors for each proposal and on average? Grand Prize Worthy: are there any cases you can identify where retail voters and major validators tended to vote against each other?