strawbetty
NFL All Day Tournament [Round 1]
Sep 5, 2022 - For the first round of this tournament, create an analysis that shows top-line NFL All Day metrics and stats. Chart total sales and sales volume growth, user analysis, player. Track metrics by player and position, and see if there are any notable spikes in sales so far this preseason.
Stablecoin Arbitrage on Jupiter
Mar 18, 2022 - Because Jupiter is a dex aggregator, there are naturally opportunities where one could take advantage of liquidity pairs across the ecosystem to create arbitrage. Since February 1st, what percentage of all swaps (with a size of at least $100) where a wallet starts the transaction with USDC or USDT and ends the transaction with either USDC or USDT have resulted in at least a 1% gain? - Are there any patterns behind the most common sources of arbitrage on Jupiter? List the top 10 wallets in terms of total arbitrage gains and provide insight over their strategy.
Sushiswap Bentobox Scavenger Hunt
Mar 25, 2022 - Show us your limit order and trade executing using your txn_hash.
New NFT Mints
May 18, 2022 - Q76. How many total new NFT projects have appeared on Magic Eden per day since the start of the new year (as in new projects that have minted that day)? Compare that to the total number of new NFT projects that were minted/created on Ethereum? Create a dashboard comparing the growth rates of the number of new NFT projects on Solana and Ethereum and understanding the amount of sales activity on ""new projects"" for each chain.
Opensea Fees
Aug 1, 2022 - Find the wallet that collects Opensea fees. Make a dashboard showing how much Opensea has earned through Polygon transactions.
Network Performance Dashboard
Jul 13, 2022 - How has the network performed over the past month compared to the rest of the year? Has transaction per second and success rates of transactions gone up recently? Is this because of less botting or fewer users, or new improvements from the Solana engineers? What wallets and programs have paid the most in fees for failed transactions?
Polygon Block Performance
Jul 25, 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 Performance
Jul 20, 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.
GMT Airdrop
Mar 19, 2022 - Q38. GMT, the governance token of StepN, was airdropped to its 5000 trailblazers (early adopters and supporters of the game) on 3/15. The airdrop amount was calculated from the amount of time played in the game.
Aave Delegates' Gas Usage
Mar 22, 2023 - How much gas was used by delegates voting in Aave in the past 90 days? In the past 180? How much gas on average is spent by voters in a single vote?
Whale Voters
Feb 16, 2022 - 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? I chose 1000 wallet with the most USD balance as whale and checked if they voted in past 90 days.
Overtime Markets - Volume
Aug 24, 2022 - 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.
Algorand Price Correlation
Jun 28, 2022 - Q109. Is the price of Algorand more closely correlated with the crypto market, and assets such as BTC or ETH, or is it more correlated with network usage such as number of transactions or ALGO transfers? How does this compare to other networks such as Solana? Note your findings and anything else that may be interesting in relation to Algorand's price movement!
Terra Scavenger Hunt (Farsi)
Feb 11, 2022 - در این داشبورد من تراکنش های دلیگیت کردن خود به فلیپساید را نمایش می دهم
Flow vs Other L1s Pt (II)
Jul 19, 2022 - How does Flow compare to other L1s in terms of user retention? Is a user who made a transaction previously likely to make another transaction a week or a month later? Compare and contrast this type of activity vs other L1s like Solana and Ethereum.
Price + Circulating Supply
Jun 4, 2022 - Q3. Draw a chart showing MATIC’s circulating supply from the start till today. Compare it with MATIC’s price.
Kashi TVL
Apr 9, 2022 - What is the Total Value Locked (TVL) by liquidity pool on Kashi? draw a weekly chart for 2022. what are the top 10 pools?
New Wallets In May
Jun 16, 2022 - Q101. How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May? How many new wallets were created in May? What % of total wallets with more than 1 ALGO is this? Additionally, show the distribution of ALGO holdings for these new wallets. What is the average ALGO holding of these new wallets? What other ASAs do these new wallets from May hold? How many of these wallets have performed a swap? Finally, note anything else interesting about these wallets! Why are these wallets being created and what are they doing on Algorand?"
Nebula Scavenger Hunt
Apr 29, 2022 - Welcome to Nebula! We hope this Nebula Hunt is an enjoyable entry into the Nebula Protocol.
Folks Finance: Minting gALGO3 For Governance
Apr 21, 2022 - Folks Finance is a newly launched lending and borrowing protocol built on Algorand. They offer a unique liquid Algorand governance opportunity which allows you to still utilize your ALGOs in in the form of gALGO3 a token you mint when you deposit your ALGOs into their governance pool.
Distinct Wallets (Optimism Bridge)
Jun 17, 2022 - How many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days? Visualize your findings.
200K ALGO Donated Toward Tree Planting
Mar 10, 2022 - Show the donations to the wallet over time. Has the donation wallet sent any of the ALGOs anywhere? If so, what addresses have most of the ALGOs been sent to? Have any of the ALGOs been sent to a centralized exchange(CEX)? If so, how much?
Governance Period 2 Payouts
Apr 14, 2022 - Q49. Let's look at the Algorand Period 2 Governance Rewards Payouts
Swapping goBTC and goETH on DEXs
May 19, 2022 - 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.
Validator Pageant
Mar 16, 2022 - Select one validator outside the top 10 and make a case for why newcomers to Terra should delegate to that validator. Define any metric of your choosing that marks a good validator (airdrops, voting, community benefits, uptime); assess the average for the full set of ~130 validators (i.e. if you pick airdrops, assess how many of them offer an airdrop); and assess how your chosen validator performs based on that metric.
LUNA Staking and Trends
May 7, 2022 - Q203. Over the past 30/60/90 days and the past year, how much LUNA has been staked per day? What is the staking percentage (LUNA staked/Circulating Supply), and how has it changed over time?
Stablecoin Popularity for Swaps
Apr 7, 2022 - Which stablecoin is more popular for a wallet to use in swaps(use algorand.swaps table): USDT, USDC, STBL? Compare volumes and number of swaps for each over the month of March 2022.
LUNA Market Cap
May 7, 2022 - Back to basics! Display the LUNA price and market cap trend over 30, 60, 90 days; the past year; and all time.
Whale Swaps
May 4, 2022 - How many swaps are above x$ and how much total amounts were swapped in such transactions?
Standardized TVL Over Time (1 Pool)
Apr 22, 2022 - Select one pool of your choice and show the total number of asset tokens (non-RUNE tokens) in that pool over time