hessAverage Active Days
Updated 2023-04-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with users as ( select min(block_timestamp::date) as date, tx_signer
from near.core.fact_transactions
group by 2)
,
new_user as ( select DISTINCT tx_signer
from users
where date >= '2023-01-01'
)
,
final as ( select a.tx_signer, count(DISTINCT(block_timestamp::date)) as active_days
from near.core.fact_transactions a join new_user b on a.tx_signer = b.tx_signer
where block_timestamp::date >= '2023-01-01'
group by 1)
select avg(active_days) as avg_days
from final
Run a query to Download Data