txs_classic as (

select

date_trunc('week',block_timestamp) as date,

tx_from,

count(distinct block_timestamp::date) as days_active

from terra.classic.fact_transactions txs

where tx_status = 'SUCCEEDED'

and block_timestamp > date('2022-05-12') - interval '90 days'

and block_id <= 7603700

group by 1,2

having days_active > 3

select

date,

count(distinct tx_from) as users

from txs_classic

group by 1