count(distinct cft.block_hash) as unique_transactions_today,

count(distinct cft.block_number) as unique_blcoks_in_transactions

from ethereum.core.fact_transactions cft

where status = 'SUCCESS' and date(cft.block_timestamp) >= current_date - 30

group by 1

order by 1 desc