date_trunc('day', block_timestamp) as day,

count(distinct from_address) as "Unique Ethereum Addresses"

from ethereum.core.fact_transactions

where block_timestamp::date >= current_date-30

group by day

order by day