-- forked from adriaparcerisas / flow stats: contracts news (over time) weekly @ https://flipsidecrypto.xyz/adriaparcerisas/q/lKz6vSvUjBvF/flow-stats-contracts-news-over-time-weekly
with
news as (
select distinct event_contract as new_contract,
min(trunc(block_timestamp,'day')) as debut
from flow.core.fact_events
group by 1
)
select
debut as date,
count(distinct new_contract) as new_contracts,
sum(new_contracts) over (order by date) as unique_contracts
from news n
group by 1
order by 1 asc