Ali3N
User Segmentation Analysis
Dec 23, 2022 - 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.
Hop In the Pool (Osmosis)
Nov 25, 2022 - Analyze how users join pools on Osmosis. Do they dive in headfirst (add both assets; joinpool) or do they wade in carefully (singleside; join swap extern amount in). Also analyze how deep the pool is (typical swap size in token and USD for both activities).
Osmosis One Year Anniversary
Jun 21, 2022 - What did the users who received the initial airdrop of OSMO do with their tokens? Create a visual that shows how many sold, staked, LPed, swapped, and held. How many individuals who received the airdrop still hodl their OSMO one year later?
wETH & wBTC On- and Off- Ramps (Osmosis Bounty)
Jun 3, 2022 - On the Osmosis Frontier, there are pools for wETH and wBTC. How do users respond and change their position in these pools in response to governance proposals involving extra incentives for these pools? Do their deposits and withdrawals of wBTC and wETH onto Osmosis change as well? Hint: Find the addresses for wBTC and wETH in the asset metadata table.
NEAR Gas Guzzlers
Jul 23, 2022 - What contracts are users spending the most gas on to use? How has this changed over the past week? Past month? Hint: The gas units in the table are in raw (not decimal adjusted) format. To adjust accordingly, divide by 10^12.
Do Whales Have Diamond Hands? (Osmosis Bounty)
Jun 16, 2022 - Does the swap behavior of OSMO whales differ from everyday users? How does it differ? Create visuals showing what whales swap to and from compared to a normal Osmosis user.
wETH Deposit Rate (Osmosis Bounty)
Jun 14, 2022 - Q11. Calculate the deposit rate of wETH over time on Osmosis. How does this compare to SushiSwap and Thorchain now? How does the wETH deposit rate compare to when wETH was a relatively new asset (or the protocol was relatively new)? Is Osmosis growing at a faster rate than Thorchain and Sushiswap? Hint: There are two types of wETH on Osmosis, wETH from the Gravity Bridge (gwETH) and WETH from the Axelier Bridge (axlWETH).
The Unstakeeeeers (Osmosis Bounty)
Jul 16, 2022 - How frequently do users on Osmosis unstake their Osmosis? What do they do with the OSMO once unstaked? Do they re-delegate, enter a LP position, or swap into another token? Do they re-delegate to certain validators more frequently than others? Why might this be so?
Unique Users (Osmosis Bounty)
Jun 3, 2022 - How many unique wallets are active on Osmosis per day? How has this changed over time? What has been the largest event that has brought the most wallet activity to Osmosis? Hint: Determine events by comparing to news sources as well as on-chain data.
Privacy Coins + Politics (Osmosis Bounty)
Jun 10, 2022 - Do major news events result in more people swapping to SCRT? Look at the volume of swaps to SCRT over the past three months. Do periods of high volume swaps into SCRT line up with major international news events? Or is there a pattern in SCRT swap volume?
Transaction Failures (Osmosis Bounty)
May 26, 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. Hint: Look at the msg_types of failed transactions to determine what type of transaction results in the most failures.
Ecosystem Entrances
Oct 25, 2022 - Welcome to Axelar! What better to way to get used to Axelar data than to analyze how people enter the ecosystem? With that in mind, analyze the activity that occurs on Axelar's Satellite Bridge. Since inception, what are the top paths over Satellite. by volume and $ amount? What is the most used token to transfer (USDC, wETH, wAXL, etc.)? Top analyses will show bridging activity since inception and analyze how that has changed over time.
Untitled Board WB&EG
Oct 22, 2022 - With the launch of Flipside's new Balances table, let's take a look at how the story of Osmosis can be told through wallet balances. Provide insights into following metrics: How has the ratio of liquid to staked OSMO changed overtime? Are the top 100 OSMO holders the same now as they were at the start of the year? What is the current average OSMO per wallet? How has that value changed over time? Plot average OSMO/wallet against user growth. Do wallets normally hold a majority of OSMO, or another token? How has this changed over time?