Looking For Swap Arbitrage
Mar 31, 2022 - Let’s see if we can find any wallets profiting from arbitrage on the Algorand DEXes. We specifically want to see if anyone is conducting arbitrage with USDT or USDC, Asset ID 31566704 or 312769. The period we will want to look at is From January 1st 2022 to current. We will want to grab wallets swapping USDC or USDT to another asset then their next swap being back out of that other asset(with the same amount of it) back to USDT or USDC in their next transaction. If we find a wallets conducting this behavior, let’s look if they end up with more USDT or USDC they started with in the initial swap. If we find users doing this, let's look at the top 10 wallets successfully earning more USDT or USDC. What assets do we see them swapping for when they commit this arbitrage? Show and explain your methodology if we don't see this arbitrage occurring.
Active Daily Wallets
Mar 2, 2022 - Let's look at daily active addresses on Algorand. -Compare the number of active daily wallets for the month of January 2022 to December 2021 and January 2021. What day had the most active number of wallets in January 2022? Was there an event on Algorand associated with this date?
GMT and SOL into StepN
May 5, 2022 - GMT is the governance token for StepN that will provide holders with a share of all fees earned within the app. However, recently StepN has made some changes to require using GMT in the game mechanics itself to give it additional utility and incentivize burning of the supply. Currently, the only way acquire GMT is by trading for it (you can not currently earn it in the game, this will change soon). Track the flow of GMT into the app. How are users acquiring GMT? Is by swapping using a DEX like Jupiter, or do flows seem to be coming from centralized exchanges? How often is GST (the token earned in the game) swapped for GMT? What other actions are wallets that are sending GMT into the app doing? Additionally, where do SOL inflows into the app seem to be coming from? Does it seem like most StepN users were already active within the Solana ecosystem, or is there a lot of activity that originated from inflows from centralized exchanges? Essentially, is StepN onboarding users into Solana? Create visualizations showing these inflows of GMT and SOL into the StepN app and if the announcement of Coinbase adding StepN to their list of tokens sparked additional interest from sources outside of the Solana ecosystem."
Defly Token Launch
Feb 9, 2022 - Defly(https://defly.blockshake.io/) is a mobile wallet and swapping platform that is currently being developed on the network. They recently had there token presale and liquidity pools have been provided for swaps on Tinyman. Chart the number of Defly Swaps by day on Tinyman What was the biggest swap for Defly on Tinyman? Chart the distribution of Defly among in wallets.
Node RUNE in/outflows
Feb 1, 2022 - Are Node operators selling/swapping more Rune per week than before EMISSIONCURVE changes? (blocks: 3636274 value: 16), (block: 3704556: value 8)
Bubblegoose Ballers Mint
Jun 15, 2022 - How many unique wallets minted a Bubblegoose Baller NFT and how many NFTs did these wallets purchase on average? How many NFTs were purchased with ETH using Crossmint? Identify any notable trends in minting activity and secondary market sales in the days following the launch. Which group(s) was most likely to "diamond fin" their NFTs?
DEX Performance Dashboard
Nov 5, 2023 - This dashboard helps in the understanding of the DEX landscape, allowing for more informed decision-making and a deeper understanding of decentralised finance trends and opportunities.
LP-er Retention
Apr 24, 2022 - Take a look at thorchain addresses that have ever added liquidity. Group them by the month of their first date of adding liquidity. What % are still providing liquidity in the THORChain ecosystem? How does it look if you filter those that provided at least $10,000 in liquidity?
Top Kashi Pairs (II)
May 16, 2022 - Find the top 5 Kashi pairs on Ethereum based on the number of loans they have given out so far. Choose one that you like, and describe the following information: How many people are lending on this pair at the moment ? How much each user is lending at the moment?
Market Volatility
May 25, 2022 - 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. What did the volume look like in decentralized exchanges on ethereum during that period? Which assets were being sold/bought the most?
Bot Activity
May 14, 2022 - 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?
Sushi rewards distribution
Apr 27, 2022 - 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)
Tracking USDH
Apr 18, 2022 - Track where USDH is being used the most on other Solana defi protocols. What are the most popular pools where users are depositing USDH? Why do you think wallets are choosing to interact with those protocols with USDH? What tokens is USDH most commonly swapped for? What are some ways that USDH can become more adopted within the Solana ecosystem?
Common LP Pairs
Jan 8, 2022 - Of Rune wallet addresses providing liquidity in 2+ pools, what are the most common combinations?
AB2 Gallery Wallets
May 25, 2022 - Let’s look at wallets that buy from AB2 Gallery! How many wallets are buying NFTs on AB2 gallery. What is the total number of unique wallets that have purchased from AB2? Create a distribution plot of how many NFTs each wallet has purchased from AB2. Are we seeing new wallets purchasing on AB2 or is it only wallets that have purchased from AB2 before? Chart the first purchase on AB2 by wallet over time. Create a table of the top 10 wallets that are purchasing from AB2 by ALGOs and number of NFTs
Pros of SOL
May 25, 2022 - Why should developers build on Solana compared to other L1 chains? What features for developers does Solana offer that make it appealing? Compare Solana in terms of transaction speed/throughput, user growth and activity, cost/fees per user, growth in defi and growth in nfts to at least two other chains. How are popular projects on Solana able to scale compared to top projects on other chains (for example a gaming app like StepN or a popular dex like Orca). How do you envision user growth of apps on Solana over time? What types of products seem to be positioned particularly well on Solana?
Staking Yield, Mvmt 1: The Basics
Jan 16, 2022 - Explain in your own words (i.e. don't copy the documentations) how Terra's staking yield is calculated. Provide a graph that compares LUNA staking yield to LUNA price over a time period that you define.
Stablecoin Dominance
Jun 28, 2022 - Compare the transaction volume for USDC, USDT, and DAI on Osmosis. Is there a stable coin that Osmosis users prefer? Is stablecoin dominance the same on Osmosis as it is on Sushiswap and Thorchain? Why might this be or not be the case?
Polygon vs Harmony
May 30, 2022 - Draw a chart comparing Polygon with Harmony on the following metrics: Average tx_fee Average number of transactions per hour
Swap Fees
Jun 28, 2022 - Do fees on Osmosis differ when users swap to or from different tokens? On average, which tokens have the highest and lowest swap fees on Osmosis?
Solana NFT Growth
Apr 27, 2022 - -Total mints and growth rates of mints over time -Total NFT sales and growth rates of sales over time -Total unique wallets that have minted or purchased a Solana NFT and growth rates over time -Total Unique Signers of Metaplex programs -Total minters of NFTs using Candy Machine V1 and total minters of NFTs using Candy Machine V2 -Total users of Metaplex's Auction House program Compare these metrics with NFT activity on Ethereum. How do the two chains compare and how are they trending?
Transaction Fees
Feb 3, 2022 - All transactions on Algorand have a transaction fee of .001 but lets dive a little deeper into fees generated on Algorand. What is the total amount of fees generated on Algorand since the first block? Plot fees generated over time by day on Algorand since the beginning of 2021. Create a table of the top 10 wallets that have generated the most amount of fees in 2022. List both number of transactions and fees of the wallets. Using the asset transfers table, what are the top 10 assets besides Algos that have generate the most fees?
Market Share Dashboard
Aug 29, 2022 - [DAILY UPDATED] This dashboard tracks affiliate fee of Thorchain affiliates
Contractually Obligated
Mar 8, 2022 - Based on your analysis for #161, provide the top 20 smart contract addresses that users interact with or the top 2 smart contract addresses per each of the protocols that you previously analyzed. Grand prize-winning submissions will assess both!
THORChain and $vTHOR Overlap
May 22, 2022 - Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards. What % of $THOR staking wallets also are currently LP-ing on THORChain?
Staking SOL on Marinade
Mar 7, 2022 - Create a visualization showing the amount of SOL staked on Marinade since the beginning of February. What is the average amount of SOL staked on Marinade per transaction, and what were the 10 largest transactions? Create a histogram showing the distribution of SOL staked per transaction. What are the most popular tokens that mSOL is swapped for on Jupiter?
Facts_Lending
Mar 12, 2022 - Build a query for a fact table about sushi's lending activity on Polygon. What questions does your table answer(At least Two questions)? What other dimensions could potentially be extracted from sushi contracts and added to this table to make it more valuable?
Tracking the Top Saber Lockers
Mar 7, 2022 - 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)?