Question:

Q20. A lot of new contracts are being deployed on Osmosis lately.

\n 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?

Overview:

According to the conversations on Discord group, the hot contracts on Osmosis considered as swap pairs. By considering this assumption, the most popular contracts on Osmosis have been investigated since start of 2022.

Approach:

• Identification of swap pairs

  Label FROM_CURRENCY as f1 and TO_CURRENCY as f2

  from osmosis.core.fact_swaps x left outer join osmosis.core.dim_labels y

  use CONCAT(f1, ' _ ', f2) as swap_pairs

• Release date of each pair

  swap_pairs,

  min(BLOCK_TIMESTAMP) as release_date

• Time period

  where release_date>='2022-01-01'

Results:

Key findings:

By considering the swap pairs on Osmosis as hot contracts, the outcomes of this essay have been summarized as:

1. The most popular contract (pair) on Osmosis is OSMO_ATOM pair with about one million usage.
2. The ATOM_OSMO and OSMO_USTC take the next ranks.
3. The daily and cumulative count of new contracts (pairs) on Osmosis reveals the launch of pairs on special dates.
4. The highest count of swap pairs launched on May 24th and the number of pairs is 83.
5. The cumulative count of new contracts (pairs) launched in 2022 reached 3000 pairs over time.
6. The daily application of hot contracts demonstrate the dominant application of OSMO_ATOM and ATOM_OSMO in 2022.