kipto
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?
Lost Anchor Funds
May 5, 2022 - There has been an increase in reports of new Anchor users losing funds. This dashboard analyzes a few of such transactions and tries to detect suspicious behavior. Furthermore, we try to dig deeper into how did these new users lose their funds and how could the loss of funds be prevented in the future?
Total Value Locked (Opyn)
Jun 30, 2022 - Q1. What is the total value locked in the Opyn Squeeth (osQETH) contract? And where does osqeth draw its value from?
User Activity (NFTx)
Jun 14, 2022 - Q2. Analyze user activity providing and removing liquidity from NFTX vaults. Which three vaults have seen the most activity over the past 60 days? Are there any similarities between these vaults or NFT projects? Explain and visualize your findings.
Polygon Scavenger Hunt: Bentobox
May 23, 2022 - Let's do Limit Orders with Sushi on Polygon. Note queries were not mentioned and I understood block explorer links are enough for this Hunt.
Thorra-Luna-UST
Apr 21, 2022 - Q65. How have the RUNE-UST, RUNE-LUNA pools been performing on Thorswap? How do the fees generated from these pools compare to other pools? Do the swaps in these 2 pools tend to be balanced or are they typically going in a certain direction (e.g. are there more swaps from $LUNA or to $LUNA)? Hint: use thorchain.swaps and thorchain.daily_pool_stats
New Active Users
May 6, 2022 - Show the number of new unique users (wallets) per day that transacted with ParaSwap over the past two months.
HODL or Sell?
Jun 15, 2022 - Q11. Identify accounts that have staked ETH with Lido when the price of ETH was much higher or much lower than it is now. Have they held or sold their stETH?
Trend Analysis Sushi
Apr 2, 2022 - Q63. Analyze the trend of active users and number of swaps for sushiswap and draw a comparison with Uniswap. Describe the trends that you see
Active Wallet Addresses
Jun 21, 2022 - Q105. We are interested in knowing how many users are currently in the ecosystem. In this case, how many are holding $RUNE in their wallet or have an open LP position. What is this number currently, and how has it trended over time?
RUNE bonded + slashed amounts
Jun 14, 2022 - Q103. How much RUNE is bonded, how much RUNE has been slashed from those bonds (total and or over time)?
Swaps to $THOR
May 27, 2022 - Q100. On May 4th, $THOR staking was enabled that yielded rewards for stakers based on THORSwap volume. Did we see a spike of swaps to $THOR around that time? Has there been any noticeable change in $THOR swapping since that event?
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?
Symmetric vs Asymmetric LPs
May 31, 2022 - Q99. On THORChain, you are allowed to add liquidity in 1 of 3 ways: Rune-only, asset-only, or symmetric (both Rune + asset). What is the breakdown of liquidity being added, according to those categories? Are there any trends over time or by pool?
Transaction Failures (Osmosis)
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.
ALGOxNFT Marketplace
May 12, 2022 - Q65. ALGOxNFT is one of the quickest growing NFT marketplaces on Algorand. Let’s take a deeper look into ALGOxNFT sales over 2022.
Head to Head
Mar 28, 2022 - Q172. Excluding the respective foundations, what are the top 10 addresses by amount of UST held? What are the top 10 addresses by amount of DAI held? Do you have any guesses to whom those addresses belong?
Stability Fee (May 13)
May 16, 2022 - Q4. How impactful is the stability fee (the interest rate) on DAI loans in terms of the impact on volume and dollar amount of loans taken out? How does activity with DAI tokens change when the stability fee is different?
USDC Deposits (PoolTogether)
Jun 22, 2022 - Q1. In the last month, how much USDC did users deposit into PoolTogether (Ethereum)? What’s the average deposit amount per user?
When Do Transactions Fail? (FLOW)
May 30, 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.
Fuse Pools to seek Yield
Mar 21, 2022 - Q3. Are the DAI and USDC Vaults using the same Fuse Pools to seek yield? What differences can you identify?
Gain or Lose?
Apr 5, 2022 - Q9. Of the stakers that have swapped ETH to stETH, how much ETH did they gain or lose depending on the peg of stETH to ETH at the time of the swap? Repeat the same analysis for stakers who have swapped stETH to ETH; how much ETH did they gain or lose?
Swapping goBTC and goETH on DEXs
May 18, 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.
Bot Activity
May 17, 2022 - Q86. 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?
Early Pool Activity
May 17, 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)
Flow vs Other L1s
Jun 21, 2022 - Q13. 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
Secret Scavenger Hunt
May 29, 2022 - Welcome to Secret! We hope this Secret Hunt will help you find an easy and enjoyable entry point into the ecosystem.
Juno Scavenger Hunt
May 29, 2022 - Welcome to Juno! We hope this Juno Hunt will help you find an easy and enjoyable entry point into the ecosystem.
Lido Rocket Pool Comparison
Apr 20, 2022 - Q13. Use the ethereum_core tables to compare deposits to Lido and Rocket Pool Hint: rETH contract: https://etherscan.io/token/0xae78736cd615f374d3085123a210448e74fc6393 Lido sETH contract: https://etherscan.io/txs?a=0xae7ab96520de3a18e5e111b5eaab095312d7fe84
Governance Reaction to Terra
May 23, 2022 - The period between May 8th - May 13th was a busy week for Osmosis governance. What was the community response like to these proposals? How quickly did these proposals hit quorum compared to the last two months of proposals? What was the voter turnout for these proposals vs the last two months of proposals?
Acquiring goBTC and goETH
Apr 7, 2022 - Where are users acquiring goBTC and goETH? Are they acquiring the assets by swapping or by minting? Has this changed over time? Explain the insights you find.
Highest Sales Volume
Jun 14, 2022 - Q1. Which 3 NFT collections have the most total sales volume in the last 60 days on NFTX? These are transactions where someone redeems their NFTX tokens for a specific NFT.
Unique Users on Algorand
Apr 7, 2022 - Q46. Compare the number of unique wallets that have sent a transaction since February 1st on Algorand vs Solana vs Ethereum vs Terra. How does user adoption seem to be trending for Algorand compared to these other major chains? Does it appear that market conditions are slowing down growth or activity on the networks? -Chart daily unique wallets by day since February 1st for each major blockchain(Algorand, Solana, Ethereum, Terra) -Does it appear that market conditions are slowing down growth or activity on the networks?