date_trunc('day', block_timestamp) as date,

COUNT(distinct tx_hash) as txns,status

from arbitrum.core.fact_transactions

WHERE block_timestamp BETWEEN CURRENT_DATE-20 AND CURRENT_DATE-2

GROUP BY 1,3