rajs# of New Users
Updated 2023-01-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with users as
(
SELECT
tx_sender,
min(block_timestamp) as date_joined
from terra.core.fact_transactions
group by 1
)
SELECT
date_trunc('day', date_joined) as date,
case when date_joined::date = '2023-01-14' then 'Announcement Date'
when date_joined <= '2023-01-14' then 'Before Announcement Date'
when date_joined >= '2023-01-15' then 'After Announcement Date'
end as period,
count(tx_sender) as no_of_new_users
from users
where date_joined >= '2023-01-01'
group by 1,2
order by 1
Run a query to Download Data