• Transactions

Transactions

This query returns the number of deployed smart contracts by week since the block 10000

with deployments as (
    select
        date_trunc('week', block_time) :: date as week,
        count(1) as txs
    from
        transactions
    where
        tx_type = 'smart contract'
        and block_height > 10000
        and status = 1
    group by
        1
)
select
    week,
    sum(txs) over(
        rows between unbounded preceding
        and current row
    )
from
    deployments