select

date_trunc('{{Interval}}',block_timestamp) as date,

count(distinct tx_hash) as number_of_transactions,

sum(tx_fee) as total_fees,

count_if(nonce=0) as new_users

from ethereum.core.fact_transactions

where 1=1

and date >= '{{Start_date}}'

and date <= '{{End_date}}'

group by date