contract_creation_tx as (

select

tx_hash,

block_timestamp,

from_address as deployer,

tx_fee

from

base.goerli.fact_transactions

where

to_address is null

and block_timestamp >= to_date('{{start_date}}')

and block_timestamp <= add_months(

to_date('{{start_date}}'),

{{duration_in_months}}

)

and status = 'SUCCESS'

),

deployers_stats as (

select

deployer,

min(block_timestamp) as first_deploy,

count(tx_hash) as deploy_count,

sum(tx_fee) as total_fee_eth

from

contract_creation_tx

group by

1

order by

1

)

date_trunc('week', first_deploy) as week,

count(deployer) as deployers,

sum(deployers) over (

order by