min(x.block_timestamp) as date1

from avalanche.core.fact_transactions x join avalanche.core.fact_event_logs y on x.tx_hash = y.tx_hash

join avalanche.core.dim_labels z on y.origin_to_address = z.address

and label_type ilike 'dapp'

GROUP by 1

order by 2)

date_trunc('{{Time_Unit}}', date1) as date,

count(origin_to_address) as "Number of New dApps",

sum("Number of New dApps") over (order by date) as "Cumulatine number of new dApps"

from t1

where date1 >= '{{From_Date}}'

and date1 <= '{{To_Date}}'

GROUP by 1

order by 1