select

from_address,

min(block_timestamp) as "time"

from

blast.core.fact_transactions

group by

1

)

select

date_trunc('hour', time) as "Time",

count(distinct from_address) as "User",

sum(count(distinct from_address)) over(

order by

date_trunc('hour', time) asc

) as "Total Users"

from frist_tx

group by 1

order by 1