headitmanagerDaily chart 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
32
33
34
35
›
⌄
with Algorand_new_users as (select count(address) cnt,first_tx_date::date as first_date from (select distinct
sender as address,
min(block_timestamp) as first_tx_date
from algorand.transactions
group by address) where first_date >= CURRENT_DATE - interval '60 days'
group by first_date)
,Ethereum_new_users as
( select count(address) cnt,first_tx_date::date as first_date from (select distinct
from_address as address,
min(block_timestamp) as first_tx_date
from ethereum_core.fact_transactions
group by address) where first_date >= CURRENT_DATE - interval '60 days'
group by first_date)
,Solana_new_users as
( select count(address) cnt,first_tx_date::date as first_date from (select distinct
signers as address,
min(block_timestamp) as first_tx_date
from solana.fact_transactions
group by address) where first_date >= CURRENT_DATE - interval '60 days'
group by first_date)
,Terra_new_users as
( select count(address) cnt,first_tx_date::date as first_date from (select distinct
tx_from[0] as address,
min(block_timestamp) as first_tx_date
from terra.transactions
group by address) where first_date >= CURRENT_DATE - interval '60 days'
group by first_date)
select *,'Algorand' from Algorand_new_users
UNION
select *,'Ethereum' from Ethereum_new_users
UNION
select *,'Solana' from Solana_new_users
UNION
select * ,'Terra' from Terra_new_users
Run a query to Download Data