daus as (

SELECT

distinct from_address as users,

trunc(block_timestamp,'DAY') as day,

count(distinct trunc(block_timestamp,'day')) as active_days

from base.core.fact_transactions

group by 1,2

),

active_users as (

SELECT

trunc(block_timestamp,'week') as date,

count(distinct from_address) as n_users,

count(distinct tx_hash) as txs

from base.core.fact_transactions

group by 1,2

select * from active_users

where date>=current_date-interval 'day'

and date <current_date

order by 1 asc