with sei_accs as (

select tx_from as user, date_trunc('hour', block_timestamp) as date

from sei.core.fact_transactions s

where tx_succeeded = 'TRUE'

and block_timestamp >= '2023-08-15'

),

new_accs as (

select tx_from, min(date_trunc('hour', block_timestamp)) as min_date

from sei.core.fact_transactions s

where tx_succeeded = 'TRUE'

and block_timestamp >= '2023-08-15'

group by 1

),

daily_new_accs as (

select count(tx_from) as new_count, min_date,

sum(new_count) over (order by min_date) as total_account

from new_accs group by min_date

),

all_accs as (

select count(distinct user) as all_count, date

from sei_accs

group by date

select all_count, new_count as new_accs, all_count - new_count as old_accs,

date, total_account

from all_accs join daily_new_accs on date = min_date