MasiTotal Active Addresses April V
Updated 2024-05-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
with tb1 as(select DISTINCT tx_signer
from near.core.fact_transactions
where block_timestamp::Date >= '2024-03-01' and block_timestamp::date < '2024-04-01'
)
,
tb2 as (select count(DISTINCT tx_signer) as march_addresses
from near.core.fact_transactions
where block_timestamp::Date >= '2024-03-01' and block_timestamp::date < '2024-04-01')
select trunc(block_timestamp,'day') as day,
count(DISTINCT tx_signer) as active_addresses
from near.core.fact_transactions
where block_timestamp::Date >= '2024-04-01' and block_timestamp::date < '2024-05-01'
and tx_signer in (select tx_signer from tb1)
group by 1
QueryRunArchived: QueryRun has been archived