Mojtaba-Banaei
#17.AB2 Gallery Wallets
May 25, 2022 - Q78. Let’s look at wallets that buy from AB2 Gallery to get a better understanding of purchasing behavior.
#8. Transaction Failure
Mar 22, 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.
#11. USDC Transfer Volumes
Apr 14, 2022 - Compare USDC transfer volumes on Algorand, Solana, Ethereum in 2022.
#7.Fractionalized Dragons
Mar 13, 2022 - Create a graph showing the total volume of $DRGNZ traded and the total deposits into the DRGNZ-SOL liquidity pool over time. Highlight the largest deposits and largest withdrawals from the pool to date. How many $BOKU tokens have been farmed so far from this rewards program?
#7. Crowdsale Contributors
Mar 16, 2022 - Question 3: How many people contributed to the crowdsale of MclubDAO on Mirror? Of those people, how many have actually used their MCLUB tokens by spending it? Is there a correlation between the amount received in the crowdsale and the amount spent?
#4.FWB Pro Airdrops
Feb 24, 2022 - Question 1: How many FWBpros have been distributed so far to the community? Create a chart showing FWBpros airdropped per day.
stETH vs. ETH
Apr 5, 2022 - Q6. How has the price of stETH compared to ETH? Are there any events that triggered a big difference in price between the two tokens?
The Bridge from Ethereum to Solana
Jun 16, 2022 - Q1. Create a visualization of the volume of assets being bridged from Ethereum to Solana over time via Wormhole. What does the average profile / size of wallets bridging to Solana from Ethereum look like (what is the average value of assets being bridged over)? What have been the most popular bridged assets from Ethereum to Solana and has that changed over time?
#15.Does Time of Day Affect Price?
May 9, 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.
#16.Early Pool Activity
May 15, 2022 - Q79. For each pool, show the swap volume and the liquidity after its first week going live (you can use the first swap date to determine when a pool went live)
Layer 2 Blocks
Jun 29, 2022 - Q2. How many layer2 StarkNet blocks have been accepted on Ethereum (L1) chain so far? How much fees have been paid(generated) to Ethereum network? Has StarkNet contributed to saving in transaction fees for its users?
#12.CowSwap Sushi Activity
Apr 21, 2022 - Q1. Using the Ethereum_core schema, find all transactions that interacted with the CoW settlement contract on ETH Mainnet that also used Sushiswap as part of the execution. Why might they have done so?
#4.Sushi Swap Seasonal Analysis
Feb 23, 2022 - Question 45: Conduct a seasonal analysis on sushi swap activity. Is there a particular month or day where there is more activity?
#20. 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.
#2. MIM User Behavior Analysis
Feb 11, 2022 - How has MIM performed at holding/regaining its peg over the past few weeks. Is MIM depegging correlated with the price of other stablecoins, especially UST?
#9. Katana Covered Call Vault Popularity
Mar 30, 2022 - Q43. Katana currently has 5 covered call vaults with a TVL of over $1 million (SOL, mSOL, BTC, ETH, wLUNA). What has been the rate of change of deposits and withdrawals for each of these vaults since the beginning of February? What vaults seem to be gaining in popularity the most? What percentage of wallets that have deposited into a covered call vault have also deposited into another vault? Which vaults seem to have the most crossover?
OSMOSIS Pool of The Week : Analysis of the First Winners
Nov 16, 2022 - Since the start of November, the Osmosis Support Labs team has run the Pool of the Week program, highlighting important and/or new pools within the ecosystem. What kind of impact has this program had on the liquidity of these pools? Track LP volume in and out of these pools based on the following dates: - 11/11/22 Pool 833 - stOSMO / OSMO - 11/15/22 Pool 837 - IST / OSMO - 11/22/22 Pool 840 - BNB / OSMO - 11/29/22 Pool 634 - wETH.grv / OSMO
#3. Whale Voters (Anchor/Terra/Mirror)
Feb 16, 2022 - Question 146: 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? *Define whales; examples: addresses >$1M USD value, top 1000 addresses, top 1% of addresses
Analyzing SOL Theta Vaults of Ribbon Finance using On-Chain Data
Dec 23, 2022 - In this dashboard, we analyze the SOL vault (T-SOL-C) of Ribbon Finance to learn more about the success and popularity of the vault on Solana since its inception on Feb and, most importantly, to see how this vault has performed during the days of Solana's historic decline.
#3. Coinbase New SOL Ecosystem Coins
Feb 13, 2022 - On January 31st, Coinbase added two Solana ecosystem coins to its listings: Bonfida and Orca. Create a visualization that shows the amount of FIDA and ORCA transferred from within wallets in the ecosystem to Coinbase. Did transfers spike right after the listing or has there been continued volume?