main as (

select

tx_hash,

block_timestamp,

contract_address

from

sei.core_evm.fact_event_logs

where

tx_status = 'SUCCESS'

and block_timestamp >= '2024-01-01'

),

new_contract_addresses as (

select

date_trunc('{{ period }}', min_date) as date,

count(distinct contract_address) as new_contract_address

from (

select

contract_address,

min(block_timestamp) as min_date

from

main

where block_timestamp >= '2024-01-01'

group by 1

)

group by 1

),

overtime as (

select

date_trunc('{{ period }}', block_timestamp) as date,

count(distinct contract_address) as contract_addresses,