Question:

Analyze how users join pools on Osmosis.

• Do they dive in headfirst (add both assets; joinpool) or do they wade in carefully (singleside; join swap extern amount in).
• Analyze how deep the pool is (typical swap size in token and USD for both activities).

Methodology:

In this bounty, we are going to separate how users joined the pool into added single asset and added both assets. For this purpose, I used

core.fact_swaps table of Osmosis schema.

• Single asset added: I found these transactions by consider following condition: to_currency is not null
• Both asset added: I found these transactions by consider following condition: to_currency is null

Single and both assets added breakdown by assets:

All left charts are regarding to the transactions that users joining pools by added single asset. Also, All right charts are regarding to the transactions that users joining pools by added both assets.

Overview of single and both assets added:

Following charts show daily overview on how users joined Osmosis pools.

As you can see, the most users prefer to joining pools by added single asset till mid-Nov.

Comparing sing and both assets added:

following charts show the comparison volume and swap size of each asset used to joining pools.

Conclusion:

• the most users prefer to joining pools by added single asset till mid-Nov.
• The number of users that added single asset to joining pools is much more than those who added both assets. We can say same thing for volume in USD and average swap size too.
• There were spikes on IOV price during first week of OCT that make the volume of this token higher than others.