Transactions

Transactions exploration examples

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