first_date as date,

count(contract) as new_contracts

from

(select

min(date(block_timestamp)) as first_date,

split(payload_function, '::') as contract

from aptos.core.fact_transactions

group by 2)

group by 1

order by 1 desc