BLOCK_TIMESTAMP::DATE AS day,

COUNT(DISTINCT TX_HASH) AS arbitrum_txs_per_day,

COUNT(DISTINCT FROM_ADDRESS) AS arbitrum_activeaddrs_per_day

FROM polygon.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= {{start_date}}

AND BLOCK_TIMESTAMP < CURRENT_DATE

GROUP BY 1

ORDER BY 1;