date(block_timestamp) as date,

count(distinct TX_RECEIVER) as new_contract,

sum(new_contract) over (order by block_timestamp::date) as cumulative_contracts

from near.core.fact_transactions

where date >= CURRENT_DATE - 180

group by date