kipto
$RUNE Movement from Crypto.com
Jun 21, 2022 - Q104. Show the in + outflow from cryto.com to native wallets over time. Are there any trends?
Standardized Swap Volume
May 17, 2022 - Q87. A few weeks ago we did a question on standardized TVL. Now we’d like to see a similar analysis looking at swap volume in a way that neutralized the impact of price changes. Feel free to look at this any way you’d like, but one idea is to fix asset prices at their current value and apply that price historically to all the tokens that were swapped. Show this metric by week or month (or both!)
Gain or Lose (June 2022)
Jun 15, 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?
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.
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.
Bridge Users (Hop Protocol)
Jun 22, 2022 - Q1. How many unique users have bridged to L2s using Hop? What days in the past 6 months have seen the most volume bridged, and were there any specific events that may have driven these spikes? Which assets have been bridged the most? Show an analysis of the asset distribution of bridging through Hop.
Does Time of Day Affect Price?
May 10, 2022 - Q62. 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.
Stablecoin Arbitrage on Jupiter
Mar 21, 2022 - Q40. Because Jupiter is a dex aggregator, there are naturally opportunities where one could take advantage of liquidity pairs across the ecosystem to create arbitrage.
Flow vs L1s
May 30, 2022 - Q3. Create a dashboard comparing the following metrics between Flow, Solana, Ethereum, and Algorand. Visualize these metrics over time since May 9th.
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
Transactional Nature
Mar 30, 2022 - Q171. In your own words, briefly explain how transaction volume relates to fees paid to stakers. Then, create a graph to show the fees derived from transactions and native swaps. Hint: Native swaps are swaps between LUNA and stablecoins (UST, KRT, etc) and vice versa Hint: https://docs.terra.money/docs/learn/protocol.html
New Wallets In May
Jun 16, 2022 - Q101. How many wallets have a balance greater than 1 ALGO? And how many of those wallets sent or received a transaction in May? How many new wallets were created in May? What % of total wallets with more than 1 ALGO is this? Additionally, show the distribution of ALGO holdings for these new wallets. What is the average ALGO holding of these new wallets? What other ASAs do these new wallets from May hold? How many of these wallets have performed a swap? Finally, note anything else interesting about these wallets! Why are these wallets being created and what are they doing on Algorand?"
Market Volatility
May 25, 2022 - Q82. The second week of May saw some huge volatility in the market and prompted many to sell their volatile assets and take a flight to safety.
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?
Optimism Scavenger Hunt (May 25)
May 26, 2022 - Let's get set for Synthetix earning. We'll first get some SNX from UniSwap, mint some sUSD and get the taste of the rewards
Flow Speed
Jun 6, 2022 - Q4. One of Flow's main features is its speed compared to other blockchains. Blockchain performance can be measured as Transactions per minute. Measure the transactions per minute of Flow since May 9th and 'Successful transactions per minute' and create a chart showing how that metric has fluctuated during that time period.
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?
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.
Fuse Pool USDC Allocation (May 2022)
May 25, 2022 - Q2. How are the tokens in the USDC Vault being allocated into the various Fuse Pools?
$THOR Staking Distribution
May 24, 2022 - Q95. Since vTHOR and THOR Staking 2.0 was released in May, we’re interested in finding out more about how the community has embraced the staking rewards. What is the distribution of $THOR currently staked? Are there any notable whales? You will need to calculate the net amount staked + unstaked to get the current amount.
Where’s The Pot of Gold?
Mar 24, 2022 - -- What % of the bAsset market cap for bLUNA and bETH is locked as collateral on Anchor? -- Show where else bLUNA/bETH is being held, and explain why you think this is.
Trend of Pools
May 18, 2022 - Q78. What kind of pools do user usually withdraw or deposit into for the last 90 days? is there any pattern/trend we can see from it?
Orca User Growth
May 25, 2022 - Q76. Orca, a popular decentralized exchange on Solana seems to have been gaining significant adoptions over the last few months, especially compared to other exchanges. Create a visualization showing Orca adoption in terms of swap volume and number of unique wallets compared to at least two other popular Solana exchanges and Uniswap on Ethereum?
Algorand x Fifa Partnership
May 12, 2022 - On May 2nd, Algorand announced a technical partnership with Fifa causing the price to move 25%. Over the rest of the week, how did this impact Algorand blockchain activity?
1M New Algorand Wallets In May
May 18, 2022 - Q66. From May 4th to May 10 we saw over a million wallets being created. What are these new wallets doing on Algorand?
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.
Volume Scoring with NBA Top Shot
Jun 7, 2022 - Q5. NBA Top Shot allows users to buy, sell, and collect NBA NFTs that showcase influential “Moments” minted on the FLOW blockchain. Create a visualization tracking the total sales volume traded on NBA Top Shot since May 9th by day. How many unique wallets have made a trade on Top Shot over that timeframe?
Moonbirds Crossovers
May 1, 2022 - Are there any notable cross overs between the Moon Birds community and other communities? How many holders also have BAYC, Doodles, etc
Sushi's contribution to Polygon growth
May 12, 2022 - Since Sushiswap introduced polygon, many have adopted polygon to either swap or use other services. With this in mind, what is the contribution of Sushi to the growth of Polygon user base?
Solend Demographics
Aug 3, 2022 - Q101.Solend is the leading lending protocol on Solana. What are the demographics of the Solend userbase?
Lil Nouns Voting Activity
Jun 21, 2022 - Q1. The Lil Nouns DAO is controlled via onchain voting by token holders. Using the ethereum database, analyze voting activity on Lil Nouns proposals. Since voting is on chain and costs gas, are smaller holders excluded from the voting process? Visualize and analyze this question, along with any other trends you find that are relevant.
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.
More Mints
Apr 16, 2022 - Q56. Metaplex is an open source protocol that allows for the creation and minting of NFTs using a standardized format across wallets and applications. It is essentially the backbone architecture for Solana NFTs.