Bounty Question:

> Cosmoverse was full of amazing announcements and alpha leaks. Analyze your favorite token’s LP & trading activity on Osmosis over the past week. Please provide volume and user growth metrics into this analysis and focus on deep insights on ONE token.

Introduction

> ## Last month, Cosmonauts across the globe gathered at the Intercontinental Medellin, Columbia, to take part in the largest annual Cosmos event — the Cosmoverse! With 1,000+ attendees, 60+ speakers, and 70+ partners, this year’s event reflected the exponential expansion and adoption of Cosmos as the dominant interchain ecosystem. In the venue filled with passionate core Cosmos contributors, appchain builders, validators, and ATOM holders, Gnoland hosted its first public booth, in search of developers that can help complete its vision of building a highly performant blockchain that focuses on simplicity, transparency, and interoperability.

About Cosmoverse

> ## Cosmoverse is a community-organized conference that focuses on the interchain ecosystem centered around Cosmos. First started in 2021, the Cosmoverse is known to be the largest Cosmos-focused conference in the industry. The conference features everything related to Cosmos including tools, the Cosmos SDK, IBC, CosmWasm, new interchain developments, and zones. Thousands of Cosmonauts gather at the venue to discuss and share ideas for the interchain.

Methodology

> Two base codes were used, one for Liquidity Providings and one for Swaps:

For Liquidity Providings:

select 
  date(recorded_at) as date0,
  hour(recorded_at) as hour0,
  SYMBOL,
  avg(price) as hourly_price
from osmosis.core.dim_prices
where symbol in ('ATOM' ,'OSMO', 'EVMOS')
and recorded_at &lt; CURRENT_DATE
and recorded_at &gt;= CURRENT_DATE - 7
group by 1 , 2 , 3
order by 3 , 2 , 1),
lps as (select 
  case 
  when currency = 'uosmo' then 'OSMO'
  when currency = 'ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2' then 'ATOM'
  when currency = 'ibc/6AE98883D4D5D5FF9E50D7130F1305DA2FFA0C652D1DD9C123657C6B4EB2DF8A' then 'EVMOS'
  end as token,
  TX_ID,
  LIQUIDITY_PROVIDER_ADDRESS as lper,
  ACTION,
  AMOUNT/pow(10,decimal) as token_amount,
  POOL_ID,
  date(block_timestamp) as date,
  hour(block_timestamp) as hour
from osmosis.core.fact_liquidity_provider_actions a 
where currency in ('uosmo','ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2','ibc/6AE98883D4D5D5FF9E50D7130F1305DA2FFA0C652D1DD9C123657C6B4EB2DF8A')
and tx_status = 'SUCCEEDED'
and action in ('pool_joined','pool_exited')
and block_timestamp &lt; CURRENT_DATE
and block_timestamp &gt;= CURRENT_DATE - 7

Fro Swaps:

with price as (
select 
  date(recorded_at) as date0,
  hour(recorded_at) as hour0,
  SYMBOL,
  avg(price) as hourly_price
from osmosis.core.dim_prices
where symbol in ('ATOM' ,'OSMO', 'EVMOS')
and recorded_at &lt; CURRENT_DATE
and recorded_at &gt;= CURRENT_DATE - 7
group by 1 , 2 , 3
order by 3 , 2 , 1),
swaps_from as (select 
  case 
  when FROM_CURRENCY = 'uosmo' then 'OSMO'
  when FROM_CURRENCY = 'ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2' then 'ATOM'
  when FROM_CURRENCY = 'ibc/6AE98883D4D5D5FF9E50D7130F1305DA2FFA0C652D1DD9C123657C6B4EB2DF8A' then 'EVMOS'
  end as token,
  TX_ID,
  TRADER as swapper,
  FROM_AMOUNT/pow(10,FROM_DECIMAL) as token_amount,
  POOL_IDS,
  date(block_timestamp) as date,
  hour(block_timestamp) as hour
from osmosis.core.fact_swaps a 
where FROM_CURRENCY in ('uosmo','ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2','ibc/6AE98883D4D5D5FF9E50D7130F1305DA2FFA0C652D1DD9C123657C6B4EB2DF8A')
and tx_status = 'SUCCEEDED'
and block_timestamp &lt; CURRENT_DATE
and block_timestamp &gt;= CURRENT_DATE - 7),
swaps_to as (select 
  case 
  when TO_CURRENCY = 'uosmo' then 'OSMO'
  when TO_CURRENCY = 'ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2' then 'ATOM'
  when TO_CURRENCY = 'ibc/6AE98883D4D5D5FF9E50D7130F1305DA2FFA0C652D1DD9C123657C6B4EB2DF8A' then 'EVMOS'
  end as token,
  TX_ID,
  TRADER as swapper,
  TO_AMOUNT/pow(10,TO_DECIMAL) as token_amount,
  POOL_IDS,
  date(block_timestamp) as date,
  hour(block_timestamp) as hour
from osmosis.core.fact_swaps a 
where TO_CURRENCY in ('uosmo','ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2','ibc/6AE98883D4D5D5FF9E50D7130F1305DA2FFA0C652D1DD9C123657C6B4EB2DF8A')
and tx_status = 'SUCCEEDED'
and block_timestamp &lt; CURRENT_DATE
and block_timestamp &gt;= CURRENT_DATE - 7)

(select
  'Swap From' as swap_type,
  date,
  TX_ID,
  swapper,
  token_amount,
  (token_amount*hourly_price) as usd_volume,
  POOL_IDS
from swaps_from a 
join price b on a.date = b.date0 and a.hour = b.hour0 and a.token = b.symbol
where token = {{Symbol}})

union all 

(select
  'Swap To' as swap_type,
  date,
  TX_ID,
  swapper,
  token_amount,
  (token_amount*hourly_price) as usd_volume,
  POOL_IDS
from swaps_to a 
join price b on a.date = b.date0 and a.hour = b.hour0 and a.token = b.symbol
where token = {{Symbol}}))

> Using these two codes, for each section, a comprehensive review was first conducted on four main parameters: > >
> - [ ] Number of LP actions/swaps > Number of users > ATOM volume > USD volume > >
> Then many average parameters were obtained and compared. > >
> Next, the top Liquidity Providers were obtained (both based on the number of LP actions and ATOM volume). > >
> Then, the top pools were also obtained (both based on the number of LP actions and ATOM volume).

Links and References

> * Cosmoerse Image > >

> * My Twitter Account > >

💥 Liquidity Providings 💥

Number of LP Actions

> 📌 The number of LP actions in the last week has been quite a fluctuating trend. That is, continuously after one day decrease, the next day increase and vice versa.

>

> > 📌 The highest number of action LPs was on October 11 with 435. But if we are to choose the top day based on the type of actions, October 11th should be mentioned for withdrawals (with 151 withdrawals) and October 5th for deposits (with 293 deposits). (The number of LP actions on October 5 is 433) > >

> 📌 The lowest number is related to October 8.

Token Volume

> 📌 The ups and downs trend mentioned here is present on all days except one! According to the previous trend, it was expected that on the 7th day of October, the downward trend would rise again, but a dramatic fall (from 27.8k to 6.2k ATOM tokens) of 77.5% in the volume of ATOMs has occurred. (There has been a 59% decrease in the volume of withdrawals and an 84.7% decrease in the volume of deposits.) Meanwhile, on October 7th, compared to the previous day, the number of LP actions increased by 30% and the number of Liquidity Providers increased by 27.5%. > >

> > 📌 Another interesting point that can be noted is that after October 7th, although the daily trend is again continuous with ups and downs, these ups and downs are exactly the opposite of the previous two charts (the number of LP actions and the number Liquidity Providers). > >

> > 📌 The lowest ATOM volume is on October 9. On this day, 697 ATOM tokens have been deposited into the pools. In comparison, this number is only equal to 3.44% of the ATOMs that were deposited in the pools on the 6th of October (the largest volume of ATOMs deposited on this day was 20.258k). But the lowest ATOM harvested is not from October 9th. On October 7th, 3.14k ATOM tokens were mined, which is 12.5% of the tokens mined on October 5th. (with 25.15k ATOM tokens withdrawn, which was the most in these seven days)

USD Volume

> 📌 Trends in USD volume are very similar to trends in ATOM token volume. The same dramatic fall on October 7, the same lows and highs and...

> 📌 It does not seem that the price of ATOM token has influenced the behavior of Liquidity Providers. Because the increasing and decreasing trends of the examined parameters are not seen in the price chart of ATOM token. For example, on October 9th, the average daily price of this token was $13.13823. On the other hand, on October 11th, the price of this token has decreased to $12.34035 (about 6.07% decrease in value). But comparing the parameters of these two days, we can say: > >
> * 31.8% increase in the number of LP actions > * 30.7% increase in the number of Liquidity Providers > * 117% increase in the volume of ATOMs (total deposit and withdrawal) > > > * 104% increase in the volume of USDs (total deposit and withdrawal) > >
> While the first two parameters and the last two parameters, except for the 5th and 6th of October, they had opposite trends in the rest of the days.

Liquidity Providers

> 📌 The fluctuating trend is also established in this chart. But the intensity of changes of these fluctuations is less than the chart of the number of LP actions.

> 📌 The highest and lowest are exactly the same as the above chart. The most withdrawers on October 11th (135 users), the most depositors on October 5th (with 253 users), the least depositors and withdrawers on October 8th (with 113 depositors and 62 withdrawers) and the most depositors and withdrawers (in total) ) was on the 11th of October. (With 387 users ---> Note: This number does not represent the number of unique users on this day.)

💥 Swaps 💥

Top Liquidity Providers

> The highest number of LP actions performed in the last week was 27 (an average of about 4 actions per day). But the ATOM volume of these 27 actions was only 92.91. That is an average of 3.44 ATOM per LP action. > >

> > But in terms of ATOM volume, if we check the top 10 Liquidity Providers, we see a large number of addresses that have contributed thousands of ATOM tokens to Liquidity Providings with just one or two actions.

Daily Swaps Overview

> The trend of these 4 daily charts, except for the 9th day of October, has a certain similarity in appearance. On the 9th of October, the number of swaps and swappers increased, but the volume of ATOM and USD decreased. > >

> > On October 11th, in all parameters and both types of swaps, the best statistics have been achieved. The second day of this comment is on the 7th of October. > >

> > In terms of the number of swaps and swappers, October 8th has the weakest results, and in terms of ATOM and USD volumes, October 9th has the weakest results. > >

> > In the number of swaps and swappers, there has always been an advantage with "Swap to" every day. But in the volume of ATOM and USD, you can see the days when "swap from" is superior to "swap to".

Conclusion

> A regular fluctuating trend in the number of LPs and LPers > >

> > A different trend (with the daily trend of the number of LPs and LPers) but with some regular fluctuations in the volume of ATOM and USD > >

> > Lack of effect of ATOM token price on Liquidity Provisions > >

> > Predominance of withdrawals over deposits in volumes. > >

> > October 11th, the bright day of ATOM token swaps > >

> > October 8th and 9th, the weakest performance in ATOM token swaps > >

> > High similarity of trends in 4 parameters (except on October 9) > >

> > In terms of amounts, “withdrawals” and “swaps from” are superior > >

> > In terms of numbers, “deposits” and “swaps to” are superior. > >

> > Pool #1 is the most prominent pool in both the LP and swap discussions.

Averages

> \

> The above numbers are a good summary of the situation of Liquidity Provisions last week and do not leave much room for interpretation and analysis. But some points can be mentioned about the type of LP actions.

> In the following parameters, deposits have contributed more than withdrawals: > > * Average Actions per LPer > * Average LPs per day

> In the following parameters, it has received more of the deposit: > > * Average ATOMs per LP > * Average USDs per LP > * Average ATOMs per Day > * Average USD per Day > * Average ATOMs per LPer > * Average USDs per LPer

> It can be clearly said that in the discussion of value and quantity, withdrawal has the upper hand and in the discussion of the number of deposits, it has the upper hand

Top Pools

> > In terms of the volume of ATOM tokens, pools number 803 (Pool #803 (ATOM/stATOM)),1(Pool #1 (ATOM/OSMO)), 13 (Pool #13 (ATOM/XPRT)), 498 (Pool #498 (ATOM/JUNO)) are ranked first to fourth, respectively. The share of these 4 pools among the top 10 pools (in terms of ATOM token volume) is more than 97.5%. > > \