contract_creation_tx as (

select

tx_hash,

block_timestamp,

hour(block_timestamp) as "Hour",

(dayofweek(block_timestamp)::string ||'.' || DAYNAME(block_timestamp))::string as "Day of Week",

from_address as deployer,

tx_json:receipt:contractAddress as contract,

-- tx_json,

tx_fee

from

base.goerli.fact_transactions

where

-- tx_hash = '0x9e9650b07853068385fddc31b8c9445995a6b1140e5a4f9e0f6ff9cc502861e1'

-- tx_hash = '0x50fb6be250321ebe517548a0c83d16a10938ac1a706232ff9077cc12da19523b' and

-- tx_hash = '0xd4d55208fa2e7a73e4dfc0945235f229f0b6a24701ec4b5c241237b791580902' and

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'

-- limit 1

-- and tx_json::string like '%Upgrade%'

),

trace_tx as (

select

tx_hash,

block_timestamp,

from_address as deployer,

to_address as contract

-- tx_fee

from

base.goerli.fact_traces