--*

date_trunc('day', block_timestamp::date) as date,

count(distinct (tx_hash)) as ethereum_txs

FROM ethereum.core.fact_transactions

WHERE --status = 'success'

block_timestamp > '2023-04-26' --AND block_timestamp < '2023-03-27'

group by 1