CartanGroupAptos Base - [chain] deployed contract modules
    Updated 2024-07-29
    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


    QueryRunArchived: QueryRun has been archived