select date_trunc('day', block_timestamp),count(*),count(distinct FROM_ADDRESS),sum(ETH_VALUE),sum(tx_fee), CASE
when block_timestamp::date = '2022-09-15' then 'merge'
else 'other' end as merge_date
from ethereum.core.fact_transactions
where block_timestamp::date > '2022-08-01'
group by 1,6