Try Quests to earn cryptoHot Contracts on Osmosis
Q20. A lot of new contracts are being deployed on Osmosis lately.
Since the beginning of May, answer the following questions: What are the top ten most popular contracts on Osmosis? What is the cumulative total of contracts launched on Osmosis, and have there been any spikes since the Terra crash or other noteworthy events?
Introduction
In this dashboard we will be using Osmosis database to analyze new contracts are being deployed on Osmosis as following:
- Top 10 liquidity providers Since the beginning of May based on number of transactions
- Top 10 liquidity providers Since the beginning of May based on OSMO volume
- Top 10 staking delegator Since the beginning of May based on number of transactions
- Top 10 staking delegator Since the beginning of May based on OSMO volume
- Top 10 Swapping pools Since the beginning of May based on number of transactions
- Cumulative total number of unique liquidity providers Since the beginning of May
- Cumulative total number of unique staking delegator Since the beginning of May
- Cumulative total number of swapping pools Since the beginning of May
We will use osmosis.core.fact_liquidity_provider_actions table to find top 10 liquidity providers and osmosis.core.fact_staking to find top 10 staking validators and osmosis.core.fact_swaps to find top 10 swapping pools.
The following chart shows number of unique LPs per day and cumulative total number of LPs since the beginning of May.
On May 17 the highest number of unique LPs by 10.538K was lunched on Osmosis.
Total number of LPs on July 10 is 241.992K unique LP.
The following chart shows number of unique staking delegators per day and cumulative total number of staking delegators since the beginning of May.
On June 6 the highest number of unique staking delegators by 11.789K was lunched on Osmosis.
Total number of staking delegators on July 10 is 645.945K unique staking delegators.
The following chart shows number of unique swapping pools per day and cumulative total number of swapping pools since the beginning of May.
We can see this number was higher than other times from May 7 to May 14 exactly the Terra crash time.
On May 11 the highest number of swapping pools by 8359 was lunched on Osmosis.
Total number of swapping pools on July 10 is 98.04K unique swapping pools.