with
module_txs as (
select
block_timestamp
, version
, address
from aptos.core.fact_changes
where success
and change_type = 'write_module'
)
select
date_trunc('day', block_timestamp) as date
, count(1) as modules
, sum(modules) over (order by date) as cumulative
, count(distinct address) as addresses
from module_txs
group by 1
order by 1 desc