SELECT date_trunc('day',frst_txns) as date,
count(contract_address) as n_contracts
FROM
(
SELECT contract_address,
min(block_timestamp) as frst_txns
FROM avalanche.core.fact_event_logs
GROUP BY contract_address
)
WHERE date <= CURRENT_DATE-1
GROUP BY date
ORDER BY date DESC