with contracts as (

select

distinct tx : body : messages[0] : contract as contracts,

min(block_timestamp) as deploy_day

from

terra.core.fact_transactions

where

TX_SUCCEEDED = 'TRUE'

group by

1

)

SELECT

date_trunc('day', deploy_day) as date,

count(distinct contracts) as total_contracts,

sum(total_contracts) over (

order by

date

) as cumulative_contracts

from

contracts

where

date > current_date - 30

group by

1

order by

1