with all_contracts as (

SELECT

block_number,

block_timestamp,

tx_hash,

to_address AS created_contract_address,

from_address AS creator_address,

input AS created_contract_input,

INSERTED_TIMESTAMP

from

blast.core.fact_traces

WHERE

TYPE ILIKE 'create%'

AND to_address IS NOT NULL

AND input IS NOT NULL

AND input != '0x'

AND tx_status = 'SUCCESS'

AND trace_status = 'SUCCESS'

date_trunc('week',block_timestamp) as date,

count(tx_hash) as "# of deployed contracts",

sum(count(tx_hash)) over (ORDER by date_trunc('week',block_timestamp) asc) as "Total contract deployments"

all_contracts

group by

1