CryptoIcicle
Osmo-6.Transaction Failures
May 29, 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.
axlUSDC: Soon to be forgotten?
Nov 4, 2022 - Recently, Circle announced the implementation of an IBC-native USDC, inserting itself into an ecosystem where axlUSDC currently dominates. Let's look at how pervasive axlUSDC is within IBC. Track Satellite bridge activity strictly related to axlUSDC transfer. Which app-chains have the most/least flows of axlUSDC? Looking at Osmosis specifically, analyze how dominant axlUSDC has become compared to both ATOM and other USDC assets in trading and pools.
Osmo-13.Osmosis Governance
Jun 18, 2022 - -- Q13. Create a dashboard that maps community participation in governance. On average, how long does it take for a new wallet to become active in Osmosis governance? Do wallets that are active in governance vote on every proposal? -- Or do they only vote on select proposals?
Osmo-12.Do Whales Have Diamond Hands?
Jun 18, 2022 - -- Q12. 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. -- For payment, submit the address of your Osmosis wallet.
Osmosis-21.Swap Fees - From
Jun 27, 2022 - -- Q21. Do fees on Osmosis differ when users swap to or from different tokens? -- On average, which tokens have the highest and lowest swap fees on Osmosis?
Osmo-7.Unique Users
Jun 4, 2022 - -- Q7. 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.
Osmo-10.Privacy Coins + Politics
Jun 13, 2022 - -- Q10. 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?
Osmo-The Unstakeeeeers
Jul 17, 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?
Osmosis - 2022 Stablecoin of choice ?
Jan 26, 2023 - Submit a deep dive dashboard that explores a specific topic in detail using Osmosis data. Open Analytics (OA) bounties are bounties without specific prompts, just a direction and a reward. It’s your chance to have your brain follow your heart — got a spark of interest, or a loose thread, or a weirdly-specific question gnawing at the back of your mind? Follow it as far as you can!
Osmo-8.Osmo Staking
May 29, 2022 - -- Q8. Over the past 30/60/90 days and since June 2021, how much OSMO has been staked per day? -- What is the staking percentage (OSMO staked vs. circulating supply) and how has it changed over time?
Binance Bonanza
Oct 31, 2022 - -- On October 28th, 2022 Binance became the first CEX to list spot trading for $OSMO. Abruptly, OSMO price shot up around 32%. -- How did this news impact trading on Osmosis. -- Analyze OSMO trading activity on October 28th and this past week vs. daily & weekly averages. -- This analysis should occur against two time periods: the 60-day averages & the 60-days prior to the May Terra collapse. -- Did any other tokens see a spike in trading on Osmosis?
Osmosis One Year Anniversary
Jun 23, 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?
Wallet Balances & Ecosystem Growth
Oct 26, 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? -- BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
Osmosis - 1. Osmosis & Stride
Jan 13, 2023 - How has Stride's LSD stOSMO impacted validators in the active set? Track the impact of undelegations & transfers to Stride. Which validators were the most impacted by stOSMO? Have the validators most impacted by undelegation received ample delegations from the Stride ICA? How has Strides ICA staking activity increased/decreased decentralization across the active set?
Open Analytics - 9. Osmosis - Governance, Proposals and Voters
Jan 20, 2023 - -- Submit a deep dive dashboard that explores a specific topic in detail using Osmosis data. -- Open Analytics (OA) bounties are bounties without specific prompts, just a direction and a reward. -- It’s your chance to have your brain follow your heart — got a spark of interest, or a loose thread, or a weirdly-specific question gnawing at the back of your mind? Follow it as far as you can!
Osmo-11.wETH Deposit Rate
Jun 13, 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).
Axelar Ecosystem Entrances
Oct 28, 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.
Liquidity Pools - Wallet Composition
Oct 27, 2022 - What type of wallets provide liquidity on Osmosis? Is liquidity concentrated and owned by a small number of whales? Or, are there a diverse range of participants in the LP ecosystem? Do LP composition change based on TVL of the pools themselves? BONUS: Post your dashboard on Twitter and tag @flipsidecrypto and any relevant accounts!
OSMO-Transaction Fees
May 24, 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? -- Hint: Look at the msg_types of transactions to determine what type of transaction results in the most collected fees.
Osmo-9.wETH & wBTC On- and Off- Ramps
Jun 5, 2022 - Q9. 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?
Daily Active User
Oct 18, 2022 - -- Daily Active User -- What does a Daily Active User look like on Osmosis? -- First, plot out how many DAUs there are on Osmosis. -- For this exercise, consider a DAU would be any wallet transacting on Osmosis a majority of days every week. -- What does a Daily Active User look like on Osmosis? First, plot out how many DAUs there are on Osmosis. -- Do they LP more or swap more? -- How often do they transfer tokens into Osmosis? -- Where are these transfers coming from?
Axelar Token Launch
Sep 28, 2022 - -- Axelar recently launched its native token, AXL, and we're celebrating with some bounties! -- For this bounty, analyze the activity within the AXL/OSMO pool (#812), as well as trading activity -- on the Osmosis DEX. Note any trends or outliers you see. -- BONUS: The best dashboards will update over time
Osmosis-20.Stablecoin Dominance
Jun 28, 2022 - Q20. Compare the transaction volume for USDC, USDT, and DAI on Osmosis. Is there a stable coin that Osmosis users prefer?
Governance Reaction to Terra
May 24, 2022 - The period between May 8th - May 13th was a busy week for Osmosis governance. What was the community response like to these proposals? How quickly did these proposals hit quorum compared to the last two months of proposals? What was the voter turnout for these proposals vs the last two months of proposals?
Osmo-7.In The Stars
May 29, 2022 - -- Q7. Stargaze Zone is an IBC NFT launchpad and marketplace, and new launchpad projects drop on mint every Friday at 4:00 PM EST. -- Does the volume of swaps involving Stars change around this time? -- Analyze the volume of swaps involving STARS from March 20th until present. -- Hint: Use the msg_attributes table and select transactions that have an appropriate msg_type for swaps. -- The token address for STARS and other tokens can be found by joining to the labels table.