lagandispensernumber of new users on Thorchain
Updated 2022-06-28
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
27
28
29
›
⌄
with liquidity as (
select
from_address,
min (BLOCK_TIMESTAMP) as min_date
from thorchain.liquidity_actions
group by 1
),
transfers as (
select
from_address,
min (BLOCK_TIMESTAMP) as min_date
from flipside_prod_db.thorchain.transfers
where from_address not in (select distinct from_address from thorchain.liquidity_actions)
group by 1
),
ALL_ as (
select min_date ,count (DISTINCT from_address) as num_users from liquidity group by 1
UNION ALL
select min_date ,count (DISTINCT from_address) as num_users from transfers group by 1
)
select
date_trunc(week,min_date) as date ,
sum (num_users) as num_new_users ,
sum (num_new_users) over (order by date) as cum_new_users
from all_
group by 1
Run a query to Download Data