kipto
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?
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?
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
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.
[Sushi] Swap Pairs on Optimism
Jul 20, 2022 - Create a document that includes all addresses for all swap pairs for Sushiswap on Optimism plus the addresses of the two tokens belonging to each pair. Getting the decimals for each of the tokens in the pair would be a bonus. If you are using sources from sushi github, please include the link.
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
RocketPool: User Profile - LIDO vs. RocketPool
Apr 24, 2022 - Q19. Lido is another application that also offers ETH2 liquid staking. Compare and contrast activity on RocketPool vs. Lido over the past three months. Is one growing more quickly than the other? Can we conclude if one of these applications is better for users than the other? Are there different types of users using RocketPool compared to Lido, or are the user profiles similar? Visualize and explain your conclusions.
Question 31: Create a visualization comparing USDC, USDT, and UST (wormhole) popularity in swaps on Jupiter since December 1st (both in terms of count and amount - swaps from and swaps to).
Mar 9, 2022 - This dashboard inspects the stablecoin (USDC, USDT, and UST) swaps on Jupiter since December 1st. The user is advised to click the colors / token groups in legend, especially the Other group as this is an artifact with no real sense. We have used the swaps table on Solana and filtered the data based on the three token contracts either from or to end. The swap data is shown as one-hour aggregates. Both the amounts and the transaction counts have been included. Please see the code at the bottom of the page. The main stablecoin that is used to swap tokens TO on Jupiter is the USDC by far with a rate of around 500 swaps/hour or more. The second stablecoin in terms of transaction rate is the USDT, however, we see that UST since mid-January has started to become increasingly more popular. We notice on Jan 28, 2022, at 2 am, a huge peak of tokens swapped to UST. Additionally, we see the February Solana downtime and a huge spike from Jan 19 to Jan 29.
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?
Solana Stables
May 18, 2022 - Q74. Track stablecoin activity on Solana since April 1st (not limited to but look into USDC, USDT, UST, USDH, UXD, PAI). What have been the flows between coins and what was the result of the UST depegging in the Solana ecosystem? What types of wallets hold a USDH, UXD, or PAI compared to a USDC and what are users doing with those coins?
It's the Catalina Whale Mixer
May 18, 2022 - Q73. Catalina Whales are a popular NFT collection on Solana with an experienced team from the entertainment industry. Chart their sales history and unique holder trends over time.
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.
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.
ERC20 Tokens (zkSync)
Jun 17, 2022 - Q2. Users can also deposit ERC20 tokens into ZkSync. Which ERC20 tokens have been deposited the most (in $ volume and total count) in the last 60 days? Visualize and explain both findings.
Gas as a proxy of activity
Jun 8, 2022 - Q89. How much did sushi users pay for gas in 2022? Is there a correlation with the price of ETH? Can you comment on the spikes in the chart?
Stablecoin Pegs
May 13, 2022 - How have USD-pegged stablecoins across different chains, and with different backing mechanisms, fared through the last 5 days?
Transaction Fees (Osmosis)
May 23, 2022 - How many transaction fees are being paid out each day for the past 30 days? Does a certain type of transaction result in a greater amount of fees being collected?
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?
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?
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?
Swap Volume and Ukraine War
Apr 18, 2022 - Q68. How has the Ukraine war affected the swap volume on Sushi and Uniswap? Has there been a surge in demand for a particular token?
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).
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.
SOL Staker Activity
Apr 11, 2022 - Q52. How frequently are SOL stakers interacting with DeFi protocols over the past month? Which protocols are they interacting most with? Which actions are they mostly taking? Staking? Farming? Swapping? Mining?
Distinct Wallets (zkSync)
Jun 17, 2022 - Q1. How many distinct wallets have deposited ETH into ZkSync in the last 60 days? How much ETH was deposited by day? Visualize both.
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.
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.
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?
![[Solana NFT Project Feature] Catalina Whales](https://res.cloudinary.com/dsr37ut2z/image/url2png/c_crop,g_north_west,h_600,q_auto,w_1200,x_0,y_0/v1675667383/https://next.flipsidecrypto.xyz/previews/dashboards/1db8c4d4-e66e-4373-b1ce-23c4ff29798e%3Ftype%3Dcover "[Solana NFT Project Feature] Catalina Whales")
[Solana NFT Project Feature] Catalina Whales
Jul 20, 2022 - Choose a NFT project from the following list and create a dashboard with the new Flipside dashboard layout that can refresh once a day highlighting at least 4 metrics of your choosing that helps show the "health" of the project. Note any noticeable trends or current events for the project. Highlight how liquidity is flowing in and out of the project and what types of buyers and sellers are interacting with the project.
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
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.
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?
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.
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?