Demands of bounty:

1️⃣ What does a Daily Active User look like on Osmosis? First, plot out how many DAUs there are on Osmosis. For this exercise, consider a DAU would be any wallet transacting on Osmosis a majority of days every week. \n 2️⃣ Once you have the DAUs, what does their activity look like?

3️⃣ Do they LP more or swap more?

4️⃣ How often do they transfer tokens into Osmosis?

5️⃣ Where are these transfers coming from?

✍️ Description of Work

In this dashboard, we want to analyze Daily Active Users (DAUs). For this, we check the following:

• Number of DAUs based on the first perspective
• Number of DAUs based on the second perspective
• List of DAUs based on the first perspective
• The activity of DAUs based on first perspective (Type/ Number)
• The activity of DAUs based on second perspective (Type/ Number)
• The activity of DAUs based on first perspective (Type/ Osmo Volume)
• The activity of DAUs based on second perspective (Type/ Osmo Volume)
• Top 100 Origin contracts for first DAUs group (Osmo coming from)
• Top 100 Origin contracts for second DAUs group (Osmo coming from)
• Average transfer number in first DAUs group (per day)
• Average transfer number in second DAUs group (per day)

✅ Observations

4️⃣ How often do they transfer tokens into Osmosis?

5️⃣ Where are these transfers coming from?

4️⃣The average transfer number per day is:

In the first perspective: 773

In the second perspective: 39.1 K

5️⃣ The top 100 origin contracts charts show the answer to question 5!

In the first perspective, more than 67% of total transfers come from “osmo1tzrry7x69sxyfrdf0td48psfa986af93makadk“

In the second perspective, more than 17.8% % of total transfers come from “osmo10kjvf7pyzzdr6jdg4yj67zfwp2n6cr879s8mau“

✅ Observations

1️⃣ What does a Daily Active User look like on Osmosis? First, plot out how many DAUs there are on Osmosis. For this exercise, consider a DAU would be any wallet transacting on Osmosis a majority of days every week. \n 2️⃣ Once you have the DAUs, what does their activity look like?

3️⃣ Do they LP more or swap more?

1️⃣ The number of DAUs is:

First Perspective: 616 Second perspective: 23.7

We also plot the "List of DAUs based on the first perspective" in a scatterplot. As you can see, the distribution is (>40 and <70) and the distribution around 70 is more.

2️⃣ The activity of the DAUs is:

From the first perspective:

• Stacking more than 1M times (57% of total activities) or more than 349 B Osmo (1.07% of total Osmo volume)
• Swap with more than 640K times (34.2% of total activities) or more than 23T Osmo (71.5% of total Osmo volume)
• Transferring more than 164K times (8.77% of total activities) or more than 8.9T Osmo (27.4% of Osmo total volume)

From the second perspective:

• Stacking greater than 1.17M times (49.6% of total activities) or greater than 14.3 T Osmo (36.6% of total Osmo volume)
• Swap with more than 883K times (37.2% of total activities) or more than 20 T Osmo (51.1% of total Osmo volume)
• Transferring more than 313 K times (13.2% of total activities) or more than 4.83 T Osmo (12.3% of Osmo total volume)

3️⃣ Based on our finding in part 2, the DAUs do swap more than LP!

✔️ Result and Discussion:

Two different perspectives were presented, and all questions were answered from two different perspectives.

The number of DAUs in the second perspective is higher than in the first perspective due to the different conditions in these perspectives.

DAUs do generally LP more than swap base on number. (In both perspectives)

DAUs do generally swap more than LP base on volume. (In both perspectives)

🧠 Methodology

1- for finding DAUs, there are two points of view first: a DUA is defined as a user that is active at least 3 days in all weeks and more than 40 active total days in 10 last week. second: a DAU is defined as a user having more than 4 active days at least a week in 5 last week.

2- for finding DAUs, we add a column with name number and value 1 to all transactions, then group all transactions with the date and tx_from. after that, we sum the number column value and group transactions weekly and by tx_form. now we have the contacts of users and active days in a week now, we can determine the first and second DAUs.

3. we used swap, transfer, and stake tables to find DAUs activities.

We also present two different perspectives to explain the requirements for this bounty.

First perspective:

In this perspective, a user who meets ==all of the following conditions== is referred to as a daily active user (DAU).

He must have ==transactions three or more days a week==

He must meet the first condition in the ==last 10 weeks==, and the total number of transactions must be ==more than 40 in the last 10 weeks==.

Second perspective:

If a user has ==4 or more transactions per week in the last 5 weeks==, they are considered a daily active user (DAU).