Cosmoverse

Cosmoverse is the largest community-driven crypto conference in the world.

Cosmoverse is not only a conference - it's the biggest community meet-up in the crypto industry! The Cosmos community is the most inclusive community in the crypto industry. Cosmoverse is all about rewarding all the Cosmonauts with real-life events.

Methodology

atom_price as ( select trunc(recorded_at,'day') as day, 
symbol,
avg(price) as token_price
from osmosis.core.dim_prices
where day >= CURRENT_DATE - 7
group by 1,2)
swaps as ( select trunc(block_timestamp,'day') as day,
tx_id, 
trader,
b.project_name as token_in,
from_amount/pow(10,from_decimal) as token_in_amount,
c.project_name as token_out,
to_amount/pow(10,to_decimal) as token_out_amount
from osmosis.core.fact_swaps a join osmosis.core.dim_labels b 
on a.from_currency = b.address
join osmosis.core.dim_labels c 
on a.to_currency = c.address
where day >= CURRENT_DATE - 7 
and tx_status = 'SUCCEEDED')
usd_amount as ( select a.day,
tx_id,
trader,
token_in,
token_in_amount,
token_in_amount*b.token_price as token_in_usd,
token_out,
token_out_amount,
token_out_amount*c.token_price as token_out_usd
from swaps a left outer join atom_price b on 
a.day = b.day and a.token_in = b.symbol
left outer join atom_price c on 
a.day = c.day and a.token_out = c.symbol
where token_in = 'ATOM')

Conclusion

• The highest number of transaction over the last week , was 4810 on October 11th.

• The highest number of user over the last week , was 4810 on October 11th.

• The most swap volume over the last week , was 403.6K on October 11th.

• The most average volume over the last week , was 83.91 on October 11th.

• The top first token based on transaction, for number of transactions, users, swap volume and average volume, was OSMO.

• The number of transaction which joined the pool was more that leaving the pool.

• The number of users which joined the pool was more that leaving the pool.

• The total swap volume which joined the pool was less that leaving the pool.

• The total average volume which joined the pool was less that leaving the pool.

Sources

Twitter : hadi3_bgh

Discord : hadiseb#1688

Total Transactions

According to these charts:

• The highest number of transaction over the last week , was 4810 on October 11th.
• The lowest number of transaction was 556 on October 12th.
• The cumulative transaction increased to 22.6K from 17.88K in October 11th.

Total User

According to these charts:

• The highest number of user over the last week , was 4810 on October 11th.
• The lowest number of user was 229 on October 12th.
• The cumulative user increased to 11.53K from 8976 in October 11th.

Total Swap Volume

According to these charts:

• The most swap volume over the last week , was 403.6K on October 11th.
• The least swap volume was 20.4K on October 12th.
• The cumulative swap volume increased to almost 1M from 696K in October 11th.

Total Average Volume

According to these charts:

• The most average volume over the last week , was 83.91 on October 11th.

• In the second place, The most average volume , was 65.68 on October 7th.

• The least average volume was 17.49K on October 9th.

  \

Top swaps token from Osmo based on transactions

According to these charts:

• OSMO with 3990 transaction, was in the first place and consisted 29.5% of transactions.
• OSMO with 2659 users, was in the first place and consisted 39.1% of transactions.
• The most swap volume was 463.4K on OSMO with 51.9% share.
• The most average volume was 116.6 on OSMO which consisted 42.3%.

Top swaps token from Osmo based on volume

According to these charts:

• OSMO with 7588 transaction, was in the first place and consisted 43.9% of transactions.
• OSMO with 4623 users, was in the first place and consisted 50.7% of transactions.
• The most swap volume was 4.7M on USDC.axi with 44.5% share.
• The most average volume was 3.2 on WETH.axi which consisted 42.8%.

Total Liquidity

According to these charts:

• 1506 transactions was for joining the pool and consisted 64.4%.
• 864 transactions was for leaving the pool and consisted 35.6%.
• 1026 users joined the pool with 57.1%.
• 771 users leaved the pool.(42.9%).
• The total swap volume that leaving the pool was 781.1K , which consisted 60.9%.
• The total swap volume that joining the pool was 500.6K , which consisted 39.1%.
• The total average volume that leaving the pool was 904 , which consisted 73.8%.
• The total average volume that joining the pool was 320.9, which consisted 26.2%.