permaryDaily active users
Updated 2024-10-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
select
date as activity_date,
count(distinct address) as daily_active_users
from
(select
date(block_timestamp) as date,
from_address as address
from kaia.core.fact_transactions
where block_timestamp >= current_date - interval '30 days'
UNION all
select date(block_timestamp) as date, to_address as address
from kaia.core.fact_transactions
where block_timestamp >= current_date - interval '30 days'
) as all_addresses
group by activity_date
order by activity_date;
QueryRunArchived: QueryRun has been archived