MoDeFignosis analysis - 5 new users
Updated 2022-10-16Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with users as (
select FROM_ADDRESS, min(BLOCK_TIMESTAMP) as BLOCK_TIMESTAMP
from (
select FROM_ADDRESS, BLOCK_TIMESTAMP
from gnosis.core.fact_transactions
where STATUS='SUCCESS'
union all
select TO_ADDRESS, BLOCK_TIMESTAMP
from gnosis.core.fact_transactions
where STATUS='SUCCESS')
group by FROM_ADDRESS)
select * from
(select *,
sum(users) over (order by date) as total_users
from
(select date_trunc(day,BLOCK_TIMESTAMP) as date, count(distinct FROM_ADDRESS) as users
from users
group by date))
where date>=CURRENT_DATE-60
Run a query to Download Data