with
t1 as (
select
distinct TX_RECEIVER as smart_cnt,
min(block_timestamp) as date1
from near.core.fact_transactions
where tx_status = 'Success'
group by 1
)
select
date_trunc('day', date1) as date,
count(smart_cnt) as "Number of New Smart Contracts"
from t1
where date1 BETWEEN '{{From}}' and DATEADD(DAY, 7, '{{From}}')
GROUP by 1
order by 1