headitmanagerTotal number of new users
Updated 2022-05-03
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
30
31
›
⌄
with Algorand_new_users as (select address,first_tx_date as first_date from
(select distinct sender as address, min(block_timestamp::date) as first_tx_date
from algorand.transactions
group by address) where first_date >= CURRENT_DATE - interval '60 days'
)
,Ethereum_new_users as
( select address,first_tx_date as first_date from
(select distinct from_address as address, min(block_timestamp::date) as first_tx_date
from ethereum_core.fact_transactions
group by address) where first_date >= CURRENT_DATE - interval '60 days'
)
,Solana_new_users as
( select address,first_tx_date as first_date from
(select distinct signers as address, min(block_timestamp::date) as first_tx_date
from solana.fact_transactions
group by address) where first_date >= CURRENT_DATE - interval '60 days'
)
,Terra_new_users as
( select address ,first_tx_date as first_date from
(select distinct tx_from[0] as address, min(block_timestamp::date) as first_tx_date
from terra.transactions
group by address) where first_date >= CURRENT_DATE - interval '60 days'
)
select 'Algorand Total New Users : ' as label , count(distinct address) as cnt from Algorand_new_users
UNION
select 'Ethereum Total New Users : ' as label , count(distinct address) as cnt from Ethereum_new_users
UNION
select 'Solana Total New Users : ' as label , count(distinct address) as cnt from Solana_new_users
UNION
select 'Terra Total New Users : ' as label ,count(distinct address) as cnt from Terra_new_users
Run a query to Download Data