kipto
Daily Transactions and Unique Addresses (Polygon)
Jul 13, 2022 - Q1. Count and plot the number of daily transactions and unique addresses on Polygon, beginning July 1, 2022. In your estimation, discuss whether Polygon is still growing, has reached a plateau, etc.
Average Price Shift for Synth Holders
Apr 13, 2022 - What is the typical price shift experienced by a synth holder? Compare the current price of the asset vs the price when they minted (relative to $RUNE).
Token Activity
May 7, 2022 - Q3. What do people do with their PSP tokens? Once people acquire PSP tokens what do they do with them? Do they stake them? How long do they hold them for? Show the journey of PSP tokens.
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.
Tokens moving in and out from Ethereum/Solana/Polygon
May 10, 2022 - Yesterday was… Well let’s not talk about yesterday, let’s analyze it.
Tornado Cash Addresses
Aug 10, 2022 - Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle. The addresses tied to the service have been publicly posted online. (Hint: we also have them in our crosschain address labels table as well).
Bridge Transactions (Across)
Jun 22, 2022 - Q1. Analyze bridge transactions via the Across bridge over the last two weeks. What assets are users bridging from Ethereum, and to what chains?
Flash Bounty: Merge Staking Providers
Sep 6, 2022 - Choose 1 liquid staking provider (Ankr / Lido / rocketpool, etc) and answer the following question: How much ETH was staked? How many unique depositors are there? What is the avg/median/max/min/distribution of ETH deposits?
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?
Solend Demographics
Aug 3, 2022 - Q101.Solend is the leading lending protocol on Solana. What are the demographics of the Solend userbase?
Gard.Money Algorand’s First Algorithmic Stablecoin
Apr 21, 2022 - Q55. GARD is the world's first algorithmic stablecoin on Algorand's blockchain. Let’s look at the collateral debt positions(CDP) users are taking on. This is where users put ALGOs up as collateral and in turn get GARD(Asset ID 684649988) in return. Gard is a stable coin pegged to $1 in value.
Tracking USDH
Apr 18, 2022 - Q57. Hubble is a decentralized finance protocol built on Solana. Hubble will offer multiple Hubble currently focuses on borrowing and minting USDH - a stable coin.
New Addresses in Polygon
May 31, 2022 - Q2. Draw a chart showing the number of new addresses every day on polygon(matic) network. New addressses are unique addresses that appeared for the first time in a transaction of Matic.
Overtime Markets - Volume
Aug 25, 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.
Transaction Failure
Mar 24, 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.
Friktion's Crab Strategy
Apr 25, 2022 - Friktion recently launched a new product offering, Volt #03 - a volatility yield strategy for stablecoins in crab markets. For more information. reference this twitter thread https://twitter.com/friktion_labs/status/1516835223576719376 And Friktion's helpful medium article: https://medium.com/friktion-research/harvest-volatility-yield-with-friktion-volt-03-2ba2c9df028b And a link to the Volt: https://app.friktion.fi/crab
Looking For Swap Arbitrage
Mar 31, 2022 - Q42. 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 the 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 wallets conducting this behavior, let’s look if they end up with more USDT or USDC they started within 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.
Sushi Price vs Volume last 30 days
Feb 14, 2022 - By looking at the price of the Sushi token and volume on Sushiswap over the past 30 days. We try to answer does the price of the Sushi token seem to impact volume on Sushiswap? Sushi token prices had a steady decline in early January. The hourly transaction counts (moving average of 24h) to and from Sushiswap laggingly show also decreasing tendency. We will look at the token price, and transaction counts from and to Sushiswap filtering the Ethereum Mainnet udm_event data to have Sushiswap either in the from_label or to_label. We see that some protocols did make huge transactions however overall the transaction volume laggingly followed the price decline both having calmed down for now.
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?
NEAR Performance
Jul 13, 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.
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
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.
Bridge Volume (Optimism Bridge)
Jun 17, 2022 - Q2. Compare user bridge volume on the Optimism Native Token Bridge vs. another Mainnet <-> Optimism Bridge of your choosing (e.g. Hop). Can we conclude if there are differences in the types of users or transactions using the native bridge vs. the non-native bridge?
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.
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
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
Top Lido Stakers
Apr 20, 2022 - Use the ethereum_core tables to identify the top stakers using Lido. Do research on these addresses, can you identify any of these accounts using a mix of off and on-chain data?
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?
Stablecoin Pegs
May 13, 2022 - How have USD-pegged stablecoins across different chains, and with different backing mechanisms, fared through the last 5 days?
Solana NFT Deal Score to rule them all
Feb 10, 2022 - Do you want to buy an NFT? Sure. How do you know the listed price is fair and avoid getting rugged? The NFT deal app is redefining how to go about making your NFT purchases by using price history and machine learning and not only strict rarity-based metrics. To make the point, we will look Pesky Penguins, Thugbirdz, and SolanaMonkeyBusiness (SMB).
Katana Covered Call Vault Popularity
Mar 27, 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?
Fact table for starting and stopping lending on Sushi
Mar 16, 2022 - We create a fact table to draw insights from Sushi's lending service Kashi.
RocketPool Recent Activity
Apr 24, 2022 - Q18. Using the Ethereum_core schema, analyze inflows and outflows to RocketPool over the past three months. As we near the ETH 2 merge, are there any emerging trends? What is the average deposit size and how has that changed vs. historical performance?