HosseinUntitled Query
Updated 2023-01-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
select
*, sum(new_users) over (ORDER by min_date) as cumulative_users
from (
select
min_date,
count(*) as new_users
from (
select
tx_from,
min(block_timestamp::date) as min_date
from osmosis.core.fact_transactions
group by tx_from
)
group BY 1
)
order by min_date
Run a query to Download Data