rwws22-Xd2GN5
USDC Deposits in PoolTogether
Jun 21, 2022 - In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
Terra LP-ers: Aftermath
Jun 20, 2022 - What did people that were LP-ing in the Terra pools do? Are they just holding onto their $RUNE now or are they back in the arena LP-ing somewhere? Or did they sell their $RUNE and leave the ecosystem completely.
Analysing swaps of goBTC and goETH on DEXs in Algorand
May 17, 2022 - In May, market volatility from the depegging of UST and the crash in the price of the Terra ecosystem token LUNA had knock-on effects across the crypto markets. This analysis looks at data on swaps of goBTC, goETH and other Algorand Standard Assets (ASAs) in several Algorand-based decentralised exchanges (DEXs).
Folks Finance Scavenger Hunt
May 19, 2022 - In this Scavenger Hunt, I acquired some ALGO, created a Pero Algo Wallet, collateralized some ALGO and then borrowed USDC on the Algorand-based borrowing and lending platform, Folks Finance. First, I created a Pero Algo Wallet. With a Pero Algo Wallet ready to receive some ALGO, I converted a small amount of USDC to ALGO on the centralised exchange FTX, seen below:
Celsius and Sushi
Jul 9, 2022 - Q104. Find out what Celsius platform has done on sushi (swaps, lending, LP'ing, farming). Make sure to use cross-chain tables as much as possible to capture data on all chains. currently, we have swaps, lending, and borrowing data cross-chain.
$RUNE Upgrades
Jun 24, 2022 - Q.107 There has been a big push for users to upgrade their ETH.RUNE + BNB.RUNE -> native RUNE, as the wrapped versions will be depreciated.
Optimism Scavenger Hunt
May 26, 2022 - In this Scavenger Hunt, I explored the Ethereum layer 2 rollup called Optimism and a DeFi protocol on this layer 2 platform called Synthetix.
Wildlife Warriors NFT Drop
Jun 23, 2022 - Q105. Wildlife Warriors was a project established by Steve Irwin in 2002 as a way to include and involve other caring people to support the protection of injured, threatened or endangered wildlife. They recently had an NFT drop(https://twitter.com/wildwarriors) on Algorand to support the project. Lets look at the wallets that own one of these NFTs.
HODL or Sell
Jun 14, 2022 - In this analysis, we want to identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now, and determine whether they have held or sold their stETH.
Algorand tutorial
May 19, 2022 - In this analysis, we look at the assets (i.e. Algorand Standard Assets) held by wallets created in 2022. In Figure 1, most wallets held Xfinite Entertainment, the token for a play-to-earn application on Algorand.
Sushi Treasury
Jun 27, 2022 - Q97. What are the in-flows and outflows from sushi treasury? Analyze the trends. Build a dashboard.
Sushi Activity on Ethereum
Jun 27, 2022 - Q96. How did the recent spike in market volatility affect the overall activity of sushi on Ethereum? Analyze both swaps and lendings?
NEAR Performance
Jul 20, 2022 - Q5. 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.
Total Metamask Users
Jun 23, 2022 - Q1. How many total Metamask wallet holders are there? What’s the average value of ETH held in wallets? What percentage of wallets are engaging in a higher order activity, like staking?
What makes a Top Shots moment valuable? (Part I)
Jul 22, 2022 - Create an analysis on NBA Top Shots moments and attempt to uncover any correlations between a specific category and sales volume.
Juno Scavenger Hunt
May 28, 2022 - In this Scavenger Hunt, I explore the Juno ecosystem, including acquiring some ATOM and JUNO, and eventually staking these tokens into a pool.
Hop Whales
Jun 21, 2022 - Are whales choosing Hop to go to L2s? Or are they choosing the native bridges? Compare Hop vs the native bridges for Polygon, Optimism, and Arbitrum over the following metrics: unique users on each, frequency of use, and the average amount of assets moved on each?
Arbs, Arbs Everywhere!
Jul 16, 2022 - Q.112 One of the core actors in the THORChain ecosystem are the “Traders” (https://docs.thorchain.org/roles/trading). These traders swap at a high frequency to make a profit and are a key cog to helping balance prices on THORChain We are taking a deep dive on these traders.
Most Common Transactions
Jun 24, 2022 - Q2. What are the most common transactions for Metamask users? Create an analysis that shows the most common wallet activities and the most common platforms for those activities.
Do Whales Have Diamond Hands?
Jun 19, 2022 - Does the swap behavior of OSMO whales differ from everyday users? How does it differ? Create visuals showing what whales swap to and from compared to a normal Osmosis user.
ETH Deposited or Withdrawn
Jun 29, 2022 - Q1. StarkNet is a layer-2 chain that ensures interoperability with Ethereum mainnet. People are using it to move real ETH to starknet and enjoy its higher speed of transaction and lower fees. How many ETHs have been deposited or withdrawn (bridged) so far from Ethereum to StarkNet or vice versa? and by how many depositors?
Celsius Swaps
Jun 18, 2022 - Find out about the swapping behaviour of Celsius network on both Sushi and Uniswap. Which tokens did they swap the most. From which one of their wallets did they conduct most of the swaps?
Pooly NFTs
Jun 22, 2022 - Q2. How many Pooly NFTs have been minted thus far, and by how many unique wallets? How many Pooly NFTs does the average collector hold?
Solana Flash Bounty: Saga
Jun 24, 2022 - How many wallets have pre ordered Saga (the new solana phone) so far? Note: the preorder is a NFT purchase on-chain. Who is preordering the phone? Provide a breakdown of the type of wallets ordering so far. Example metrics to investigate: what other programs are these wallets interacting with, how active have these wallets been on Solana, are they average users or whales?
Gas Efficiency on Sushiswap
Jun 4, 2022 - In this analysis, we look at Sushiswap and examine the gas efficiency of various services offered by Sushiswap.
Fuse Pool USDC Allocation
May 22, 2022 - In this analysis, we look at how the USDC vault on Rari Capital allocates USDC to the different Fuse pools.
Top TOKE Holders
Jun 21, 2022 - Identify the top holders of the TOKE token in January 2022, have they kept their position today?
Algorand Price Correlation
Jun 29, 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?
Privacy Coins + Politics
Jun 11, 2022 - In this analysis, we look at swaps of assets to the Secret Network's native token, SCRT, over time. Using this insight, we will determine if major news events and macroeconomic factors influence swaps to SCRT.
Polygon Block Performance
Jul 22, 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?"
Distinct Wallets (Optimism Bridge)
Jun 14, 2022 - In this analysis, we analyse the Optimism Gateway - the bridge from Mainnet to Optimistic Ethereum. Specifically, we will find out how many distinct wallets have deposited or withdrawn ETH to Optimism via the native bridge in the last 60 days.