hessNew Vs. Old users
Updated 2024-09-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
›
⌄
with new as ( select min(block_timestamp::date) as date,
sender
from aptos.core.fact_transactions
where success = 'TRUE'
and tx_type = 'user_transaction'
group by 2)
,
new_users as (select DISTINCT sender
from new
where date >= '2024-01-01'
)
select date(block_timestamp) as date,
count(DISTINCT tx_hash) as transactions,
case when sender in (select sender from new_users) then 'New Users' else 'Old Users' end as type
from aptos.core.fact_transactions
where success = 'TRUE'
and tx_type = 'user_transaction'
and block_timestamp::Date >= '2024-01-01'
group by 1,3
QueryRunArchived: QueryRun has been archived