MasiDaily Retention
Updated 2024-11-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with tb1 as(select DISTINCT receiver_id
from near.core.fact_receipts
where block_timestamp::Date >= '2024-09-01' and block_timestamp::date < '2024-10-01'
)
,
tb2 as (select count(DISTINCT receiver_id) as august_addresses
from near.core.fact_receipts
where block_timestamp::Date >= '2024-09-01' and block_timestamp::date < '2024-10-01')
select trunc(block_timestamp,'day') as day,
count(DISTINCT receiver_id) as active_addresses
from near.core.fact_receipts
where block_timestamp::Date >= '2024-10-01' and block_timestamp::date < '2024-11-01'
and receiver_id in (select receiver_id from tb1)
group by 1
QueryRunArchived: QueryRun has been archived