BLOCK_TIMESTAMP::DATE AS day,

COUNT(DISTINCT TX_HASH) AS optimism_txs_per_day,

COUNT(DISTINCT FROM_ADDRESS) AS optimism_activeaddrs_per_day

FROM optimism.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= {{start_date}}

AND BLOCK_TIMESTAMP < CURRENT_DATE

GROUP BY 1

ORDER BY 1;