with all_contracts as (

SELECT

count(*)

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('day',block_timestamp) as date,

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

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

all_contracts

group by

1