effortcapital1Current Month MAUs
Updated 2023-05-27
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
›
⌄
with user_acq_date as (
select
tx_from as address,date_trunc('month',min(block_timestamp)) as first_tx_month
from cosmos.core.fact_transactions
group by 1
),
monthly_new_users as (
select
first_tx_month, count(address) as monthly_new_users
from user_acq_date
group by first_tx_month
),
monthly_total_users as (
select
date_trunc('month',block_timestamp) as month, count(distinct tx_from) as monthly_total_users
from cosmos.core.fact_transactions
group by month
)
select
monthly_total_users
from monthly_total_users
where month = date_trunc('month',CURRENT_DATE)
Run a query to Download Data