shadil
Does Time of Day Affect Price?
May 10, 2022 - Crypto does not follow a 9-5 schedule, but some traders may take advantage of different time zones. Using the Prices Swap table is there an hour (or hours) of the day that more frequently exceeds or falls short of the average of the day.
Rare Traits
Apr 30, 2022 - Question: What Moon Bird traits are rarest? How have different traits performed with buyers and sellers?
Algorand Foundation New CEO Staci Warden
Mar 7, 2022 - Question 31: Algorand Foundation appointed a new CEO Staci Warden on February 10th 2022. How did this impact the Algorand ecosystem?
Marinade's Non-fungible Chefs
Apr 17, 2022 - Q55. Marinade Finance officially launched their protocol governance system on April 4, 2022. In order to participate in governance, holders of the protocol's native MNDE token lock their tokens in exchange for an NFT. This NFT, which varies in size based on the total amount of MNDE locked, represents total voting power and is used to vote on proposals. Governance NFT holders will soon have direct control over a portion of the protocol's validator delegation strategy too.
Sushi on Polygon
Mar 19, 2022 - Q57. What are the 10 largest sushi liquidity pools on Polygon? What is their volume and TVL?
Magic Eden Volume Trends
Mar 12, 2022 - Question 36: Create a visualization of Magic Eden total sales volume per day since January 1st. How has sales volume trended over time? Are there any trends to when sales volume seems to go up or down on certain days of the week or during certain times of the day? Are users more likely to trade a NFT during the week or the weekend?
Orca + Jupiter Volumes
Mar 12, 2022 - Question: Compare the 5 most popular swaps SOL -> coin swaps (SOL swapped for another coin) on Orca and on Jupiter since January 1st. Create a visualization showing the total volume per day on Orca and Jupiter since January 1st for SOL to another coin swaps. What has been the historical swap success rate since January 1st on Orca and on Jupiter?
Inflows and Outflows
Sep 14, 2022 - What is the volume of ETH and a stablecoin of your choice that's moved between the Optimism network and the Ethereum network across the bridge? How has that changed over time?
Cryptopunk Sales and Traders
Aug 30, 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.
Fuse Pool DAI Allocation
May 21, 2022 - Q1. How are the tokens in the DAI Vault being allocated into the various Fuse Pools?
DEX Popularity: Tinyman, Algofi, Pactfi
May 16, 2022 - Q70. Since the beginning of April, how has the growth of AlgoFi and Pact impacted swaps on Tinyman? Show us how the Algorand DEX ecosystem is changing as each DEX grows.
MNDE Locked In Governance
May 4, 2022 - Create a line chart showing the total amount of MNDE tokens locked in governance over time. What percentage of the current circulating supply does this represent?
Stablecoin Arbitrage on Jupiter
Mar 19, 2022 - Q40. Because Jupiter is a dex aggregator, there are naturally opportunities where one could take advantage of liquidity pairs across the ecosystem to create arbitrage.
Fuse Pool Analysis
May 21, 2022 - Q3. Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? What differences can you identify?
Magic Eden Whales
Apr 9, 2022 - Q50. Track the top 20 wallets in terms of sales volume on Magic Eden since March 1st. What have these wallets been buying and selling the most over that time period? As in, which collections seem to have their attention? Do these wallets tend to ""sweep"" (buy a lot of the same collection at once) or patiently buy collections? How often are these wallets buying vs selling NFTs and what does their profit look like?
Popular Algorand Assets To Swap On DEXes
Mar 20, 2022 - Q35. Let’s use the new Algorand.Swaps table to look at what ASAs(Algorand Standard Assets) are popular to swap for in 2022. A swap is performed on a decentralized exchange(DEX) such as Tinyman.
Tinyman Dex Popularity
Mar 20, 2022 - Q36. Tinyman was Algorand’s first DEX(decentralized exchange) and in 2022 we’ve seen the launch of three other DEXes: pactFi, algoFi, and Wagmiswap. Let’s look at the launch of these other DEXes and see how they have impacted the number of swaps on Tinyman.
Swapping for YLDLY on DEXs
May 19, 2022 - Let’s get a better understanding of how people are swapping Yieldly(YLDY: Asset ID: 226701642). Show us the total volume inflow and outflow of Yieldly(YLDY: Asset ID: 226701642) by day in 2022 then break it out by DEX as well. Is swapping for YLDY more popular on some DEXs than others? Additionally what assets are users swapping for YLDLY? Are there any standout days of swap volume for Yieldly? If so, write about what may have caused that spike. Note any other interesting findings related to YLDY swaps!
Fuse Pool DAI Allocation
Mar 22, 2022 - Q1. How are the tokens in the DAI Vault being allocated into the various Fuse Pools?
Getting Your Feet Wet, Part 2
Mar 6, 2022 - Question 161: Assess the extent to which new users interact with each of the following projects. For Definition, clearly define what “interact with” means, e.g. “at least 1 transaction”, “at least 5 transactions”, etc. Anchor, Mirror, Pylon, Astroport, Terraswap, Prism, Mars
ALGO Transaction Payment Size
Mar 28, 2022 - Q43. Let’s look at the quantities of ALGOs being sent in transactions since January 1st 2022 to see if we see any upwards or downwards trends. Group the transactions(algorand.payment_transactions) by size 0-10ALGOs, 10-100ALGOs,100-1000ALGOS, 1,000-10,000ALGOs and 10,000+ ALGOs. Count the number of transaction in each size and chart them by day from January 1st 2022 to current.
Sushi during Volatile Times II
May 29, 2022 - Q86. During the recent spike in market volatility, which chain saw the most activity in swaps for sushi? Polygon, Ethereum or Harmony?
When Do Transactions Fail?
May 27, 2022 - Q2. Do times of high transaction volume lead to more transaction failures? Create a visualization that shows the relationship between transaction volume and success rate of transactions since May 9th.
Flash Bounty: Merge Staking Providers
Sep 4, 2022 - Choose 1 liquid staking provider (Ankr / Lido / rocketpool, etc) and answer the following question.
Solport vs. Magic Eden
Apr 3, 2022 - Q48. Solport - a NFT marketplace on Solana - launched a V2 on March 12th that includes various new features for marketplaces. Beginning on March 12th, compare the NFT sales volume on Solport to Magic Eden's sales volume. How many unique wallets have used Solport over that timeframe compared to Magic Eden?
New to the Menu
Apr 8, 2022 - Q64. What are the 10 most recent assets (coins) supported by sushi?
Untitled Board
Sep 21, 2022 - How many $MATIC have been staked since July 1, 2022? What is the staking ratio of $MATIC (amount of $MATIC staked vs circulating $MATIC) during the same time frame?
Cosmoverse Free Play
Oct 12, 2022 - Cosmoverse was full of amazing announcements and alpha leaks. Analyze your favorite token’s LP & trading activity on Osmosis over the past week.
Osmosis Transaction Failures
May 27, 2022 - Q6. Establish the failed transaction rate for Osmosis over the last 4 months. Make a case for what is causing the failed transaction rate that you assess and provide recommendations to mitigate it.
When Do Flow Transactions Fail? (Part II)
Jun 3, 2022 - Q7. Building off last week's question investigating when transactions fail on Flow, what addresses and contracts are causing the majority of failures? What types of activities and events are these addresses doing that are spamming the network? What types of arbitrage opportunities are they seeking and how profitable are these efforts?
The Law Offices of NEAR
Aug 1, 2022 - Q7. Provide your best assessment of the number of smart contracts deployed on NEAR and clearly outline your methodology (after all, contract lawyers love clearly specified terms).
New Active Users
May 7, 2022 - Q1. Show the number of new unique users (wallets) per day that transacted with ParaSwap over the past two months.
AlgoFi's AlgoVault Governance Period 3
Apr 19, 2022 - Q54. AlgoVault allows you to commit to Algorand Governance via the AlgoFi protocol. Let’s look at what users placed their ALGOs in the AlgoVault and Committed to Governance