rupertchan
Outbound Traffic
Mar 16, 2022 - Question 166: The Terra Bridge has expanded its capabilities: https://twitter.com/Speicherx/status/1501883479457288193 Create a dashboard to track the outflows of LUNA and UST to Osmosis, Secret, Axelar, and Injective. What conclusions can you draw from the outflows thus far?
Question 9 - ENS - Claimed Token Distribution
Dec 22, 2021 - My dashboard will answer the question 9: What’s the average amount of ENS claimed from the airdrop? Create a histogram that shows claim size distribution.
Untitled Board
Nov 17, 2022 - This week has highlighted the need for transparency & decentralization in crypto markets. Let's see how users have reacted to this wild week in Web3. Have behaviors changed? Analyze growth in Osmosis Volumes & User Count this week. Has more money flowed into Osmosis this week compared to the past few weeks/months? Where is this money coming from? Centralized Exchanges? Have wallets moved more into stables?
Question 34. The Season of Swapping
Dec 24, 2021 - Which wallet address has performed the most swaps in the last 30 days? Hint: Use thorchain.swaps
Top LDO Holders
Jun 2, 2022 - Q1. Who are the top LDO holders on ethereum and where have their LDO come from? Did they buy it or was it an airdrop?
When Do Transactions Fail?
Jan 21, 2022 - 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 throughout the month of December. Are there any noticeable patterns to when transactions are more likely to fail?
Untitled Board
Dec 21, 2022 - Let’s explore some key indicators of the health of the Web3 industry. Project ETH supply growth for 2023 by using various average gas prices. What is the highest value DEX swap, by protocol? Where was there the most DEX swaps by protocol? Which were the highest gas consuming NFT mints?
Untitled Board
Jan 4, 2023 - Last week we analyzed how users join pools, single or double-sided, which showed that most users join two-sided. This means that most users are already engaged within the Osmosis ecosystem. Let's analyze a typical user journey through Osmosis. Analyze the following: * The most common ways of entering Osmosis (Axelar (Satellite) or elsewhere) * The most common asset transferred into Osmosis for first transfer Stay or leave: * What do wallets do when they first come to Osmosis? * Join to swap and then transfer that asset out? * Join to stake OSMO? * Join to swap and then LP? * Which assets are most commonly swapped for and transferred out? * Which assets are most commonly swapped for and then LP'd? Calculate the above from both a volume and # of user standpoint
Killer Crossover, Mvmt. I: LUNA/Solana
Feb 24, 2022 - Friktion on Solana offers a “covered call” strategy for numerous assets, including LUNA. This strategy’s overall return depends on how often the call options are exercised, i.e. how often LUNA ends up above the strike price of the option.
Untitled Board
Nov 16, 2022 - Flipside is holding a bounty tournament to celebrate the arrival of the World Cup — plus a weekly side quest bounty open each week to anyone, even those who arent participating in the tournament. For this week's side quest, the World Cup right around the corner help Fifa+ Collect(https://collect.fifa.com/drops) collectors understand how good their collection is by creating a rating system.
How have the average and total borrows and deposits on Anchor changed over time?
Dec 29, 2021 - In this analysis, I will visualize how the average and total borrows and deposits on Anchor changed over time
Untitled Board
Nov 17, 2022 - Earlier this year, Optimism offered an airdrop to users. Let’s examine the airdrop after a few months. How many users claimed optimism airdrop? How much of total airdrop was claimed? How many wallets are still holding tokens from airdrop? How much of users delegated their OPs? Feel free to provide any information that you think is related to token price.