MasiTotal Number of New Addresses (AUG Vs. JULY)
Updated 2024-09-11
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
›
⌄
with tb1 as ( select block_timestamp,
tx_signer as user
from near.core.fact_transactions
where TX_SUCCEEDED = 'true'
UNION
select block_timestamp,
tx_receiver as user
from near.core.fact_transactions
where TX_SUCCEEDED = 'true'
)
,
tb2 as ( select min(block_timestamp) as min,
user
from tb1
group by 2)
,
tb3 as (select trunc(min,'day') as daily,
count(DISTINCT user) as users
from tb2
where min::date >= '2024-07-01' and min::date < '2024-09-01'
group by 1)
select
case when daily >= '2024-07-01' and daily < '2024-08-01' then 'July' else 'August' end as month,
sum(users) as total
from tb3
group by 1
QueryRunArchived: QueryRun has been archived